Hi-

Yes, I am interested in seeing your formula method. I can
probably learn something from it.

Thanks
-----Original Message-----

Golfer Wrote:
Hi-

The corresponding date of the minimum value for a
specific
year.

There can be multiple dates witin the same year that
also
have the same hdcp -

6/5/1972 10
7/2/1972 10

Since this is a very complex formula I would expect the
returned value be the earliest date by default.
...



I'd think you'd want them all, not just one earliest or
not.

There is a formula system I posted at numerous occasions
which is
capable of returning a Top N list (N = 1, 2, ...) when no
additional
conditions involved (like year in your case). The system
delivers the
same results as an appropriately built pivot table.
Approaching the
problem of the dates list corresponding to the minimum
handicap in a
given year or every year in the data using pivot tables
is a route you
could take. The formula system I mentioned can be adapted
in order to
create a conditional list of dates (all dates in a year
associated with
the minimum handicap in that year), but it would be quite
unnerving. If
interested, we can take up the formula route. Just to
recap the
expected product: Given...

Date Handicap
1/1/1970 10
3/5/1970 9
3/7/1970 9
1/1/1971 15
5/1/1971 12
1/1/1972 11
6/5/1972 10
8/7/1972 10

we should get a llist consisting of:

3/5/1970
3/7/1970

for 1970...

5/1/1971

for 1971...

6/5/1972
8/7/1972

for 1972.


--
Aladin Akyurek
----------------------------------------------------------
--------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=278211

.