Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Comparing Two Cells

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've one workbook with 3 different name of worksheet. My question is, I would like to compare the cell at sheet 1 and cell at sheet 2. If the cell in sheet 1(A1=Unique_Identifier) not equal to cell in sheet 2 (A1=Unique_Identifier) then the sheet 3 (A1=Result) will display the value of cell of sheet1.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Australia
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok, first of all you need to write the formula into a cell in sheet 3. From this cell type = and click on sheet1. click on the area or cell you want to reference and it should automatically be added to your formula. You then write your compare statement, and then reference sheet2 just like you did sheet1.

    I hope this made some sense to you, i just woke up........so could be a little hazy

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 19:24, chku55 wrote:
    I've one workbook with 3 different name of worksheet. My question is, I would like to compare the cell at sheet 1 and cell at sheet 2. If the cell in sheet 1(A1=Unique_Identifier) not equal to cell in sheet 2 (A1=Unique_Identifier) then the sheet 3 (A1=Result) will display the value of cell of sheet1.
    Hi chku55:
    Furthe to what KnAsTa said, you can go directly to cell A1 in sheet3 and type the following formula

    =IF(SHEET1!A1=SHEET2!A1,"",SHEET1!A1)

    HTH

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  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

    use my file nos 12 'compare range'

    http://www.pexcel.com/download.htm

    it will give you the solution.

    ni****h desai
    http://www.pexcel.com

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
  •