Spreadsheet: 808517d1670503144-filter-data-with-multiple-drop-down-boxes-and-multiple-criteria-filter-based-on-multiple-criteria
Sheet: Data

[NAME]: | Broker is Active: | Broker List: | Yes/No: | [NAME]: | Lender is Active: | Lender List: | Deal Type Name: | Deal Type is Active: | Deal Type List: | Loan Type Name: | Loan Type is Active: | Loan Type List: | Payment Status: | Payment Status Days: | Referrer Name: | Referrer is Active: | Referrer List: | Loan Book Status: | Loan Book Status Days: | Green Formatting: | Month Name: | Month Calendar Number: | Month Fiscal Number: | Fiscal Start Date: | Fiscal End Date: | Fiscal Year: | Calendar Start Date: | Calendar End Date: | Calendar Year: | Fiscal Month Date: | Fiscal Month: | Calendar Month Date: | Calendar Month: | Year Type Filter: | Year Filter: | Months Filter: | Brokers Filter: | Lenders Filter: | Deal Types Filter: | [NAME] Filter: | Payment Status Filter: | Loan Book Status Filter: | Self-Employed Filter: | Referrer Filter:
Erin | Yes | — [NAME] — | Yes | Lender 1 | Yes | — Choose Lender — | Car/Equipment | Yes | — Choose Deal Type — | Bridging | Yes | — Choose Loan Type — | — Choose Status — | 56 | Client Referral | Yes | — Choose Referrer — | — Choose Option — | 84 | Entire Column | July | 7 | 1 | 1999-07-01 00:00:00 | 2000-06-30 00:00:00 | 1999 - 2000 | 2000-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000 | 2000-07-01 00:00:00 | July | 2000-01-01 00:00:00 | January | Calendar | All Years | All Months | All Brokers | All Lenders | All Deal Types | All Loan Types | All Payment Status | All Loan Book Status | Both | All Referrers
[NAME] | Yes |  | No | Lender 2 | Yes |  | Commercial | Yes |  | Construction (INV) | Yes |  | Paid |  | Existing Client | Yes |  | Yes |  | Individual Cells | August | 8 | 2 | 2000-07-01 00:00:00 | 2001-06-30 00:00:00 | 2000 - 2001 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 2001 | 2000-08-01 00:00:00 | August | 2000-02-01 00:00:00 | February | Fiscal |  |  |  |  |  |  |  |  | Self-Employed
[NAME] | Yes |  |  | Lender 3 | Yes |  | Residential | Yes |  | Construction (OO) | Yes |  | Unpaid |  | GMB | Yes |  | Overdue |  |  | September | 9 | 3 | 2001-07-01 00:00:00 | 2002-06-30 00:00:00 | 2001 - 2002 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002 | 2000-09-01 00:00:00 | September | 2000-03-01 00:00:00 | March |  | 2000 - 2001 |  |  |  |  |  |  |  | Not Self-Employed
[NAME] | Yes |  |  | Lender 4 | Yes |  | Spare Deal Type 1 | No |  | Debt Consolidation | Yes |  | Pending |  | Own Network | Yes |  | Pending |  |  | October | 10 | 4 | 2002-07-01 00:00:00 | 2003-06-30 00:00:00 | 2002 - 2003 | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | 2003 | 2000-10-01 00:00:00 | October | 2000-04-01 00:00:00 | April |  | 2001 - 2002
Kelsey | Yes |  |  | Lender 5 | Yes |  | Spare Deal Type 2 | No |  | Deposit Bond | Yes |  | Clawback |  | Referral Partner | Yes |  | Withdrawn |  |  | November | 11 | 5 | 2003-07-01 00:00:00 | 2004-06-30 00:00:00 | 2003 - 2004 | 2004-01-01 00:00:00 | 2004-12-31 00:00:00 | 2004 | 2000-11-01 00:00:00 | November | 2000-05-01 00:00:00 | May |  | 2002 - 2003
Lynette | Yes |  |  | Lender 6 | Yes |  | Spare Deal Type 3 | No |  | Increase | Yes |  | Redraw |  | Social Media | Yes |  |  |  |  | December | 12 | 6 | 2004-07-01 00:00:00 | 2005-06-30 00:00:00 | 2004 - 2005 | 2005-01-01 00:00:00 | 2005-12-31 00:00:00 | 2005 | 2000-12-01 00:00:00 | December | 2000-06-01 00:00:00 | June |  | 2003 - 2004
[NAME] | Yes |  |  | Lender 7 | Yes |  | Spare Deal Type 4 | No |  | Investment (Shares) | Yes |  | Withdrawn |  | Spare Referrer 1 | No |  |  |  |  | January | 1 | 7 | 2005-07-01 00:00:00 | 2006-06-30 00:00:00 | 2005 - 2006 | 2006-01-01 00:00:00 | 2006-12-31 00:00:00 | 2006 | 2000-01-01 00:00:00 | January | 2000-07-01 00:00:00 | July |  | 2004 - 2005
[NAME] | Yes |  |  | Lender 8 | Yes |  | Spare Deal Type 5 | No |  | Other | Yes |  |  |  | Spare Referrer 2 | No |  |  |  |  | February | 2 | 8 | 2006-07-01 00:00:00 | 2007-06-30 00:00:00 | 2006 - 2007 | 2007-01-01 00:00:00 | 2007-12-31 00:00:00 | 2007 | 2000-02-01 00:00:00 | February | 2000-08-01 00:00:00 | August |  | 2005 - 2006
[NAME] | Yes |  |  | Lender 9 | Yes |  | Spare Deal Type 6 | No |  | Personal | Yes |  |  |  | Spare Referrer 3 | No |  |  |  |  | March | 3 | 9 | 2007-07-01 00:00:00 | 2008-06-30 00:00:00 | 2007 - 2008 | 2008-01-01 00:00:00 | 2008-12-31 00:00:00 | 2008 | 2000-03-01 00:00:00 | March | 2000-09-01 00:00:00 | September |  | 2006 - 2007
[NAME] | Yes |  |  | Lender 10 | Yes |  | Spare Deal Type 7 | No |  | Purchase (INV) | Yes |  |  |  | Spare Referrer 4 | No |  |  |  |  | April | 4 | 10 | 2008-07-01 00:00:00 | 2009-06-30 00:00:00 | 2008 - 2009 | 2009-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009 | 2000-04-01 00:00:00 | April | 2000-10-01 00:00:00 | October |  | 2007 - 2008
Sanda | Yes |  |  | Lender 11 | Yes |  | Spare Deal Type 8 | No |  | Purchase (OO) | Yes |  |  |  | Spare Referrer 5 | No |  |  |  |  | May | 5 | 11 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009 - 2010 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010 | 2000-05-01 00:00:00 | May | 2000-11-01 00:00:00 | November |  | 2008 - 2009
Sofia | Yes |  |  | Lender 12 | Yes |  | Spare Deal Type 9 | No |  | Purchase Land (INV) | Yes |  |  |  | Spare Referrer 6 | No |  |  |  |  | June | 6 | 12 | 2010-07-01 00:00:00 | 2011-06-30 00:00:00 | 2010 - 2011 | 2011-01-01 00:00:00 | 2011-12-31 00:00:00 | 2011 | 2000-06-01 00:00:00 | June | 2000-12-01 00:00:00 | December |  | 2009 - 2010
Sue | Yes |  |  | Lender 13 | Yes |  | Spare Deal Type 10 | No |  | [NAME] (OO) | Yes |  |  |  | Spare Referrer 7 | No |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2012-06-30 00:00:00 | 2011 - 2012 | 2012-01-01 00:00:00 | 2012-12-31 00:00:00 | 2012 |  |  |  |  |  | 2010 - 2011
Spare Broker 1 | No |  |  | Lender 14 | Yes |  | Spare Deal Type 11 | No |  | Refinance | Yes |  |  |  | Spare Referrer 8 | No |  |  |  |  |  |  |  | 2012-07-01 00:00:00 | 2013-06-30 00:00:00 | 2012 - 2013 | 2013-01-01 00:00:00 | 2013-12-31 00:00:00 | 2013 |  |  |  |  |  | 2011 - 2012
Spare Broker 2 | No |  |  | Lender 15 | Yes |  | Spare Deal Type 12 | No |  | Renovations | Yes |  |  |  | Spare Referrer 9 | No |  |  |  |  |  |  |  | 2013-07-01 00:00:00 | 2014-06-30 00:00:00 | 2013 - 2014 | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014 |  |  |  |  |  | 2012 - 2013
Spare Broker 3 | No |  |  | Lender 16 | Yes |  | Spare Deal Type 13 | No |  | Restructure | Yes |  |  |  | Spare Referrer 10 | No |  |  |  |  |  |  |  | 2014-07-01 00:00:00 | 2015-06-30 00:00:00 | 2014 - 2015 | 2015-01-01 00:00:00 | 2015-12-31 00:00:00 | 2015 |  |  |  |  |  | 2013 - 2014
Spare Broker 4 | No |  |  | Lender 17 | Yes |  | Spare Deal Type 14 | No |  | Spare Loan Type 1 | No |  |  |  | Spare Referrer 11 | No |  |  |  |  |  |  |  | 2015-07-01 00:00:00 | 2016-06-30 00:00:00 | 2015 - 2016 | 2016-01-01 00:00:00 | 2016-12-31 00:00:00 | 2016 |  |  |  |  |  | 2014 - 2015
Spare Broker 5 | No |  |  | Lender 18 | Yes |  | Spare Deal Type 15 | No |  | Spare Loan Type 2 | No |  |  |  | Spare Referrer 12 | No |  |  |  |  |  |  |  | 2016-07-01 00:00:00 | 2017-06-30 00:00:00 | 2016 - 2017 | 2017-01-01 00:00:00 | 2017-12-31 00:00:00 | 2017 |  |  |  |  |  | 2015 - 2016
Spare Broker 6 | No |  |  | Lender 19 | Yes |  | Spare Deal Type 16 | No |  | Spare Loan Type 3 | No |  |  |  | Spare Referrer 13 | No |  |  |  |  |  |  |  | 2017-07-01 00:00:00 | 2018-06-30 00:00:00 | 2017 - 2018 | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018 |  |  |  |  |  | 2016 - 2017
Spare Broker 7 | No |  |  | Lender 20 | Yes |  | Spare Deal Type 17 | No |  | Spare Loan Type 4 | No |  |  |  | Spare Referrer 14 | No |  |  |  |  |  |  |  | 2018-07-01 00:00:00 | 2019-06-30 00:00:00 | 2018 - 2019 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | 2019 |  |  |  |  |  | 2017 - 2018
Spare Broker 8 | No |  |  | Lender 21 | Yes |  | Spare Deal Type 18 | No |  | Spare Loan Type 5 | No |  |  |  | Spare Referrer 15 | No |  |  |  |  |  |  |  | 2019-07-01 00:00:00 | 2020-06-30 00:00:00 | 2019 - 2020 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 2020 |  |  |  |  |  | 2018 - 2019
Spare Broker 9 | No |  |  | Lender 22 | Yes |  | Spare Deal Type 19 | No |  | Spare Loan Type 6 | No |  |  |  | Spare Referrer 16 | No |  |  |  |  |  |  |  | 2020-07-01 00:00:00 | 2021-06-30 00:00:00 | 2020 - 2021 | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021 |  |  |  |  |  | 2019 - 2020
Spare Broker 10 | No |  |  | Lender 23 | Yes |  | Spare Deal Type 20 | No |  | Spare Loan Type 7 | No |  |  |  | Spare Referrer 17 | No |  |  |  |  |  |  |  | 2021-07-01 00:00:00 | 2022-06-30 00:00:00 | 2021 - 2022 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 | 2022 |  |  |  |  |  | 2020 - 2021
Spare Broker 11 | No |  |  | Lender 24 | Yes |  |  |  |  | Spare Loan Type 8 | No |  |  |  | Spare Referrer 18 | No |  |  |  |  |  |  |  | 2022-07-01 00:00:00 | 2023-06-30 00:00:00 | 2022 - 2023 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 2023 |  |  |  |  |  | 2021 - 2022
Spare Broker 12 | No |  |  | Lender 25 | Yes |  |  |  |  | Spare Loan Type 9 | No |  |  |  | Spare Referrer 19 | No |  |  |  |  |  |  |  | 2023-07-01 00:00:00 | 2024-06-30 00:00:00 | 2023 - 2024 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 | 2024 |  |  |  |  |  | 2022 - 2023
Spare Broker 13 | No |  |  | Lender 26 | Yes |  |  |  |  | Spare Loan Type 10 | No |  |  |  | Spare Referrer 20 | No |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 2025-06-30 00:00:00 | 2024 - 2025 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 | 2025 |  |  |  |  |  | 2023 - 2024
Spare Broker 14 | No |  |  | Lender 27 | Yes |  |  |  |  | Spare Loan Type 11 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-01 00:00:00 | 2026-06-30 00:00:00 | 2025 - 2026 | 2026-01-01 00:00:00 | 2026-12-31 00:00:00 | 2026 |  |  |  |  |  | 2024 - 2025
Spare Broker 15 | No |  |  | Lender 28 | Yes |  |  |  |  | Spare Loan Type 12 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2026-07-01 00:00:00 | 2027-06-30 00:00:00 | 2026 - 2027 | 2027-01-01 00:00:00 | 2027-12-31 00:00:00 | 2027 |  |  |  |  |  | 2025 - 2026
Spare Broker 16 | No |  |  | Lender 29 | Yes |  |  |  |  | Spare Loan Type 13 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2027-07-01 00:00:00 | 2028-06-30 00:00:00 | 2027 - 2028 | 2028-01-01 00:00:00 | 2028-12-31 00:00:00 | 2028 |  |  |  |  |  | 2026 - 2027
Spare Broker 17 | No |  |  | Lender 30 | Yes |  |  |  |  | Spare Loan Type 14 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2028-07-01 00:00:00 | 2029-06-30 00:00:00 | 2028 - 2029 | 2029-01-01 00:00:00 | 2029-12-31 00:00:00 | 2029 |  |  |  |  |  | 2027 - 2028
Spare Broker 18 | No |  |  | Lender 31 | Yes |  |  |  |  | Spare Loan Type 15 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2029-07-01 00:00:00 | 2030-06-30 00:00:00 | 2029 - 2030 | 2030-01-01 00:00:00 | 2030-12-31 00:00:00 | 2030 |  |  |  |  |  | 2028 - 2029
Spare Broker 19 | No |  |  | Lender 32 | Yes |  |  |  |  | Spare Loan Type 16 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2030-07-01 00:00:00 | 2031-06-30 00:00:00 | 2030 - 2031 | 2031-01-01 00:00:00 | 2031-12-31 00:00:00 | 2031 |  |  |  |  |  | 2029 - 2030
Spare Broker 20 | No |  |  | Lender 33 | Yes |  |  |  |  | Spare Loan Type 17 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2031-07-01 00:00:00 | 2032-06-30 00:00:00 | 2031 - 2032 | 2032-01-01 00:00:00 | 2032-12-31 00:00:00 | 2032 |  |  |  |  |  | 2030 - 2031
 |  |  |  | Lender 34 | Yes |  |  |  |  | Spare Loan Type 18 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2032-07-01 00:00:00 | 2033-06-30 00:00:00 | 2032 - 2033 | 2033-01-01 00:00:00 | 2033-12-31 00:00:00 | 2033 |  |  |  |  |  | 2031 - 2032
 |  |  |  | Lender 35 | Yes |  |  |  |  | Spare Loan Type 19 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2033-07-01 00:00:00 | 2034-06-30 00:00:00 | 2033 - 2034 | 2034-01-01 00:00:00 | 2034-12-31 00:00:00 | 2034 |  |  |  |  |  | 2032 - 2033
 |  |  |  | Lender 36 | Yes |  |  |  |  | Spare Loan Type 20 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2034-07-01 00:00:00 | 2035-06-30 00:00:00 | 2034 - 2035 | 2035-01-01 00:00:00 | 2035-12-31 00:00:00 | 2035 |  |  |  |  |  | 2033 - 2034
 |  |  |  | Lender 37 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2035-07-01 00:00:00 | 2036-06-30 00:00:00 | 2035 - 2036 | 2036-01-01 00:00:00 | 2036-12-31 00:00:00 | 2036 |  |  |  |  |  | 2034 - 2035
 |  |  |  | Lender 38 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2036-07-01 00:00:00 | 2037-06-30 00:00:00 | 2036 - 2037 | 2037-01-01 00:00:00 | 2037-12-31 00:00:00 | 2037 |  |  |  |  |  | 2035 - 2036
 |  |  |  | Lender 39 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2037-07-01 00:00:00 | 2038-06-30 00:00:00 | 2037 - 2038 | 2038-01-01 00:00:00 | 2038-12-31 00:00:00 | 2038 |  |  |  |  |  | 2036 - 2037
 |  |  |  | Lender 40 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2038-07-01 00:00:00 | 2039-06-30 00:00:00 | 2038 - 2039 | 2039-01-01 00:00:00 | 2039-12-31 00:00:00 | 2039 |  |  |  |  |  | 2037 - 2038
 |  |  |  | Lender 41 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2039-07-01 00:00:00 | 2040-06-30 00:00:00 | 2039 - 2040 | 2040-01-01 00:00:00 | 2040-12-31 00:00:00 | 2040 |  |  |  |  |  | 2038 - 2039
 |  |  |  | Lender 42 | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2039 - 2040
 |  |  |  | Lender 43 | Yes
 |  |  |  | Lender 44 | Yes
 |  |  |  | Lender 45 | Yes
 |  |  |  | Lender 46 | Yes
 |  |  |  | Lender 47 | Yes
 |  |  |  | Lender 48 | Yes
 |  |  |  | Spare Lender 1 | No
 |  |  |  | Spare Lender 2 | No
 |  |  |  | Spare Lender 3 | No
 |  |  |  | Spare Lender 4 | No
 |  |  |  | Spare Lender 5 | No
 |  |  |  | Spare Lender 6 | No
 |  |  |  | Spare Lender 7 | No
 |  |  |  | Spare Lender 8 | No
 |  |  |  | Spare Lender 9 | No
 |  |  |  | Spare Lender 10 | No
 |  |  |  | Spare Lender 11 | No
 |  |  |  | Spare Lender 12 | No
 |  |  |  | Spare Lender 13 | No
 |  |  |  | Spare Lender 14 | No
 |  |  |  | Spare Lender 15 | No
 |  |  |  | Spare Lender 16 | No
 |  |  |  | Spare Lender 17 | No
 |  |  |  | Spare Lender 18 | No
 |  |  |  | Spare Lender 19 | No
 |  |  |  | Spare Lender 20 | No