ZIP code compare

[Guest]

I have one set of ZIP codes I am trying to compare to another to see if any ZIPS in column 1 are equal to any ZIPS on column 2. Is there an easy way to put a yes/ no type answer next to the ZIPS in Coulmn 1 after looking up the inormation in Column 2? Example: the first ZIP in coulmn 1 is 42301- I'd like to see if that ZIP is listed anywhere in Column 2 and if so give me an indicator (in column 3 or somewhere) that the ZIP code is included.

Thanks.

 

[Al Chara]

Put the following formula in column 3:
=IF(COUNTIF(B:B,A1)>0,"yes","no")
This code will count the number of times the ZIP code in column A appears in column B. If the number is greater than 0 then it will display yes otherwise it will display no.

I hope this helps.
Kind regards, Al

 

[Guest]

Thanks.. worked perfectly.

 

[nisht]

Yes,

You can do this..

download a small utility from my website

comparrange.zip


http://www.pexcel.com/download.htm

this will solve your problem

nisht