Formula on b4 to drag write
NAME YEAR2010 YEAR2011 YEAR2012 YEAR2013 YEAR2014 seller 1 169,309,657 182,777,005 153,182,727 143,592,995 141,260,547 seller 2 57,613,227 112,302,752 91,099,046 149,578,323 110,737,111 seller 3 26,941,126 39,818,690 48,923,687 105,061,601 134,282,919
Expected answer seller 1 , seller 1 , seller 1 , seller 2 , seller 1
Last edited by JBeaucaire; 12-13-2014 at 12:40 PM.
maybe something like this?
=index($A2:$A4,match(max(B2:B4),B2:B4,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you FDIBBINS
Happy to help and thanks for the feedback
Last edited by FDibbins; 12-13-2014 at 12:52 PM.
Assuming the titles are in row1, the data in rows 2-4, this formula in B5, then copied to the right:
=INDEX($A2:$A4, MATCH(MAX(B2:B4), B2:B4, 0))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you too Jbeaucaire ,
what tool did you use to put the table into that manner
Is it the first toolbar before the fx sign toolbar ?
I use a notepad to lay out text with spaces instead of tabs.
Then I paste the results into the Forum and wrap CODE tags around them, CODE tags preserve spacing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks