Hi All,
I am stumped when trying to create a list of the non-blank items in a row.
The attached sample gives an idea of what I am trying to do. I have a series of clients (column B, B5:B9), then for each month (Row 4, C4:N4) I am recording client visits. The cells left blank are truly blank, text is only entered upon a client visit.
At the end of the year I want to be able to capture a summary that only shows the non-blank entries for each client. (see the 'desired result' on the lower half of the attachment).
My thought (using client A as an example) was to have the first cell (C16) containing a formula that finds the first non-blank cell in the range C5:N5. The next cell (D16) containing a formula that finds the second non-blank, the next cell the third non-blank... and so on.
I have been able to find various ways to identify the first non-blank but I am yet to find a way to capture the nth non-blank for subsequent matches.
I appreciate any help!
Bookmarks