View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RayportingMonkey RayportingMonkey is offline
external usenet poster
 
Posts: 87
Default 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!"