E
evoxfan
I have many columns of different vendors with numbers that sum to a
particular row.
Row/Column: A B C D
1 Vendor1 Vendor2 Vendor3
2 1000 2000 1500
3 500 2000 2000
Totals 1500 4000 3500
"Name of lowest Vendor" "Amount of lowest Vendor"
I want to find the lowest number and display it in a cell and display the
name of the vendor in adjacent cell. What is best way to accomplish this?
Thanks in advance.
particular row.
Row/Column: A B C D
1 Vendor1 Vendor2 Vendor3
2 1000 2000 1500
3 500 2000 2000
Totals 1500 4000 3500
"Name of lowest Vendor" "Amount of lowest Vendor"
I want to find the lowest number and display it in a cell and display the
name of the vendor in adjacent cell. What is best way to accomplish this?
Thanks in advance.