View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default How can you identify duplicate entries in a singe column?


If the values are in Column A, Sort the column. Then enter a Title for
the the column A in Cell A1 or just insert a row and leave it "Blank".
Then in Column B you can enter the following formula.
=IF(A2=A1,"Duplicate","Non Duplicate") and then copy down - this will
give you a visual representation of any duplicate values. You can enter
any value you want for Duplicate and Non Duplicate.
Second part of your Question:
Sheet 1 in Column B add Sheet1 for each value
Sheet 2 in Column B add Sheet2 for each value
Copy Columns A and B from Sheet 1 and Sheet 2 - paste them into Sheet
3
and then do the same formula as above in Column C - This will show you
where the duplicates are.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498031