LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default Find the lowest number?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find the lowest number in a given column smartin Excel Worksheet Functions 8 June 28th 09 08:01 PM
Find the number of the lowest filled row Roberto Villa Real Excel Worksheet Functions 3 May 2nd 08 03:26 PM
How to find the lowest number of a row and delete it automatically awinslow Excel Discussion (Misc queries) 1 October 10th 06 01:20 AM
find the lowest value in a row and add a number to it Kim Excel Worksheet Functions 4 September 28th 05 05:27 PM
how do i find the lowest number in a column in Excel? MKA808 Excel Discussion (Misc queries) 4 August 23rd 05 07:27 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"