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
Bookmarks