Help Developing List of Conditions

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?

Select the columns, and Sort by the second column from largest to smallest (or vice versa). You could also apply a Filter, for example, to only display values of "1" or "2" that require serious attention, or "5" to see what's good.

My gut feeling is Sort & Filter is the toolset you need for this.