excel - Collecting the first digit of 1000 random numbers and putting each 9 digits into frequency -


I have created 1000 random numbers under a spreadsheet (A1, A1000), but I search for the amount of time each time The first issue comes up. Issue 2 / />

Example

  12345 1354 2849   

Digitally comes twice,
Points 2 comes up once in the B1 :

 C1  in  = LEFT (A1,1 ) Enter   

and copy

:

  = COUNTIF ($ B $ 1: $ B $ 1000, ROW ( ))   

and C9 / ht Ml>

Comments

Popular posts from this blog

c++ - Cmake produces file extensions in static library archives -

c# - Roxy file manager in MVC doesn't accept session path -

c# - Check if a NumericUpDown has no value -