seulberg1
06-25-2014, 05:34 PM
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
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