I have a similar question, is there a way to get the column numbers for the first and last non-blank values in a row? In my spreadsheet, each column represents a week of time billed to a client, so with a start week and end week I can get a length of relationship.