-
VBA Code Help Needed. Lookup Value Ranges
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules