Hi ,Hi Narayan
Sorry, still showing duplicates, cells highlighted in yellow. I'm looking for similar on example on columns J,K,L.
If I could look to the entire columns it will be better, beause the file has hundreds of thousabds rows.
Thanks again
R
1] The other faster way is using helper column.All
Apologies to disturb you again with this.
The formula works fine, the only trouble I'm having is that, excel it's painfull slow to run it as I have 500000+ rows to calculate, I'm wondering if there is any other (faster) way to do it?
Thanks
R