Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Finding duplicate cell entries in a column of data | Excel Discussion (Misc queries) | |||
Counting Duplicate Entries | Excel Worksheet Functions | |||
Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) |