Create ID for each weekday time1 and time2 based on the sample data

[bhaskarpbi999]

Hi ,

I need some help as the ID is working for all weekdays but not for friday.

Sample data google drive link

https://docs.google.com/spreadsheets/d/1kMgzehh1inILMJ7VA-EuHR36vsv53JcO/edit?usp=drive_link&ouid=10... 

[dufoq3]

You are not reading properly...

[bhaskarpbi999]

Hi Dufo,

Current source data has 3 columns Index, Date, time like below

Expected output is 4th custom column ID need to created and time1 and time 2 values needed for each weekday.

Attaching source sample data with below link and sorry for the trouble caused by me.

Sample Data 

[dufoq3]

You're still repeating the same and not reading. In previous post you have a link with solution.

[bhaskarpbi999]

Hi Dufo,

I have link and the solution is working for All days except friday where it is displaying time1 and time1 instead of Time2 that is the only issue.

Thanks for your whole hearted support.Kudos any tricks please help me.

Regards,

Bhaskar

[bhaskarpbi999]