Finding Duplicates in Excel

[barnsey11]

I have 10 long long keyword lists in on spreadsheet in excel. Approx 40,000 terms in each list. Is is possible to find duplicates in excel ?

Thank you in advance

Stephen

 

[VoG]

Where are these lists - same/different workbooks / worksheets / columns? Single column dups or multiple columns? And so on and soforth.

It is possible but without details it is difficult to advise.

 

[Oaktree]

Are the duplicates only across lists? (i.e. does each list have unique values? Or could duplicates exist within the same list as well?)

 

[barnsey11]

The duplicates can occur within each list (column) and also across the numerous lists (columns)

I did try and put all lists in one column, sort the list and then do an IF formula to pull out duplicates, the only issue with this that it screwed up my lists..