Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Minimum and Return a Figure
Good morning,
I have in column i from i22 to i whatever a list of amounts. What I would like to do please is find the minimum amount in column i and for the formula to return the figure from column B. Thanks in advance, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Minimum and Return a Figure
Try
=INDEX(B:B,MATCH(MIN(I:I),I:I,0)) -- __________________________________ HTH Bob "Paul Black" wrote in message ... Good morning, I have in column i from i22 to i whatever a list of amounts. What I would like to do please is find the minimum amount in column i and for the formula to return the figure from column B. Thanks in advance, Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Minimum and Return a Figure
On Sep 28, 9:43*am, "Bob Phillips" wrote:
Try =INDEX(B:B,MATCH(MIN(I:I),I:I,0)) -- __________________________________ HTH Bob "Paul Black" wrote in message ... Good morning, I have in column i from i22 to i whatever a list of amounts. What I would like to do please is find the minimum amount in column i and for the formula to return the figure from column B. Thanks in advance, Paul- Hide quoted text - - Show quoted text - Hi Bob, Brilliant, works like a dream. Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning A Minimum Figure | Excel Worksheet Functions | |||
Need help with look up and return minimum value | Excel Discussion (Misc queries) | |||
need help with if statement that calculate minimum figure | Excel Worksheet Functions | |||
minimum a fixed figure when it is lower | New Users to Excel | |||
How do I get "minimum value" in a range to NOT return zero? | Excel Worksheet Functions |