Hello there! I have a large number of data over 600,000 in sheet and there are around 7-8 such sheets. I want to find and highlight the duplicate phone number present in "column I" in all the sheets. Is it possible to compare all sheets and get the duplicate entries from them Regards
Solved by K. J. in 21 mins