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

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

<FREUQUENCY()

make that

FREQUENCY()

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
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

Assuming that the numbers are in A2:A200

B2: = A1
B3: enter

=IF(ISERROR(MATCH(0,COUNTIF(B$2:B2,$A$2:$A$200&"") ,0)),"",
INDEX(IF(ISBLANK($A$2:$A$200),"",$A$2:$A$200),MATC H(0,COUNTIF(B$2:B2,$A$2:$A
$200&""),0)))

as an array formula, so commit with Ctrl-Shift-Enter

Copy this as far down column B as you think you might have unique values in
column A

Select C2:Cn, where n is the number of uniques previously estimate (I have
estimated down to 10 for this exercise), and then in the formula bar enter
this formula

=IF($B$2:$B$10<"",FREQUENCY($A$2:$A$200,$B$2:$B$1 0),"")

again an array formula, committed with Ctrl-Shift-Enter
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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