Macro: sort value within an array

[tandeman]

Hi Friends,

Sheet 1 (data dump)
I'm working on a macro that get values from column A then look up their ranking (a number) from a database sheet. The ranking will determine the output i.e. values in column A with Top 3 rankings will output "keep" and the rest are "discarded".

In the database sheet.
column A has the same value as in column A before for lookup purposes. Column B has the ranking. Column C has the status, included or excluded from the test.

So what I'm wondering is how can I get all the value on sheet 1 in an array and sort them by ranking (sort only those included in the test). After sorting, I will only keep the top 3 ranking values.

I dont think i have explained it really well. Please me know if you dont understand or have any questions. Thanks

 

[frank_AL]

Chip Pearson provides a couple of options for sorting array values. Take a took at this link.

 

[tandeman]

Thanks Frank I'll give it a go