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