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,
<tbody>
</tbody>
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,
Total | Fuel | Travel | Mobile | Sundries | |||
0.8 | |||||||
43374 | |||||||
43374 | Tesco's | 40.01 | 33.34 | Fuel | |||
43374 | Anxiety Transfer Experts | 120 | |||||
43374 | O2 | 80 | 66.66666667 | Mobile |
<tbody>
</tbody>