sorting and filtering

[Dupsy]

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?

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

 

[queuesmef]

if you Normalized your data (like database) you may have better results sorting. if possible try this.. you might try putting into a Pivot table too? (note i did NOT totally complete the table)