Spreadsheet: 328226d1403821355-median-indirect-find-median-in-range-and-bring-back-adjacent-cells-median-and-bring-back-adjacent-cell-example
Sheet: DATA MERGE

1 |  |  |  | 3 | 4 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  | OrgCategories
RowID | UniCode | Level 1 | Level 2 | Cost (P$M) | [NAME] | Central | Central Other | FC | Ins | Sch
054Admin & TS | 54 | Admin & TS | . | 362.369 | 0.8837588685532901
058Admin & TS | 58 | Admin & TS | . | 362.69 | 1.079705059040754
056Admin & TS | 56 | Admin & TS | . | 398.42 | 1.014623794209967
057Admin & TS | 57 | Admin & TS | . | 81.888 | 0.8889295598484205
059Admin & TS | 59 | Admin & TS | . | 186.169 | 0.9504619042302316
05401. Governance | 54 | 01. Governance | .
05402. Finance | 54 | 02. Finance | .
05403. Human Resources | 54 | 03. Human Resources | .
05404. Information Technology | 54 | 04. Information Technology | .
05407. Community Engagement | 54 | 07. Community Engagement | .
05408. Teaching Support | 54 | 08. Teaching Support | .
05411. General Administration | 54 | 11. General Administration | .
05801. Governance | 58 | 01. Governance | .
05802. Finance | 58 | 02. Finance | .
05803. Human Resources | 58 | 03. Human Resources | .
05804. Information Technology | 58 | 04. Information Technology | .
05805. Facilities Management | 58 | 05. Facilities Management | .
05807. Community Engagement | 58 | 07. Community Engagement | .
05811. General Administration | 58 | 11. General Administration | .
05601. Governance | 56 | 01. Governance | .
05602. Finance | 56 | 02. Finance | .
05603. Human Resources | 56 | 03. Human Resources | .
05604. Information Technology | 56 | 04. Information Technology | .
05605. Facilities Management | 56 | 05. Facilities Management | .
05607. Community Engagement | 56 | 07. Community Engagement | .
05611. General Administration | 56 | 11. General Administration | .
05701. Governance | 57 | 01. Governance | .
05702. Finance | 57 | 02. Finance | .
05703. Human Resources | 57 | 03. Human Resources | .
05704. Information Technology | 57 | 04. Information Technology | .
05705. Facilities Management | 57 | 05. Facilities Management | .
05707. Community Engagement | 57 | 07. Community Engagement | .
05711. General Administration | 57 | 11. General Administration | .
05901. Governance | 59 | 01. Governance | .
05902. Finance | 59 | 02. Finance | .
05903. Human Resources | 59 | 03. Human Resources | .
05904. Information Technology | 59 | 04. Information Technology | .
05905. Facilities Management | 59 | 05. Facilities Management | .
05907. Community Engagement | 59 | 07. Community Engagement | .
05911. General Administration | 59 | 11. General Administration | .
05401. Governance01.01 Plan&Policy | 54 | 01. Governance | 01.01 Plan&Policy
05401. Governance01.02 GenMgmnt | 54 | 01. Governance | 01.02 GenMgmnt
05401. Governance01.03 Rpting&Comms | 54 | 01. Governance | 01.03 Rpting&Comms
05401. Governance01.05 Prog&ChgMgmt | 54 | 01. Governance | 01.05 Prog&ChgMgmt
05401. Governance01.06 GovernServ | 54 | 01. Governance | 01.06 GovernServ
05402. Finance02.01 Bud&Forecast | 54 | 02. Finance | 02.01 Bud&Forecast
05402. Finance02.02 FinAcc&Rpt | 54 | 02. Finance | 02.02 FinAcc&Rpt
05402. Finance02.03 StratProcmnt | 54 | 02. Finance | 02.03 StratProcmnt
05402. Finance02.04 AP/AR | 54 | 02. Finance | 02.04 AP/AR
05402. Finance02.05 Treas&Inv | 54 | 02. Finance | 02.05 [NAME]
05403. Human Resources03.01 Payroll&Sup | 54 | 03. Human Resources | 03.01 Payroll&Sup
05403. Human Resources03.02 EmpAdvisor | 54 | 03. Human Resources | 03.02 EmpAdvisor
05403. Human Resources03.03 StaffDev&Train | 54 | 03. Human Resources | 03.03 StaffDev&Train
05403. Human Resources03.04 EquityAccess&Div | 54 | 03. Human Resources | 03.04 EquityAccess&Div
05403. Human Resources03.05 IR Mgmnt | 54 | 03. Human Resources | 03.05 IR Mgmnt
05404. Information Technology04.01 ITInfrastr-D&T | 54 | 04. Information Technology | 04.01 ITInfrastr-D&T
05404. Information Technology04.02 ITInfrastr-S&M | 54 | 04. Information Technology | 04.02 ITInfrastr-S&M
05404. Information Technology04.03 ITClientServs-D&T | 54 | 04. Information Technology | 04.03 ITClientServs-D&T
05404. Information Technology04.04 ITClientServs-S&M | 54 | 04. Information Technology | 04.04 ITClientServs-S&M
05405. Facilities Management05.01 PropServices | 54 | 05. Facilities Management | 05.01 PropServices
05405. Facilities Management05.02 FMServices | 54 | 05. Facilities Management | 05.02 FMServices
05405. Facilities Management05.03 FMProjMgmnt | 54 | 05. Facilities Management | 05.03 FMProjMgmnt
05405. Facilities Management05.04 UniServices | 54 | 05. Facilities Management | 05.04 UniServices
05407. Community Engagement07.01 StuRecruit | 54 | 07. Community Engagement | 07.01 StuRecruit
05407. Community Engagement07.02 Mkting | 54 | 07. Community Engagement | 07.02 Mkting
05407. Community Engagement07.03 RelMgmnt | 54 | 07. Community Engagement | 07.03 RelMgmnt
05407. Community Engagement07.04 Alum&Dev | 54 | 07. Community Engagement | 07.04 [NAME]
05411. General Administration11.01 PA,[NAME] | 54 | 11. General Administration | 11.01 PA,[NAME]
05411. General Administration11.02 GenRecordsMgmnt | 54 | 11. General Administration | 11.02 GenRecordsMgmnt
05411. General Administration11.03 PurchTravel&CCds | 54 | 11. General Administration | 11.03 PurchTravel&CCds
05412. Other Activities12.01 AccomServices | 54 | 12. Other Activities | 12.01 AccomServices
05412. Other Activities12.02 Retail&OtherServ | 54 | 12. Other Activities | 12.02 Retail&OtherServ
05412. Other Activities12.03 Commercial Serv | 54 | 12. Other Activities | 12.03 Commercial Serv
05801. Governance01.01 Plan&Policy | 58 | 01. Governance | 01.01 Plan&Policy
05801. Governance01.02 GenMgmnt | 58 | 01. Governance | 01.02 GenMgmnt
05801. Governance01.03 Rpting&Comms | 58 | 01. Governance | 01.03 Rpting&Comms
05801. Governance01.05 Prog&ChgMgmt | 58 | 01. Governance | 01.05 Prog&ChgMgmt
05801. Governance01.06 GovernServ | 58 | 01. Governance | 01.06 GovernServ
05802. Finance02.01 Bud&Forecast | 58 | 02. Finance | 02.01 Bud&Forecast
05802. Finance02.02 FinAcc&Rpt | 58 | 02. Finance | 02.02 FinAcc&Rpt
05802. Finance02.03 StratProcmnt | 58 | 02. Finance | 02.03 StratProcmnt
05802. Finance02.04 AP/AR | 58 | 02. Finance | 02.04 AP/AR
05802. Finance02.05 Treas&Inv | 58 | 02. Finance | 02.05 [NAME]
05803. Human Resources03.01 Payroll&Sup | 58 | 03. Human Resources | 03.01 Payroll&Sup
05803. Human Resources03.02 EmpAdvisor | 58 | 03. Human Resources | 03.02 EmpAdvisor
05803. Human Resources03.03 StaffDev&Train | 58 | 03. Human Resources | 03.03 StaffDev&Train
05803. Human Resources03.04 EquityAccess&Div | 58 | 03. Human Resources | 03.04 EquityAccess&Div
05803. Human Resources03.05 IR Mgmnt | 58 | 03. Human Resources | 03.05 IR Mgmnt
05804. Information Technology04.01 ITInfrastr-D&T | 58 | 04. Information Technology | 04.01 ITInfrastr-D&T
05804. Information Technology04.02 ITInfrastr-S&M | 58 | 04. Information Technology | 04.02 ITInfrastr-S&M
05804. Information Technology04.03 ITClientServs-D&T | 58 | 04. Information Technology | 04.03 ITClientServs-D&T
05804. Information Technology04.04 ITClientServs-S&M | 58 | 04. Information Technology | 04.04 ITClientServs-S&M
05805. Facilities Management05.01 PropServices | 58 | 05. Facilities Management | 05.01 PropServices
05805. Facilities Management05.02 FMServices | 58 | 05. Facilities Management | 05.02 FMServices
05805. Facilities Management05.03 FMProjMgmnt | 58 | 05. Facilities Management | 05.03 FMProjMgmnt
05805. Facilities Management05.04 UniServices | 58 | 05. Facilities Management | 05.04 UniServices
05807. Community Engagement07.01 StuRecruit | 58 | 07. Community Engagement | 07.01 StuRecruit
05807. Community Engagement07.02 Mkting | 58 | 07. Community Engagement | 07.02 Mkting
05807. Community Engagement07.03 RelMgmnt | 58 | 07. Community Engagement | 07.03 RelMgmnt
05807. Community Engagement07.04 Alum&Dev | 58 | 07. Community Engagement | 07.04 [NAME]
05811. General Administration11.01 PA,[NAME] | 58 | 11. General Administration | 11.01 PA,[NAME]
05811. General Administration11.02 GenRecordsMgmnt | 58 | 11. General Administration | 11.02 GenRecordsMgmnt
05811. General Administration11.03 PurchTravel&CCds | 58 | 11. General Administration | 11.03 PurchTravel&CCds
05812. Other Activities12.01 AccomServices | 58 | 12. Other Activities | 12.01 AccomServices
05812. Other Activities12.02 Retail&OtherServ | 58 | 12. Other Activities | 12.02 Retail&OtherServ
05812. Other Activities12.03 Commercial Serv | 58 | 12. Other Activities | 12.03 Commercial Serv
05601. Governance01.01 Plan&Policy | 56 | 01. Governance | 01.01 Plan&Policy
05601. Governance01.02 GenMgmnt | 56 | 01. Governance | 01.02 GenMgmnt
05601. Governance01.03 Rpting&Comms | 56 | 01. Governance | 01.03 Rpting&Comms
05601. Governance01.05 Prog&ChgMgmt | 56 | 01. Governance | 01.05 Prog&ChgMgmt
05601. Governance01.06 GovernServ | 56 | 01. Governance | 01.06 GovernServ
05602. Finance02.01 Bud&Forecast | 56 | 02. Finance | 02.01 Bud&Forecast
05602. Finance02.02 FinAcc&Rpt | 56 | 02. Finance | 02.02 FinAcc&Rpt
05602. Finance02.03 StratProcmnt | 56 | 02. Finance | 02.03 StratProcmnt
05602. Finance02.04 AP/AR | 56 | 02. Finance | 02.04 AP/AR
05602. Finance02.05 Treas&Inv | 56 | 02. Finance | 02.05 [NAME]
05603. Human Resources03.01 Payroll&Sup | 56 | 03. Human Resources | 03.01 Payroll&Sup
05603. Human Resources03.02 EmpAdvisor | 56 | 03. Human Resources | 03.02 EmpAdvisor
05603. Human Resources03.03 StaffDev&Train | 56 | 03. Human Resources | 03.03 StaffDev&Train
05603. Human Resources03.04 EquityAccess&Div | 56 | 03. Human Resources | 03.04 EquityAccess&Div
05603. Human Resources03.05 IR Mgmnt | 56 | 03. Human Resources | 03.05 IR Mgmnt
05604. Information Technology04.01 ITInfrastr-D&T | 56 | 04. Information Technology | 04.01 ITInfrastr-D&T
05604. Information Technology04.02 ITInfrastr-S&M | 56 | 04. Information Technology | 04.02 ITInfrastr-S&M
05604. Information Technology04.03 ITClientServs-D&T | 56 | 04. Information Technology | 04.03 ITClientServs-D&T
05604. Information Technology04.04 ITClientServs-S&M | 56 | 04. Information Technology | 04.04 ITClientServs-S&M
05605. Facilities Management05.01 PropServices | 56 | 05. Facilities Management | 05.01 PropServices
05605. Facilities Management05.02 FMServices | 56 | 05. Facilities Management | 05.02 FMServices
05605. Facilities Management05.03 FMProjMgmnt | 56 | 05. Facilities Management | 05.03 FMProjMgmnt
05605. Facilities Management05.04 UniServices | 56 | 05. Facilities Management | 05.04 UniServices
05607. Community Engagement07.01 StuRecruit | 56 | 07. Community Engagement | 07.01 StuRecruit
05607. Community Engagement07.02 Mkting | 56 | 07. Community Engagement | 07.02 Mkting
05607. Community Engagement07.03 RelMgmnt | 56 | 07. Community Engagement | 07.03 RelMgmnt
05607. Community Engagement07.04 Alum&Dev | 56 | 07. Community Engagement | 07.04 [NAME]
05611. General Administration11.01 PA,[NAME] | 56 | 11. General Administration | 11.01 PA,[NAME]
05611. General Administration11.02 GenRecordsMgmnt | 56 | 11. General Administration | 11.02 GenRecordsMgmnt
05611. General Administration11.03 PurchTravel&CCds | 56 | 11. General Administration | 11.03 PurchTravel&CCds
05612. Other Activities12.01 AccomServices | 56 | 12. Other Activities | 12.01 AccomServices
05612. Other Activities12.02 Retail&OtherServ | 56 | 12. Other Activities | 12.02 Retail&OtherServ
05612. Other Activities12.03 Commercial Serv | 56 | 12. Other Activities | 12.03 Commercial Serv
05701. Governance01.01 Plan&Policy | 57 | 01. Governance | 01.01 Plan&Policy
05701. Governance01.02 GenMgmnt | 57 | 01. Governance | 01.02 GenMgmnt
05701. Governance01.03 Rpting&Comms | 57 | 01. Governance | 01.03 Rpting&Comms
05701. Governance01.05 Prog&ChgMgmt | 57 | 01. Governance | 01.05 Prog&ChgMgmt
05701. Governance01.06 GovernServ | 57 | 01. Governance | 01.06 GovernServ
05702. Finance02.01 Bud&Forecast | 57 | 02. Finance | 02.01 Bud&Forecast
05702. Finance02.02 FinAcc&Rpt | 57 | 02. Finance | 02.02 FinAcc&Rpt
05702. Finance02.03 StratProcmnt | 57 | 02. Finance | 02.03 StratProcmnt
05702. Finance02.04 AP/AR | 57 | 02. Finance | 02.04 AP/AR
05702. Finance02.05 Treas&Inv | 57 | 02. Finance | 02.05 [NAME]
05703. Human Resources03.01 Payroll&Sup | 57 | 03. Human Resources | 03.01 Payroll&Sup
05703. Human Resources03.02 EmpAdvisor | 57 | 03. Human Resources | 03.02 EmpAdvisor
05703. Human Resources03.03 StaffDev&Train | 57 | 03. Human Resources | 03.03 StaffDev&Train
05703. Human Resources03.04 EquityAccess&Div | 57 | 03. Human Resources | 03.04 EquityAccess&Div
05703. Human Resources03.05 IR Mgmnt | 57 | 03. Human Resources | 03.05 IR Mgmnt
05704. Information Technology04.01 ITInfrastr-D&T | 57 | 04. Information Technology | 04.01 ITInfrastr-D&T
05704. Information Technology04.02 ITInfrastr-S&M | 57 | 04. Information Technology | 04.02 ITInfrastr-S&M
05704. Information Technology04.03 ITClientServs-D&T | 57 | 04. Information Technology | 04.03 ITClientServs-D&T
05704. Information Technology04.04 ITClientServs-S&M | 57 | 04. Information Technology | 04.04 ITClientServs-S&M
05705. Facilities Management05.01 PropServices | 57 | 05. Facilities Management | 05.01 PropServices
05705. Facilities Management05.02 FMServices | 57 | 05. Facilities Management | 05.02 FMServices
05705. Facilities Management05.03 FMProjMgmnt | 57 | 05. Facilities Management | 05.03 FMProjMgmnt
05705. Facilities Management05.04 UniServices | 57 | 05. Facilities Management | 05.04 UniServices
05707. Community Engagement07.01 StuRecruit | 57 | 07. Community Engagement | 07.01 StuRecruit
05707. Community Engagement07.02 Mkting | 57 | 07. Community Engagement | 07.02 Mkting
05707. Community Engagement07.03 RelMgmnt | 57 | 07. Community Engagement | 07.03 RelMgmnt
05707. Community Engagement07.04 Alum&Dev | 57 | 07. Community Engagement | 07.04 [NAME]
05711. General Administration11.01 PA,[NAME] | 57 | 11. General Administration | 11.01 PA,[NAME]
05711. General Administration11.02 GenRecordsMgmnt | 57 | 11. General Administration | 11.02 GenRecordsMgmnt
05711. General Administration11.03 PurchTravel&CCds | 57 | 11. General Administration | 11.03 PurchTravel&CCds
05712. Other Activities12.01 AccomServices | 57 | 12. Other Activities | 12.01 AccomServices
05712. Other Activities12.02 Retail&OtherServ | 57 | 12. Other Activities | 12.02 Retail&OtherServ
05712. Other Activities12.03 Commercial Serv | 57 | 12. Other Activities | 12.03 Commercial Serv
05901. Governance01.01 Plan&Policy | 59 | 01. Governance | 01.01 Plan&Policy
05901. Governance01.02 GenMgmnt | 59 | 01. Governance | 01.02 GenMgmnt
05901. Governance01.03 Rpting&Comms | 59 | 01. Governance | 01.03 Rpting&Comms
05901. Governance01.05 Prog&ChgMgmt | 59 | 01. Governance | 01.05 Prog&ChgMgmt
05901. Governance01.06 GovernServ | 59 | 01. Governance | 01.06 GovernServ
05902. Finance02.01 Bud&Forecast | 59 | 02. Finance | 02.01 Bud&Forecast
05902. Finance02.02 FinAcc&Rpt | 59 | 02. Finance | 02.02 FinAcc&Rpt
05902. Finance02.03 StratProcmnt | 59 | 02. Finance | 02.03 StratProcmnt
05902. Finance02.04 AP/AR | 59 | 02. Finance | 02.04 AP/AR
05902. Finance02.05 Treas&Inv | 59 | 02. Finance | 02.05 [NAME]
05903. Human Resources03.01 Payroll&Sup | 59 | 03. Human Resources | 03.01 Payroll&Sup
05903. Human Resources03.02 EmpAdvisor | 59 | 03. Human Resources | 03.02 EmpAdvisor
05903. Human Resources03.03 StaffDev&Train | 59 | 03. Human Resources | 03.03 StaffDev&Train
05903. Human Resources03.04 EquityAccess&Div | 59 | 03. Human Resources | 03.04 EquityAccess&Div
05903. Human Resources03.05 IR Mgmnt | 59 | 03. Human Resources | 03.05 IR Mgmnt
05904. Information Technology04.01 ITInfrastr-D&T | 59 | 04. Information Technology | 04.01 ITInfrastr-D&T
05904. Information Technology04.02 ITInfrastr-S&M | 59 | 04. Information Technology | 04.02 ITInfrastr-S&M
05904. Information Technology04.03 ITClientServs-D&T | 59 | 04. Information Technology | 04.03 ITClientServs-D&T
05904. Information Technology04.04 ITClientServs-S&M | 59 | 04. Information Technology | 04.04 ITClientServs-S&M
05905. Facilities Management05.01 PropServices | 59 | 05. Facilities Management | 05.01 PropServices
05905. Facilities Management05.02 FMServices | 59 | 05. Facilities Management | 05.02 FMServices
05905. Facilities Management05.03 FMProjMgmnt | 59 | 05. Facilities Management | 05.03 FMProjMgmnt
05905. Facilities Management05.04 UniServices | 59 | 05. Facilities Management | 05.04 UniServices
05907. Community Engagement07.01 StuRecruit | 59 | 07. Community Engagement | 07.01 StuRecruit
05907. Community Engagement07.02 Mkting | 59 | 07. Community Engagement | 07.02 Mkting
05907. Community Engagement07.03 RelMgmnt | 59 | 07. Community Engagement | 07.03 RelMgmnt
05907. Community Engagement07.04 Alum&Dev | 59 | 07. Community Engagement | 07.04 [NAME]
05911. General Administration11.01 PA,[NAME] | 59 | 11. General Administration | 11.01 PA,[NAME]
05911. General Administration11.02 GenRecordsMgmnt | 59 | 11. General Administration | 11.02 GenRecordsMgmnt
05911. General Administration11.03 PurchTravel&CCds | 59 | 11. General Administration | 11.03 PurchTravel&CCds
05912. Other Activities12.01 AccomServices | 59 | 12. Other Activities | 12.01 AccomServices
05912. Other Activities12.02 Retail&OtherServ | 59 | 12. Other Activities | 12.02 Retail&OtherServ
05912. Other Activities12.03 Commercial Serv | 59 | 12. Other Activities | 12.03 Commercial Serv
End | End | End | End | End | End | End |  | End | End | End | End | End | End | End | End | End | End | End | End | End | End | End | End | End
 |  |  |  |  |  | 0.1361359596938851 | 0.2970960207993655
 |  |  |  |  |  | 0.6027862327323812 | 0.1547646921095762
 |  |  |  |  |  | 0.4183875022445682 | 0.1742981983599688
 |  |  |  |  |  | Median | [NAME]:
 |  |  |  |  |  |  | Should return 29.7 as it’s the closest to the Median value in H?