hello, thanks for trying helping. i have column C with random T and F. I need to get the manual result i did in column D. since there are over thousand rows, can someone help me here? below are the criterias to get column D result. Attached is the sample spreadsheet.
there is differences in this task compared with the previous i posted and i couldn’t calculate this one.
1. T and F must be alternate. i.e. T must be followed by F and vice versa.
2. when there is F, immediately place following T available in column C.
3. when there is T, place following F which available AFTER NEXT 5 rows.
Thanks. Thanks a lot.
