Finding Column Position
 

I'm creating a spreadsheet to help me with scheduling employees.

Is there a way to find out the position of the last entry in a row?

I'm using the following formula to find the first entry:

MATCH(1,b7:ak7,0)

This returns the first "1" that it finds in column 7, but I don't know
how to find the last "1" that it finds in the same column.

Any help would be greatly appriciated.

Thanks,
Brian


--
Brian Mann
------------------------------------------------------------------------
Brian Mann's Profile: http://www.excelforum.com/member.php...o&userid=27466
View this thread: http://www.excelforum.com/showthread...hreadid=469800

Sorry... I found the answer... should have read a little more...


--
Brian Mann
------------------------------------------------------------------------
Brian Mann's Profile: http://www.excelforum.com/member.php...o&userid=27466
View this thread: http://www.excelforum.com/showthread...hreadid=469800