May be we can have another way of writing this query instead of the above query. I copy that query fron someone in Stack Overflow support forum that answer my exact question and edit and applying I don’t know it gives me so much trouble.
Can you share the link here?
Check Karl’s reply:
Please let him edit the sheet. Its a dummy don’t worry about the data. It would be very please for me to see how he created that helper. Thank you all
Let’s do it your way but I am not going to use the TRUE and FALSE. Putting a helper on 67000 rows X 6 Columns every text and every minutes count. I am going to use very laymen logic by replace TRUE =1 and FALSE=0 which i think will be faster.
That table you shared with me it not really comparing column value A to C. It compare direct row to row but I have a different column size. Try to put my name Desmond LEE at row 710 on orange and blue is still FALSE.
I use this formula dn its works