Find last entry in row and return column header name

**cralph78** · 08-06-2014, 05:34 AM

Hi

I need a formula which will look at a number of columns and determine which column has a figure in it greater than zero and then return the column header date - please see attached file for clarification.

I have to use this on a number of rows independently.

Thanks

**martindwilson** · 08-06-2014, 05:40 AM

try
=IFERROR(LOOKUP(10^99,1/$A2:$L2,$A$1:$L$1),"") filled down.

Find last entry in row and return column header name

LinkBack

Thread Tools

Rate This Thread

Display

Find last entry in row and return column header name

Re: Find last entry in row and return column header name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find last entry in row and return column header

[SOLVED] Need formula to return column header name for first entry on each row greater than zero

[SOLVED] Find specific value in table and return header row and header column value

Find a value and return value of the row and column header

Find Max values in row then return Column Header

Bookmarks

Bookmarks

Posting Permissions