Remember Me?

#1
January 4th 06, 07:23 PM posted to microsoft.public.excel.worksheet.functions
 Melissa Posts: n/a
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
January 4th 06, 07:33 PM posted to microsoft.public.excel.worksheet.functions
 JustMe602 Posts: n/a
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

#3
January 4th 06, 09:06 PM posted to microsoft.public.excel.worksheet.functions
 wjohnson Posts: n/a
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.
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

#4
January 4th 06, 09:20 PM posted to microsoft.public.excel.worksheet.functions
 Melissa Posts: n/a
How can you identify duplicate entries in a singe column?

Thanks! Worked like a charm!!
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM Krisjhn Excel Worksheet Functions 2 September 1st 05 01:59 PM Ellie Excel Discussion (Misc queries) 1 July 28th 05 01:41 PM No_name Excel Worksheet Functions 1 July 18th 05 04:01 PM Bruce Excel Discussion (Misc queries) 3 January 29th 05 12:33 AM

All times are GMT +1. The time now is 04:31 AM.