Last Column header for non blank in row?

[Darth269]

Hi folks,

I'm using

=IF(COUNTA(D7:AC7),INDEX(D$2:AC$2,MATCH(TRUE,INDEX(D7:AC7<>"",0),)),"")

to find the header (in D2:AC2), but I can't get my head around how to use this, or another code, to find the header for the LAST populated cell.

I used this Stack Overflow article to find the above code ...

https://stackoverflow.com/questions...-the-first-non-blank-cell-of-a-range-in-excel


Any advice would be much appreciated.

 

[Darth269]

Slight amendment to this request, I've found a way to do it by simply adding some other numbers together, however, is there a way to look for NON BLANKS or a specified character? Such as NO BLANKS / "S" / "HR" etc?

 

[Peter_SSs]

.. find the header for the LAST populated cell.

Welcome to the MrExcel board!

If the headers are text (that is, not numerical) then try

=LOOKUP(REPT("z",255),D7:AC7)