LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 90
Default Return the 2 lowest numbers within a range

Hey,
How can search a range of numbers (ex. E15:I15) and have it find the 2
lowest numbers in the range (most likely 0 and 0) and give me the header
number at the top of the column. And if there's more than 2, give me all of
the lowest possible numbers.

Ex.
Headers - 1 2 3 4 8
1 0 1 2 0

Then I would want the formula to give me the header of that row which the
two 0's are in (so it would give me "2,8".

Thanks!
Matt

 
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
lookup range of numbers; return corresponding data for the fixed r mmpfa07 Excel Worksheet Functions 1 May 2nd 07 07:33 PM
I need to return the lowest time value in a range of cells. al elkins Excel Worksheet Functions 2 January 26th 07 06:24 AM
How to return a single value for a range of numbers Tami Excel Worksheet Functions 3 January 13th 06 02:34 AM
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc jwebb Excel Discussion (Misc queries) 2 March 9th 05 12:38 PM
How can I get the lowest price, second lowest etc. from a range o. Robin Excel Worksheet Functions 2 November 9th 04 12:23 PM


All times are GMT +1. The time now is 02:58 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"