ZIP code compare

Mar 14th, 2002, 08:40 AM

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 · Mar 14th, 2002, 09:14 AM

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

Mar 14th, 2002, 02:47 PM

Thanks.. worked perfectly.

nisht · Mar 15th, 2002, 12:08 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 08:40 AM	#1
Guest Posts: n/a	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.

Mar 14th, 2002, 09:14 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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

Mar 14th, 2002, 02:47 PM	#3
Guest Posts: n/a	Thanks.. worked perfectly.

Mar 15th, 2002, 12:08 AM	#4
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	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