Forum Discussion

dtiede's avatar
dtiede
Copper Contributor
May 20, 2024

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...
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
May 21, 2024

dtiede If you are on Microsoft-365 then could try single cell dynamic array formula.

=HSTACK(
MAP(B2:B10,C2:C10,D2:D10,LAMBDA(x,y,z,IF(MINIFS(D2:D10,B2:B10,x)=z,y,""))),
MAP(B2:B10,C2:C10,D2:D10,LAMBDA(x,y,z,IF(MINIFS(D2:D10,B2:B10,x)=z,z,"")))
)

 

 

Resources