Look in HELP for the FREUQUENCY() function

--
Kind regards,

Niek Otten

"Pivotrend" wrote
in message ...

hello


how do i find out the most frequently occurring value, digit, or number
in a set of rows & columns ?
then i need to find out the second most occurring value then the 3rd

then find the least frequently occurring value
then the second least occurring value then the 3rd


thanx...


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile:
http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=495720