•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Highlighting Best Pricing from multiple columns
I feel like I have seen this in the community before but couldn't find an exact solution when I searched. I have to pick out the Most Favored Customer out of a large number of contracts by SKU. I will have 25+ columns that will have loaded in the pricing by SKU and there are thousands of SKUs so filtering and sorting is too much of a bear.
I am using the MIN function to get the best price, is there a way to also highlight the column it picked it from or is it too complicated because of there being potentially multiples of the same value in the columns? Example item 3 has $1.10 in both contract A&C.
[link] [comments]
Want to read more?
Check out the full article on the original site