tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861592d1709483345-formula-help-to-reflect-value-in-table-1-from-table-2-in-same-row-matching-criteria-demo-030324
Sheet: Statement

 |  | Table 1 |  |  | Table 2
 |  | Fruits | Month |  | Fruits | MONTHS
 |  | Income | 2023-04-30 00:00:00 | <----Criteria | Income | 2023-04-30 00:00:00 |  | 2023-06-30 00:00:00
 | Criteria---> | Water melon |  | <----Corrsponding value of same row from table 2 ( Cell G6) | Water melon | 550.739308999999 | 553.4624294999909 | 642.3954794000001 | Target value G6
 |  | Apple |  | <----Corrsponding value of same row from table 2 ( Cell G7) | Apple | 544.7793536999989 | 620.4713416000011 | 614.8303793000002 | Target value G7
 |  | Orange |  | <----Corrsponding value of same row from table 2 ( Cell G8) | Orange | 141.816426999999 | 148.993615 | 149.979060000001 | Target value G8
 |  | Mango |  |  | Mango | 1 | 1 | 1
 |  | Blackberry |  |  | Blackberry | 2.5 | 0.08499999999999996 | 17.835
 |  | Expenses |  |  | Expenses
 |  | Water melon |  |  | Water melon | 375.739308999999 | 378.4624294999909 | 467.3954794000001
 |  | Apple |  |  | Apple | 369.7793536999989 | 445.4713416000011 | 439.8303793000002
 |  | Orange |  |  | Orange | 33.183573000001 | 26.006385 | 25.020939999999
 |  | Mango |  |  | Mango | 174 | 174 | 174
 |  | Blackberry |  |  | Blackberry | 172.5 | 174.915 | 157.165
 |  | Need your help on to reflect the cell value of same row matching with month as criteria in first table in cell no. D5 against table 2. In give data set if I select month Apr 23 in table 1 ( D5), corresponding data in table 2 of April23 (column G)  should capture in D column against each fruit in same line. Hope I could explain my query.
Spreadsheet: 677702d1589475502-isolating-outlier-data-sets-2020-05-13-oeldere2-mromar-677505d1589377845-isolating-outlier-data-sets-sample-data
Sheet: Sheet2

criteria | (Meerdere items)
Rijlabels
2020-01-01 00:00:00
123 Main Street
1
2020-01-02 00:00:00
456 Main Street
2
2020-01-03 00:00:00
123 Main Street
1
5
2020-01-04 00:00:00
789 Main Street
3
2020-01-05 00:00:00
456 Main Street
2
4
2020-01-06 00:00:00
123 Main Street
1
Eindtotaal
Spreadsheet: 701439d1603769130-salary-budget-report-sumifs-formula-salary-budget
Sheet: Budgeted Salaries

 |  |  |  |  |  |  | 1 |  |  |  | Year To Date
 |  |  |  |  |  |  |  | Budget Spend |  |  | Budget Spend
 |  |  |  |  |  |  |  | Actual Spend |  |  | Actual Spend
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
EMPLOYEE MONTHLY SALARY BUDGET
Employee Code Number | Employee Name | Desgnation | Date of Employment | Period | Budgeted Work Hours | [NAME] | Budgeted Overtime Hours | Budgeted Overtime Rate | Budgeted Benefits | Budgeted Bonus | Total Budgeted Salaries | Actual | [NAME] |  | Notes
CA1 | MARY | MANGER | 1974-05-30 00:00:00 | 1 | 200 | 10 | 10 |  | 200 | 1000 |  |  |  | 1
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 1 | 200 | 5 | 10 |  | 120 | 500
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 1 | 200 | 5 | 10 |  | 120 | 500
CA1 | MARY | MANGER | 1974-05-30 00:00:00 | 2 | 200 | 10 | 10 |  | 200 | 1000
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 2 | 200 | 5 | 10 |  | 120 | 500
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 2 | 200 | 5 | 10 |  | 120 | 500
CA1 | MARY | MANGER | 1974-05-30 00:00:00 | 3 | 200 | 12 | 10 |  | 250 | 1200
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 3 | 200 | 7 | 10 |  | 200 | 700
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 3 | 200 | 7 | 10 |  | 200 | 700
Desired Outcome
CA1 | MARY | MANGER | 1974-05-30 00:00:00 | 1 | 200 | 10 | 10 |  | 200 | 1000 |  | 3455
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 1 | 200 | 5 | 10 |  | 120 | 500 |  | 1650
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 1 | 200 | 5 | 10 |  | 120 | 500 |  | 1650
CA1 | MARY | MANGER | 1974-05-30 00:00:00 | 2 | 200 | 10 | 10 |  | 200 | 1000 |  | 3395
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 2 | 200 | 5 | 10 |  | 120 | 500 |  | 1717.5
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 2 | 200 | 5 | 10 |  | 120 | 500 |  | 1717.5
CA1 | MARY | MANGER | 1974-05-30 00:00:00 | 3 | 200 | 12 | 10 |  | 250 | 1200 |  | 4048
CA2 | [NAME] | CLERK | 1984-03-20 00:00:00 | 3 | 200 | 7 | 10 |  | 200 | 700 |  | 2415.5
CA3 | [NAME] | [NAME] | 1980-07-08 00:00:00 | 3 | 200 | 7 | 10 |  | 200 | 700 |  | 2415.5
Spreadsheet: 715954d1611934241-pull-x-information-from-another-page-excel-example
Sheet: Dashboard

[NAME]
 | Site | Notes
Note:
Spreadsheet: 75869d1276499350-auto-copy-record-to-different-spreadsheets-example
Sheet: programe 1

Surname | Name | code | Sallary | Shift | Company | Τype | [NAME]
surname4 | name 4 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 1
surname8 | name 8 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
surname12 | name 12 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 1
surname16 | name 16 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
surname20 | name 20 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
surname24 | name 24 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
surname27 | name 27 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 1
surname30 | name 30 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
surname33 | name 33 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
surname36 | name 36 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
surname39 | name 39 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
Spreadsheet: 800683d1665798796-formula-for-counting-occurrences-of-shift-times-dummy-1-
Sheet: Sheet1

 | Time of Arrival
 | 2021-10-01 03:01:00
 | 2021-10-02 23:21:00 |  |  |  |  | formula | manual
 | 2021-10-31 06:42:00 |  |  |  | 08:00-14:30 |  | 5
 | 2021-12-08 15:02:00 |  |  | 14:30:00 | 22:00:00 |  | 8
 | 2021-10-15 16:11:00 |  |  |  | 22:00-08:00 |  | 6
 | 2021-12-08 15:27:00
 | 2021-12-24 11:35:00
 | 2021-10-23 16:13:00
 | 2021-12-11 03:46:00
 | 2021-12-12 10:08:00
 | 2022-01-09 19:20:00
 | 2022-01-16 07:04:00
 | 2022-02-07 13:06:00
 | 2021-12-30 20:25:00
 | 2022-01-03 13:29:00
 | 2022-02-12 12:20:00
 | 2021-10-18 20:18:00
 | 2022-02-17 23:12:00
 | 2022-02-27 15:01:00
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: West Power Admins

 | West Power Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  | 10000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  | 10000 |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  |  | 40000
ENASUPP | Supplies Expense |  |  |  |  | 17280
ENAMKTEX | Marketing |  |  |  |  |  |  |  |  | [NAME] | 33600 | 1
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 52800
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  | 5000 |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  | 5000 |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.22.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-22 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 4 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0
 | 4TH FL | 38 | 22 | 19 | 0 | 4 | 0 | 2 | 0 | 0 | 1 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 19 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-22 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 13 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 1
 | 5TH FL | 34 | 20 | 16 | 0 | 4 | 1 | 2 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 21 | 0 | 6 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 21043d1208086720-excel-import-stock-branches
Sheet: STK BR4

PART_NO | DESC | QTY
150069 | MAJMUR A00003 | 1
COS100 | PERT PLUS 200 | 5
BEU023 | MAKE UP SET 7070 | 3
BEU003 | MAKE UP SET 8000 | 3
BEU011 | MAKE UP SET 8080 | 4
MAK014 | MAKE UP SET 9070 R | 2
BEU063 | MAKE UP SET 9090 | 1
BEU037 | MAKE UP SET 9292 | 2
MAK060 | MAKE UP SET 9595W | 1
BEU012 | MAKE UP SET 979 | 2
COS550 | MAKE UP 220 | 5
Spreadsheet: 23083d1212494172-how-to-use-vlookup-euro2008finals
Sheet: Sheet1

2008-06-07 00:00:00 | Switzerland | - | Czech Rep | 2 | - | 1 |  |  |  |  | PLD | W | D | L | F | A | [NAME] | PTS
2008-06-07 00:00:00 | Portugal | - | Turkey | 2 | - | 0 |  |  |  | Czech Rep | 1 | 0 | 0 | 1 | 1 | 2 | 1 | 0
2008-06-08 00:00:00 | Austria | - | Croatia | 1 | - | 0 |  |  |  | Portugal | 1 | 1 | 0 | 0 | 2 | 0 | -2 | 3
2008-06-08 00:00:00 | Germany | - | Poland | 0 | - | 2 |  |  |  | Switzerland | 1 | 1 | 0 | 0 | 2 | 1 | -1 | 3
2008-06-09 00:00:00 | Romania | - | France | 1 | - | 2 |  |  |  | Turkey | 1 | 0 | 0 | 1 | 0 | 2 | 2 | 0
2008-06-09 00:00:00 | Holland | - | Italy | 1 | - | 1
2008-06-10 00:00:00 | Spain | - | Russia | 2 | - | 0 |  |  |  | Austria | 1 | 1 | 0 | 0 | 1 | 0 | -1 | 3
2008-06-10 00:00:00 | Greece | - | Sweden | 3 | - | 3 |  |  |  | Croatia | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0
2008-06-11 00:00:00 | Czech Rep | - | Portugal |  | - |  |  |  |  | Germany | 1 | 0 | 0 | 1 | 0 | 2 | 2 | 0
2008-06-11 00:00:00 | Switzerland | - | Turkey |  | - |  |  |  |  | Poland | 1 | 1 | 0 | 0 | 2 | 0 | -2 | 3
2008-06-12 00:00:00 | Croatia | - | Germany |  | -
2008-06-12 00:00:00 | Austria | - | Poland |  | - |  |  |  |  | France | 1 | 1 | 0 | 0 | 2 | 1 | -1 | 3
2008-06-13 00:00:00 | Italy | - | Romania |  | - |  |  |  |  | Holland | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1
2008-06-13 00:00:00 | Holland | - | France |  | - |  |  |  |  | Italy | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1
2008-06-14 00:00:00 | Sweden | - | Spain |  | - |  |  |  |  | Romania | 1 | 0 | 0 | 1 | 1 | 2 | 1 | 0
2008-06-14 00:00:00 | Greece | - | Russia |  | -
2008-06-15 00:00:00 | Switzerland | - | Portugal |  | - |  |  |  |  | Greece | 1 | 0 | 1 | 0 | 3 | 3 | 0 | 1
2008-06-15 00:00:00 | Turkey | - | Czech Rep |  | - |  |  |  |  | Russia | 1 | 0 | 0 | 1 | 0 | 2 | 2 | 0
2008-06-16 00:00:00 | Austria | - | Germany |  | - |  |  |  |  | Spain | 1 | 1 | 0 | 0 | 2 | 0 | -2 | 3
2008-06-16 00:00:00 | Poland | - | Croatia |  | - |  |  |  |  | Sweden | 1 | 0 | 1 | 0 | 3 | 3 | 0 | 1
2008-06-17 00:00:00 | France | - | Italy |  | -
2008-06-17 00:00:00 | Holland | - | Romania |  | -
2008-06-18 00:00:00 | Greece | - | Spain |  | -
2008-06-18 00:00:00 | Russia | - | Sweden |  | -
Spreadsheet: 138441d1327663622-average-out-a-total-starting-with-0-spread
Sheet: Sheet1

 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
sales | 0 | ** | ** | ** | ** | ** | ** | ** | ** | ** | ** | 650
Spreadsheet: 816579d1675711241-nested-if-with-vlookup-based-on-a-yes-no-selection-test-for-vlookup-mr-excel-etaf
Sheet: Dining List

 | ser | Title | Surname | First Name | Payment Type
 |  |  | Black | [NAME] | BACS Confirmed
 |  | Mrs | [NAME] | [NAME] | BACS TBN
 |  | Mr | Jones | [NAME] | Card
 |  | Mr | Smith | [NAME] | BACS Confirmed
 |  | Ms | Ward | [NAME] | Card
 |  | Mrs | White | [NAME] | BACS Confirmed
Spreadsheet: 871676d1718103247-want-only-digits-in-cell-account-details-format
Sheet: Employee Details

District Code: |  |  |  |  |  | College Code:
Name of College:
S. No. | Employee Name | Account No. | IFS Code | Bank Name | Branch | Total Amount
 |  | 03 | BKID0ARYAGB
- | - | - | - | - | - | -
Spreadsheet: larry_campbell__21028__PTE Calcs
Sheet: Truck Loading

LOADING EMISSIONS CALCULATIONS
 |  | [NAME] | Daily Max | AVG. VAPOR | SAT. | ANNUAL | MONTHLY
EPN: | PRODUCT | Wt | Ambient | PRESSURE | FACTOR | THROUGHPUT | EMISSIONS
 | (1) | (lb/lb-mol) | deg F | psia | (2) | (gals/year) | tons/year
LOAD | CONDENSATE | 92 | 65.56 | 3.2898 | 0.6 | 150
NOTES:
(1) Condensate is assumed to be 100 percent VOC.
(2) Saturation factor for submerged loading, dedicated normal service.
(3) [NAME] ambient temperatures taken from EPA Tanks program database.
Spreadsheet: 77857d1278354895-figuring-golf-skins-and-highlighting-that-cell-skins
Sheet: SKINS

 |  |  | 2009-04-23 00:00:00 | Week 1
 |  |  |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Gross | Net
 |  | Net |  | Front Par | 4 | 4 | 5 | 3 | 4 | 3 | 5 | 3 | 4 | 35
 |  | Rank | Name | HCP | 10 | 4 | 5 | 12 | 16 | 14 | 6 | 2 | 1
 |  |  |  | Low Score for [NAME] (MIN) | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0
 |  | 1 | [NAME] | 5 | 6 | 4 | 5 | 3 | 5 | 4 | 5 | 6 | 6 | 44 | 39
 |  | 6 | [NAME] | 12 | 6 | 6 | 5 | 3 | 6 | 6 | 9 | 5 | 7 | 53 | 41
 |  | 11 | [NAME] | 13 | 6 | 9 | 10 | 5 | 5 | 3 | 7 | 5 | 9 | 59 | 46
 |  | 1 | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 3 | 6 | 3 | 7 | 44 | 39
 |  | 5 | [NAME] | 9 | 5 | 6 | 6 | 5 | 6 | 5 | 6 | 5 | 5 | 49 | 40
 |  | 10 | [NAME] | 10 | 6 | 6 | 10 | 4 | 4 | 3 | 7 | 5 | 7 | 52 | 42
 |  | 1 | [NAME] | 3 | 4 | 4 | 6 | 5 | 4 | 4 | 5 | 5 | 5 | 42 | 39
 |  | 6 | [NAME] | 14 | 6 | 8 | 6 | 4 | 7 | 5 | 7 | 5 | 7 | 55 | 41
 |  | 6 | [NAME] | 14 | 6 | 5 | 7 | 5 | 7 | 6 | 6 | 5 | 8 | 55 | 41
 |  | 6 | [NAME] | 14 | 6 | 7 | 6 | 5 | 8 | 6 | 6 | 6 | 5 | 55 | 41
 |  | 1 | Stevie | 9 | 3 | 7 | 6 | 4 | 6 | 5 | 8 | 4 | 5 | 48 | 39
Spreadsheet: 152646d1335459882-making-a-sheet-with-a-12month-running-total-totals
Sheet: Sheet1

 |  | Start Date | 2012-01-01 00:00:00 |  | Rolling 12 - Method 1 | 520
 |  | End Date | 2012-04-01 00:00:00 |  | Rolling 12 - Method 2 | 520
 |  | Month | Year | Date for Calc | Amount
 | 0 | April | 2011 | 2011-04-01 00:00:00 | 20
 | 0 | April | 2011 | 2011-04-01 00:00:00 | 10
 | 0 | April | 2011 | 2011-04-01 00:00:00 | 10
 | 0 | April | 2011 | 2011-04-01 00:00:00 | 10
 | 0 | May | 2011 | 2011-05-01 00:00:00 | 10
 | 0 | May | 2011 | 2011-05-01 00:00:00 | 10
 | 0 | May | 2011 | 2011-05-01 00:00:00 | 10
 | 0 | May | 2011 | 2011-05-01 00:00:00 | 20
 | 0 | June | 2011 | 2011-06-01 00:00:00 | 10
 | 0 | June | 2011 | 2011-06-01 00:00:00 | 10
 | 0 | June | 2011 | 2011-06-01 00:00:00 | 30
 | 0 | June | 2011 | 2011-06-01 00:00:00 | 100
 | 0 | July | 2011 | 2011-07-01 00:00:00 | 10
 | 0 | July | 2011 | 2011-07-01 00:00:00 | 10
 | 0 | July | 2011 | 2011-07-01 00:00:00 | 10
 | 0 | July | 2011 | 2011-07-01 00:00:00 | 20
 | 0 | August | 2011 | 2011-08-01 00:00:00 | 5
 | 0 | August | 2011 | 2011-08-01 00:00:00 | 5
 | 0 | August | 2011 | 2011-08-01 00:00:00 | 5
 | 0 | August | 2011 | 2011-08-01 00:00:00 | 10
 | 0 | September | 2011 | 2011-09-01 00:00:00 | 100
 | 0 | September | 2011 | 2011-09-01 00:00:00 | 10
 | 0 | September | 2011 | 2011-09-01 00:00:00 | 10
 | 0 | September | 2011 | 2011-09-01 00:00:00 | 10
 | 0 | October | 2011 | 2011-10-01 00:00:00 | 100
 | 0 | October | 2011 | 2011-10-01 00:00:00 | 10
 | 0 | October | 2011 | 2011-10-01 00:00:00 | 10
 | 0 | October | 2011 | 2011-10-01 00:00:00 | 10
 | 0 | November | 2011 | 2011-11-01 00:00:00 | 100
 | 0 | November | 2011 | 2011-11-01 00:00:00 | 10
 | 0 | November | 2011 | 2011-11-01 00:00:00 | 10
 | 0 | November | 2011 | 2011-11-01 00:00:00 | 10
 | 0 | December | 2011 | 2011-12-01 00:00:00 | 10
 | 0 | December | 2011 | 2011-12-01 00:00:00 | 10
 | 0 | December | 2011 | 2011-12-01 00:00:00 | 10
 | 0 | December | 2011 | 2011-12-01 00:00:00 | 10
 | 1 | January | 2012 | 2012-01-01 00:00:00 | 100
 | 1 | January | 2012 | 2012-01-01 00:00:00 | 10
 | 1 | January | 2012 | 2012-01-01 00:00:00 | 10
 | 1 | January | 2012 | 2012-01-01 00:00:00 | 10
 | 1 | February | 2012 | 2012-02-01 00:00:00 | 100
 | 1 | February | 2012 | 2012-02-01 00:00:00 | 10
 | 1 | February | 2012 | 2012-02-01 00:00:00 | 10
 | 1 | February | 2012 | 2012-02-01 00:00:00 | 10
 | 1 | March | 2012 | 2012-03-01 00:00:00 | 100
 | 1 | March | 2012 | 2012-03-01 00:00:00 | 10
 | 1 | March | 2012 | 2012-03-01 00:00:00 | 10
 | 1 | March | 2012 | 2012-03-01 00:00:00 | 10
 | 1 | April | 2012 | 2012-04-01 00:00:00 | 100
 | 1 | April | 2012 | 2012-04-01 00:00:00 | 10
 | 1 | April | 2012 | 2012-04-01 00:00:00 | 10
 | 1 | April | 2012 | 2012-04-01 00:00:00 | 10
Spreadsheet: 752379d1634737734-averageif-function-question-average
Sheet: TABLE B

A | IF 'A' IS PRESENT IN TABLE A (COLUMN A) AND COLUMN C = 2021 OR 21/22 THEN SHOW ME THE AVERAGE OF ALL A'S (VALUES FROM COLUMN B) FROM TABLE A
B
C
A | IF 'A' IS PRESENT IN TABLE A (COLUMN A) AND COLUMN C = 2021 OR 21/22 THEN SHOW ME THE AVERAGE OF ALL A'S (VALUES FROM COLUMN B) FROM TABLE A
B
C
C
B
A | IF 'A' IS PRESENT IN TABLE A (COLUMN A) AND COLUMN C = 2021 OR 21/22 THEN SHOW ME THE AVERAGE OF ALL A'S (VALUES FROM COLUMN B) FROM TABLE A
A | IF 'A' IS PRESENT IN TABLE A (COLUMN A) AND COLUMN C = 2021 OR 21/22 THEN SHOW ME THE AVERAGE OF ALL A'S (VALUES FROM COLUMN B) FROM TABLE A
A | IF 'A' IS PRESENT IN TABLE A (COLUMN A) AND COLUMN C = 2021 OR 21/22 THEN SHOW ME THE AVERAGE OF ALL A'S (VALUES FROM COLUMN B) FROM TABLE A
A | IF 'A' IS PRESENT IN TABLE A (COLUMN A) AND COLUMN C = 2021 OR 21/22 THEN SHOW ME THE AVERAGE OF ALL A'S (VALUES FROM COLUMN B) FROM TABLE A
B
B
D
D
D
Spreadsheet: 780349d1652415118-text-to-multiple-column-with-formulas-forum_upload
Sheet: Forum Q

Input | Output 1 | Output 2
TEC List | BC Act | EPBC Act
Not listed | Not listed | Not listed
Listed BC Act,E: Sandhill Pine Woodland in the Riverina, Murray-Darling Depression and NSW South Western Slopes bioregions (Part) ; | [NAME] in the Riverina, Murray-Darling Depression and NSW South Western Slopes bioregions | Not listed
Listed BC Act,E: Allocasuarina luehmannii Woodland in the Riverina and Murray-Darling Depression Bioregions (Equivalent) wholly subset of ; Listed EPBC Act,E: Buloke Woodlands of the Riverina and Murray-Darling Depression Bioregions (Part) ; | Allocasuarina luehmannii Woodland in the Riverina and Murray-Darling Depression Bioregions | Buloke Woodlands of the Riverina and Murray-Darling Depression Bioregions
Listed BC Act,CE: Artesian Springs Ecological Community in the Great Artesian Basin (Part) ; Listed BC Act,E: Myall Woodland in the Darling Riverine Plains, [NAME], Cobar Peneplain, Murray-Darling Depression, Riverina and NSW South Western Slopes bioregions (Part) ; Listed EPBC Act,E: Weeping Myall Woodlands (Equivalent) ; | Artesian Springs Ecological Community in the Great Artesian Basin OR Myall Woodland in the Darling Riverine Plains, [NAME], Cobar Peneplain, Murray-Darling Depression, Riverina and NSW South Western Slopes bioregions | Weeping Myall Woodlands
Listed BC Act,E: Sandhill Pine Woodland in the Riverina, Murray-Darling Depression and NSW South Western Slopes bioregions (Part) ; Listed BC Act,E: [NAME] melvillei Shrubland in the Riverina and Murray-Darling Depression bioregions (Part) ; | [NAME] in the Riverina, Murray-Darling Depression and NSW South Western Slopes bioregions OR [NAME] melvillei Shrubland in the Riverina and Murray-Darling Depression bioregions | Not listed
Not listed | Not listed | Not listed
Spreadsheet: 731570d1620414795-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: KMD

S.N. | Particulars | Bought  Units | Unit or KMD Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] | 227.81916442 | 0.00060705 |  |  | 11501 | 2018-01-21 00:00:00 | 2018-01-21 00:00:00
2 | [NAME] | -227.81916442 | 0.000421 |  |  | 11166.9 | 2018-02-19 00:00:00 | 2018-02-19 00:00:00
3
4
5
6
7
8
9
 | Next Buy
 | Komodo in Ledger Nano S | 0
 | Komodo in Bittrex | 0
 | Komodo in Cryptopia | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 1814
2
3
4
5
6
7
8 | 7351 | 2570
9 | 9796
10 | 9830
11 | 124
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-04-30 00:00:00 |  |  | 453999
2001-05-31 00:00:00
Spreadsheet: 810592d1671874556-filtering-data-with-search-box-option-search-sample-file
Sheet: DATA

DATA
TOTAL NUMBER OF STUDENTS :
Sl. No. | Regd. No. | HS ROLL NO. | Name | Father's Name | Class | Sec. | Roll No. | Sex | Lang. 1 | Lang. 2 | Comp. Elec. 1 | Comp. Elec. 2 | Comp. Elec. 3 | Opt. Elec.
1 |  | NA | [NAME] | Rohit [NAME] | XI | A | 1 | G | BNGA | ENGB | [NAME] | PHIL | SNSK | HIST
2 |  | NA | [NAME] | [NAME] | XI | A | 2 | B | BNGA | ENGB | HIST | PHIL | SNSK | ENVS
3 |  | NA | Sunil Kumar | Dhiraj Kumar | XI | A | 3 | G | BNGA | ENGB | [NAME] | PHIL | SNSK | HIST
4 |  | NA | [NAME] | [NAME] | XI | A | 4 | B | BNGA | ENGB | [NAME] | PHIL | SNSK | ENVS
5 |  | NA | Anil Kumar | Suresh Kumar | XI | A | 5 | G | BNGA | ENGB | [NAME] | PHIL | SNSK | ENVS
6 |  | NA | Rohit Agarwal | [NAME] | XI | A | 6 | B | BNGA | ENGB | HIST | PHIL | SNSK | ENVS
7 |  | NA | Dhiraj Kumar | Sunil Kumar | XI | A | 7 | B | BNGA | ENGB | ENVS | [NAME] | PHIL | HIST
8 |  | NA | [NAME] | Sachin Jadav | XI | A | 8 | G | BNGA | ENGB | PHIL | HIST | SNSK | ENVS
9 |  | NA | [NAME] | [NAME] | XI | A | 9 | B | BNGA | ENGB | [NAME] | PHIL | SNSK | HIST
10 |  | NA | [NAME] | [NAME] | XI | A | 10 | G | BNGA | ENGB | PHIL | HIST | SNSK | ENVS