Forum Discussion
finding the least cost number from a group of reference numbers
Hello, I am looking to have excel return the results of the least cost option from reference number 1, then 2 then 3 etc.. We are trying to get optimal results using multiple vendors. Pleas...
Assuming that your data are in columns A, B and C, starting in row 2:
Enter the following formula in another cell in row 2, for example in E2:
=IF($C2=MINIFS($C$2:$C$1000, $A$2:$A$1000, $A2), $B2:$C2, "")
Fill down.