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<>"").
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?
The cells are not really empty, aren't they? The probably contain a formula.
Change ($AA2:$AI2>0) to ($AA2:$AI2<>"").
- Yes!!! It worked! Thanks a lot!