Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Provided Answers: 1

    Unanswered: Statment Help, checking for identical data across 3 columns

    Excell 2003

    Hi, I am trying to check to see if the same data exists within three columns on the same row

    I need a if statment or something that checks the three columns across the row, and depending on the result gives an answer, so if Column1 Titled A", Column2 Titled "B" & Column3 Titled "C", so if part A is in C1R1 and Part A is in C2R1 the resuilt would be "AB", if part B is in C2R2 and Part B is in C3R2 the resuilt would be "BC"
    Hope this makes sense, I have attached an example to hopefully clarify
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2009
    Lake County, IL
    When I open your file, its jibberish.


Posting Permissions

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