There is a list of numbers in column A, and list out the possible numbers in
column B, but the list does not contain a fixed number of samples, and the
number does not fixed within any range. On the other words, sometimes, there
are 100 numbers, or 1000 numbers and the number can be any digits in length
I would like to measure the frequency on the listed numbers, if I input
{=Frequency(A:A,B:B)} on column C then #N/A occurs because some cells do not
contain any value for trying to measure frequency.
Does anyone have any suggestions on how to set condition for frequency? if
the cell is blank, then skip measure frequency for this cell only.
Thank for any suggestions
Eric

1. If column B is either text or blank, then apply an AutoFilter to column B
to display only the rows with non-blank entries in column B.

2. Print the range.

3. Remove the AutoFilter
--
Gary's Student
gsnu200712

Sorry wrong question

Ignore first post
--
Gary''s Student
gsnu200712


"Gary''s Student" wrote:

1. If column B is either text or blank, then apply an AutoFilter to column B
to display only the rows with non-blank entries in column B.

2. Print the range.

3. Remove the AutoFilter
--
Gary's Student
gsnu200712

See my response in excel.worksheet.functions

In article ,
Eric wrote:

There is a list of numbers in column A, and list out the possible numbers in
column B, but the list does not contain a fixed number of samples, and the
number does not fixed within any range. On the other words, sometimes, there
are 100 numbers, or 1000 numbers and the number can be any digits in length
I would like to measure the frequency on the listed numbers, if I input
{=Frequency(A:A,B:B)} on column C then #N/A occurs because some cells do not
contain any value for trying to measure frequency.
Does anyone have any suggestions on how to set condition for frequency? if
the cell is blank, then skip measure frequency for this cell only.
Thank for any suggestions
Eric

[1] Let describe more about the question ---

There is a list of numbers in column A, but the list does not contain a
fixed number of samples, and the number does not fixed within any range. On
the other words, sometimes, there are 100 numbers, or 1000 numbers and the
number can be any digits in length.

[2] What I want to do ---

I would like to measure the frequency on the listed numbers. Firstly, how to
list out all the possible numbers under column B within the list, and then
measure the frequency of occurrence of those numbers under column C, but the
amount of possible numbers is unknown for column B, if I input
{=Frequency(A:A,B:B)} on column C then #N/A occurs because some cells do not
contain any value.

Does anyone have any suggestions on how to measure frequency?
Thank for any suggestions
Eric