Thread: Last Occurance
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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.