Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparing lists (2003)

    How can I compare the telephone codes - What I need to do is compare supplier 1 codes against supplier 2 in one column then compare supplier 1 with supplier 3 and return the results in another column ??

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Comparing lists (2003)

    Can you please explain in detail what you want to do (for example, which columns must be compared, do you only want to compare values in the same row or across rows, etc. - be as specific as possible) and what the result should look like?

  3. #3
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing lists (2003)

    I need to compare the telephone codes in column B with those in column E, then column B codes with column H codes.
    In column J I would like to see the results from column B versus E - so if the code in cell B3 (1876) appears anywhere in column E then cell J1 will return the code itself (1876).
    When comparing column B versus column H the results should appear in column K.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Comparing lists (2003)

    If I understand you correctly, the following should do what you ask: in cell J3, enter this formula:

    =IF(B3="","",IF(COUNTIF($E$3:$E$33,B3),B3,""))

    and in cell K3, enter this formula:

    =IF(B3="","",IF(COUNTIF($H$3:$H$33,B3),B3,""))

    Select J3:K3 and fill down to row 33.

  5. #5
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing lists (2003)

    Thanks Hans worked perfectly

Posting Permissions

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