•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
Tagged with
#rows.com
#Excel compatibility
#large dataset processing
#Excel alternatives for data analysis
#Excel alternatives
#pricing
#SKU
#best price
#Most Favored Customer
#MIN function
#columns
#contracts
#highlight
#filtering
#sorting
#multiple values
#value
#contract A
#contract C
#data