FUNCTION ?

[Guest]

? 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

 

[JE McGimpsey]

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,6000,7000,8000,9000})

 

[David Biddulph]

.... 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)?