MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If 3 Text Cells are the same make the cell = 1

Posted by Lewis on April 19, 2001 6:11 PM

Hey all, trying to get 3 cells to cross check each other. If cell 1 = cell2 = cell3 then the active cell =1 else 0

does anyone know how to make that formula I figured it out if the cells had numaric data but I can't seem to get it to work with text data

thanks in advance...

please e-mail


Posted by Jim on April 19, 2001 9:08 PM

How about this: cells to be cross-checked are B1, C1 and D1



=IF((AND(B1=C1, C1=D1)),1,0)