View Single Post
  #1  
Old March 18th, 2010, 04:35 PM posted to microsoft.public.excel.worksheet.functions
ker_01
external usenet poster
 
Posts: 87
Default Sumproduct but only first time corresponding value is seen e.g. un

Using XL03

Sample Data:

Name Race Speed Avg Speed Track Month
Joe 2:12 2:15 OFCF Jan
Joe 2:28 2:15 ADL Feb
Mary 2:14 2:07 ADL Jan
Joe 2:15 2:15 ADL Feb
etc

I already have sumproducts in place to count how many participants raced in
each month, how many at each track, etc.

The last piece I need to add is the number of people for a given track on a
given month, who had an /average/ time of over 2 minutes. But, I have
repeats- the same person can run a track more than once in the same month, so
their average comes across more than once and skews the total count.

Is there a straightforward way to only count the "unique" value combinations
(first time for combo of person, track, month) and ignore all subsequent
races by that person on the same track/month in the sumproduct count?

Thank you!
Keith