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

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

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