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