Show cell value based upon data contained in column below

CarlT

New Member
Joined
Jan 2, 2019
Messages
2
Hey all,

I'm trying to work out the best formula to use for the below requirements.

I have my sheet below, I'm looking to show the top field (row 1), if there is any amount within the corresponding columns below, into a new column. What formula am I best working with? This could extend to 20+ columns. Thinking HLookup or IFS..

Thanks in advance,


TotalFuelTravelMobileSundries
0.8
43374
43374Tesco's40.0133.34Fuel
43374Anxiety Transfer Experts120
43374O28066.66666667Mobile

<tbody>
</tbody>
 

Chrisdontm

Well-known Member
Joined
May 4, 2015
Messages
802
Assuming that row two is where that " 0.8 " is, then in cell H2 put this formula;

=IF(LARGE((D2:G2>0)*COLUMN(D2:G2),1)=0,"",INDEX($A$1:$G$1,LARGE((D2:G2>0)*COLUMN(D2:G2),1)))

This is an array formula, so to enter it, you will need to hold control & shift then hit enter...

Then copy it down as far as you need top.

( Widen the listed ranges as needed... )
 

Forum statistics

Threads
1,077,635
Messages
5,335,379
Members
399,014
Latest member
hamzalaarif

Some videos you may like

This Week's Hot Topics

Top