Dear;can you explain the logic of getting Activity End ? how you get Activity end = 15/3/2020 5:13:53 am for first instance of ABC2000078276, New Addition, and how come the next instance become Upgrade / Downgrade
Once you explain clearly, you can use Power Query to transform to the format
Hi;Hi,
or
=IFERROR(INDEX($Q$4:$Q$51,MATCH(2, 1/($O$4:$O$51="Active")/($N$4:$N$51=H4))),"not found")
CTRL-SHIFT-ENTER copy down
Regards
Hi; Activity end date is entered manually... Activity 1: New Addition, when customer like to upgrade / downgrade, lock, terminate; we will first close the first activity manually by adding date in activity date column... From this date; we need to derive the next date time of next activity start... If customer next activity is locked; system will get date from last instance and add one sec and will start customer activity which is locked...Hi, don't get you, please give us a final output of the correct activity end date that you want, or you just create another few table to replace "Active:" to other status (Upgrade / Downgrade , lock)