Spreadsheet: 762179d1641429552-help-on-formula-with-3-criteria-in-columns-sample-book
Sheet: Data

DATA |  |  |  |  |  |  |  |  |  | What I want it to be
Category 1 | # | DBA | Type | Date | End | Begin | Change |  |  | Category 1 | # | DBA | Type | Date | End | Begin | Change
1001 | 00001 | Name 1 | Modified | 2017-11-01 00:00:00 | 15.27 | 14.82 |  |  |  | 1001 | 00001 | Name 1 | Modified | 2017-11-01 00:00:00 | 15.27 | 14.82
1001 | 00001 | Name 1 | Contract | 2022-11-01 00:00:00 | 15.27 | 15.27 |  |  |  | 1001 | 00001 | Name 1 | Contract | 2022-11-01 00:00:00 | 15.27 | 15.27
1001 | 00001 | Name 1 | REJREN | 2024-05-01 00:00:00 | 15.27 | 15.27 |  |  |  | 1001 | 00001 | Name 1 | REJREN | 2024-05-01 00:00:00 | 15.27 | 15.27
1001 | 00002 | Name 2 | SPEC | 2022-09-01 00:00:00 | 22.58000307692308 | 18 |  |  |  | 1001 | 00002 | Name 2 | SPEC | 2022-09-01 00:00:00 | 22.58000307692308 | 18
1001 | 00003 | Name 3 | Contract | 2016-11-01 00:00:00 | 23.48592734225621 | 23.48592734225621 |  |  |  | 1001 | 00003 | Name 3 | Contract | 2016-11-01 00:00:00 | 23.48592734225621 | 23.48592734225621
1001 | 00003 | Name 3 new | SPEC | 2022-12-01 00:00:00 | 23.49 | 23.49 |  |  |  | 1001 | 00003 | Name 3 new | SPEC | 2022-12-01 00:00:00 | 23.49 | 23.49
1001 | 00004 | Name 4 | Contract | 2015-06-01 00:00:00 | 16.94 | 16.94 |  |  |  | 1001 | 00004 | Name 4 | Contract | 2015-06-01 00:00:00 | 16.94 | 16.94
1001 | 00004 | Name 4 new | SPEC | 2025-10-01 00:00:00 | 18.63 | 16.94 |  |  |  | 1001 | 00004 | Name 4 new | SPEC | 2025-10-01 00:00:00 | 18.63 | 16.94
1001 | 00005 | Name 5 | Contract | 2010-05-04 00:00:00 | 8.531810539928872 | 8.08276753960556 |  |  |  | 1001 | 00005 | Name 5 | Contract | 2010-05-04 00:00:00 | 8.531810539928872 | 8.08276753960556
1001 | 00006 | Name 6 | Modified | 2018-07-13 00:00:00 | 17.35999226455231 | 15.50000386772384 |  |  |  | 1001 | 00006 | Name 6 | Modified | 2018-07-13 00:00:00 | 17.35999226455231 | 15.50000386772384
1001 | 00007 | Name 7 | Modified | 2012-06-14 00:00:00 | 11.9168004196171 | 10.64 |  |  |  | 1001 | 00007 | Name 7 | Modified | 2012-06-14 00:00:00 | 11.9168004196171 | 10.64
1001 | 00007 | Name 7 | ACCEPT | 2023-08-01 00:00:00 | 11.92 | 11.92 |  |  |  | 1001 | 00007 | Name 7 | Modified | 2023-08-01 00:00:00 | 11.92 | 11.92
1001 | 00008 | Name 8 | Contract | 2020-07-17 00:00:00 | 30.22443433029909 | 30.22443433029909 |  |  |  | 1001 | 00008 | Name 8 | Contract | 2020-07-17 00:00:00 | 30.22443433029909 | 30.22443433029909
1001 | 00009 | Name 9 | Contract | 2015-04-10 00:00:00 | 14.50000158755358 | 13.5 |  |  |  | 1001 | 00009 | Name 9 | Contract | 2015-04-10 00:00:00 | 14.50000158755358 | 13.5
1001 | 00010 | Name 10 | Modified | 2018-01-01 00:00:00 | 20.77719962157048 | 20.77719962157048 |  |  |  | 1001 | 00010 | Name 10 | Modified | 2018-01-01 00:00:00 | 20.77719962157048 | 20.77719962157048
1001 | 00010 | Name 10 | Modified | 2019-01-01 00:00:00 | 20.77719962157048 | 20.77719962157048 |  |  |  | 1001 | 00010 | Name 10 | Modified | 2019-01-01 00:00:00 | 20.77719962157048 | 20.77719962157048
1001 | 00010 | Name 10 new | SPEC | 2024-10-01 00:00:00 | 101.5100094607379 | 92.28 |  |  |  | 1001 | 00010 | Name 10 new | SPEC | 2024-10-01 00:00:00 | 101.5100094607379 | 92.28
1001 | 00011 | Name 11 | Modified | 2020-03-01 00:00:00 | 24.55403076923077 | 24.55403076923077 |  |  |  | 1001 | 00011 | Name 11 | Modified | 2020-03-01 00:00:00 | 24.55403076923077 | 24.55403076923077
1001 | 00012 | Name 12 | Modified | 2015-02-01 00:00:00 | 15.31 | 13.92 |  |  |  | 1001 | 00012 | Name 12 | Modified | 2015-02-01 00:00:00 | 15.31 | 13.92
1001 | 00014 | Name 13 | Contract | 2017-04-01 00:00:00 | 44.08620624408704 | 44.08620624408704 |  |  |  | 1001 | 00014 | Name 13 | Contract | 2017-04-01 00:00:00 | 44.08620624408704 | 44.08620624408704
1001 | 00014 | Name 14 | Contract | 2021-02-22 00:00:00 | 45.40881740775781 | 44.08620624408704 |  |  |  | 1001 | 00014 | Name 14 | Contract | 2021-02-22 00:00:00 | 45.40881740775781 | 44.08620624408704
1001 | 00014 | Name 14 | Contract | 2022-04-01 00:00:00 | 51.10796594134342 | 45.40881740775781 |  |  |  | 1001 | 00014 | Name 14 | Contract | 2022-04-01 00:00:00 | 51.10796594134342 | 45.40881740775781
1001 | 00015 | Name 15 | MTMEXT | 2018-03-01 00:00:00 | 45.96527472527473 | 43.32668131868132 |  |  |  | 1001 | 00015 | Name 15 | Contract | 2018-03-01 00:00:00 | 45.96527472527473 | 43.32668131868132
1001 | 00015 | Name 15 new | SPEC | 2025-12-01 00:00:00 | 51.74004395604395 | 45.97002197802198 |  |  |  |  | 00015 | Name 15 new | SPEC | 2025-12-01 00:00:00 | 51.74004395604395 | 45.97002197802198