Need to find 22 of the smallest numbers to populate a table R1 R2 and R3 listing from the least to the largest placing them in the 22 lowest table. Also is there a way to simplify my countif's formulas
the project.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | |||
5 | Number Frequency | |||||||
6 | #1 | R1 | #2 | R2 | #3 | R3 | ||
7 | 1 | 6 | 13 | 14 | 25 | 6 | ||
8 | 2 | 8 | 14 | 12 | 26 | 4 | ||
9 | 3 | 10 | 15 | 9 | 27 | 11 | ||
10 | 4 | 10 | 16 | 6 | 28 | 8 | ||
11 | 5 | 10 | 17 | 7 | 29 | 7 | ||
12 | 6 | 10 | 18 | 12 | 30 | 14 | ||
13 | 7 | 8 | 19 | 12 | 31 | 7 | ||
14 | 8 | 9 | 20 | 12 | 32 | 11 | ||
15 | 9 | 7 | 21 | 12 | 33 | 10 | ||
16 | 10 | 14 | 22 | 10 | 34 | 12 | ||
17 | 11 | 13 | 23 | 4 | 35 | 13 | ||
18 | 12 | 9 | 24 | 8 | 36 | 9 | ||
19 | ||||||||
20 | 22 Lowest | |||||||
21 | ||||||||
22 | ||||||||
23 | ||||||||
24 | ||||||||
Overview |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F7 | F7 | =COUNTIF(Data!D:D,1) |
F8 | F8 | =COUNTIF(Data!D:D,2) |
F9 | F9 | =COUNTIF(Data!D:D,3) |
F10 | F10 | =COUNTIF(Data!D:D,4) |
F11 | F11 | =COUNTIF(Data!D:D,5) |
F12 | F12 | =COUNTIF(Data!D:D,6) |
F13 | F13 | =COUNTIF(Data!D:D,7) |
F14 | F14 | =COUNTIF(Data!D:D,8) |
F15 | F15 | =COUNTIF(Data!D:D,9) |
F16 | F16 | =COUNTIF(Data!D:D,10) |
F17 | F17 | =COUNTIF(Data!D:D,11) |
F18 | F18 | =COUNTIF(Data!D:D,12) |
H7 | H7 | =COUNTIF(Data!D:D,13) |
H8 | H8 | =COUNTIF(Data!D:D,14) |
H9 | H9 | =COUNTIF(Data!D:D,15) |
H10 | H10 | =COUNTIF(Data!D:D,16) |
H11 | H11 | =COUNTIF(Data!D:D,17) |
H12 | H12 | =COUNTIF(Data!D:D,18) |
H13 | H13 | =COUNTIF(Data!D:D,19) |
H14 | H14 | =COUNTIF(Data!D:D,20) |
H15 | H15 | =COUNTIF(Data!D:D,21) |
H16 | H16 | =COUNTIF(Data!D:D,22) |
H17 | H17 | =COUNTIF(Data!D:D,23) |
H18 | H18 | =COUNTIF(Data!D:D,24) |
J7 | J7 | =COUNTIF(Data!D:D,25) |
J8 | J8 | =COUNTIF(Data!D:D,26) |
J9 | J9 | =COUNTIF(Data!D:D,27) |
J10 | J10 | =COUNTIF(Data!D:D,28) |
J11 | J11 | =COUNTIF(Data!D:D,29) |
J12 | J12 | =COUNTIF(Data!D:D,30) |
J13 | J13 | =COUNTIF(Data!D:D,31) |
J14 | J14 | =COUNTIF(Data!D:D,32) |
J15 | J15 | =COUNTIF(Data!D:D,33) |
J16 | J16 | =COUNTIF(Data!D:D,34) |
J17 | J17 | =COUNTIF(Data!D:D,35) |
J18 | J18 | =COUNTIF(Data!D:D,36) |