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
Jeng Chi Order Guide 2024 - Copy.xlsm
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?
