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 tod.b@home.com
thanx