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