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