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

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

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