Good day House.
Following the data below
I have 'N Z RR LWC and W' common to each height namely 160, 320, 480, 640 and so on...
I intend to remove the zeros using the RR column for each height and after cleaning, categorise the data set using the RR column into 0.1-2;2.1-4;4.1-10;10.1 above.
i have tried the custom sort which is actually working for the sort and to characterise create data set for each height as a table. but because of the numerous sheet i am working with coupled with the numerous books. Its actually very slow. can someone help on this?
Following the data below
I have 'N Z RR LWC and W' common to each height namely 160, 320, 480, 640 and so on...
I intend to remove the zeros using the RR column for each height and after cleaning, categorise the data set using the RR column into 0.1-2;2.1-4;4.1-10;10.1 above.
i have tried the custom sort which is actually working for the sort and to characterise create data set for each height as a table. but because of the numerous sheet i am working with coupled with the numerous books. Its actually very slow. can someone help on this?
PRACTICE (version 1).xlsb | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | |||
1 | 160 | 320 | 480 | 640 | 800 | 960 | ||||||||||||||||||||||||||||
2 | H | LT | N | Z | RR | LWC | W | N | Z | RR | LWC | W | N | Z | RR | LWC | W | N | Z | RR | LWC | W | N | Z | RR | LWC | W | N | Z | RR | LWC | W | ||
3 | 0 | 72 | 13.4 | 1 | 4 | 2 | 104 | 13.4 | 2 | 1 | 2 | 26 | 10.7 | 3 | 4 | 2.07 | 168 | 8.6 | 3 | 2 | 1.97 | 67 | 10.3 | 1 | 3 | 1.89 | 104 | 2 | 3 | 4 | 1 | |||
4 | 100 | 30 | 11.5 | 3 | 2 | 2.98 | 191 | 11.5 | 2 | 1 | 2.98 | 80 | 13.3 | 3 | 1 | 2.79 | 36 | 10.9 | 1 | 1 | 1.94 | 98 | 9.4 | 3 | 1 | 3.12 | 154 | 2 | 2 | 4 | 2 | |||
5 | 200 | 196 | 12.9 | 1 | 4 | 2.63 | 105 | 12.9 | 2 | 3 | 2.63 | 24 | 12 | 2 | 1 | 2.38 | 176 | 12.1 | 2 | 4 | 2.33 | 123 | 10.9 | 1 | 4 | 2.24 | 81 | 4 | 4 | 4 | 2 | |||
6 | 300 | 77 | 12.3 | 2 | 2 | 2.96 | 192 | 12.3 | 2 | 3 | 2.96 | 174 | 12.8 | 4 | 1 | 2.93 | 74 | 11.9 | 3 | 2 | 1.89 | 40 | 10.4 | 4 | 2 | 2.16 | 91 | 1 | 4 | 3 | 2 | |||
7 | 400 | 113 | 11.7 | 2 | 2 | 2.14 | 130 | 11.7 | 3 | 1 | 2.14 | 111 | 11.1 | 4 | 1 | 2.27 | 141 | 11.2 | 3 | 1 | 2.29 | 185 | 9.1 | 3 | 3 | 2.55 | 99 | 4 | 4 | 2 | 4 | |||
8 | 500 | 200 | 10.6 | 4 | 4 | 2.64 | 93 | 10.6 | 4 | 2 | 2.64 | 139 | 10.1 | 4 | 1 | 1.77 | 67 | 11 | 3 | 2 | 2.18 | 191 | 10.8 | 4 | 3 | 1.88 | 197 | 2 | 4 | 2 | 1 | |||
9 | 600 | 58 | 12 | 2 | 2 | 2.57 | 35 | 12 | 3 | 2 | 2.57 | 73 | 12.1 | 1 | 2 | 1.83 | 75 | 10.2 | 3 | 4 | 2.19 | 97 | 9.6 | 4 | 1 | 2.43 | 82 | 4 | 2 | 4 | 3 | |||
10 | 700 | 97 | 11.6 | 1 | 1 | 3.03 | 126 | 11.6 | 2 | 4 | 3.03 | 69 | 12 | 2 | 1 | 2.9 | 25 | 11.9 | 4 | 1 | 2.14 | 80 | 9.6 | 2 | 3 | 2.61 | 53 | 4 | 3 | 3 | 2 | |||
11 | 800 | 42 | 12.3 | 3 | 1 | 2.43 | 30 | 12.3 | 2 | 3 | 2.43 | 154 | 12.5 | 2 | 4 | 1.92 | 99 | 10.4 | 1 | 2 | 2.05 | 187 | 8.2 | 3 | 4 | 1.85 | 106 | 1 | 4 | 1 | 2 | |||
12 | 900 | 94 | 10.9 | 4 | 4 | 2.21 | 187 | 10.9 | 1 | 2 | 2.21 | 100 | 10.5 | 1 | 4 | 2.65 | 137 | 11.7 | 3 | 3 | 3.32 | 109 | 10.5 | 4 | 1 | 3.18 | 130 | 3 | 3 | 1 | 3 | |||
13 | 1000 | 173 | 13.4 | 2 | 3 | 2.83 | 109 | 13.4 | 4 | 4 | 2.83 | 153 | 11.1 | 4 | 3 | 2.24 | 90 | 10.2 | 2 | 4 | 2.3 | 178 | 9.9 | 3 | 1 | 3.13 | 54 | 4 | 4 | 3 | 3 | |||
14 | 1100 | 167 | 13.3 | 2 | 4 | 2.07 | 55 | 13.3 | 1 | 2 | 2.07 | 107 | 9.9 | 2 | 2 | 2.67 | 50 | 9.7 | 3 | 1 | 2.72 | 132 | 7.6 | 2 | 2 | 2.13 | 120 | 1 | 3 | 3 | 4 | |||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
W3:W14,R3:R14,M3:M14,H3:H14,C3:C14,AB3:AB14 | C3 | =RANDBETWEEN(20,200) |
AC3:AF14,Y3:Z14,T3:U14,O3:P14,J3:K14,E3:F14 | E3 | =RANDBETWEEN(1,4) |
B4:B14 | B4 | =B3+100 |