find first non blank cell and return cell in top row in that column

[42dcp]

Suppose you have a table with the days of the week on the top row and the names of different people in the first column. Suppose a 7 by 7 table of data with numbers randomly in there with several cells blank. What is a formula for each person that tells the day of the week for the first non blank cell? And maybe the last too?

 

[Weazel]

maybe something like...

Excel 2012

	A	B	C	D	E	F	G	H	I
1		Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
2	Joe		3						Monday
3	Mary			3				2	Tuesday
4	Pete				2				Wednesday
5	Mike			2			2		Tuesday
6	Sam	2				2	2		Sunday
7	Molly				2			2	Wednesday

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula I2 =INDEX($B$1:$H$1,MATCH(TRUE,INDEX($B2:$H2<>"",1,0),0)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>