I have a list with items in the rows, suppliers email me their prices which I then paste in the columns.
I want to know which supplier gives me the lowest price for an item without having to look at all the prices in the row. First I sorted horizontally, but I cannot do this for the entire list
since it wil sort the prices, but not the supplier name, since that is different each time.
I then added a new colum and used the formula MIN, now at least I can see the lowest prices, but I would love to have a formula to also show me the name of the supplier beloning to that prices. (supplier names are all in row 1).
Bookmarks