CODEWITHSUNDEEP
arraysexcelfunctionif-statementformula
mb78461982
mb78461982

Reputation: 11

Returning the column header with a value in its row

I have 24 column headers with a date (K6:AH6)

I need to return the column header that has a number in it aka a non blank. the number of value is either 1,2,3,4

There are 1120 non blank and number rows (k7:ah1120)

enter image description here

I want column J7 to show up as Jul 2016 because cell Q7 has a value in it.

the kicker is that 75 of the 1120 rows have a value in 2 or more columns. I may manually do these or insert a row to turn the value back to 1. Not sure how to depict this in a formulation. TIA!

Upvotes: 1

Views: 78

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

Try this in J7 and copy down:

=INDEX($K$6:$AHT$6,MATCH(TRUE,INDEX($K7:$AH7<>"",),0))

enter image description here

Upvotes: 1

Related Questions