I have a column with 5columns: ItemNumber, Competitor1, Competitor2, Competitor3, Competitor4
The competitor columns have the price for each item number. I want to add 2 more columns: LowestPrice and Competitor.
I want to be able to find the lowest price and who the competitor is.
I used the MIN function but that just gives me the lowest price but how do I find out who the competitor with the lowest price is.
Any ideas? Thanks.