Forum Discussion
hugo_p_23
Helper I
2 years agoGet non blank value from previous row
Hi,
I need to create a column that fetches the last non-blank value as an example.
Initial data:
Column that i need to create:
Yellow column it's the goal, green column is to exemplify the logic, if the column "Avaliação Final" have data, i use that data, if the follow rows doesn't have, i use the previous data available.
Thanks
Hugo
For fun only, a showcase of powerful Excel formulas,
I forgot to mention that i also need to filter by customer, i need the previous status by cliente too: