Formula on b4 to drag writePlease Login or Register to view this content.
Expected answer seller 1 , seller 1 , seller 1 , seller 2 , seller 1
Formula on b4 to drag writePlease Login or Register to view this content.
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 the icon 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)
Bookmarks