I need a excel/google sheets formula/script to compare the values of:
Which ever is the cheapest (ignore cell if there is no data in it to compare):
1 put the value in (I2) and olour code to the supplier
2, Show the diference in value to the next cheapest supplier in (J2)
Được trao cho:
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
11 freelancer đang chào giá trung bình $22 cho công việc này
I have the expertise and experience using Excel and google sheets formulas for data analysis and conditionally updating relevant cells with codes or text. Ready to start work immediately.
How about something like a simple macro that opens the list, does the calculation, then saves the list (perhaps changing the filename to indicate it has been processed).
Hello! I am a native English speaker from the US who is an Excel/Google Sheets expert. I can easily help you solve this problem right away! Let me know if you have any questions for me!