DMAX User Function

  • Thread starter Thread starter andibevan
  • Start date Start date
A

andibevan

I have a spreadsheet which logs the scores players achieve in eac
cricket match of a season. Producing something similar to this:-


A B
Mark 74
Matt 33
James45
Mark 36
Matt 64
James134

I need a user function that could be used to produce a table of the to
scores each player has achieved.

i.e.

Name Top Score
Mark X
Matt X
James X

Essentially I need the user function to search column a for all record
that match the selected name and then produces (/outputs) the maximu
value in column B

I have tried to use the DMAX function but can only get it to work fo
one item at a time.

Any help would be gladly receive
 
=MAX((A2:A50="Mark")*(B2:B50))

entered with ctrl + shift & enter
will return Mark's max
You might want to create a unique list with the names using
advanced filter unique records only and copy to another location,
then adjacent using the above formula and replace the hard coded name by
it's cell reference
assume the filtered name list starts in H2, in I2 put

=MAX(($A$2:$A$50=H2)*($B$2:$B$50))

copy down

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Thanks all - particularly to Peo, I have been stuck on this for som
time and needed to find a formula that did this.

Peo:-

Your forumula works great but what does pressing "ctrl + shift & enter
instead of just enter actually do?

Thanks

Andy

:
 
Back
Top