Hi,Hi @Sudhakar Vashist (and @PCosta87).
@PCosta87: Your formula not work if the data not appears in order. Please see attached with another option with distinct list. Blessings!
Hi,
I'm not sure what you mean... it works independently of how the source data is sorted, at least in my PC.
Can you please double check?
Thanks
I see,Please check the file with the comparison. Blessings!