filter dynamic data without filter function

[Tdw1990]

Hello,
I'm needing help to find a way to filter data without using the updated filter and sortby functions released in excel 365. Is it possible to filter data using multiple criteria with basic excel functions? I've attached a sheet with cell A4 using the filter function to produce the desired results.

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			Property	Unit(s)	Lease	Lease Type	Area	Lease From	Lease To	Term	Monthly	Monthly	Annual	Annual	Annual	Annual	Security	LOC Amount/
2											Rent	Rent	Rent	Rent	Rec.	Misc	Deposit	Bank Guarantee
3												Per Area		Per Area	Per Area	Per Area
4	100A, 100B	Ben T. Morris	10000 - Laureate RE Investors, LP,Houston
5	100D	Fundamental Advisors, Inc.	Current Leases
6	100E	Shari Fish Wellness, LLC	10000		New Cingular Wireless PCS, LLC	Office Net	0.00	6/1/2011	5/31/2026	180.00	4,087.15	0.00	49,045.80	0.00	0.00	0.00	0.00	0.00
7	100F	Active Campus LLC	10000		SprintCom, Inc. (Sprint PCS)	Office Net	0.00	8/1/2014	7/31/2034	240.00	4,838.40	0.00	58,060.80	0.00	0.00	0.00	0.00	0.00
8	100G	NRI Energy Partners LLC	10000		T-Mobile USA, Inc.	Office Net	0.00	8/5/2015	8/4/2030	180.00	3,091.01	0.00	37,092.12	0.00	0.00	0.00	0.00	0.00
9	100H	Peter Busher	10000		GTE Mobilnet of South Texas LP	Office Net	0.00	9/1/2018	8/31/2023	60.00	4,243.60	0.00	50,923.20	0.00	0.00	0.00	0.00	0.00
10	100J, 100K	Marian Louise Designs LLC	10000		Tuan Tran	Office Net	0.00	1/1/2016		0.00	1,500.00	0.00	18,000.00	0.00	0.00	0.00	0.00	0.00
11	100N	Texas Investors Title, LLC	10000		David Rogers	Office Net	0.00	7/1/2019		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
12	100P	T.O.S. Advisors, LLC	10000	100A, 100B	Ben T. Morris	Office Net	835.00	11/1/2018	10/31/2021	36.00	3,677.07	4.40	44,124.84	52.84	0.00	1.94	6,500.00	0.00
13	260	J. Ron Young	10000	100D	Fundamental Advisors, Inc.	Office Net	322.00	7/1/2019	6/30/2022	36.00	1,545.00	4.80	18,540.00	57.58	0.00	3.03	1,500.00	0.00
14	300	Fisher, Johnson & Huguenard, LLP	10000	100E	Shari Fish Wellness, LLC	Office Net	323.00	7/1/2019	1/31/2022	31.00	1,050.63	3.25	12,607.56	39.03	0.00	2.01	1,000.00	0.00
15	310	Three Mile Creek, LLC	10000	100F	Active Campus LLC	Office Net	502.00	5/1/2021	10/31/2021	6.00	2,450.00	4.88	29,400.00	58.57	0.00	3.88	0.00	0.00
16	330	eCorp Texas, LLC	10000	100G	NRI Energy Partners LLC	Office Net	413.00	5/1/2021	11/30/2021	7.00	1,750.00	4.24	21,000.00	50.85	0.00	3.15	1,750.00	0.00
17	450	Giammalva Properties	10000	100H	Peter Busher	Office Net	256.00	11/1/2018	10/31/2021	36.00	848.56	3.31	10,182.72	39.78	0.00	2.54	2,500.00	0.00
18	500	Rio Grande E&P, LLC	10000	100J, 100K	Marian Louise Designs LLC	Office Net	614.00	6/1/2021	11/30/2021	6.00	2,700.00	4.40	32,400.00	52.77	0.00	4.93	2,700.00	0.00
19	550	JVL Advisors, LLC	10000	100N	Texas Investors Title, LLC	Office Net	382.00	7/1/2019	7/31/2022	37.00	1,250.00	3.27	15,000.00	39.27	0.00	1.70	1,250.00	0.00
20	660	SLM Discovery Ventures, Inc.	10000	100P	T.O.S. Advisors, LLC	Office Net	382.00	11/1/2018	10/31/2021	36.00	1,131.41	2.96	13,576.92	35.54	0.00	1.70	2,000.00	0.00
21	740	Crosstimbers Capital Group, LLC	10000	170	The Retail Connection - Houston, LLC	Office Net	4,408.00	11/1/2018	10/31/2023	60.00	7,714.00	1.75	92,568.00	21.00	18.07	1.47	0.00	0.00
22	770	Quail Creek Oil Corporation	10000	200	Elite Insurance Agency, Inc.	Office Net	5,916.00	2/1/2019	10/31/2023	57.00	8,972.60	1.52	107,671.20	18.20	18.07	2.31	66,885.28	0.00
23	790	NRI Energy Partners, LLC	10000	260	J. Ron Young	Office Net	4,629.00	3/1/2017	2/28/2022	60.00	9,065.13	1.96	108,781.56	23.50	18.07	1.33	0.00	0.00
24	100C	VACANT	10000	300	Fisher, Johnson & Huguenard, LLP	Office Net	5,076.00	1/1/2018	3/31/2022	51.00	9,801.46	1.93	117,617.52	23.17	18.07	1.73	0.00	0.00
25	100L	VACANT	10000	310	Three Mile Creek, LLC	Office Net	912.00	4/1/2018	5/31/2022	50.00	1,786.00	1.96	21,432.00	23.50	18.07	1.42	32,000.00	0.00
26	100M	VACANT	10000	320	GT International, Inc.	Office Net	2,717.00	7/1/2018	7/31/2023	61.00	5,320.79	1.96	63,849.48	23.50	18.07	2.51	0.00	0.00
27	105-BSR	VACANT	10000	330	eCorp Texas, LLC	Office Net	3,274.00	10/6/2018	10/31/2021	37.00	6,411.58	1.96	76,938.96	23.50	17.89	3.17	0.00	0.00
28	160-BTR	VACANT	10000	420, 480	Raintree Resorts International, Inc.	Office Net	6,335.00	1/1/2017	12/31/2026	120.00	14,306.54	2.26	171,678.48	27.10	17.89	2.72	0.00	0.00
29	165-BUS	VACANT	10000	440	Herbert Scott Galloway	Office Net	1,112.00	2/1/2019	2/28/2023	49.00	2,455.67	2.21	29,468.04	26.50	18.07	1.17	8,087.94	0.00
30	175-TSR	VACANT	10000	450	Giammalva Properties	Office Net	2,259.00	10/1/2017	9/30/2022	60.00	4,910.42	2.17	58,925.04	26.08	18.07	1.73	0.00	0.00
31	180-CRF	VACANT	10000	460	ESS1B HOLDINGS COMPANY LLC	Office Net	2,906.00	10/8/2018	1/7/2024	63.00	6,296.33	2.17	75,555.96	26.00	18.07	1.45	12,228.27	0.00
32	250	VACANT	10000	500	Rio Grande E&P, LLC	Office Net	6,487.00	6/1/2018	8/31/2022	51.00	13,514.58	2.08	162,174.96	25.00	18.07	1.80	22,423.40	0.00
33	400	VACANT	10000	510	Ralph S. O'Connor	Office Net	3,138.00	8/1/2015	7/31/2023	96.00	9,414.00	3.00	112,968.00	36.00	9.01	0.93	0.00	0.00
34	410	VACANT	10000	540	National Cardiovascular Partners, LP	Office Net	7,110.00	12/1/2017	1/30/2023	61.00	14,516.25	2.04	174,195.00	24.50	18.07	0.49	0.00	0.00
35	555	VACANT	10000	550	JVL Advisors, LLC	Office Net	2,518.00	6/1/2020	11/30/2022	30.00	6,504.83	2.58	78,057.96	31.00	17.89	1.68	0.00	0.00
36	575	VACANT	10000	600, 610, 620	Tex-Isle Supply, Inc.	Office Net	10,633.00	10/1/2016	2/28/2024	88.00	29,831.38	2.81	357,976.56	33.67	7.49	1.25	0.00	0.00
37	760	VACANT	10000	650	Westwood Holdings Group, Inc.	Office Net	7,772.00	1/1/2017	6/30/2024	90.00	16,839.33	2.17	202,071.96	26.00	18.07	3.18	0.00	0.00
38	920B	VACANT	10000	660	SLM Discovery Ventures, Inc.	Office Net	3,218.00	5/1/2017	4/30/2022	60.00	6,570.08	2.04	78,840.96	24.50	18.07	0.91	0.00	0.00
39			10000	700	Jones Companies, Inc.	Office Net	3,863.00	9/1/2019	9/30/2026	85.00	9,818.46	2.54	117,821.52	30.50	18.07	1.85	0.00	0.00
40			10000	740	Crosstimbers Capital Group, LLC	Office Net	6,230.00	8/1/2017	12/31/2022	65.00	12,979.17	2.08	155,750.04	25.00	18.07	1.20	0.00	0.00
41			10000	750	Vickery & Shepherd	Office Net	2,037.00	7/1/2014	6/30/2024	120.00	5,092.50	2.50	61,110.00	30.00	17.89	2.23	0.00	0.00
42			10000	770	Quail Creek Oil Corporation	Office Net	3,197.00	10/1/2016	9/30/2021	60.00	11,056.29	3.46	132,675.48	41.50	1.33	1.83	0.00	0.00
43			10000	785	IMI MARINE OPERATIONS, INC.	Office Net	809.00	5/1/2019	4/30/2024	60.00	2,056.21	2.54	24,674.52	30.50	18.07	2.81	0.00	0.00
44			10000	790	NRI Energy Partners, LLC	Office Net	2,351.00	5/1/2019	4/30/2022	36.00	5,877.50	2.50	70,530.00	30.00	18.07	1.38	0.00	0.00
45			10000	800	Employee Benefit Systems, Inc.	Office Net	4,361.00	6/1/2016	6/30/2024	97.00	8,903.71	2.04	106,844.52	24.50	17.89	2.23	0.00	0.00
46			10000	888	Jones & Granger	Office Net	13,947.00	6/1/2016	6/30/2024	97.00	28,475.13	2.04	341,701.56	24.50	17.89	2.42	0.00	0.00
47			10000	900	The George and Barbara Bush Foundation	Office Net	3,553.00	5/1/2019	4/30/2024	60.00	8,142.29	2.29	97,707.48	27.50	18.07	1.01	0.00	0.00
48			10000	920	Chase Untermeyer & Gold Sky Energy Corp.	Office Net	1,651.00	5/1/2019	4/30/2024	60.00	3,783.54	2.29	45,402.48	27.50	18.07	0.92	0.00	0.00
49			10000	950	Marble Capital, LP	Office Net	5,907.00	1/1/2020	12/31/2029	120.00	15,013.63	2.54	180,163.56	30.50	17.66	1.10	0.00	0.00
50			10000	100C	VACANT		323.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
51			10000	100L	VACANT		495.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
52			10000	100M	VACANT		483.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
53			10000	105-BSR	VACANT		156.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
54			10000	160-BTR	VACANT		1,278.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
55			10000	165-BUS	VACANT		65.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
56			10000	175-TSR	VACANT		137.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
57			10000	180-CRF	VACANT		518.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
58			10000	250	VACANT		1,886.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
59			10000	400	VACANT		6,059.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
60			10000	410	VACANT		2,198.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
61			10000	555	VACANT		0.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
62			10000	575	VACANT		1,766.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
63			10000	760	VACANT		2,720.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
64			10000	920B	VACANT		0.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
65			Total Current				150,439.00				319,592.23	2.12	########	25.49	14.07	1.61	160,824.89	0.00
66
67				Total Units	Total Area	Percentage	Monthly Rent	Annual Rent
68			Occupied	43.00	132,355.00	87.98	319,592.23	3,835,106.76
69			Vacant	15.00	18,084.00	12.02	0.00	0.00
70			Total	58.00	150,439.00		319,592.23	########
71
72			10343 - SH Crossing I LP,Houston
73			Current Leases
74			10343	110	Strayer University, LLC	Office Net	7,519.00	12/1/2017	5/31/2025	90.00	10,338.63	1.38	124,063.56	16.50	9.88	0.00	0.00	0.00
75			10343	200	Brock Enterprises, Inc.	Office Net	27,860.00	11/1/2008	4/30/2026	210.00	38,307.50	1.38	459,690.00	16.50	9.88	1.04	0.00	0.00
76			10343	220	Carrier Corporation	Office Net	4,878.00	10/1/2018	12/31/2023	63.00	6,300.75	1.29	75,609.00	15.50	9.88	0.00	10,382.01	0.00
77			10343	225	Ziebel US, Inc.	Office Net	4,993.00	6/1/2018	5/31/2023	60.00	7,281.46	1.46	87,377.52	17.50	9.88	0.00	11,458.94	0.00
78			10343	230	Iberdrola Solutions LLC	Office Net	3,517.00	2/15/2020	6/30/2025	65.00	4,835.88	1.38	58,030.56	16.50	9.88	0.00	8,270.81	0.00
79			10343	310	Ricoh USA, Inc.	Office Net	15,121.00	12/15/2018	4/14/2024	64.00	22,051.46	1.46	264,617.52	17.50	9.88	0.00	0.00	0.00
80			10343	325	Aqua Terra Water Management, LP	Office Net	7,355.00	3/1/2019	5/31/2023	51.00	10,113.13	1.38	121,357.56	16.50	9.88	0.00	16,266.81	0.00
81			10343	100	VACANT		17,750.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
82			10343	120	VACANT		13,998.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
83			10343	150	VACANT		11,271.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
84			10343	210	VACANT		7,248.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
85			10343	215	VACANT		5,386.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
86			10343	300	VACANT		27,740.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
87			10343	350	VACANT		4,539.00			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
88			Total Current				159,175.00				99,228.81	0.62	########	7.48	4.42	0.18	46,378.57	0.00
Sheet1

Cell Formulas
Range	Formula
A4:B38	A4	=FILTER($D$5:$E$200,(C5:C200="10000")*((E5:E200="VACANT")+(YEAR(I5:I200)=2022)+(YEAR(I5:I200)=2022-1)),"")
Dynamic array formulas.

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			Property	Unit(s)	Lease	Lease Type	Area	Lease From	Lease To	Term	Monthly	Monthly	Annual	Annual	Annual	Annual	Security	LOC Amount/
2											Rent	Rent	Rent	Rent	Rec.	Misc	Deposit	Bank Guarantee
3												Per Area		Per Area	Per Area	Per Area
4	100A, 100B	Ben T. Morris	10000 - Laureate RE Investors, LP,Houston
5	100D	Fundamental Advisors, Inc.	Current Leases
6	100E	Shari Fish Wellness, LLC	10000		New Cingular Wireless PCS, LLC	Office Net	0	6/1/2011	5/31/2026	180	4087.15	0	49045.8	0	0	0	0	0
7	100F	Active Campus LLC	10000		SprintCom, Inc. (Sprint PCS)	Office Net	0	8/1/2014	7/31/2034	240	4838.4	0	58060.8	0	0	0	0	0
8	100G	NRI Energy Partners LLC	10000		T-Mobile USA, Inc.	Office Net	0	8/5/2015	8/4/2030	180	3091.01	0	37092.12	0	0	0	0	0
9	100H	Peter Busher	10000		GTE Mobilnet of South Texas LP	Office Net	0	9/1/2018	8/31/2023	60	4243.6	0	50923.2	0	0	0	0	0
10	100J, 100K	Marian Louise Designs LLC	10000		Tuan Tran	Office Net	0	1/1/2016		0	1500	0	18000	0	0	0	0	0
11	100N	Texas Investors Title, LLC	10000		David Rogers	Office Net	0	7/1/2019		0	0	0	0	0	0	0	0	0
12	100P	T.O.S. Advisors, LLC	10000	100A, 100B	Ben T. Morris	Office Net	835	11/1/2018	10/31/2021	36	3677.07	4.4	44124.84	52.84	0	1.94	6500	0
13	260	J. Ron Young	10000	100D	Fundamental Advisors, Inc.	Office Net	322	7/1/2019	6/30/2022	36	1545	4.8	18540	57.58	0	3.03	1500	0
14	300	Fisher, Johnson & Huguenard, LLP	10000	100E	Shari Fish Wellness, LLC	Office Net	323	7/1/2019	1/31/2022	31	1050.63	3.25	12607.56	39.03	0	2.01	1000	0
15	310	Three Mile Creek, LLC	10000	100F	Active Campus LLC	Office Net	502	5/1/2021	10/31/2021	6	2450	4.88	29400	58.57	0	3.88	0	0
16	330	eCorp Texas, LLC	10000	100G	NRI Energy Partners LLC	Office Net	413	5/1/2021	11/30/2021	7	1750	4.24	21000	50.85	0	3.15	1750	0
17	450	Giammalva Properties	10000	100H	Peter Busher	Office Net	256	11/1/2018	10/31/2021	36	848.56	3.31	10182.72	39.78	0	2.54	2500	0
18	500	Rio Grande E&P, LLC	10000	100J, 100K	Marian Louise Designs LLC	Office Net	614	6/1/2021	11/30/2021	6	2700	4.4	32400	52.77	0	4.93	2700	0
19	550	JVL Advisors, LLC	10000	100N	Texas Investors Title, LLC	Office Net	382	7/1/2019	7/31/2022	37	1250	3.27	15000	39.27	0	1.7	1250	0
20	660	SLM Discovery Ventures, Inc.	10000	100P	T.O.S. Advisors, LLC	Office Net	382	11/1/2018	10/31/2021	36	1131.41	2.96	13576.92	35.54	0	1.7	2000	0
21	740	Crosstimbers Capital Group, LLC	10000	170	The Retail Connection - Houston, LLC	Office Net	4408	11/1/2018	10/31/2023	60	7714	1.75	92568	21	18.07	1.47	0	0
22	770	Quail Creek Oil Corporation	10000	200	Elite Insurance Agency, Inc.	Office Net	5916	2/1/2019	10/31/2023	57	8972.6	1.52	107671.2	18.2	18.07	2.31	66885.28	0
23	790	NRI Energy Partners, LLC	10000	260	J. Ron Young	Office Net	4629	3/1/2017	2/28/2022	60	9065.13	1.96	108781.6	23.5	18.07	1.33	0	0
24	100C	VACANT	10000	300	Fisher, Johnson & Huguenard, LLP	Office Net	5076	1/1/2018	3/31/2022	51	9801.46	1.93	117617.5	23.17	18.07	1.73	0	0
25	100L	VACANT	10000	310	Three Mile Creek, LLC	Office Net	912	4/1/2018	5/31/2022	50	1786	1.96	21432	23.5	18.07	1.42	32000	0
26	100M	VACANT	10000	320	GT International, Inc.	Office Net	2717	7/1/2018	7/31/2023	61	5320.79	1.96	63849.48	23.5	18.07	2.51	0	0
27	105-BSR	VACANT	10000	330	eCorp Texas, LLC	Office Net	3274	10/6/2018	10/31/2021	37	6411.58	1.96	76938.96	23.5	17.89	3.17	0	0
28	160-BTR	VACANT	10000	420, 480	Raintree Resorts International, Inc.	Office Net	6335	1/1/2017	12/31/2026	120	14306.54	2.26	171678.5	27.1	17.89	2.72	0	0
29	165-BUS	VACANT	10000	440	Herbert Scott Galloway	Office Net	1112	2/1/2019	2/28/2023	49	2455.67	2.21	29468.04	26.5	18.07	1.17	8087.94	0
30	175-TSR	VACANT	10000	450	Giammalva Properties	Office Net	2259	10/1/2017	9/30/2022	60	4910.42	2.17	58925.04	26.08	18.07	1.73	0	0
31	180-CRF	VACANT	10000	460	ESS1B HOLDINGS COMPANY LLC	Office Net	2906	10/8/2018	1/7/2024	63	6296.33	2.17	75555.96	26	18.07	1.45	12228.27	0
32	250	VACANT	10000	500	Rio Grande E&P, LLC	Office Net	6487	6/1/2018	8/31/2022	51	13514.58	2.08	162175	25	18.07	1.8	22423.4	0
33	400	VACANT	10000	510	Ralph S. O'Connor	Office Net	3138	8/1/2015	7/31/2023	96	9414	3	112968	36	9.01	0.93	0	0
34	410	VACANT	10000	540	National Cardiovascular Partners, LP	Office Net	7110	12/1/2017	1/30/2023	61	14516.25	2.04	174195	24.5	18.07	0.49	0	0
35	555	VACANT	10000	550	JVL Advisors, LLC	Office Net	2518	6/1/2020	11/30/2022	30	6504.83	2.58	78057.96	31	17.89	1.68	0	0
36	575	VACANT	10000	600, 610, 620	Tex-Isle Supply, Inc.	Office Net	10633	10/1/2016	2/28/2024	88	29831.38	2.81	357976.6	33.67	7.49	1.25	0	0
37	760	VACANT	10000	650	Westwood Holdings Group, Inc.	Office Net	7772	1/1/2017	6/30/2024	90	16839.33	2.17	202072	26	18.07	3.18	0	0
38	920B	VACANT	10000	660	SLM Discovery Ventures, Inc.	Office Net	3218	5/1/2017	4/30/2022	60	6570.08	2.04	78840.96	24.5	18.07	0.91	0	0
39			10000	700	Jones Companies, Inc.	Office Net	3863	9/1/2019	9/30/2026	85	9818.46	2.54	117821.5	30.5	18.07	1.85	0	0
40			10000	740	Crosstimbers Capital Group, LLC	Office Net	6230	8/1/2017	12/31/2022	65	12979.17	2.08	155750	25	18.07	1.2	0	0
41			10000	750	Vickery & Shepherd	Office Net	2037	7/1/2014	6/30/2024	120	5092.5	2.5	61110	30	17.89	2.23	0	0
42			10000	770	Quail Creek Oil Corporation	Office Net	3197	10/1/2016	9/30/2021	60	11056.29	3.46	132675.5	41.5	1.33	1.83	0	0
43			10000	785	IMI MARINE OPERATIONS, INC.	Office Net	809	5/1/2019	4/30/2024	60	2056.21	2.54	24674.52	30.5	18.07	2.81	0	0
44			10000	790	NRI Energy Partners, LLC	Office Net	2351	5/1/2019	4/30/2022	36	5877.5	2.5	70530	30	18.07	1.38	0	0
45			10000	800	Employee Benefit Systems, Inc.	Office Net	4361	6/1/2016	6/30/2024	97	8903.71	2.04	106844.5	24.5	17.89	2.23	0	0
46			10000	888	Jones & Granger	Office Net	13947	6/1/2016	6/30/2024	97	28475.13	2.04	341701.6	24.5	17.89	2.42	0	0
47			10000	900	The George and Barbara Bush Foundation	Office Net	3553	5/1/2019	4/30/2024	60	8142.29	2.29	97707.48	27.5	18.07	1.01	0	0
48			10000	920	Chase Untermeyer & Gold Sky Energy Corp.	Office Net	1651	5/1/2019	4/30/2024	60	3783.54	2.29	45402.48	27.5	18.07	0.92	0	0
49			10000	950	Marble Capital, LP	Office Net	5907	1/1/2020	12/31/2029	120	15013.63	2.54	180163.6	30.5	17.66	1.1	0	0
50			10000	100C	VACANT		323			0	0	0	0	0	0	0	0	0
51			10000	100L	VACANT		495			0	0	0	0	0	0	0	0	0
52			10000	100M	VACANT		483			0	0	0	0	0	0	0	0	0
53			10000	105-BSR	VACANT		156			0	0	0	0	0	0	0	0	0
54			10000	160-BTR	VACANT		1278			0	0	0	0	0	0	0	0	0
55			10000	165-BUS	VACANT		65			0	0	0	0	0	0	0	0	0
56			10000	175-TSR	VACANT		137			0	0	0	0	0	0	0	0	0
57			10000	180-CRF	VACANT		518			0	0	0	0	0	0	0	0	0
58			10000	250	VACANT		1886			0	0	0	0	0	0	0	0	0
59			10000	400	VACANT		6059			0	0	0	0	0	0	0	0	0
60			10000	410	VACANT		2198			0	0	0	0	0	0	0	0	0
61			10000	555	VACANT		0			0	0	0	0	0	0	0	0	0
62			10000	575	VACANT		1766			0	0	0	0	0	0	0	0	0
63			10000	760	VACANT		2720			0	0	0	0	0	0	0	0	0
64			10000	920B	VACANT		0			0	0	0	0	0	0	0	0	0
65			Total Current				150439				319592.2	2.12	3835107	25.49	14.07	1.61	160824.9	0
66
67				Total Units	Total Area	Percentage	Monthly Rent	Annual Rent
68			Occupied	43	132355	87.97918	319592.2	3835107
69			Vacant	15	18084	12.02082	0	0
70			Total	58	150439		319592.2	3835107
71
72			10343 - SH Crossing I LP,Houston
73			Current Leases
74			10343	110	Strayer University, LLC	Office Net	7519	12/1/2017	5/31/2025	90	10338.63	1.38	124063.6	16.5	9.88	0	0	0
75			10343	200	Brock Enterprises, Inc.	Office Net	27860	11/1/2008	4/30/2026	210	38307.5	1.38	459690	16.5	9.88	1.04	0	0
76			10343	220	Carrier Corporation	Office Net	4878	10/1/2018	12/31/2023	63	6300.75	1.29	75609	15.5	9.88	0	10382.01	0
77			10343	225	Ziebel US, Inc.	Office Net	4993	6/1/2018	5/31/2023	60	7281.46	1.46	87377.52	17.5	9.88	0	11458.94	0
78			10343	230	Iberdrola Solutions LLC	Office Net	3517	2/15/2020	6/30/2025	65	4835.88	1.38	58030.56	16.5	9.88	0	8270.81	0
79			10343	310	Ricoh USA, Inc.	Office Net	15121	#########	4/14/2024	64	22051.46	1.46	264617.5	17.5	9.88	0	0	0
80			10343	325	Aqua Terra Water Management, LP	Office Net	7355	3/1/2019	5/31/2023	51	10113.13	1.38	121357.6	16.5	9.88	0	16266.81	0
81			10343	100	VACANT		17750			0	0	0	0	0	0	0	0	0
82			10343	120	VACANT		13998			0	0	0	0	0	0	0	0	0
83			10343	150	VACANT		11271			0	0	0	0	0	0	0	0	0
84			10343	210	VACANT		7248			0	0	0	0	0	0	0	0	0
85			10343	215	VACANT		5386			0	0	0	0	0	0	0	0	0
86			10343	300	VACANT		27740			0	0	0	0	0	0	0	0	0
87			10343	350	VACANT		4539			0	0	0	0	0	0	0	0	0
88			Total Current				159175				99228.81	0.62	1190746	7.48	4.42	0.18	46378.57	0
Sheet21

Cell Formulas
Range	Formula
A4:B39	A4	=IFERROR(INDEX(D:D,AGGREGATE(15,6,ROW(D$6:D$200)/($C$6:$C$200=10000)/SIGN(($E$6:$E$200="VACANT")+(YEAR($I$6:$I$200)=2022)+(YEAR($I$6:$I$200)=2022-1)),ROWS(A$4:A4))),"")

Drag the formulas down as needed. I had to change the "10000" to 10000 because of how the copy/paste worked.