Find Vendor with most sales

Hi All,

It's hard to explain a few of the questions I have. The main one is I am trying to find the vendor that has the most sales within the highest selling segment. It probably will be easier to see in the attached excel document.

Also if anyone knows how to change this formula so it works for positive AND negative numbers - that would be a huge help.

=IF(F27 < 1000,F27,IF(F27 < 1000000,
"$" & ROUND(F27/1000,0) & "K",
"$" & ROUND(F27/1000000,1) & "M"))

Thanks in advance!!

Sean

Formula change

=IF(ABS(F2) < 1000,F2,IF(ABS(F2) < 1000000,
"$" & ROUND(F2/1000,0) & "K",
"$" & ROUND(F2/1000000,1) & "M"))

For the Vendor/segment calculation you will require "helper" columns: is this OK (maybe separate sheet).

What is max no, of Vendors and max no, of segments?

Thank you! That would work as long as I wouldn't have to touch the separate sheet each week when the data refreshes?

I actually figured it out! (The columns might be different in the file I sent because I am working on another one but this worked!)

=INDEX(S:S,MATCH(MAX(W:W),W:W,0))

Thanks for your help!