hi,
im sure ive done this before but sometimes i just cant get my brain to work
ive got a list of data say 10 columns by 500 rows.
in column E i have the country name i.e "USA".
in column H i have a value i.e "$10,000".
I want to return the 10 highest values in Column H where Column E = "USA".
Ive got the data in one worksheet "RawData" and i will have multiple worksheets one for each country, i.e "USA".
Thanks for any help.
Bookmarks