|i know excel cannot loop so wondering if there is another way to do this:|
I have a list of cummulative percentages say in A1:A12, and i want the last non zero percentage to be displayed in another excel sheet. the way i had thought of doing it was:
and so on but this doesnt work.
the data to generate each percentage is added each hour so need the cumulative percentage that is updated at each point.