G
Guest
This should be easy but I'm having problems. Data looks like this.
Jan Feb Mar Apr.........Dec
John 10 5 6
Mary 2 4
Jill 5 1 5
I want to add a column that will find the first non-blank cell after the
name and then return the column header to that cell so it looks somethng like
this.
Name Start
John Feb
Mary Mar
Jill Jan
And if there is never a non-blank cell I'd like it to return N/A.
Jan Feb Mar Apr.........Dec
John 10 5 6
Mary 2 4
Jill 5 1 5
I want to add a column that will find the first non-blank cell after the
name and then return the column header to that cell so it looks somethng like
this.
Name Start
John Feb
Mary Mar
Jill Jan
And if there is never a non-blank cell I'd like it to return N/A.