Forum Discussion
Index match Function
please help me out, i need a formula to select column name, on basis of finding the min value . i need a formula to selection-1 and selction-2 for selecting vendor with min values place vendor-...
If you wish to retain the crosstab layout and have Excel 365 you can return a sorted list of vendors using the SORTBY function
= LET(
valuesRanked, SORTBY(Values[#Headers],Values[@]),
INDEX(valuesRanked, {1,2}))With older versions of Excel one is faced with ranking the values, using COUNTIFS as a tie-breaker, and then using MATCH/INDEX to lookup the header.
Note. I paced the value columns in a Table in order to provide structured references to the data.
i have attached a file, my problem is when two vendors have same rate then it should come in O column, like in Australia rate are 13000, but of different vendors but in my formula same Logistics vendor -3 occurs, i want in O column Logistics vendor 5 should come.