Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 06, 07:23 PM posted to microsoft.public.excel.worksheet.functions
Melissa
 
Posts: n/a
Default 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   Report Post  
Old January 4th 06, 07:33 PM posted to microsoft.public.excel.worksheet.functions
JustMe602
 
Posts: n/a
Default 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   Report Post  
Old January 4th 06, 09:06 PM 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

  #4   Report Post  
Old January 4th 06, 09:20 PM posted to microsoft.public.excel.worksheet.functions
Melissa
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Excel Worksheet Functions 2 September 1st 05 01:59 PM
Finding duplicate cell entries in a column of data Ellie Excel Discussion (Misc queries) 1 July 28th 05 01:41 PM
Counting Duplicate Entries No_name Excel Worksheet Functions 1 July 18th 05 04:01 PM
Preventing Duplicate Entries within a column Bruce Excel Discussion (Misc queries) 3 January 29th 05 12:33 AM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017