Forum Discussion
Solved
Excel 365 - Extracting non-empty values from a row of values?
Hi, I've been searching and trying out different formulas that I found online and I couldn't get it to work, so I'm a bit perplexed and am asking for some help. It would be amazing if someone sma...
The cells are not really empty, aren't they? The probably contain a formula.
Change ($AA2:$AI2>0) to ($AA2:$AI2<>"").
Formula in AL2:
=IFERROR(INDEX(2:2,AGGREGATE(15,6,COLUMN($AA2:$AI2)/($AA2:$AI2>0),COLUMNS($AL2:AL2))),"")Copy to the right and down.
Hi, thanks for your quick response but it still gives me the blanks, which I don't want. I want the order of the extracted value to always be T+0, T+1..,T+3. Any idea how?