My company does inspections on various structures and we evaluate how bad a deficiency is with a 1 to 5 scale (1 being really bad and 5 being ok). I am developing a spreadsheet that would summarize our findings. I have it counting how many 1's, 2's, ect and spitting that info into the summary sheet. What I do not know how to do is have it automatically list deficiencies with a 1 rating at the bottom of the page (or on the next page(s) as we can have hundreds of items in a single report).

Example:

Deficiency / Rating (obviously seperate columns)

A / 1
B / 4
C / 5
D / 1
E / 2
F / 4

I would then want A and D to be listed on the bottom of the summary sheet, one right after the other. I know I can make this happen with a macro, but most the people in my office refuse to enable/use macros (I have no idea why they don't) so I was hoping I could automate this with functions. Any ideas?