Return Column Header from an Index/array, finding Large with a userinput date

A

alovell

I'm looking for the brand name of the largest sales. I have a function I can use if I know the row I am searching for, but this will change based on a user date.

bmw ford lexus mercedes
201201 5 6 3 15
201202 8 6 4 7
201203 10 9 5 11
201204 12 6 3 9

Worksheet is 24 rows by 100+ columns, I need the first largest, 2nd largest, etc for a user input date. So, someone wants the top 5 brands for 201206, then wants to compare to 201201 2 minutes later, we have that input in A1on another sheet. Any help? Also, using excel in a different language so VBA is mostly out of the question.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top