If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare a cell to a range of cells
Could someone help me?
What I need is to compare one cell with 35 other static cells. If the data in the main cell is the same as any of the other cells it is compared against then I want to have some thing like a 'X' else I want the output cell to be the same as the main cell.. I hope that wasn't to confusing! So basically this would be; =IF(AL8=AQ8:AQ43,"X",AL8) =if(maincell=AnyOneOfASeriesOfCells,'X',maincell How do I specify the range? |
#2
|
|||
|
|||
Compare a cell to a range of cells
Hi
try =IF(ISNA(MATCH(AL8,AQ8:AQ43,0)),AL8,"X") -- Regards Frank Kabel Frankfurt, Germany wrote: Could someone help me? What I need is to compare one cell with 35 other static cells. If the data in the main cell is the same as any of the other cells it is compared against then I want to have some thing like a 'X' else I want the output cell to be the same as the main cell.. I hope that wasn't to confusing! So basically this would be; =IF(AL8=AQ8:AQ43,"X",AL8) =if(maincell=AnyOneOfASeriesOfCells,'X',maincell How do I specify the range? |
#3
|
|||
|
|||
Compare a cell to a range of cells
Perfect Frank. Thanks, your doing a great service..
-----Original Message----- Hi try =IF(ISNA(MATCH(AL8,AQ8:AQ43,0)),AL8,"X") -- Regards Frank Kabel Frankfurt, Germany wrote: Could someone help me? What I need is to compare one cell with 35 other static cells. If the data in the main cell is the same as any of the other cells it is compared against then I want to have some thing like a 'X' else I want the output cell to be the same as the main cell.. I hope that wasn't to confusing! So basically this would be; =IF(AL8=AQ8:AQ43,"X",AL8) =if(maincell=AnyOneOfASeriesOfCells,'X',maincell How do I specify the range? . |
Thread Tools | |
Display Modes | |
|
|