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