Returning a minimum value from a list of changing length

asawhill

New Member
Joined
Jul 26, 2004
Messages
8
Hello -

I am using Excel 2002 and I am trying to return the minimum value from a given list that is dynamic in length. For example, if my list was comprised of the values 5, 6, 7, 8, 9, and 10, then the value I would want returned is 5. However, if I add a value so that the list is now 5, 6, 7 8, 9, 10, and 2, then I would want the value 2 returned. My trouble isn't getting the minimum value -- it's figuring out how to automatically adjust to a list that will expand or contract in length. Any ideas?
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
asawhill said:
Hello -

I am using Excel 2002 and I am trying to return the minimum value from a given list that is dynamic in length. For example, if my list was comprised of the values 5, 6, 7, 8, 9, and 10, then the value I would want returned is 5. However, if I add a value so that the list is now 5, 6, 7 8, 9, 10, and 2, then I would want the value 2 returned. My trouble isn't getting the minimum value -- it's figuring out how to automatically adjust to a list that will expand or contract in length. Any ideas?

Assuming that the list starts in A2...

=MIN(A2:INDEX(A2:A65536,MATCH(9.99999999999999E+307,A2:A65536)))
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,493
Office Version
  1. 365
Platform
  1. Windows
Why not just =MIN(A:A)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top