| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing values in two columns
Hi,
I have two columns (Col A and Col B) having the employee numbers. I want to compare the numbers in both the columns and highlight the duplicate entries in Col A. Can you help? Regards, P Hamsa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing values in two columns
Put this in B1 as cond.format and copy format down
=IF(COUNTIF($A$1:$A$100,B1)=1,B1:$B$100,"") "P.hamsa" skrev: Hi, I have two columns (Col A and Col B) having the employee numbers. I want to compare the numbers in both the columns and highlight the duplicate entries in Col A. Can you help? Regards, P Hamsa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing values in two columns
and select color
"P.hamsa" skrev: Hi, I have two columns (Col A and Col B) having the employee numbers. I want to compare the numbers in both the columns and highlight the duplicate entries in Col A. Can you help? Regards, P Hamsa |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing values in two columns
Highlight your range in Column A
Conditional Formatting =COUNTIF($B$1:$B$100,$A1)0 Adjust range to suit format any color you like "P.hamsa" wrote: Hi, I have two columns (Col A and Col B) having the employee numbers. I want to compare the numbers in both the columns and highlight the duplicate entries in Col A. Can you help? Regards, P Hamsa |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing values in two columns
Thanks to both the replies. It is working. Regards, P.Hamsa -- "Teethless mama" wrote: Highlight your range in Column A Conditional Formatting =COUNTIF($B$1:$B$100,$A1)0 Adjust range to suit format any color you like "P.hamsa" wrote: Hi, I have two columns (Col A and Col B) having the employee numbers. I want to compare the numbers in both the columns and highlight the duplicate entries in Col A. Can you help? Regards, P Hamsa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing values in columns | Excel Worksheet Functions | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
| comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
| Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Linear Mode
