Conditional Min Value
 

If I have data like the following:

Name Month Sales
Bob June 500
Bob July 700
Bob April 600
Jane June 300
Jane July 900

Is there a way to return the value of an individual's smallest sales number
from the list? The number of times any person's name appears varies and
isn't necessarily sorted by Name.

Thanks,

Conditional Min Value
 

With
Your posted sample data in A1:C6

Try one of these:
D1: =SUMPRODUCT(MIN((A2:A6="bob")*C2:C6+(A2:A6<"bob") *10^99))
(Commit that formula by just pressing [enter]

or this ARRAY FORMULA
D1: =MIN(IF(A2:A6="Bob",C2:C6,10^99))

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Instead of typing "Bob", you could also just reference a cell containing the
name to find.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"VictorMuraw" wrote:

If I have data like the following:

Name Month Sales
Bob June 500
Bob July 700
Bob April 600
Jane June 300
Jane July 900

Is there a way to return the value of an individual's smallest sales number
from the list? The number of times any person's name appears varies and
isn't necessarily sorted by Name.

Thanks,

Conditional Min Value
 

Yes - it worked. I went with the Array option as the first one looked a
little out of my league. Thanks.

"Ron Coderre" wrote:

With
Your posted sample data in A1:C6

Try one of these:
D1: =SUMPRODUCT(MIN((A2:A6="bob")*C2:C6+(A2:A6<"bob") *10^99))
(Commit that formula by just pressing [enter]

or this ARRAY FORMULA
D1: =MIN(IF(A2:A6="Bob",C2:C6,10^99))

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Instead of typing "Bob", you could also just reference a cell containing the
name to find.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"VictorMuraw" wrote:

If I have data like the following:

Name Month Sales
Bob June 500
Bob July 700
Bob April 600
Jane June 300
Jane July 900

Is there a way to return the value of an individual's smallest sales number
from the list? The number of times any person's name appears varies and
isn't necessarily sorted by Name.

Thanks,