Okay, I am working on populating this reporting structure for a client 100% automatically. I need to pull the top two product names out of a table, so I did this pretty simply nesting a max function inside the lookup function. Now I need to get to the second highest performing product.
I have attached a spreadsheet with what I am trying to do. Thanks!
Last edited by RussellNonBrand; 07-26-2011 at 11:33 AM.
=lookup(large(b1:b4,2),b1:b4,a1:a4)
Okay maybe not THAT big of a challenge... I completely forgot about large. THANKS!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks