How can you identify duplicate entries in a singe column?
How can you identify duplicate entries in a singe column? Can you identify
duplicate data in 2 columns where each column in on a different worksheet? |
How can you identify duplicate entries in a singe column?
You will need to input the following formula in as a conditional format. Menu - Format - Conditional Format - [Change drop down to] Formula is =COUNTIF($B:$B,$B1)1 That should work... JustMe. -- JustMe602 ------------------------------------------------------------------------ JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854 View this thread: http://www.excelforum.com/showthread...hreadid=498031 |
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 |
How can you identify duplicate entries in a singe column?
Thanks! Worked like a charm!!
I appreciate your help! Melissa "JustMe602" wrote: You will need to input the following formula in as a conditional format. Menu - Format - Conditional Format - [Change drop down to] Formula is =COUNTIF($B:$B,$B1)1 That should work... JustMe. -- JustMe602 ------------------------------------------------------------------------ JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854 View this thread: http://www.excelforum.com/showthread...hreadid=498031 |
All times are GMT +1. The time now is 08:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com