populated array from multiple same small results

[EduCopyGuy]

Hi, I work with copiers, and have been using this formula to populate a single cell in a monthly spreadsheet from two other spreadsheets based upon a small set (1-5) click count on each machine (also in a separate spreadsheet.) Normally, I do not get two machines that have the same copy count with them a month, but as this is the summer, I now have multiple machines with "0" copy totals. I need to have a way to let the formula know that the first "0" copy total has already been pulled, and to look for the next school/machine in the list on that particular spreadsheet that has a "0" copy total.

Formula for the looking of the copy count (not needed to be adjusted):

=SMALL(('Meter Summary 2012'!$S$266:$S$269,'Meter Summary 2012'!$S$282:$S$291,'Meter Summary 2012'!$S$296:$S$309,'Meter Summary 2012'!$S$320:$S$329,'Meter Summary 2012'!$S$334:$S$341,'Meter Summary 2012'!$S$346:$S$357,'Meter Summary 2012'!$S$364:$S$367,'Meter Summary 2012'!$S$372:$S$377,'Meter Summary 2012'!$S$382:$S$389,'Meter Summary 2012'!$S$394:$S$401,'Meter Summary 2012'!$S$406:$S$415,'Meter Summary 2012'!$S$420:$S$429,'Meter Summary 2012'!$S$436:$S$443,'Meter Summary 2012'!$S$448:$S$457,'Meter Summary 2012'!$S$462:$S$477,'Meter Summary 2012'!$S$482:$S$495,'Meter Summary 2012'!$S$500:$S$511,'Meter Summary 2012'!$S$516:$S$531,'Meter Summary 2012'!$S$536:$S$549,'Meter Summary 2012'!$S$554:$S$557,'Meter Summary 2012'!$S$564:$S$585,'Meter Summary 2012'!$S$590:$S$593),{1}) Array formula to find the name of the school, and machine (needing to be adjusted): {=CONCATENATE("1)",INDEX('Meter Summary 2012'!AI$266:AI$593,SMALL(IF('Meter Summary 2012'!$S$266:$S$593=$K70,IF('Meter Summary 2012'!$S$266:$S$593<>"",ROW('Meter Summary 2012'!$S$266:$S$593)-ROW('Utilization Summary 2011'!$S$266)+1)),COLUMNS('Meter Summary 2012'!AI$266:AI$593)))," ",INDEX('Meter Summary 2012'!AJ$266:AJ$593,SMALL(IF('Meter Summary 2012'!$S$266:$S$593=$K70,IF('Meter Summary 2012'!$S$266:$S$593<>"",ROW('Meter Summary 2012'!$S$266:$S$593)-ROW('Utilization Summary 2011'!$S$266)+1)),COLUMNS('Meter Summary 2012'!AJ$266:AJ$593)))," ",INDEX('Meter Summary 2012'!AK$266:AK$593,SMALL(IF('Meter Summary 2012'!$S$266:$S$593=$K70,IF('Meter Summary 2012'!$S$266:$S$593<>"",ROW('Meter Summary 2012'!$S$266:$S$593)-ROW('Utilization Summary 2011'!$S$266)+1)),COLUMNS('Meter Summary 2012'!AK$266:AK$593))))} Any help or suggestions would be greatly appreciated. EduCopyGuy

<tbody>
</tbody>

 

[EduCopyGuy]

Here is what the spreadsheet shows:


[TABLE="width: 374"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 3"]Lowest 5 Utilized B&W Machines [/TD]
[TD]Ttl. Impr.[/TD]
[TD]Last Month[/TD]
[/TR]
[TR]
[TD="colspan: 3"] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 3"]1)CoxES Library MP 2851[/TD]
[TD]0[/TD]
[TD]2)[/TD]
[/TR]
[TR]
[TD="colspan: 3"]2)CoxES Library MP 2851[/TD]
[TD]0[/TD]
[TD]n/a[/TD]
[/TR]
[TR]
[TD="colspan: 3"]3)CoxES Library MP 2851[/TD]
[TD]0[/TD]
[TD]5)[/TD]
[/TR]
[TR]
[TD="colspan: 3"]4)CoxES Library MP 2851[/TD]
[TD]0[/TD]
[TD]n/a[/TD]
[/TR]
[TR]
[TD="colspan: 3"]5)SRES Library MP 2851[/TD]
[TD]7[/TD]
[TD]4)[/TD]
[/TR]
[TR]
[TD="colspan: 3"] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

I need 2,3,and 4 to not read the name of the same school, but the next school in the spreadsheet with a "0" copy total.