How to find the second most frequent datum in a list?

I have a list of numbers in a column (say, Column A).
What should I do if I want to find the second most frequent datum in the
list and store it in B1?
Thanks in advance.

On Wed, 16 Mar 2005 13:58:37 +0800, "Sam" <[email protected]> wrote:

>I have a list of numbers in a column (say, Column A).
>What should I do if I want to find the second most frequent datum in the
>list and store it in B1?
>Thanks in advance.
>

How do you want to handle different datums that are equally frequent?

For example, let us say that out of an array of 1000 data points, the numbers
14, 48 and 16 all occur 8 times and the numbers 12, 19 and 23 all occur 7
times. What kind of a result would you want in B1?


--ron

Unrelated to the subject, but where did you find the OP's post, Ron? It
does not appear to be archived in Google (despite no mention of an
attachment), nor am I able to find any other messages with this subject
or any messages from Sam on 16 Mar among the headers from my news server.

Jerry

Ron Rosenfeld wrote:

> On Wed, 16 Mar 2005 13:58:37 +0800, "Sam" <[email protected]> wrote:
>
>
>>I have a list of numbers in a column (say, Column A).
>>What should I do if I want to find the second most frequent datum in the
>>list and store it in B1?
>>Thanks in advance.
>>
>>
>
> How do you want to handle different datums that are equally frequent?
>
> For example, let us say that out of an array of 1000 data points, the numbers
> 14, 48 and 16 all occur 8 times and the numbers 12, 19 and 23 all occur 7
> times. What kind of a result would you want in B1?
>
>
> --ron

On Sun, 20 Mar 2005 07:51:30 -0500, "Jerry W. Lewis"
<post_a_reply@no_e-mail.com> wrote:

>Unrelated to the subject, but where did you find the OP's post, Ron? It
>does not appear to be archived in Google (despite no mention of an
>attachment), nor am I able to find any other messages with this subject
>or any messages from Sam on 16 Mar among the headers from my news server.
>
>Jerry

Jerry,

I use Agent for my newsreader and, for the microsoft news groups, I have it
pointed at msnews.microsoft.com for the "news server".

It just showed up as a new posting this morning.

However, even with this setup, I have noted rarely that an OP's posting doesn't
show up. If I've been interested, I've been able to find it. And I've assumed
that I did not see it perhaps due to one of my filters.

In any event, the full header of the OP's initial message as it exists in Agent
(along with the message) follows:

===================================
From: "Sam" <[email protected]>
Newsgroups: microsoft.public.excel
Subject: How to find the second most frequent datum in a list?
Date: Wed, 16 Mar 2005 13:58:37 +0800
Organization: IMS Netvigator
Lines: 6
Message-ID: <[email protected]>
NNTP-Posting-Host: pcd576017.netvigator.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Path:
TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsgate.netvigator.com!imsp212.netvigator.com!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.excel:42462
--------------------------------------
I have a list of numbers in a column (say, Column A).
What should I do if I want to find the second most frequent datum in the
list and store it in B1?
Thanks in advance.
======================================


--ron