View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pivotrend
 
Posts: n/a
Default most frequently occurring value


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