How to find duplicates record across multiple sheets from anywhere.
I have attach sample file.
How to find duplicates record across multiple sheets from anywhere.
I have attach sample file.
What is your expected result? Can you amend your sheet to show what you want?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I have once again attach with expected result required in duplicate sheet.
Also want duplicate value highlighted (in red color) from all six sheets except duplicate sheet.
Last edited by avk; 04-22-2015 at 04:31 AM. Reason: adding point
Yes, but...
The value 212 is also duplicated. Where should it appear? How will you be able to tell that the 6 refers to 122? Surely the value that is duplicated should appear somewhere?? Also, what is the meaning of the top row in the summary. It looks like a date, but the 122's appear under different dats in the other sheets. What is the logic of counting them and putting the result in cell B2 (not B1 as you stated), instead of in another cell. Basically: what links B2 to thevalue 122????
anywhere in any sheet. i hv workout some different way. My aim is to find duplicate values. Ref attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks