Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a solution - maybe vlookup?
Hi, I have a list of documents with unique IDs that were delivered;
electronically, posted or faxed. There are duplicates in the ID column because some docs were posted AND sent electronically - I need to isolate ID numbers that are duplicated by multiple-delivery methods. Can a vlookup do this? very much a newbie with lookup, and the list is very big... thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a solution - maybe vlookup?
You want Countif. If your IDs are in column A, use:
=Countif(A:A,a1) and copy down. Any result more than one means a duplicated ID. Regards, Fred "Noetic76" wrote in message ... Hi, I have a list of documents with unique IDs that were delivered; electronically, posted or faxed. There are duplicates in the ID column because some docs were posted AND sent electronically - I need to isolate ID numbers that are duplicated by multiple-delivery methods. Can a vlookup do this? very much a newbie with lookup, and the list is very big... thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a solution - maybe vlookup?
Noetic,
Use a formula like =IF(COUNTIF(A:A,A2)1,"Duplicate","") in cell B2, and copy down. Then you can filter or sort to find the Duplicated values in column A. If your list of IDs is in column E, then you would use =IF(COUNTIF(E:E,E2)1,"Duplicate","") HTH, Bernie MS Excel MVP "Noetic76" wrote in message ... Hi, I have a list of documents with unique IDs that were delivered; electronically, posted or faxed. There are duplicates in the ID column because some docs were posted AND sent electronically - I need to isolate ID numbers that are duplicated by multiple-delivery methods. Can a vlookup do this? very much a newbie with lookup, and the list is very big... thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a solution - maybe vlookup?
Thanks a bunch Fred and Bernie, we're cooking with gas now!
"Bernie Deitrick" wrote: Noetic, Use a formula like =IF(COUNTIF(A:A,A2)1,"Duplicate","") in cell B2, and copy down. Then you can filter or sort to find the Duplicated values in column A. If your list of IDs is in column E, then you would use =IF(COUNTIF(E:E,E2)1,"Duplicate","") HTH, Bernie MS Excel MVP "Noetic76" wrote in message ... Hi, I have a list of documents with unique IDs that were delivered; electronically, posted or faxed. There are duplicates in the ID column because some docs were posted AND sent electronically - I need to isolate ID numbers that are duplicated by multiple-delivery methods. Can a vlookup do this? very much a newbie with lookup, and the list is very big... thanks! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is the solution Vlookup? | Excel Worksheet Functions | |||
HLOOKUP, VLOOKUP, MATCH, INDEX - Help with the Right Solution! | Excel Discussion (Misc queries) | |||
VLOOKUP - or a better solution | Excel Worksheet Functions | |||
My Vlookup solution is too clumsy (longish) | Excel Discussion (Misc queries) | |||
VLOOKUP Limitation and Solution? | Excel Worksheet Functions |