Forum Discussion
swstr510
May 24, 2021Copper Contributor
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-...
tusharm10
May 24, 2021Brass Contributor
* What happens if there are 3 or more vendors that match the minimum value?
* You will be much better off if you can reorganize the data to the format
| place | vendor | value |
| usa | vendor-1 | 4000 |
| usa | vendor-2 | 2000 |
| etc. |
If you can do that, there are fairly straightforward approaches to consider.