Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find the lowest number in a given column | Excel Worksheet Functions | |||
Find the number of the lowest filled row | Excel Worksheet Functions | |||
How to find the lowest number of a row and delete it automatically | Excel Discussion (Misc queries) | |||
find the lowest value in a row and add a number to it | Excel Worksheet Functions | |||
how do i find the lowest number in a column in Excel? | Excel Discussion (Misc queries) |