Results 1 to 14 of 14

how to compare if multiple cells are equal

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2009
    Location
    Southampton, England
    MS-Off Ver
    Excel 2003
    Posts
    28

    how to compare if multiple cells are equal

    Hi All

    I need to compare the data in three fields and if the same ignore but if different then add them with a space and a hyphen.

    I use this formula for 2 fields and it works great I just can't get it to work with three.

    =IF(TRIM(Data!BC2)=TRIM(Data!AY2),TRIM(Data!BC2),TRIM(Data!BC2)&" - "&TRIM(Data!AY2))

    I use the trim command as the users entering data often add unnecessary spaces etc. and it combines the data even when the same.

    Any help appreciated.
    Last edited by evanhughes; 01-31-2010 at 03:09 PM. Reason: Changed Title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1