Hi

I am fairly new to VBA and want to code a macro that allows me to look up the exact cells of the Top5 values in a specific range, restricted by criteria. The Sheet looks like this:

A B
6 North
4 East
99 South
6 West
4 North
2 North

I want to lookup the 5 highest values in a range like in column A, given that they meet the criteria of having e.g. "North" in B. But i am not only interested in the exact numeric values of the Top5, but also in which row they are in.
I would need an output of that into a seperate sheet.

Can anybody help me? I hope I explained the problem properly.

Thank you
seulberg1