anyone any good at excel?
basically i have a table of prices for various parts from different suppliers, i want it to pick the cheapest supplier for each part and highlight it, then give me a total cost of all the cheapest parts.
is this possible?
basically i have a table of prices for various parts from different suppliers, i want it to pick the cheapest supplier for each part and highlight it, then give me a total cost of all the cheapest parts.
is this possible?