View Single Post
  #1   Report Post  
plf100
 
Posts: n/a
Default How do I select & use contents of first non-blank cell in row?

I've got 12 columns (headed Jan - Dec), each of which contains a combination
of numerical & blank cells. For each row, I want to select the first
non-blank cell and return the column header that it lies in e.g. Row 1, first
non-blank cell is in the Apr column, so I want the text "Apr" to be returned
to another cell.

Help please.