? to the experts
In a workbook I have 1000 A1 to A1000 cells each has a 4 digit number
example A1=2313, A2=9876 A3=9144 and so on .
What formula or procedure can I use to determine the frequency of the first
digit of neach number of each cell?
thx
joseph robert

One way:

Take a look at the FREQUENCY function in XL Help.

E.G., Array-enter (CTRL-SHIFT-ENTER or CMD-RETURN) into a range of 10
cells:

=FREQUENCY(A1:A1000,{0,1000,2000,3000,4000,5000,60 00,7000,8000,9000})






In article ,
joseph robert wrote:

? to the experts
In a workbook I have 1000 A1 to A1000 cells each has a 4 digit number
example A1=2313, A2=9876 A3=9144 and so on .
What formula or procedure can I use to determine the frequency of the first
digit of neach number of each cell?
thx
joseph robert

.... or should it be
=FREQUENCY(A1:A1000,{999,1999,2999,3999,4999,5999, 6999,7999,8999})
(only 9 elements in the second array if using only 10 cells, & 999 rather
than 1000 because it looks for values less than OR EQUAL TO the specified
element)?
--
David Biddulph
"JE McGimpsey" wrote in message
...
One way:

Take a look at the FREQUENCY function in XL Help.

E.G., Array-enter (CTRL-SHIFT-ENTER or CMD-RETURN) into a range of 10
cells:

=FREQUENCY(A1:A1000,{0,1000,2000,3000,4000,5000,60 00,7000,8000,9000})

In article ,
joseph robert wrote:

? to the experts
In a workbook I have 1000 A1 to A1000 cells each has a 4 digit number
example A1=2313, A2=9876 A3=9144 and so on .
What formula or procedure can I use to determine the frequency of the
first
digit of neach number of each cell?
thx
joseph robert