• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

External Formula for finding duplicates

I have a workbook with 1500+ sheets, with similar format in each sheet, A column contains Dates, B Column has Unique Text String, C has Particulars, D,E & F has Numbers. I want to Know from external sheet, whether B Column of any sheet has Duplicate Text String, Please help me.
 

Chihiro

Excel Ninja
1500+ sheets in a workbook? I'd really recommend restructuring your data.

If you have Power Query / Get & Transform available. Query the workbook and append all sheets into one table.

How you identify duplicate will depend on some factors... such as how many unique items are expected.

But I'd start with adding data from Power Query directly into data model. Then add B column to row label of Pivot table, and perform distinct count.
If > 1, then you know it has duplicate.
 
Top