duplication of information in cells

P

Paul

I have email addresses stored in an excel workbook on different pages. Is
there any way you can check if the same record (email address) is duplicated
on another page in the workbook.
I have each page sorted in alphabetical order so you can manually scroll
each page and look for duplicates as they appear together.
Is there a way you can get excell to check if duplicated data exists in
different cells on different pages?
 
T

Toppers

Paul,
I don't know if this is acceptable but you could give it a try:

Set up a range named "MySheets" with your sheet names.

Assuming data is column A on all sheets, put this formula in "spare" column
on EACH sheet: enter with Ctrl+ShifT+Enter and copy down as required.


=SUM(IF(--COUNTIF(INDIRECT("'"&MySheets&"'!$A1:$A20"),A1)>0,1,0))

Change range(s) to suit.

Any result > 1 indicates a duplicate somewhere. You can filter on "> 1"

HTH
 
Top