Forum Discussion
EXCEL HELP FORMULA
The goal is to get the max price item from the OrderPriceTracker from vendor.
Please and thank you for helping me
https://1drv.ms/x/s!AmU4zfB4So9SiIwe5kSJkcyDJcZLTg?e=9rq35R
5 Replies
I added a helper column. The formula then becomes relatively straight-forward. See the attached version.
but Now i have the max price but I need to assign this price who's vendor has this price ?
with this specific item!!, for example if the Chili Garlic Sauce needs to see in Formosa has $ 55
Please and thank you !!!
What I am looking for is to track all the prices from my vendors, One item can sold for different vendors, but I will choose the cheapest. But in the end my goal is to see the order tracking price for a specific week, or month
Thank you for your help
What should the result look like?
