# Solved Loop in Excel August 25, 2011 at 06:26:08
Specs: Windows 7
 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:=IF(G16="",G15,IF(G15="",G14,IF(G14="",G13,IF(G13="",G12,G16))))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. See More: Loop in Excel August 26, 2011 at 08:39:35
 I am assuming that the last value in the list will always be the minimum value in the list.If that is the case, try this:=INDIRECT(CELL("address",INDEX(A1:A12,MATCH(MIN(A1:A12),A1:A12,0))))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

#1 August 25, 2011 at 10:44:46
 Please post an example of the data that is A1:A12 and what value you want returned based on that example.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
August 26, 2011 at 06:50:05
 in A1:A12 i have calculated percentages. for examples sake 100%:89% and as 89% is the last in the list i want this number to be shown in another cell.However each row is updated every hour so at the 1st hour A1= 100% and A2:A12 will be blank and as A1 will be the last in the list this is the number i want to be shown in this other cell.So if A1:A11 are 100%:88% and A12 is blank i want some formula to to find the last number in the list(A1:A12) and display it.

Report •

#3 August 26, 2011 at 07:59:00
 The answer may depend how the calculated percentages end up in A1:A12.Please explain that. Please post the formula if one is being used.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

#4
August 26, 2011 at 08:21:46
 the formula is =IF(C6="", "", (F6/E6))

Report •

#5 August 26, 2011 at 08:39:35 