Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing columns to find dup's
i have 1 worksheet with 2 columns....i need to know the names that show in
both columns. i know there is a =countif formula but i cant find it anywhere. thx ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing columns to find dup's
You have two options:
You can use a countif in C2. That would be =COUNTIF(A:A,B2) THis assumes your first column in A, the second is B and you would countif in C. The other option is a VLOOKUP. Either way, you will be able to flag the duplicates. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "stacey" wrote: i have 1 worksheet with 2 columns....i need to know the names that show in both columns. i know there is a =countif formula but i cant find it anywhere. thx ! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing columns to find dup's
this is what i am using:
=COUNTIF(B:E,G2) but column B & E have some repeating last names. how do i incorporate the formula to go off of ab / de. this would catch the full name & be able to find all the dup's. column a & d being the first name & b & e being the last name. thx ! "PJFry" wrote: You have two options: You can use a countif in C2. That would be =COUNTIF(A:A,B2) THis assumes your first column in A, the second is B and you would countif in C. The other option is a VLOOKUP. Either way, you will be able to flag the duplicates. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "stacey" wrote: i have 1 worksheet with 2 columns....i need to know the names that show in both columns. i know there is a =countif formula but i cant find it anywhere. thx ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing columns to find a difference | Excel Worksheet Functions | |||
comparing columns | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
VLOOKUP 1 stop Answer: 3 steps: count dup's, compare dif's, merg | Excel Discussion (Misc queries) |