Last Occurance
Hmm! You are right... what was I thinking (that's what I get for making a
last minute modification to a posting). Thanks for catching that.
--
Rick (MVP - Excel)
"smartin" wrote in message
...
Rick, Your first solution
=INDEX(B$1:J$1,1,SUMPRODUCT(MAX((B2:J2<"")*COLUMN (B2:J2)))-1)
was better. The solution below hits the first occurrence of text in row 2,
not the last as the OP requested.
Rick Rothstein wrote:
I gave you a "general" solution (looking for *any* text in the row), but
you said you were marking the attendance with an "X"... so here is a
simpler formula that keys off of that fact (for Row 2 in this example
formula)...
=INDEX(B$1:J$1,1,MATCH("X",B2:J2,0))
Again, change the ranges to suit your set up and copy down.
|