Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: ZIP code compare

  1. #1
    Guest

    Default

    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.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Guest

    Default

    Thanks.. worked perfectly.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •