| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do All Cells in a Row Match?
I'm a little stumped on this one...
I need to know if all the cells in a row match the value in the first cell. I tried match, index and killed nested ifs as the cols are A:EB For example, Cell A1 is XXY1 and A2 is also XXY1, but A3 is ZZZ3. I need to know that there is a cell that doesn't match A1. A simple "TRUE / FALSE" is fine. These are alpha-numeric strings. My guess is this is an array formula of sorts, but I had trouble figuring it out! Any help is appreciated! -- "Trying to make reports so easy... even a monkey could run ''em!" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Do All Cells in a Row Match?
Something like this should work:
=COUNTIF(A1:A10,A1)=10 Assuming that *every* cell in the range must contain an entry (even though they may not all match). -- Biff Microsoft Excel MVP "RayportingMonkey" wrote in message ... I'm a little stumped on this one... I need to know if all the cells in a row match the value in the first cell. I tried match, index and killed nested ifs as the cols are A:EB For example, Cell A1 is XXY1 and A2 is also XXY1, but A3 is ZZZ3. I need to know that there is a cell that doesn't match A1. A simple "TRUE / FALSE" is fine. These are alpha-numeric strings. My guess is this is an array formula of sorts, but I had trouble figuring it out! Any help is appreciated! -- "Trying to make reports so easy... even a monkey could run ''em!" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Do All Cells in a Row Match?
No array formula needed. Try
=(COUNTIF(A1:EB1,A1)=COLUMN(EB1)) Hope this helps, Hutch "RayportingMonkey" wrote: I'm a little stumped on this one... I need to know if all the cells in a row match the value in the first cell. I tried match, index and killed nested ifs as the cols are A:EB For example, Cell A1 is XXY1 and A2 is also XXY1, but A3 is ZZZ3. I need to know that there is a cell that doesn't match A1. A simple "TRUE / FALSE" is fine. These are alpha-numeric strings. My guess is this is an array formula of sorts, but I had trouble figuring it out! Any help is appreciated! -- "Trying to make reports so easy... even a monkey could run ''em!" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Match Cells | Excel Worksheet Functions | |||
| Look for a value in two cells and match it with another | Excel Discussion (Misc queries) | |||
| Match cells with cells on another workbook | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
Linear Mode
