Spreadsheet: 862187d1709927034-sort-unique-filter-non-adjacent-columns-and-exlude-blanks-i-can-do-all-but-one-filter-issue
Sheet: Budget Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SUM(IF(LEFT(UNIQUE(BudTbl[FY_AP]),5)="2024_",1,0)) |  |  |  |  | Filtered PACs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =ROWS(UNIQUE(FILTER(BudTbl[FY_AP],(LEFT(BudTbl[FY_AP],5)="2024_")*(BudTbl[Ledger]="FTE")))) |  |  |  |  | 00FCLTIM | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST | 70000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH | 35000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH | 39800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH | 89177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH | 10550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSCR | 10500
Summary Table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD | 10500
Unique Depts | [NAME] | [NAME] | [NAME] | YTD Paid FTES | [NAME] | Avg Monthly Salary Exp | [NAME] per FTE | Auth FTE | Active | Filled | Vacant | L1001 | L1002 | L2009S | Overall |  | Key | BUDGET_REF | UNIT | UNIT_DESCR | DEPTID | DEPTID_DESCR | PROGRAM | [NAME] | BUDGET_CATEGORY | BUD_ACCOUNT | LAR_JC_DESCR | [NAME] | HDR_VENDOR_NAME | LN_VENDOR_NAME | ACCOUNT | ACCOUNT_DESCR | CNTRCT_ID | INVOICE_ID | TX_INVOICE_DESCR | PO_ID_REQ | JOURNAL_ID | JOURNAL_LINE | CP_PAC | Strategy | Ledger | FY_AP | BUDGET | PRE_ENC | OPEN_ENC | EXPENSE | PROJECTIONS |  | 00TIMSDD | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSDD |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSCR |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSCR |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSCR |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMSCR |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00FCLCSS |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00FCLCSS |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00FCLCSS |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00FCLTIM |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00FCLTIM |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00FCLTIM |  | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 10600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 70000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 70000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 70000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMPST |  | 70000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 35000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 35000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 35000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 39800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 39800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 39800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 39800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 89177
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 10550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 10550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 10550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 10550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00TIMRYH |  | 10550