Finding the maximum values in a series
Large?
What access version is that?
--
Regards,
Bas Cost Budde, Holland
website: http://utopia.knoware.nl/users/hegedu
Quote:
>>Subject: Finding the maximum values in a series
>>Date: 3/7/00 4:30 PM Central Standard Time
>>Hi all. There is a function in Excel (though I'll be hanged if I can
>>remember its name!) to extract the maximun values out of a series eg
>>1,3,1,2,4,3,5 would return 3, 4 & 5. Anyone done something similar in
VBA?
>>Thanks
>>Fionnbarr
>Max() returns the largest; Large(,n) returns the n-th largest.
>HTH,
>Merjet