software

hellohow do i find out the most frequently occurring value, digit, or number
in a set of rows amp; 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 3rdthanx...--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: www.excelforum.com/member.php...foamp;userid=4062
View this thread: www.excelforum.com/showthread...hreadid=495720Look in HELP for the FREUQUENCY() function

--
Kind regards,

Niek Otten

quot;Pivotrendquot; gt; wrote
in message ...
gt;
gt; hello
gt;
gt;
gt; how do i find out the most frequently occurring value, digit, or number
gt; in a set of rows amp; columns ?
gt; then i need to find out the second most occurring value then the 3rd
gt;
gt; then find the least frequently occurring value
gt; then the second least occurring value then the 3rd
gt;
gt;
gt; thanx...
gt;
gt;
gt; --
gt; Pivotrend
gt; ------------------------------------------------------------------------
gt; Pivotrend's Profile:
gt; www.excelforum.com/member.php...foamp;userid=4062
gt; View this thread: www.excelforum.com/showthread...hreadid=495720
gt;
lt;FREUQUENCY()gt;

make that

FREQUENCY()

--
Kind regards,

Niek Otten

quot;Niek Ottenquot; gt; wrote in message
...
gt; Look in HELP for the FREUQUENCY() function
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Pivotrendquot; gt; wrote
gt; in message ...
gt;gt;
gt;gt; hello
gt;gt;
gt;gt;
gt;gt; how do i find out the most frequently occurring value, digit, or number
gt;gt; in a set of rows amp; columns ?
gt;gt; then i need to find out the second most occurring value then the 3rd
gt;gt;
gt;gt; then find the least frequently occurring value
gt;gt; then the second least occurring value then the 3rd
gt;gt;
gt;gt;
gt;gt; thanx...
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Pivotrend
gt;gt; ------------------------------------------------------------------------
gt;gt; Pivotrend's Profile:
gt;gt; www.excelforum.com/member.php...foamp;userid=4062
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=495720
gt;gt;
gt;
gt;
Assuming that the numbers are in A2:A200

B2: = A1
B3: enter

=IF(ISERROR(MATCH(0,COUNTIF(B$2:B2,$A$2:$A$200amp;quot;quot;) ,0)),quot;quot;,
INDEX(IF(ISBLANK($A$2:$A$200),quot;quot;,$A$2:$A$200),MATC H(0,COUNTIF(B$2:B2,$A$2:$A
$200amp;quot;quot;),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$10lt;gt;quot;quot;,FREQUENCY($A$2:$A$200,$B$2:$B$1 0),quot;quot;)

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

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Pivotrendquot; gt; wrote
in message ...
gt;
gt; hello
gt;
gt;
gt; how do i find out the most frequently occurring value, digit, or number
gt; in a set of rows amp; columns ?
gt; then i need to find out the second most occurring value then the 3rd
gt;
gt; then find the least frequently occurring value
gt; then the second least occurring value then the 3rd
gt;
gt;
gt; thanx...
gt;
gt;
gt; --
gt; Pivotrend
gt; ------------------------------------------------------------------------
gt; Pivotrend's Profile:
www.excelforum.com/member.php...foamp;userid=4062
gt; View this thread: www.excelforum.com/showthread...hreadid=495720
gt;