View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VictorMuraw VictorMuraw is offline
external usenet poster
 
Posts: 2
Default 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,