Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement or other methds to find similar data
Hello
I have two set of data. I have to match that both contain PCO12345. All PCO# # # # are different. Majority are in both files but some of the them are missing. There is no particular order. Is there any way to find PCO # # # # that are in both files and which ones are missing? I there any easy method like if statements? other than going through each finding each PCOnumber one by one. There are 2300+ recods. thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement or other methds to find similar data
Try conditional formatting with a formula of
=ISNUMBER(MATCH(A1,Sheet2!A:A,0) and =ISNUMBER(MATCH(A1,Sheet1!A:A,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Funky" wrote in message ... Hello I have two set of data. I have to match that both contain PCO12345. All PCO# # # # are different. Majority are in both files but some of the them are missing. There is no particular order. Is there any way to find PCO # # # # that are in both files and which ones are missing? I there any easy method like if statements? other than going through each finding each PCOnumber one by one. There are 2300+ recods. thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement or other methds to find similar data
Give this a try:
=SUMIF(A1:A2300,"PCO*",B1:B2300) =SUMPRODUCT(ISNUMBER(SEARCH("PCO*",A1:A2300))*((B1 :B2300))) Also, if you are just matching numbers, you may be able to use a Pivot Table: http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html Regards, Ryan--- -- RyGuy "Bob Phillips" wrote: Try conditional formatting with a formula of =ISNUMBER(MATCH(A1,Sheet2!A:A,0) and =ISNUMBER(MATCH(A1,Sheet1!A:A,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Funky" wrote in message ... Hello I have two set of data. I have to match that both contain PCO12345. All PCO# # # # are different. Majority are in both files but some of the them are missing. There is no particular order. Is there any way to find PCO # # # # that are in both files and which ones are missing? I there any easy method like if statements? other than going through each finding each PCOnumber one by one. There are 2300+ recods. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Similar | Excel Worksheet Functions | |||
compare and find similar numbers in two columns | New Users to Excel | |||
find similar numbers | Excel Discussion (Misc queries) | |||
how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
IF statement with logical_value that is similar to this 0 |
Excel Worksheet Functions |