Conditional TRIMMEAN

[Aletor]

Hi everyone,

I am trying to calculate a "conditional" trimmed mean where I only get the trimmed mean for that data within a dataset that meets certain criteria; in this example, data that falls within certain intervals.

I have attached a mini-sheet to illustrate what I mean. I want to be able to change the interval values (in I3/J3 and L3/M3) and calculate the trimmed mean for the "% increase" for those samples that fall within the specified intervals. The trimmed mean should exclude the top/bottom 10%.

I have been trying to solve this for days, surely there must be an expert out there who can help me out

Thanks,
Alex

TRIMMEAN.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Date	Name	Marketcap	Price	% Increase				Marketcap Interval			Price Interval			TRIMMEAN
2	2021-03-08	PSLV	N/A	9.05	0.994475138				>	<=		>	<=		?
3	2021-03-08	CLNY	3190	6.05	5.289256198				100	300		0.1	5
4	2021-03-08	SFIX	4940	74.92	1.147891084
5	2021-03-08	STL	4370	N/A	N/A
6	2021-03-08	U	27050	95.54	4.908938664
7	2021-03-08	BBBY	3680	28.06	11.72487527
8	2021-03-08	AVGR	138.18	1.46	7.534246575
9	2021-03-08	FEYE	4770	19.56	1.687116564
10	2021-03-08	NHIC	182.85	10.5	0
11	2021-03-08	ENDP	1820	7.05	11.34751773
12	2021-03-08	PBF	1840	16.88	3.376777251
13	2021-03-08	RMO	1540	9.81	4.587155963
14	2021-03-08	CLDR	4620	14.79	0.473292765
15	2021-03-08	VXRT	755.08	6.11	6.710310966
16	2021-03-08	DDD	3340	24.8	3.306451613
17	2021-03-08	RPRX	27820	43.8	3.607305936
18	2021-03-08	VLDR	2210	12.83	3.273577553
19	2021-03-08	AKBA	538.78	3.53	0
20	2021-03-08	MNKD	864.99	3.66	3.551912568
21	2021-03-08	NXTD	72.68	1.47	2.040816327
22	2021-03-08	ABML	N/A	2.19	8.219178082
23	2021-03-08	MDLA	5160	31.03	0.870125685
24	2021-03-08	MFA	1860	4.02	4.726368159
25	2021-03-08	PK	5130	21.1	4.218009479
26	2021-03-08	NYMT	1680	4.28	3.271028037
27	2021-03-08	UAMY	147.63	1.2	3.333333333
28	2021-03-08	CLNE	2450	11.62	4.13080895
29	2021-03-08	BLNK	1440	30.3	9.240924092
30	2021-03-08	AYRO	230.4	5.91	8.798646362
31	2021-03-08	OPK	3010	4.21	5.700712589
32	2021-03-08	IBIO	352.41	1.44	7.638888889
33	2021-03-08	EB	2140	20.25	10.71604938
34	2021-03-08	ATOS	177.5	2.26	1.327433628
35	2021-03-08	BTG	4740	4.54	-0.220264317
36	2021-03-08	EQT	5030	18.08	0.940265487
37	2021-03-08	RIDE	3030	16.69	8.088675854
38	2021-03-08	DPW	102.21	3.12	5.448717949
39	2021-03-08	SDC	4470	10.01	8.291708292
40	2021-03-08	BORR	322.11	1.23	2.43902439
41	2021-03-08	FPRX	1670	37.75	0.529801325
42	2021-03-08	UAA	9380	22.62	4.199823165
43	2021-03-08	EAF	3200	11.51	3.909643788
44	2021-03-08	KOPN	723.96	7.94	6.675062972
45	2021-03-08	BRK/B	N/A	255	2.050980392
46	2021-03-08	HL	3120	5.92	0.168918919
47	2021-03-08	AR	2770	9.95	2.211055276
48	2021-03-08	SAVE	3690	35.34	5.121675156
49	2021-03-08	GLSI	404.05	23	130.3478261
50	2021-03-08	MOTS	42.11	1.16	19.82758621
51	2021-03-08	MAC	2290	13.51	1.258327165
52	2021-03-08	ANAB	496.28	18.5	10.27027027
53	2021-03-08	BLDP	7020	22.18	4.283137962
54	2021-03-08	OGI	717.38	2.74	6.569343066
55	2021-03-08	VUZI	766.47	16.94	0.944510035
56	2021-03-08	NGD	1150	1.6	6.25
57	2021-03-08	WTRH	297.68	3.33	9.309309309
58	2021-03-08	ESGC	453.54	1.99	5.025125628
59	2021-03-08	AEO	4660	28.95	3.66148532
60	2021-03-08	CPG	2280	4.4	1.136363636
61	2021-03-08	TSNPD	N/A	3.7	0
62	2021-03-08	UWMC	14010	8.75	0.342857143
63	2021-03-08	SOLO	604.64	5.21	4.222648752
64	2021-03-08	REI	201	2.68	3.358208955
65	2021-03-08	XL	1530	11.37	2.726473175
66	2021-03-08	TELL	975.66	2.27	3.524229075
67	2021-03-08	MIK	3250	21.65	1.29330254
68	2021-03-08	MBI	526.98	8.49	19.43462898
69	2021-03-08	NOVN	229.39	1.61	0.621118012
70	2021-03-08	SHIP	178.8	1.13	2.654867257
71	2021-03-08	WTI	445.78	4.61	1.952277657
72	2021-03-08	SLGG	163.17	5.36	3.917910448
73	2021-03-08	MVIS	2130	12.79	3.674745895
74	2021-03-08	Al	5520	88	5.681818182
75	2021-03-08	FTI	3660	9.06	2.428256071
76	2021-03-08	MICT	166.38	1.86	3.76344086
77	2021-03-08	VISL	140.28	3.02	8.940397351
78	2021-03-08	ACB	2030	9.67	2.481902792
79	2021-03-08	QEP	966.58	4.42	0
80	2021-03-08	RWLK	103.07	2.62	25.19083969
81	2021-03-08	INO	2020	9.16	3.165938865
82	2021-03-08	KOSS	141.05	15.68	29.9744898
83	2021-03-08	TXMD	500.52	1.4	0.714285714
84	2021-03-08	SRNE	2730	9.18	0.762527233
85	2021-03-08	TTOO	302.92	1.7	1.764705882
86	2021-03-08	WISH	9620	17.81	2.077484559
87	2021-03-08	CHS	389.08	2.33	33.9055794
88	2021-03-08	SABR	5200	15.42	4.798962387
89	2021-03-08	CTXR	238.77	1.8	6.666666667
90	2021-03-08	WEN	4450	19.73	5.625950329
91	2021-03-08	AUY	4290	4.25	2.117647059
92	2021-03-08	FUBO	2090	29.73	4.843592331
93	2021-03-08	AIKI	90.39	1.06	7.547169811
94	2021-03-08	TNXP	353.45	1.03	6.796116505
95	2021-03-08	AMRX	1750	5.15	10.48543689
96	2021-03-08	OPEN	13750	21.38	5.986903648
97	2021-03-08	IVR	886.38	3.79	2.638522427
98	2021-03-08	OPTT	119.69	2.91	27.14776632
99	2021-03-08	AHT	200.48	2.86	11.18881119
100	2021-03-08	IMVT	1550	19.4	0.463917526
101	2021-03-08	FSR	6520	22.86	3.105861767
102	2021-03-08	ITRM	197.78	1.42	8.450704225
103	2021-03-08	APHA	5750	15.71	6.301718651
104	2021-03-08	CDEV	1480	5.06	7.312252964
105	2021-03-08	KOS	1260	3.46	2.023121387
106	2021-03-08	SLNO	108.98	1.63	4.294478528
107	2021-03-08	DGLY	74.45	1.75	16.57142857
108	2021-03-08	TRCH	323.49	2.28	7.01754386
109	2021-03-08	ASXC	551.25	3.86	8.031088083
110	2021-03-08	DNN	744.79	1.02	2.941176471
111	2021-03-08	MARA	3680	31.49	3.048586853
112	2021-03-08	GSAT	2640	1.38	7.971014493
113	2021-03-08	RIOT	3870	42.37	3.021005428
114	2021-03-08	SWN	2690	3.99	2.255639098
115	2021-03-08	TLRY	4390	21.73	7.777266452
116	2021-03-08	EARS	60.89	3.21	30.8411215
117	2021-03-08	GNUS	621	1.8	4.444444444
118	2021-03-08	PS	3330	22.04	0.317604356
119	2021-03-08	CYDY	N/A	2.9	13.10344828
120	2021-03-08	VIAC	47790	74.56	13.92167382
121	2021-03-08	IDEX	1210	2.92	4.452054795
122	2021-03-08	ZNGA	11320	10.34	0.580270793
123	2021-03-08	OCGN	1690	8.93	4.031354983
124	2021-03-08	CIDM	192.6	1.19	20.16806723
125	2021-03-08	M	5320	15.42	7.717250324
126	2021-03-08	FCEL	5300	13.13	7.083015994
127	2021-03-08	RKT	54130	24.9	11.48594378
128	2021-03-08	GEVO	1740	7.38	12.19512195
129	2021-03-08	XSPA	167.54	1.95	5.128205128
130	2021-03-08	X	5290	18.45	13.82113821
131	2021-03-08	RIG	2340	4.33	0.692840647
132	2021-03-08	SENS	1060	2.64	5.303030303
133	2021-03-08	WKHS	2130	14.01	26.6952177
134	2021-03-08	ZOM	2080	1.89	4.232804233
135	2021-03-08	BNGO	1580	7.75	15.48387097
136	2021-03-08	JAGX	268.14	1.75	41.71428571
137	2021-03-08	PLTR	45650	23.76	3.451178451
138	2021-03-08	EXPR	223.96	2.53	71.93675889
139	2021-03-08	AMC	3550	8.53	11.13716295
140	2021-03-08	SNDL	2220	1.14	7.01754386
141	2021-03-08	EYES	88.7	8.9	66.62921348
142	2021-03-08	OPGN	78.75	2.25	80
143	2021-03-09	AMRS	4270	17.6	11.81818182
144	2021-03-09	SUNW	345.03	12.01	15.73688593
145	2021-03-09	WWR	170.45	5.13	11.69590643
146	2021-03-09	MUX	500.39	1.07	3.738317757
147	2021-03-09	AG	3620	16.24	1.908866995
148	2021-03-09	REI	212.21	2.6	1.153846154
149	2021-03-09	UEC	450.66	2.05	7.317073171
150	2021-03-09	ABML	1000	2.38	7.142857143
151	2021-03-09	AEO	4830	29.58	3.684922245
152	2021-03-09	FEYE	4780	19.88	2.716297787
153	2021-03-09	OPTT	119.69	3.26	9.81595092
154	2021-03-09	VUZI	784.89	15	10.26666667
155	2021-03-09	NEPT	256.51	1.42	10.56338028
156	2021-03-09	KOPN	777.28	7.9	13.5443038
157	2021-03-09	CLBS	124.82	1.97	3.045685279
158	2021-03-09	NTNX	5310	26.5	3.924528302
159	2021-03-09	KOSS	238.61	19.47	6.214689266
160	2021-03-09	LAZR	8300	23	2.608695652
161	2021-03-09	MGNI	5280	39.52	13.10728745
162	2021-03-09	U	27560	97.86	1.931330472
163	2021-03-09	CPG	2430	4.25	4
164	2021-03-09	ISR	155.06	1.1	4.545454545
165	2021-03-09	SFT	721.36	8.52	2.699530516
166	2021-03-09	SPWR	5620	30.85	7.747163695
167	2021-03-09	BRQS	60.84	1.33	12.03007519
168	2021-03-09	SLGG	178.27	4.88	11.2704918
169	2021-03-09	VBIV	771.59	3.19	1.253918495
170	2021-03-09	CRBP	178.27	1.92	10.41666667
171	2021-03-09	OBLN	27.64	3.08	25.32467532
172	2021-03-09	AM	4590	9.35	-0.427807487
173	2021-03-09	STL	4510	23.54	0.552251487
174	2021-03-09	IBIO	361.12	1.49	10.06711409
175	2021-03-09	BE	4950	27.3	3.553113553
176	2021-03-09	PBF	1980	17.14	0.641773629
177	2021-03-09	BCRX	2360	11.47	7.236268527
178	2021-03-09	RIDE	2970	17.12	3.679906542
179	2021-03-09	IRWD	1680	N/A	N/A
180	2021-03-09	BBBY	3490	31.11	6.460945034
181	2021-03-09	VISL	137.66	3.17	6.624605678
182	2021-03-09	EQT	5330	17.35	2.997118156
183	2021-03-09	CDEV	1550	4.6	7.608695652
184	2021-03-09	TRIT	611.02	8	1.25
Data

 

[AhoyNC]

See if this works for you.
Note that on the TRIMMEAN function I set the percent to 20%. The way TRIMMEAN works for 20% it will drop the bottom 10% and the top 10%. If you set the percent to 10% it will drop the bottom 5% and top 5%.
Reference:

TRIMMEAN function - Microsoft Support

Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set.

support.microsoft.com

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Name	Marketcap	Price	% Increase				Marketcap	Interval		Price	Interval		TRIMMEAN
2	3/8/2021	PSLV	N/A	9.05	0.994475138				>	<=		>	<=		8.757822057
3	3/8/2021	CLNY	3190	6.05	5.289256198				100	300		0.1	5
4	3/8/2021	SFIX	4940	74.92	1.147891084
5	3/8/2021	STL	4370	N/A	N/A
6	3/8/2021	U	27050	95.54	4.908938664
7	3/8/2021	BBBY	3680	28.06	11.72487527
8	3/8/2021	AVGR	138.18	1.46	7.534246575
9	3/8/2021	FEYE	4770	19.56	1.687116564
10	3/8/2021	NHIC	182.85	10.5	0
11	3/8/2021	ENDP	1820	7.05	11.34751773
12	3/8/2021	PBF	1840	16.88	3.376777251
13	3/8/2021	RMO	1540	9.81	4.587155963
14	3/8/2021	CLDR	4620	14.79	0.473292765
15	3/8/2021	VXRT	755.08	6.11	6.710310966
16	3/8/2021	DDD	3340	24.8	3.306451613
17	3/8/2021	RPRX	27820	43.8	3.607305936
18	3/8/2021	VLDR	2210	12.83	3.273577553
19	3/8/2021	AKBA	538.78	3.53	0
20	3/8/2021	MNKD	864.99	3.66	3.551912568
21	3/8/2021	NXTD	72.68	1.47	2.040816327
22	3/8/2021	ABML	N/A	2.19	8.219178082
23	3/8/2021	MDLA	5160	31.03	0.870125685
24	3/8/2021	MFA	1860	4.02	4.726368159
25	3/8/2021	PK	5130	21.1	4.218009479
26	3/8/2021	NYMT	1680	4.28	3.271028037
27	3/8/2021	UAMY	147.63	1.2	3.333333333
28	3/8/2021	CLNE	2450	11.62	4.13080895
29	3/8/2021	BLNK	1440	30.3	9.240924092
30	3/8/2021	AYRO	230.4	5.91	8.798646362
31	3/8/2021	OPK	3010	4.21	5.700712589
32	3/8/2021	IBIO	352.41	1.44	7.638888889
33	3/8/2021	EB	2140	20.25	10.71604938
34	3/8/2021	ATOS	177.5	2.26	1.327433628
35	3/8/2021	BTG	4740	4.54	-0.220264317
36	3/8/2021	EQT	5030	18.08	0.940265487
37	3/8/2021	RIDE	3030	16.69	8.088675854
38	3/8/2021	DPW	102.21	3.12	5.448717949
39	3/8/2021	SDC	4470	10.01	8.291708292
40	3/8/2021	BORR	322.11	1.23	2.43902439
41	3/8/2021	FPRX	1670	37.75	0.529801325
42	3/8/2021	UAA	9380	22.62	4.199823165
43	3/8/2021	EAF	3200	11.51	3.909643788
44	3/8/2021	KOPN	723.96	7.94	6.675062972
45	3/8/2021	BRK/B	N/A	255	2.050980392
46	3/8/2021	HL	3120	5.92	0.168918919
47	3/8/2021	AR	2770	9.95	2.211055276
48	3/8/2021	SAVE	3690	35.34	5.121675156
49	3/8/2021	GLSI	404.05	23	130.3478261
50	3/8/2021	MOTS	42.11	1.16	19.82758621
51	3/8/2021	MAC	2290	13.51	1.258327165
52	3/8/2021	ANAB	496.28	18.5	10.27027027
53	3/8/2021	BLDP	7020	22.18	4.283137962
54	3/8/2021	OGI	717.38	2.74	6.569343066
55	3/8/2021	VUZI	766.47	16.94	0.944510035
56	3/8/2021	NGD	1150	1.6	6.25
57	3/8/2021	WTRH	297.68	3.33	9.309309309
58	3/8/2021	ESGC	453.54	1.99	5.025125628
59	3/8/2021	AEO	4660	28.95	3.66148532
60	3/8/2021	CPG	2280	4.4	1.136363636
61	3/8/2021	TSNPD	N/A	3.7	0
62	3/8/2021	UWMC	14010	8.75	0.342857143
63	3/8/2021	SOLO	604.64	5.21	4.222648752
64	3/8/2021	REI	201	2.68	3.358208955
65	3/8/2021	XL	1530	11.37	2.726473175
66	3/8/2021	TELL	975.66	2.27	3.524229075
67	3/8/2021	MIK	3250	21.65	1.29330254
68	3/8/2021	MBI	526.98	8.49	19.43462898
69	3/8/2021	NOVN	229.39	1.61	0.621118012
70	3/8/2021	SHIP	178.8	1.13	2.654867257
71	3/8/2021	WTI	445.78	4.61	1.952277657
72	3/8/2021	SLGG	163.17	5.36	3.917910448
73	3/8/2021	MVIS	2130	12.79	3.674745895
74	3/8/2021	Al	5520	88	5.681818182
75	3/8/2021	FTI	3660	9.06	2.428256071
76	3/8/2021	MICT	166.38	1.86	3.76344086
77	3/8/2021	VISL	140.28	3.02	8.940397351
78	3/8/2021	ACB	2030	9.67	2.481902792
79	3/8/2021	QEP	966.58	4.42	0
80	3/8/2021	RWLK	103.07	2.62	25.19083969
81	3/8/2021	INO	2020	9.16	3.165938865
82	3/8/2021	KOSS	141.05	15.68	29.9744898
83	3/8/2021	TXMD	500.52	1.4	0.714285714
84	3/8/2021	SRNE	2730	9.18	0.762527233
85	3/8/2021	TTOO	302.92	1.7	1.764705882
86	3/8/2021	WISH	9620	17.81	2.077484559
87	3/8/2021	CHS	389.08	2.33	33.9055794
88	3/8/2021	SABR	5200	15.42	4.798962387
89	3/8/2021	CTXR	238.77	1.8	6.666666667
90	3/8/2021	WEN	4450	19.73	5.625950329
91	3/8/2021	AUY	4290	4.25	2.117647059
92	3/8/2021	FUBO	2090	29.73	4.843592331
93	3/8/2021	AIKI	90.39	1.06	7.547169811
94	3/8/2021	TNXP	353.45	1.03	6.796116505
95	3/8/2021	AMRX	1750	5.15	10.48543689
96	3/8/2021	OPEN	13750	21.38	5.986903648
97	3/8/2021	IVR	886.38	3.79	2.638522427
98	3/8/2021	OPTT	119.69	2.91	27.14776632
99	3/8/2021	AHT	200.48	2.86	11.18881119
100	3/8/2021	IMVT	1550	19.4	0.463917526
101	3/8/2021	FSR	6520	22.86	3.105861767
102	3/8/2021	ITRM	197.78	1.42	8.450704225
103	3/8/2021	APHA	5750	15.71	6.301718651
104	3/8/2021	CDEV	1480	5.06	7.312252964
105	3/8/2021	KOS	1260	3.46	2.023121387
106	3/8/2021	SLNO	108.98	1.63	4.294478528
107	3/8/2021	DGLY	74.45	1.75	16.57142857
108	3/8/2021	TRCH	323.49	2.28	7.01754386
109	3/8/2021	ASXC	551.25	3.86	8.031088083
110	3/8/2021	DNN	744.79	1.02	2.941176471
111	3/8/2021	MARA	3680	31.49	3.048586853
112	3/8/2021	GSAT	2640	1.38	7.971014493
113	3/8/2021	RIOT	3870	42.37	3.021005428
114	3/8/2021	SWN	2690	3.99	2.255639098
115	3/8/2021	TLRY	4390	21.73	7.777266452
116	3/8/2021	EARS	60.89	3.21	30.8411215
117	3/8/2021	GNUS	621	1.8	4.444444444
118	3/8/2021	PS	3330	22.04	0.317604356
119	3/8/2021	CYDY	N/A	2.9	13.10344828
120	3/8/2021	VIAC	47790	74.56	13.92167382
121	3/8/2021	IDEX	1210	2.92	4.452054795
122	3/8/2021	ZNGA	11320	10.34	0.580270793
123	3/8/2021	OCGN	1690	8.93	4.031354983
124	3/8/2021	CIDM	192.6	1.19	20.16806723
125	3/8/2021	M	5320	15.42	7.717250324
126	3/8/2021	FCEL	5300	13.13	7.083015994
127	3/8/2021	RKT	54130	24.9	11.48594378
128	3/8/2021	GEVO	1740	7.38	12.19512195
129	3/8/2021	XSPA	167.54	1.95	5.128205128
130	3/8/2021	X	5290	18.45	13.82113821
131	3/8/2021	RIG	2340	4.33	0.692840647
132	3/8/2021	SENS	1060	2.64	5.303030303
133	3/8/2021	WKHS	2130	14.01	26.6952177
134	3/8/2021	ZOM	2080	1.89	4.232804233
135	3/8/2021	BNGO	1580	7.75	15.48387097
136	3/8/2021	JAGX	268.14	1.75	41.71428571
137	3/8/2021	PLTR	45650	23.76	3.451178451
138	3/8/2021	EXPR	223.96	2.53	71.93675889
139	3/8/2021	AMC	3550	8.53	11.13716295
140	3/8/2021	SNDL	2220	1.14	7.01754386
141	3/8/2021	EYES	88.7	8.9	66.62921348
142	3/8/2021	OPGN	78.75	2.25	80
143	3/9/2021	AMRS	4270	17.6	11.81818182
144	3/9/2021	SUNW	345.03	12.01	15.73688593
145	3/9/2021	WWR	170.45	5.13	11.69590643
146	3/9/2021	MUX	500.39	1.07	3.738317757
147	3/9/2021	AG	3620	16.24	1.908866995
148	3/9/2021	REI	212.21	2.6	1.153846154
149	3/9/2021	UEC	450.66	2.05	7.317073171
150	3/9/2021	ABML	1000	2.38	7.142857143
151	3/9/2021	AEO	4830	29.58	3.684922245
152	3/9/2021	FEYE	4780	19.88	2.716297787
153	3/9/2021	OPTT	119.69	3.26	9.81595092
154	3/9/2021	VUZI	784.89	15	10.26666667
155	3/9/2021	NEPT	256.51	1.42	10.56338028
156	3/9/2021	KOPN	777.28	7.9	13.5443038
157	3/9/2021	CLBS	124.82	1.97	3.045685279
158	3/9/2021	NTNX	5310	26.5	3.924528302
159	3/9/2021	KOSS	238.61	19.47	6.214689266
160	3/9/2021	LAZR	8300	23	2.608695652
161	3/9/2021	MGNI	5280	39.52	13.10728745
162	3/9/2021	U	27560	97.86	1.931330472
163	3/9/2021	CPG	2430	4.25	4
164	3/9/2021	ISR	155.06	1.1	4.545454545
165	3/9/2021	SFT	721.36	8.52	2.699530516
166	3/9/2021	SPWR	5620	30.85	7.747163695
167	3/9/2021	BRQS	60.84	1.33	12.03007519
168	3/9/2021	SLGG	178.27	4.88	11.2704918
169	3/9/2021	VBIV	771.59	3.19	1.253918495
170	3/9/2021	CRBP	178.27	1.92	10.41666667
171	3/9/2021	OBLN	27.64	3.08	25.32467532
172	3/9/2021	AM	4590	9.35	-0.427807487
173	3/9/2021	STL	4510	23.54	0.552251487
174	3/9/2021	IBIO	361.12	1.49	10.06711409
175	3/9/2021	BE	4950	27.3	3.553113553
176	3/9/2021	PBF	1980	17.14	0.641773629
177	3/9/2021	BCRX	2360	11.47	7.236268527
178	3/9/2021	RIDE	2970	17.12	3.679906542
179	3/9/2021	IRWD	1680	N/A	N/A
180	3/9/2021	BBBY	3490	31.11	6.460945034
181	3/9/2021	VISL	137.66	3.17	6.624605678
182	3/9/2021	EQT	5330	17.35	2.997118156
183	3/9/2021	CDEV	1550	4.6	7.608695652
184	3/9/2021	TRIT	611.02	8	1.25
Sheet1

Cell Formulas
Range	Formula
O2	O2	=TRIMMEAN(FILTER($E$2:$E$184,($C$2:$C$184>$I$3)*($C$2:$C$184<=$J$3)*($D$2:$D$184>$L$3)*($D$2:$D$184<=$M$3),""),0.2)

 

[Aletor]

See if this works for you.
Note that on the TRIMMEAN function I set the percent to 20%. The way TRIMMEAN works for 20% it will drop the bottom 10% and the top 10%. If you set the percent to 10% it will drop the bottom 5% and top 5%.
Reference:

TRIMMEAN function - Microsoft Support

Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set.

support.microsoft.com

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Name	Marketcap	Price	% Increase				Marketcap	Interval		Price	Interval		TRIMMEAN
2	3/8/2021	PSLV	N/A	9.05	0.994475138				>	<=		>	<=		8.757822057
3	3/8/2021	CLNY	3190	6.05	5.289256198				100	300		0.1	5
4	3/8/2021	SFIX	4940	74.92	1.147891084
5	3/8/2021	STL	4370	N/A	N/A
6	3/8/2021	U	27050	95.54	4.908938664
7	3/8/2021	BBBY	3680	28.06	11.72487527
8	3/8/2021	AVGR	138.18	1.46	7.534246575
9	3/8/2021	FEYE	4770	19.56	1.687116564
10	3/8/2021	NHIC	182.85	10.5	0
11	3/8/2021	ENDP	1820	7.05	11.34751773
12	3/8/2021	PBF	1840	16.88	3.376777251
13	3/8/2021	RMO	1540	9.81	4.587155963
14	3/8/2021	CLDR	4620	14.79	0.473292765
15	3/8/2021	VXRT	755.08	6.11	6.710310966
16	3/8/2021	DDD	3340	24.8	3.306451613
17	3/8/2021	RPRX	27820	43.8	3.607305936
18	3/8/2021	VLDR	2210	12.83	3.273577553
19	3/8/2021	AKBA	538.78	3.53	0
20	3/8/2021	MNKD	864.99	3.66	3.551912568
21	3/8/2021	NXTD	72.68	1.47	2.040816327
22	3/8/2021	ABML	N/A	2.19	8.219178082
23	3/8/2021	MDLA	5160	31.03	0.870125685
24	3/8/2021	MFA	1860	4.02	4.726368159
25	3/8/2021	PK	5130	21.1	4.218009479
26	3/8/2021	NYMT	1680	4.28	3.271028037
27	3/8/2021	UAMY	147.63	1.2	3.333333333
28	3/8/2021	CLNE	2450	11.62	4.13080895
29	3/8/2021	BLNK	1440	30.3	9.240924092
30	3/8/2021	AYRO	230.4	5.91	8.798646362
31	3/8/2021	OPK	3010	4.21	5.700712589
32	3/8/2021	IBIO	352.41	1.44	7.638888889
33	3/8/2021	EB	2140	20.25	10.71604938
34	3/8/2021	ATOS	177.5	2.26	1.327433628
35	3/8/2021	BTG	4740	4.54	-0.220264317
36	3/8/2021	EQT	5030	18.08	0.940265487
37	3/8/2021	RIDE	3030	16.69	8.088675854
38	3/8/2021	DPW	102.21	3.12	5.448717949
39	3/8/2021	SDC	4470	10.01	8.291708292
40	3/8/2021	BORR	322.11	1.23	2.43902439
41	3/8/2021	FPRX	1670	37.75	0.529801325
42	3/8/2021	UAA	9380	22.62	4.199823165
43	3/8/2021	EAF	3200	11.51	3.909643788
44	3/8/2021	KOPN	723.96	7.94	6.675062972
45	3/8/2021	BRK/B	N/A	255	2.050980392
46	3/8/2021	HL	3120	5.92	0.168918919
47	3/8/2021	AR	2770	9.95	2.211055276
48	3/8/2021	SAVE	3690	35.34	5.121675156
49	3/8/2021	GLSI	404.05	23	130.3478261
50	3/8/2021	MOTS	42.11	1.16	19.82758621
51	3/8/2021	MAC	2290	13.51	1.258327165
52	3/8/2021	ANAB	496.28	18.5	10.27027027
53	3/8/2021	BLDP	7020	22.18	4.283137962
54	3/8/2021	OGI	717.38	2.74	6.569343066
55	3/8/2021	VUZI	766.47	16.94	0.944510035
56	3/8/2021	NGD	1150	1.6	6.25
57	3/8/2021	WTRH	297.68	3.33	9.309309309
58	3/8/2021	ESGC	453.54	1.99	5.025125628
59	3/8/2021	AEO	4660	28.95	3.66148532
60	3/8/2021	CPG	2280	4.4	1.136363636
61	3/8/2021	TSNPD	N/A	3.7	0
62	3/8/2021	UWMC	14010	8.75	0.342857143
63	3/8/2021	SOLO	604.64	5.21	4.222648752
64	3/8/2021	REI	201	2.68	3.358208955
65	3/8/2021	XL	1530	11.37	2.726473175
66	3/8/2021	TELL	975.66	2.27	3.524229075
67	3/8/2021	MIK	3250	21.65	1.29330254
68	3/8/2021	MBI	526.98	8.49	19.43462898
69	3/8/2021	NOVN	229.39	1.61	0.621118012
70	3/8/2021	SHIP	178.8	1.13	2.654867257
71	3/8/2021	WTI	445.78	4.61	1.952277657
72	3/8/2021	SLGG	163.17	5.36	3.917910448
73	3/8/2021	MVIS	2130	12.79	3.674745895
74	3/8/2021	Al	5520	88	5.681818182
75	3/8/2021	FTI	3660	9.06	2.428256071
76	3/8/2021	MICT	166.38	1.86	3.76344086
77	3/8/2021	VISL	140.28	3.02	8.940397351
78	3/8/2021	ACB	2030	9.67	2.481902792
79	3/8/2021	QEP	966.58	4.42	0
80	3/8/2021	RWLK	103.07	2.62	25.19083969
81	3/8/2021	INO	2020	9.16	3.165938865
82	3/8/2021	KOSS	141.05	15.68	29.9744898
83	3/8/2021	TXMD	500.52	1.4	0.714285714
84	3/8/2021	SRNE	2730	9.18	0.762527233
85	3/8/2021	TTOO	302.92	1.7	1.764705882
86	3/8/2021	WISH	9620	17.81	2.077484559
87	3/8/2021	CHS	389.08	2.33	33.9055794
88	3/8/2021	SABR	5200	15.42	4.798962387
89	3/8/2021	CTXR	238.77	1.8	6.666666667
90	3/8/2021	WEN	4450	19.73	5.625950329
91	3/8/2021	AUY	4290	4.25	2.117647059
92	3/8/2021	FUBO	2090	29.73	4.843592331
93	3/8/2021	AIKI	90.39	1.06	7.547169811
94	3/8/2021	TNXP	353.45	1.03	6.796116505
95	3/8/2021	AMRX	1750	5.15	10.48543689
96	3/8/2021	OPEN	13750	21.38	5.986903648
97	3/8/2021	IVR	886.38	3.79	2.638522427
98	3/8/2021	OPTT	119.69	2.91	27.14776632
99	3/8/2021	AHT	200.48	2.86	11.18881119
100	3/8/2021	IMVT	1550	19.4	0.463917526
101	3/8/2021	FSR	6520	22.86	3.105861767
102	3/8/2021	ITRM	197.78	1.42	8.450704225
103	3/8/2021	APHA	5750	15.71	6.301718651
104	3/8/2021	CDEV	1480	5.06	7.312252964
105	3/8/2021	KOS	1260	3.46	2.023121387
106	3/8/2021	SLNO	108.98	1.63	4.294478528
107	3/8/2021	DGLY	74.45	1.75	16.57142857
108	3/8/2021	TRCH	323.49	2.28	7.01754386
109	3/8/2021	ASXC	551.25	3.86	8.031088083
110	3/8/2021	DNN	744.79	1.02	2.941176471
111	3/8/2021	MARA	3680	31.49	3.048586853
112	3/8/2021	GSAT	2640	1.38	7.971014493
113	3/8/2021	RIOT	3870	42.37	3.021005428
114	3/8/2021	SWN	2690	3.99	2.255639098
115	3/8/2021	TLRY	4390	21.73	7.777266452
116	3/8/2021	EARS	60.89	3.21	30.8411215
117	3/8/2021	GNUS	621	1.8	4.444444444
118	3/8/2021	PS	3330	22.04	0.317604356
119	3/8/2021	CYDY	N/A	2.9	13.10344828
120	3/8/2021	VIAC	47790	74.56	13.92167382
121	3/8/2021	IDEX	1210	2.92	4.452054795
122	3/8/2021	ZNGA	11320	10.34	0.580270793
123	3/8/2021	OCGN	1690	8.93	4.031354983
124	3/8/2021	CIDM	192.6	1.19	20.16806723
125	3/8/2021	M	5320	15.42	7.717250324
126	3/8/2021	FCEL	5300	13.13	7.083015994
127	3/8/2021	RKT	54130	24.9	11.48594378
128	3/8/2021	GEVO	1740	7.38	12.19512195
129	3/8/2021	XSPA	167.54	1.95	5.128205128
130	3/8/2021	X	5290	18.45	13.82113821
131	3/8/2021	RIG	2340	4.33	0.692840647
132	3/8/2021	SENS	1060	2.64	5.303030303
133	3/8/2021	WKHS	2130	14.01	26.6952177
134	3/8/2021	ZOM	2080	1.89	4.232804233
135	3/8/2021	BNGO	1580	7.75	15.48387097
136	3/8/2021	JAGX	268.14	1.75	41.71428571
137	3/8/2021	PLTR	45650	23.76	3.451178451
138	3/8/2021	EXPR	223.96	2.53	71.93675889
139	3/8/2021	AMC	3550	8.53	11.13716295
140	3/8/2021	SNDL	2220	1.14	7.01754386
141	3/8/2021	EYES	88.7	8.9	66.62921348
142	3/8/2021	OPGN	78.75	2.25	80
143	3/9/2021	AMRS	4270	17.6	11.81818182
144	3/9/2021	SUNW	345.03	12.01	15.73688593
145	3/9/2021	WWR	170.45	5.13	11.69590643
146	3/9/2021	MUX	500.39	1.07	3.738317757
147	3/9/2021	AG	3620	16.24	1.908866995
148	3/9/2021	REI	212.21	2.6	1.153846154
149	3/9/2021	UEC	450.66	2.05	7.317073171
150	3/9/2021	ABML	1000	2.38	7.142857143
151	3/9/2021	AEO	4830	29.58	3.684922245
152	3/9/2021	FEYE	4780	19.88	2.716297787
153	3/9/2021	OPTT	119.69	3.26	9.81595092
154	3/9/2021	VUZI	784.89	15	10.26666667
155	3/9/2021	NEPT	256.51	1.42	10.56338028
156	3/9/2021	KOPN	777.28	7.9	13.5443038
157	3/9/2021	CLBS	124.82	1.97	3.045685279
158	3/9/2021	NTNX	5310	26.5	3.924528302
159	3/9/2021	KOSS	238.61	19.47	6.214689266
160	3/9/2021	LAZR	8300	23	2.608695652
161	3/9/2021	MGNI	5280	39.52	13.10728745
162	3/9/2021	U	27560	97.86	1.931330472
163	3/9/2021	CPG	2430	4.25	4
164	3/9/2021	ISR	155.06	1.1	4.545454545
165	3/9/2021	SFT	721.36	8.52	2.699530516
166	3/9/2021	SPWR	5620	30.85	7.747163695
167	3/9/2021	BRQS	60.84	1.33	12.03007519
168	3/9/2021	SLGG	178.27	4.88	11.2704918
169	3/9/2021	VBIV	771.59	3.19	1.253918495
170	3/9/2021	CRBP	178.27	1.92	10.41666667
171	3/9/2021	OBLN	27.64	3.08	25.32467532
172	3/9/2021	AM	4590	9.35	-0.427807487
173	3/9/2021	STL	4510	23.54	0.552251487
174	3/9/2021	IBIO	361.12	1.49	10.06711409
175	3/9/2021	BE	4950	27.3	3.553113553
176	3/9/2021	PBF	1980	17.14	0.641773629
177	3/9/2021	BCRX	2360	11.47	7.236268527
178	3/9/2021	RIDE	2970	17.12	3.679906542
179	3/9/2021	IRWD	1680	N/A	N/A
180	3/9/2021	BBBY	3490	31.11	6.460945034
181	3/9/2021	VISL	137.66	3.17	6.624605678
182	3/9/2021	EQT	5330	17.35	2.997118156
183	3/9/2021	CDEV	1550	4.6	7.608695652
184	3/9/2021	TRIT	611.02	8	1.25
Sheet1

Cell Formulas
Range	Formula
O2	O2	=TRIMMEAN(FILTER($E$2:$E$184,($C$2:$C$184>$I$3)*($C$2:$C$184<=$J$3)*($D$2:$D$184>$L$3)*($D$2:$D$184<=$M$3),""),0.2)

That did the trick, thank you!