tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763163d1642013724-combining-different-if-fuctions-based-on-multiple-criterias-in-different-tabs-example-pl-act-bud-ly-and-departments
Sheet: P&L

Month: | November
Department: | Department 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | January | Department 1
 | MTD |  |  | YTD |  |  |  |  |  |  |  |  |  |  | February | Department 2
Category | Actual | Budget | 2020 | Actual | Budget | 2020 |  |  |  |  |  |  |  |  | March | Department 3
Revenue 1 |  |  |  | ? | ? | ? |  |  |  |  |  |  |  |  | April
Revenue 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
Total revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
Cost 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
Cost 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
Total costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
1. I want a formula that returns values based on Month (B1), Department (B2), Actual/Budget/2020 on MTD and YTD and the categories (A5,A6,A8 and A9). So when I change the month and department, the values in my MTD and YTD table will change according to this.
2. In this example I have created 3 departments in 3 different tabs with unique values in actual, budget and 2020 numbers (the set up is the same in all tabs).
3. In the D1,D2 and [NAME] tabs I have set different categories (column A in each tab).
4. The formulas I have put in this tab (P&L) in cell B5, C5 and D5 is the correct numbers, and somehow how I want it, but the problem is that if i change Month and Department in Cell B1 and B2, the whole table wont update.
5. I also have an issue figuring out how I can get the Year-to-date numbers based on Month and Department.
Spreadsheet: 1292c8d3-6d22-454f-a0e9-a68dd9713ec9
Sheet: Operating

OPERATING/PROGRAMMATIC |  |  |  |  |  |  | 120629
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Capital Maintenance Budget
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund |  |  | $ | 0 |  | $ | 0
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund
 | Special Revenue |  |  | $ | 3000000 |  | $ | 0
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | Appropriation will serve to preserve permanent public buildings.  Contractors will perform all repairs.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | No |  | x | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
 | This ordinance will authorize funding to repair public facilities and avoid inflation of future deferred repair costs.
 | Facilities included are the convention center, municipal auditorium, [NAME], and the American
 | Royal Center.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 177594d1346354124-tally-chart-using-buttons-mcsmith
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Red
 |  |  |  |  |  |  |  |  |  | Blue
 |  |  |  |  |  |  |  |  |  | Green
 |  |  |  |  |  |  |  |  |  | Yellow
 |  |  |  |  |  |  |  |  |  | Purple
 |  |  |  |  |  |  |  |  |  | Violet
 |  |  |  |  |  |  |  |  |  | White
 |  |  |  |  |  |  |  |  |  | Black
 |  |  |  |  |  |  |  |  |  | Received
 |  |  |  |  |  |  |  |  |  | Dispatched
 |  |  |  |  |  |  |  |  |  | Invoiced
 |  |  |  |  |  |  |  |  |  | [NAME]
 | 1 |  | 2 |  | 3 |  | 4
 | 5 |  | 9 |  | 10 |  | 11
 | 12 |  | 6 |  | 8 |  | 7
Spreadsheet: 746076d1630493099-conditional-formatting-for-highlighting-month-if-dates-are-not-matched-sample1234556-1-
Sheet: Sheet1

 |  |  | Case 1 |  |  |  |  |  |  |  | Case 2
 |  |  | Month |  | Start Date | End Date |  |  |  | Start Date | End Date | Net workdays
 |  |  | 2021-08-01 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00 | 5
 |  |  | 2021-08-02 00:00:00 |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00 |  |  |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00 | 9
 |  |  | 2021-08-03 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 | 20
 |  |  | 2021-08-04 00:00:00 |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | Month, start date and end date not falling in the same month |  |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 13
 |  |  | 2021-08-05 00:00:00 |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | Month, start date and end date not falling in the same month |  |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | 13
 |  |  | 2021-08-06 00:00:00 |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00 |  |  |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  | Here if the network days are not matching with [NAME] date and end date, then that particular cell to be highlighted
 |  |  | Start date, end date and month should fall within the same month . If any of the column D,F and G not matching within the month then month column should be highligted. Here [NAME], F7 adn G7 not fallling on same month hence i need to get column D7 to be highlighted nd similar to D8, F8 adn G8.
Spreadsheet: 117762d1313004571-result-for-last-occurence-solved_result_for_last_occurance
Sheet: example

numbers | occurance | dates |  | inputs | result_date_of_first_occurance | result_date_of_last_occurance | result_date_of_last_occurance | check_
1 |  | 2008-01-01 00:00:00 |  | 1 |  |  | 2010-05-01 00:00:00
2 |  | 2009-01-01 00:00:00 |  | 2 |  |  | 2010-06-01 00:00:00
3 |  | 2009-01-01 00:00:00 |  | 3 |  |  | 2009-01-01 00:00:00
2 |  | 2010-01-01 00:00:00 |  | 4 |  |  | 2010-02-01 00:00:00
4 |  | 2010-02-01 00:00:00 |  | 5 |  |  | 2010-04-01 00:00:00
5 |  | 2010-04-01 00:00:00 |  | 6 |  |  | 2010-04-01 00:00:00
6 |  | 2010-04-01 00:00:00 |  | 7
1 |  | 2010-05-01 00:00:00 |  | 8
2 |  | 2010-06-01 00:00:00 |  | 9
Spreadsheet: 111424d1307792619-testing-a-few-conditions-and-also-within-multiple-ranges-sample-data-for-y-or-n-check
Sheet: HTRANS DATA

 |  |  | ARTICLE |  | CODE | y / n | y / n check | CAL DAY | CAL DAY |  |  |  |  |  |  |  |  |  |  | sum |  |  |  |  |  |  | BU | CM | GM | SALES
 |  |  | 12952 |  | M10 | Y |  | 20090530 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 9.47 | R 3.42 | R 171.05
 |  |  | 12952 |  | M01 | Y |  | 20090530 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 10.75 | R 4.78 | R 171.05
 |  |  | 12952 |  | M10 | Y |  | 20090530 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 10.34 | R 3.42 | R 171.05
 |  |  | 12952 |  | M01 | Y |  | 20090531 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 11.62 | R 4.78 | R 171.05
 |  |  | 12952 |  | M01 | Y |  | 20090601 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 11.62 | R 4.78 | R 171.05
 |  |  | 12952 |  | M01 | Y |  | 20090602 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 11.62 | R 4.78 | R 171.05
 |  |  | 12952 |  | M01 | Y |  | 20090603 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 13.80 | R 4.78 | R 171.05
 |  |  | 83283 |  | M01 | Y |  | 20090605 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 11.62 | R 4.78 | R 171.05
 |  |  | 83283 |  | M01 | Y |  | 20090606 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | R 11.62 | R 4.78 | R 171.05
Spreadsheet: 123680d1317805208-designing-the-best-structure-for-data-sheet-kennybonesexample
Sheet: Names

Name | Jacket | Pants | Shoes | T-Shirt | Leather Pants | Hard Hat
[NAME] | 3 | 2 | 4 | 3 | 3 | 2
[NAME] | 2 | 1 | 5 | 1 | 3 | 1
[NAME] | 1 | 3 | 2 | 3 | 1 | 1
Ringo Starr | 3 | 1 | 5 | 3 | 2 | 4
Spreadsheet: 145156d1331324512-need-help-with-triggering-checkboxes-to-other-cells-jen-l_09mar12_01
Sheet: Sheet1

 |  | EXPENSE REPORT
 |  |  |  |  |  |  |  |  |  | Billable: | 1
Employee Name: |  |  |  |  |  |  |  |  |  | Indirect:
Project #: |  |  |  |  |  |  |  | Report Date:
Purpose:
Expense Category |  | Description |  |  |  | Receipt? Y / N | Service Date(s) |  |  | Amount
Approved: |  |  |  |  |  |  | Total Expense Report:
Direct:
Copies
Documents/Data |  |  |  |  |  |  |  | Administrative-100
Membership |  |  |  |  |  |  |  | Business Development-200
Other |  |  |  |  |  |  |  | Anadarko, Bankruptcy-210002
Postage/Shipping |  |  |  |  |  |  |  | Library-300
Supplies |  |  |  |  |  |  |  | Bent-Cambridge-211002
Travel |  |  |  |  |  |  |  | Breeze-Eastern-Glennhead-212002.07
Entertainment |  |  |  |  |  |  |  | Brooklyn Union-210009
Ground Transportation |  |  |  |  |  |  |  | [NAME] (BKK)-210006
Incidentals |  |  |  |  |  |  |  | [NAME]
Lodging |  |  |  |  |  |  |  | [NAME] Oil-212002.01
Meals |  |  |  |  |  |  |  | CLP [NAME]
Parking |  |  |  |  |  |  |  | CSR-212002.08
Tolls |  |  |  |  |  |  |  | Fairmount Minerals-210017
Document Management |  |  |  |  |  |  |  | Fitchburg-210011
Auto Expense |  |  |  |  |  |  |  | FM Zinc Smelter-211005
Dues and Subscriptions |  |  |  |  |  |  |  | GE - Hudson Briefing-21003
 |  |  |  |  |  |  |  | GE Insurance-210004
 |  |  |  |  |  |  |  | Gnarus Library/Administration SOW #1-212002.00
Indirect: |  |  |  |  |  |  |  | [NAME] Gas-210010
Auto Expenses |  |  |  |  |  |  |  | [NAME]
Indirect Library |  |  |  |  |  |  |  | Monsanto Colella-210020
Office Supplies |  |  |  |  |  |  |  | Monsanto Cost-210003
Postage |  |  |  |  |  |  |  | [NAME]
Professional Services |  |  |  |  |  |  |  | Montana Fish-210007
Meals and Entertainment |  |  |  |  |  |  |  | NCR, Fox River-211004
Telephone/Mobile Phone |  |  |  |  |  |  |  | NEC-Phase 2-210018
 |  |  |  |  |  |  |  | NuWest-210019
 |  |  |  |  |  |  |  | NYSEG-210001
 |  |  |  |  |  |  |  | [NAME] Ins.-210022
 |  |  |  |  |  |  |  | Orange & Rockland MGP-210013
 |  |  |  |  |  |  |  | Paulsboro Plains All America-210016
 |  |  |  |  |  |  |  | Portland Harbor Costs-211001
 |  |  |  |  |  |  |  | Portland Harbor-210014
 |  |  |  |  |  |  |  | Project Gamo-212001
 |  |  |  |  |  |  |  | RIAPERC-212002.06
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | TCP-210015
 |  |  |  |  |  |  |  | Tidewater-210005
 |  |  |  |  |  |  |  | Valley Crest-210021
 |  |  |  |  |  |  |  | VanderMark-Lead Contamination-212002.03
 |  |  |  |  |  |  |  | VanderMark-VOC Contamination-212002.04
Spreadsheet: 795930d1663011409-activate-formula-to-find-true-average-of-ph-ph-formula-question
Sheet: Sheet1

pH rep 1 | pH rep 1 | pH rep 1 | Arithmetic Average pH | True Average  -log_10[(SCi)/(n)] | <--HOW DO I SET UP THIS FORMULA??
9.07 | 9.16 | 9.18
7.87 | 7.84 | 7.86
8.48 | 8.6 | 8.68
7.55 | 7.61 | 7.65
7.18 | 7.16 | 7.09
7.9 | 7.77 | 7.64
7.74 | 7.74 | 7.66
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Unit 13S

NAME | SURNAME | P1 | P2 | P3 | P4 | P5 | M1 | M2 | D1 | D2 | Final Grade | Final Points Value
Spreadsheet: 588095d1535474454-find-text-in-cell-from-list-and-return-text-from-adjacent-cell-book2-7-
Sheet: Sheet1

Year | Month | Date | Place | Cost | Category |  |  |  |  |  | Word | category
 |  | 43242 | HARRIS TEETER #305 | -6.51 |  |  |  |  |  |  | Beach | Vacation
 |  | 43321 | HARRIS TEETER 0061 | -7.46 |  |  |  |  |  |  | Savings | Savings
 |  | 43308 | HARRIS TEETER 305 | -9.64 |  |  |  |  |  |  | Payroll | Income
 |  | 43306 | harris Teeter 323 | -10 |  |  |  |  |  |  | [NAME] | Groceries
 |  |  | Payroll From Work
Spreadsheet: joe_parks__15051__BridgeDPR0617
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1431.987462800002 | 6586.987462800002 | 11877.9874628
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1431.987462800002 | 6586.987462800002 | 11877.9874628
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 550252d1512173885-needing-help-creating-a-template-for-hospital-equipment-uptime-biomed
Sheet: Sheet1

 | CHAZ REGIONAL HOSPITAL - Biomedial Engineering
 |  | Monthly Reporting |  |  | Enter the start day/time
 | 2017-12-17 00:00:00 |  |  |  |  | Enter the end day/time |  |  |  |  |  |  | Total time available in month of Dec.
 |  |  |  |  |  |  |  |  |  |  |  |  | Used for calculating totals below
 | IV Pump #4329-17 | 1st Occurrence | 2nd Occurrence | 3rd Occurrence | 4th Occurrence | 5th Occurrence |  |  | Monthly Totals
 | Downtime | 2017-11-27 10:00:00 | 2017-11-27 14:00:00 | 2017-11-29 14:00:00 |  |  |  |  |  |  |  |  |  |  | Total time for month this
 | Uptime | 2017-11-28 09:00:00 | 2017-12-01 19:30:00 | 2017-12-01 19:30:00 |  |  |  |  |  |  |  |  |  |  | unit was available for use.
 | Total |  |  |  |  |  |  | Down Time |  | Total Uptime |  | Mo. %
 | Repair Time Total | 6.5 | 8.75 |  |  |  |  | Repair Time
 | Repair Cost Total | 525.33 | 235.41 |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time |  |  |  | Mo. %
 | IV Pump #4364-17
 | Downtime | 2017-11-27 14:00:00
 | Uptime | 2017-12-01 19:30:00 |  |  |  |  |  |  |  |  | Do you want to auto enter these times by copying data above (E8) or do you
 | Total |  |  |  |  |  |  |  |  |  | want to manually enter because the times will differ from E8 ?
 | Repair Time Total
 | Repair Cost Total |  |  | Do you want numerous items on each sheet … or do you want only
 | Patient Wait Times |  |  | one piece of equipment per sheet ?
 | IV Pump #2851-15 |  |  |  |  |  |  |  |  |  | This is just one idea. We can change this
 | Downtime | 2017-11-27 14:00:00 |  |  |  |  |  |  |  |  | around any way you want, so long as the design is
 | Uptime | 2017-12-01 19:30:00 |  |  |  |  |  |  |  |  | amenable to obtaining totals and percentages.
 | Total
 | Repair Time Total
 | Repair Cost Total
 | Patient Wait Times
 | Surgical Laser #001-14
 | Downtime | 2017-11-27 14:00:00
 | Uptime | 2017-12-01 19:30:00
 | Total
 | Repair Time Total
 | Repair Cost Total
 | Patient Wait Times
 | Hematology #1262-12
 | Downtime | 2017-11-27 14:00:00
 | Uptime | 2017-12-01 19:30:00
 | Total
 | Repair Time Total
 | Repair Cost Total
 | Patient Wait Times
 | EKG #5402-15
 | Downtime | 2017-11-27 14:00:00
 | Uptime | 2017-12-01 19:30:00
 | Total
 | Repair Time Total
 | Repair Cost Total
 | Patient Wait Times
 | ECG #7921-13
 | Downtime | 2017-11-27 14:00:00
 | Uptime | 2017-12-01 19:30:00
 | Total
 | Repair Time Total
 | Repair Cost Total
 | Patient Wait Times
Spreadsheet: 539047d1505935209-conditional-formatting-for-multiple-checkboxes-client
Sheet: Sheet1

Company Name | Client | [NAME] | Contract |  | User Agreement |  | Disclosure Signed |  | Portfolio |  | Questionnaire
Carmela's Closet | [NAME] | GP Website |  | False |  | False |  | True |  | True |  | True
Polard Mocks | [NAME] |  |  | False |  | False |  | False |  | False |  | False
InterLace Design Co. | [NAME] |  |  | False |  | False |  | False |  | False |  | False
Pure Life Co. | Micka Black |  |  | False |  | False |  | False |  | False |  | False
Spreadsheet: 526131d1499155181-value-change-as-the-coloum-fills-working-sheet
Sheet: Sheet1

 |  |  |  | 1
 |  |  | Estimate
 |  | Split |  | 1 | 5 | 6 | 5 | 8 | 8 | 5
 |  | Window |  | 1 | 2 | 5 | 8 | 2 | 4 | 8
 |  | Cooler |  | 2 | 6 | 8 | 8 | 2 | 8 | 5
 |  | [NAME] |  | 5 | 5 | 6 | 5 | 8 | 8 | 5
 |  | Total
Spreadsheet: 140369d1328721442-changing-slope-calculation-ef31_changingslopes
Sheet: Data to be referenced in sheet

 |  | 2012-01-01 00:00:00 | 9
 |  | 2012-01-02 00:00:00 | 14 |  | This is where the data will be pulled into
 |  | 2012-01-03 00:00:00 | 18
 |  | 2012-01-04 00:00:00 | 23
 |  | 2012-01-05 00:00:00 | 25
 |  | 2012-01-06 00:00:00 | 30
 |  | 2012-01-07 00:00:00 | 35
 |  | 2012-01-08 00:00:00 | 42
 |  | 2012-01-09 00:00:00 | 48
 |  | 2012-01-10 00:00:00 | 55
 |  | 2012-01-11 00:00:00 | 59
 |  | 2012-02-03 00:00:00 | 60
 |  | 2012-02-04 00:00:00 | 68
 |  | 2012-02-05 00:00:00 | 73
 |  | 2012-02-06 00:00:00 | 78
 |  | 2012-02-08 00:00:00 | 80
 |  | 2012-02-20 00:00:00 | 89
 |  | 2012-02-21 00:00:00 | 93
 |  | 2012-02-22 00:00:00 | 100
 |  | 2012-02-23 00:00:00 | 110
 |  | 2012-02-24 00:00:00 | 114
 |  | 2012-02-25 00:00:00 | 117
 |  | 2012-02-26 00:00:00 | 124
 |  | 2012-02-27 00:00:00 | 130
 |  | 2012-02-28 00:00:00 | 133
 |  | 2012-02-29 00:00:00 | 139
 |  | 2012-03-01 00:00:00 | 150 |  |  | GO TO OTHER SHEET
 |  | 2012-03-02 00:00:00 | 151
 |  | 2012-03-03 00:00:00 | 152
 |  | 2012-03-04 00:00:00 | 160
Spreadsheet: 844489d1696266044-unique-vstack-subtotal-on-two-filtered-tables-subtotal-tabel-row-headers-into-unique-list-using-vstack-for-mulitple-tables-question
Sheet: Sheet1

 |  | Animal list 1 | Category
 |  | Cat | 1
 |  | Dog | 1
 |  | Frog | 2
 |  | Chicken | 2
 |  | Animal list 2 | Category
 |  | Horse | 1
 |  | Eagle | 2
 |  | Cat | 1
 |  | Frog | 2
 |  | The below list in C21 but with subtotal function so if I filter one table the spilled array will adjust
 |  | Eagle
 |  | Cat
 |  | Frog
 |  | Dog
 |  | Chicken
Spreadsheet: 873549d1720039802-find-a-result-from-2-matrix-tables-matrix-example
Sheet: Results

 | users / groups |  |  |  |  |  | functions / groups |  |  |  |  |  | results
 |  | Production | Sales | Finance | Management |  |  | Production | Sales | Finance | Management |  |  | Order | Quote | Job | Pay | PO's | Supplier
 | User1 | x |  |  |  |  | Order | x | x | x | x |  | User1 | x |  | x |  | x
 | User2 | x |  |  |  |  | Quote |  | x | x |  |  | User2 | x |  | x |  | x
 | User3 |  | x |  |  |  | Job | x | x |  |  |  | User3 | x | x | x |  | x
 | User4 |  | x |  |  |  | Pay |  |  | x |  |  | User4 | x | x | x |  | x
 | [NAME] |  | x |  |  |  | PO's | x | x | x |  |  | [NAME] | x | x | x |  | x
 | [NAME] |  |  | x |  |  | Supplier |  |  | x | x |  | [NAME] | x | x |  | x | x | x
 | User7 |  |  |  | x |  |  |  |  |  |  |  | User7 | x |  |  |  |  | x
 | User8 |  |  |  | x |  |  |  |  |  |  |  | User8 | x |  |  |  |  | x
 | [NAME] | x | x |  |  |  |  |  |  |  |  |  | [NAME] | x | x | x |  | x
 | User10 | x |  |  |  |  |  |  |  |  |  |  | User10 | x |  | x |  | x
1 | find the group for the user (x indicates true)
2 | find the function to the group (x indicates true)
3 | show the result of user to function (x indicates true)
Spreadsheet: 693592d1599050072-sum-if-horizontal-and-vertical-criteria-matches-excel-example
Sheet: Sheet1

 |  |  |  | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00
 | Summary |  |  | £ | £ | £ | £ | £ | £
 | Apples |  |  | 10000 | 1000 | 8750 | 5000 | 12000 | 20000
 | Pears |  |  | 0 | 0 | 0 | 0 | 0
 | Oranges |  |  | 3000 | 5000 | 6000 | 2000 | 1000 | 4000
 | Bananas |  |  | 6000 | 4400 | 4400 | 4400 | 4400 | 4400
 | Pineapple |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Strawberries |  |  | 0 | 0 | 1500 | 0 | 2000 | 0
 | Melon |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
 |  |  | 2020-07-01 00:00:00
 |  | Melon
Spreadsheet: 07d6e1a4-3d95-4af3-b6b0-7f3170c07f26
Sheet: OPT 1

Step 1 Exclude by fund | Step 2 Exclude by object | Step 3 Exclude by function | Step 4 Classify by fund | Step 5 Classify by object | Step 6 Classify by function | Step 7 Classify by OPU | If Elementary-Secondary Expenditure is... |  | Then the Expenditure is treated as…
Exclude funds  017, 021, 022, 023, 024, 026, 027, 028, 200 | Exclude objects 470-479, 810-819, 881, 891, 900-969 | Exclude functions 7000-7990 |  |  | 1000-1390, 1900-1990, 4100-4390, 4600-4690 |  | Instruction | II.1 | Included - Classroom instructional
 |  |  |  |  | 2100-2190  (except 2110, 2121, 2131, 2141, 2151, 2171) |  | Pupil Support Services | II.2
 |  |  |  |  | 2200-2290  (except 2211, 2221, 2231) |  | Instructional Staff Support Services | II.3
 |  |  |  |  | 2300-2419 | 2110, 2121, 2131, 2141, 2151, 2171, 2211, 2221, 2231 and 2490 if OPU = central | General Administration | II.4 | Included - Non-classroom
 |  |  |  |  | 2420-2429 | 2110, 2121, 2131, 2141, 2151, 2171, 2211, 2221, 2231 and 2490 if any other OPU | School Administration | II.5
 |  |  |  |  | 2700-2790 |  | Operation and Maintenenace of Plant | II.6
 |  |  |  |  | 2800-2890 |  | Pupil Transportation | II.7
 |  |  |  |  | 2500-2690, 2900-2990 |  | Other and Non-specified Support Services | II.8
 |  |  |  |  | 3100-3190 |  | Elem-Sec Noninstructional Food Service | II.9
 |  |  | All fund 011, 014, 020 |  | 3300, 3400-3431 |  | Elem-Sec Noninstructional - Enterprise Operations | II.10 | Non-Operating                             (Excluded)
 |  |  |  |  | 3900, 4500-4590 |  | Elem-Sec Noninstructional - Other | II.11
 |  |  | All fund 013 |  | 3200-3250, 3290 |  | Nonelem-sec Programs - Community Svcs | II.12
 |  |  | All fund 012, 413, 414, 426, 501, 535 |  | 1400-1490 |  | Nonelem-sec Programs - Adult Ed | II.13
 |  |  | All fund 025, 401 |  | 3260 |  | Nonelem-sec Programs - Other | II.14
 |  |  |  |  | 5200-5900 |  | Construction | III.1
 |  |  |  |  | 5100 |  | Land and Existing Structures | III.2
 |  |  |  | 645 (when function = instruction) |  |  | Equipment - Instructional | III.3
 |  |  |  | 645 (any other function), 650, 660 |  |  | Equipment - Other | III.4
 |  |  |  |  |  |  | Payments to Other Governments | IV.3-5
 |  |  |  |  | 6000-6100 |  | Interest on Debt | IV.6