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?
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?