Complicated data lookups/ranks

Hello again,
I posted a question yesterday that helped on a project incredibly well, hoping to ask of one more favor with a solution. I am building a dashboard for a project, which is going to be on a separate woorksheet for easy printing and providing only needed data from my database. I have attached a small example in the format I will actually be using as I think the formula is going to be specific to my dashboard.

Attached file, you should see a column "Rank" highlighted orange, with certain rows being numbered. My objective is to display certain data from that particular row, and display it (scroll to the right to see the dashboard display layout) on the dashboard. I think my main goal is to have the specified data displayed in ranked order 1-10 from the top down, and I don't know where to start with that....the other possiblity is to just have the specified data display in ascending order of the zip codes as long as something other than <blank> is in the "Rank" field. Even just a basic direction to go to achieve something close to this will be more than appreciated.