Character as a Number
I don't understand the formula and would appreciate it if you would tell me
how this works. It is so close. What I'm finding, however, is that when an *
is put in a cell in a row the formula works fine but it allows another * to
be added to the same row and that can't be allowed. How would this formula be
changed to accomodate that? Would it be to count the *'s and if more than one
have a statement displayed. Appreciate your help very much!!! Jani
"Gary''s Student" wrote:
=(MATCH("*",A1:E1,0)-1)*2
for the first four cells in row 1
No IFs were needed
--
Gary''s Student - gsnu200805
|