tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 687764d1595401306-how-to-add-totals-in-a-column-with-if-then-statements-excelforum
Sheet: Sheet1

 |  |  |  | PICKED | REJECTED
 | 0.04418190645735551 | 0.06785545210667515
 | 0.4535885167464114 | -0.1211121583411875
 | 0.4197666740039622 | 0.3143222740151724
 | 0.6595333425376224 | -0.35667107001321
 | 0.7559444550123645 | -0.146513202437373
 | 0.7191752577319587 | 0.1040935672514621
Spreadsheet: 90b9cbfd-2514-4593-bb9c-92191d51bcd1
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
AudioQuest | P8M-S Speaker Cable Connector Multi-Spade/ Silver/ 4 per set |  | W AQ P8M-S | Connectors |  |  | Equipment | 15
Furutech | FI-20M (G) Gold Plated Male Plug |  | W FI-20MG | Connectors |  |  | Equipment | 65.95
Spreadsheet: 136478d1326667141-setting-up-my-books-excel-forum-post
Sheet: General Ledger

DATE | [NAME] / INVOICE NUMBER | ACCOUNT # | ACCOUNT NAME | DEBIT | CREDIT | Total
JAN 11 | 2007137, DR. BOB | 1200 |  | 2526.78 |  |  |  | THIS WORKSHEET IS SIMPLY ENTERING IN MY DAILY TRANSACTIONS.
 |  | 2300 |  |  | 120.32
 |  | 4100 |  |  | 2406.46
JAN 13 | 2007138, [NAME] | 1200 |  | 334.96
 |  | 2300 |  |  | 36.85
 |  | 4200 |  |  | 298.11
JAN 19 | CANEX, CASING, BOARD | 5750 |  | 384.23
 |  | 2310 |  | 17.95
 |  | 3100 |  |  | 402.18
 | AFTER READING THIS PAGE AND THE NEXT PAGE, I AM WONDERING IF THERE IS A REASON FOR EVEN HAVING THE LEDGER ACCOUNT, AS I THINK I CAN PRINT OFF ANYTHING I NEED FROM THE TABLE ON THIS WORKSHEET.  I WOULD STILL LIKE TO KNOW THE FORMULA FOR THE LEDGER THOUGH AS IT I THINK I COULD USE IT TO TRANSFER INFORMATION TO AN INVOICE TRACKER.
Spreadsheet: 553533d1514389960-drop-down-list-populate-an-entry-sample-file
Sheet: Sheet1

 |  |  | sdf
 | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | blue | green | blue | red
[NAME] | yellow | green | blue | red
[NAME] | red | green | yellow | blue
[NAME] | green | red | blue | blue
Spreadsheet: john_griffith__15659__1_Book4
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.3 | 0.33 | 0.37 | 0.4835000000000025 | -0.02249999999999752
 | N | 4.35 | 0.62 | 0.66 | 0.513000000000001 | -0.009599999999998943
 | Q | 4.4 | 0.85 | 0.86 | 0.5347 | 0.0008999999999999009
 | U | 4.45 | 1.01 | 1.04 | 0.5350000000000006 | -0.005099999999999438
 | V | 4.45 | 1.17 | 1.21 | 0.5579999999999997 | 0.002099999999999769
 | X | 4.65 | 1.34 | 1.39 | 0.5574000000000001 | -0.001199999999999868
 | Z | 4.8 | 1.52 | 1.58 | 0.5665000000000006 | -0.004799999999999471
 | F | 4.85 | 1.67 | 1.73 | 0.5756000000000001 | -0.0008999999999999009
 | G | 4.7 | 1.72 | 1.77 | 0.5758999999999994 | 0.005099999999999438
 | H | 4.55 | 1.58 | 1.65 | 0.5227999999999993 | 0.006599999999999273
 | J | 4.2 | 1.15 | 1.25 | 0.3999500000000005 | -0.004649999999999488
 | K | 4.15 | 1.1 | 1.22 | 0.3811999999999995 | 0.004199999999999537
 |  |  | 2001-05-10 11:27:57.770000
Spreadsheet: 0fb5fa31-9fab-4527-9c2c-4cadff3b69be
Sheet: Sheet1

AUDITOR'S OFFICE, MAHONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
DATE: | 3/2/2012 |  |  |  |  |  |  |  |  |  | 10500 - MAHONING COUNTY
STATEMENT OF SEMIANNUAL APPORTIONMENT OF TAXES
 |  |  |  |  |  |  |  |  |  |  |  | PAGE: 2
MADE AT THE FIRST HALF REAL ESTATE SETTLEMENT 2011,   WITH THE COUNTY TREASURER FOR MAHONING COUNTY
SOURCE OF RECEIPTS |  |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  | TOTAL
Amount Advanced |  |  | 118000 | 224000 |  |  |  |  |  |  |  |  | 342000
COMMENTS |  |  |  |  |  |  |  |  |  |  | FROM PREV. PAGE:
PLEASE SIGN AND RETURN TO THIS OFFICE, REVISED CODE, SEC. 321.34. 'IT IS HEREBY CERTIFIED THAT THE ABOVE FUNDS FOR RETIREMENT OF BONDS HAVE BEEN RECEIVED AND PAID INTO THE BOND RETIREMENT FUND' |  |  |  |  |  |  |  |  |  |  | TOTAL: |  | 342000
 |  |  |  |  |  |  |  |  |  | ANTHONY MAGNETTA
 |  |  |  |  |  | [NAME]
 |  | SIGNATURE OF OFFICER |  |  |  |  | COUNTY AUDITOR |  |  |  | DEPUTY AUDITOR
Spreadsheet: 683005d1592423069-being-able-to-select-a-label-with-3-columns-to-show-or-not-multiples-book1
Sheet: Sheet1

 | Countries
 | Country A |  |  | Country B |  |  | Country C |  |  | Country D
 | Cost1 Cost 2 | Cost 3 | Details | Cost1 Cost 2 | Cost 3 | Details | Cost1 Cost 2 | Cost 3 | Details | Cost1 Cost 2 | Cost 3 | Details
Transport
Food
Utilities
Insurance
Tax
Spreadsheet: 96879d1296140149-sorting-litlfrogoutput2
Sheet: Sheet1

Route ID# | Route Name | Stop # | Account # | Name | CR Code | CR Description | Account type | Bil Street | Bil City | Bil State | Route ID 2 | Route Name 2 | Stop # 2
50 | ALL AMERICAN | 390 | 11058 | DICKINSON JIMMY |  | Trash Service | Residential | 22 Walnut Road | Bethel | CT | 19 | PHIL MONDAY | 22
50 | ALL AMERICAN | 636 | 11059 | ACKER [NAME] |  | Trash Service | Residential | 13 Shilling Road | Bethel | CT | 22 | MIKE THURSDAY | 636
Spreadsheet: 847295d1698305125-to-get-a-total-score-whereby-1-or-2-conditions-may-affect-the-result-support-excel
Sheet: Other

 | Risk Factor | Risk Sub-Factor | Weight | Risk Assessment
 |  | xxxxx | 1 | Very High
 |  | xxxx | 0.75 | High
 |  | xxx | 0.5 | Medium
 |  | xx | 0.25 | Low
 |  | x | 0 | None
 |  | Column1 | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  | Column1 | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  |  | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 1 | Very High
 |  | X | 1 | Very High
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  | X | 0.25 | Low
 |  | X | 0.25 | Low
 |  |  | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 1 | Very High
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  | X | 0.25 | Low
 |  | X | 0.25 | Low
 |  | X | 0 | None
 |  | Column1 | Weight | Risk Assessment
 |  | PEP | 1 | Very High
 |  | Adverse Media | 1 | Very High
 |  | No adverse Media | 0 | None
 |  | Column1 | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  | Column1 | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  |  | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  |  | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0 | None
 |  |  | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0 | None
 |  |  | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium
 |  | X | 0.25 | Low
 |  | Column1 | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0 | None
 |  | Column1 | Weight | Risk Assessment
 |  | X | 1 | Very High
 |  | X | 0.75 | High
 |  | X | 0.5 | Medium | `
 |  | X | 0.25 | Low
Spreadsheet: 145339d1331542306-need-help-regarding-graph-bidyut_review-format_chart
Sheet: MONTH 1

[NAME] : |  |  | BIDYUT GANGULY
MONTH : |  |  | 2012-02-01 00:00:00
 |  | DOJ | NAME | HQ | TARGET | PRI SALES | ACH | TARGET | SEC SALES | SEC ACH | TARGET | DR. CALL | CALL ACH
BE | 1 | 2011-10-01 00:00:00 | [NAME] | Sonarpur | 30000 | 20000 |  | 18000 | 15000 |  | 300 | 250
BE | 2 | 2012-01-04 00:00:00 | [NAME] | D Harbor | 21000 | 18000 |  | 15000 | 12000 |  | 300 | 300
BE | 3 | 2011-10-01 00:00:00 | S.S.Roy | Midnapur | 35000 | 25000 |  | 15000 | 10000 |  | 300 | 270
BE | 4 | 2011-10-01 00:00:00 | Sumit Mahapatra | Contai | 25000 | 15000 |  | 15000 | 9000 |  | 300 | 280
EMPLOYEE STRENGTH |  |  |  | TOTAL SALE :
VACCANT HQ |  |  |  | PCPM :
Spreadsheet: 55678d1255817406-help-auto-insert-data-from-another-column-with-single-input-simpsons-rule
Sheet: Sheet4

 | Station |  | 1/2 Ordinate | SM | Area Function | Lever | 1st Moment Function
 | AP | 0 |  | 0.5 |  | 0 |  |  |  | LCF=
 | 0.5 | 2.55 |  | 2 |  | 0.5
 | 1 | 5.1 |  | 1 |  | 1
 | 1.5 | 7.65 |  | 2 |  | 1.5
 | 2 | 10.2 |  | 1.5 |  | 2
 | 3 | 15.3 |  | 4 |  | 3
 | 4 | 20.4 |  | 2 |  | 4
 | 5 | 25.5 |  | 4 |  | 5
 | 6 | 30.6 |  | 2 |  | 6
 | 7 | 35.7 |  | 4 |  | 7
 | 8 | 40.8 |  | 2 |  | 8
 | 9 | 45.9 |  | 4 |  | 9
 | 10 | 51 |  | 2 |  | 10
 | 11 | 56.1 |  | 4 |  | 11
 | 12 | 61.2 |  | 2 |  | 12
 | 13 | 66.3 |  | 4 |  | 13
 | 14 | 71.4 |  | 2 |  | 14
 | 15 | 76.5 |  | 4 |  | 15
 | 16 | 81.6 |  | 2 |  | 16
 | 17 | 86.7 |  | 4 |  | 17
 | 18 | 91.8 |  | 1.5 |  | 18
 | 18.5 | 94.35 |  | 2 |  | 18.5
 | 19 | 96.9 |  | 1 |  | 19
 | 19.5 | 99.45 |  | 2 |  | 19.5
 | FP | 102 |  | 0.5 |  | 20
Spreadsheet: 806370d1669262489-rolling-average-excluding-blank-cells-but-including-zeros-sample-34-ans3
Sheet: Sheet1

ID | VALUE | val_roll_ave |  | SIMPLIFIED FORMULA | REQUIRED
1 | 123.2739130434782 |  |  |  | 123.2739130434782
1 | 8.18 |  |  |  | 65.72695652173913
1 | 41.81666666666666 |  |  |  | 57.75685990338164
1 |  |  |  |  |  | <--- should ignore the blank cell B5
1 | 0 |  |  |  |  | <--- should include the 0 in cell [NAME]
1 | 7.15
1 | 90.28749999999998
1
1 | 12.65
2 | 121.5333333333333
2 | 39.25
2 | 53.47692307692309
2 | 15.4
2 | 0
2 | 62.0611111111111
2 | 35.8
2 | 70.07499999999999
2 | 49.56666666666666
2 | 126.6560606060606
2 | 23.06666666666667
2 | 126.6560606060606
2 | 23.06666666666667
2 | 177.1351724137931
2 | 8.4
2 | 12
2 |  |  |  |  |  | <--- should ignore the blank cell B27
2 | 110
2 | 0 |  |  |  |  | <--- should include the 0 in cell B29
2
Spreadsheet: 800983d1666021001-dynamic-formula-that-subtracts-last-column-from-second-last-column-in-the-grand-total-line-pivothelp-1-1-
Sheet: Pivot

Sum of Numer of Accounts | Column Labels
Row Labels | 1 | 2 | 5 | 10 | 15 | 20
[NAME] | 16 | 5
Jery |  |  | 15 | 63 | 4 | 3
[NAME] |  |  |  |  | 50
[NAME] |  |  | 3
Grand Total | 16 | 5 | 18 | 63 | 54 | 3
Scenario:
Each week we will be adding a week which will expand the columns.  I would like some sort of a dynamic function that as the pivot table rows it would look at the Grand Total line and subtract
the last column from the second last column.  So in this case it would be 3 - 54.
[NAME]
Spreadsheet: 272542d1382428274-how-to-join-two-worksheets-into-one-based-on-the-data-they-contain-workbook1
Sheet: defects

# defect | type of defect | # quality control
23454 | z2 | 222
23455 | z1 | 231
23456 | z1 | 234
23457 | z2 | 245
23458 | z1 | 267
23459 | z3 | 277
23460 | z2 | 289
23461 | z2 | 292
23462 | z3 | 301
23463 | z1 | 303
23464 | z3 | 333
23465 | z1 | 343
23466 | z3 | 351
23467 | z2 | 364
23468 | z1 | 367
Spreadsheet: 799543d1665137289-countifs-with-multiple-criteria-using-cell-reference-test
Sheet: Sheet1

id | unit 502
1 | Pass |  |  | Pass |  |  | Pass
2 | submitted |  |  |  | Submitted |  | Submitted
3 | pass |  |  |  | Refer
4 | pass |  |  |  | Re-Refer |  | Re-Refer
5 | resit pass |  |  |  | submitted
6 | resit pass |  |  |  | not submitted |  | submitted
7 | pass |  |  |  | Resit Pass |  | not submitted
8 | pass
9 | pass |  |  |  |  |  | Resit Pass
10 | not submitted
11 | not submitted |  |  |  |  |  | Refer
should return 7, cell reference are in a cont. [NAME] | =SUM(COUNTIFS(tbl_result[Unit 502],E2,f3:G8))
should return7, Cell references are scattered
I just want to know how to write a formula when criteria is cell referance.
Spreadsheet: 0d4b97fe-ccc1-496d-94d7-89b80f5bf545
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | DISTRICT USE ONLY | Unnamed: 17 | Unnamed: 18
Request for Budget Revision |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Document Number
To:  District Accounting Office, Administrative Services
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
PROGRAM TITLE
INCOME: |  |  | Account Number
Fund (2) |  |  | Program (4) |  |  |  | Sub-Program (1) |  |  |  | Tops (6) |  |  |  | Object (4) |  |  | Amount
 |  | — |  |  |  | — |  |  |  | — | 000000 |  |  | —
 |  | — |  |  |  | — |  |  |  | — | 000000 |  |  | —
APPROPRIATION:
Account Number |  |  |  |  |  |  |  |  | Account Description |  |  |  |  |  |  |  |  | Amount
Fund (2) | Program     (4) |  | Sub Program (1) | Tops                 (6) |  |  | Object     (4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  | 0
Explanation:
(Describe source of income and purpose of project, etc.)
Requested by: |  |  |  |  |  |  |  |  |  | Approved by:
Signature |  |  |  |  |  |  |  |  |  | Signature
Print Name and Title |  |  |  |  |  |  |  |  |  | Print Name and Title of Supr/Pres. or Vice President
Spreadsheet: 725233d1616595570-dynamic-counta-example-21-ans
Sheet: Data

LoadDate | LoadRef | Supplier | CollPostcode | Pallets | SubContractor | Plt rate per PC | MAX plt rate | MAX plt rate per load
2021-03-24 00:00:00 | 30178 | AAA | LS9 0SJ | 52 | TEST
2021-03-24 00:00:00 | 30178 | BBB | CW10 9UN | 52 | TEST
2021-03-24 00:00:00 | 30178 | CCC | LU5 5BN | 26 | TEST
Spreadsheet: 79452d1279720045-excel-2007-conditional-average-across-multiple-sheets-bowlingtest
Sheet: Sheet3

[NAME] |  | Geran |  | [NAME]
- | 8 | - | 5 | - | 9
19 |  | 6 |  | 9 |  |  |  | = spare
9 |  | 11 |  | 6
8 |  | 1 |  | 4
5 |  | 7 |  | 11
9 |  | 7 |  | 9
5 |  | 4 |  | 9
8 |  | 6 |  | 8
8 |  | 6 |  | 11
9 |  | 8 |  | 8
- | 6 | - | 1 | - | 6
4 |  | 6 |  | 10
19 |  | 19 |  | 6
9 |  | 9 |  | 9
8 |  | 8 |  | 9
7 |  | 3 |  | 8
7 |  | 9 |  | 6
10 |  | 7 |  | 8
7 |  | 4 |  | 9
7 |  | 6 |  | 9
- | 9 | - | 7 | - | 10
9 |  | 6 |  | 3
7 |  | 7 |  | 6
8 |  | 7 |  | 9
9 |  | 6 |  | 10
10 |  | 3 |  | 8
7 |  | 6 |  | 9
6 |  | 9 |  | 9
7 |  | 5 |  | 8
9 |  | 8 |  | 9
Spreadsheet: 785693d1656554712-index-match-for-multiple-values-in-array-data
Sheet: Position (2)

Position Nbr | Count.[NAME] | Count.Position Title | Count.Column4
190765 | 43678 | Associate Professor
196634 | 42064 | Assistant Professor
275446 | 41375 | Financial/Staffing Assistant
348562 | 42902 | Director
368235 | 41456 | Associate Librarian
385637 | 367 | Assistant Manager
457152 | 41456 | Associate Librarian
549823 | 41821 | Lecturer
565728 | 44136 | Office Assistant
627837 | 41456 | Associate Director
628465 | 41821 | Financial Assistant
654915 | 367 | Research Associate
659204 | 43831 | Clinic [NAME]
716499 | 43952 | Project Manager
726384 | 367 | Associate Professor
798762 | 42705 | Manager
822345 | 43586 | Business Analyst
825593 | 43466 | Lecturer
913728 | 42332 | Clinic [NAME]/After Hours Clinic Assistant
918867 | 41518 | Administrative Secretary
991564 | 43979 | Associate Professor
Spreadsheet: 220331d1363121512-is-there-a-way-to-automatically-work-out-stats-based-on-wins-and-losses-in-a-table-big-pots
Sheet: Sheet1

Last 6 game average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide them
 |  | [NAME] |  | [NAME] |  | [NAME] |  | Mat Davies |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
Game |  | W |  | W | L | W | W | W |  | W | W | W |  | L |  | W
Game |  | W |  | W | W | W |  | L |  | W | W | W |  | W |  | W | L
Game |  | W | W | W | L | L |  | W |  | W | W | L |  | W |  | W
Game |  | W | W | W | W | L |  | L |  | W | W | W |  | W |  | W
Game |  | W | L | L | W | W |  | W |  | W | W | W |  | L |  | L
Game |  | W |  | W | W | L | L | W |  | W | W | W |  | W |  | W
Game |  | L |  | W |  | W |  | W | W | W | W | W | W | W |  | W
Game |  | W
Game
Game
Win/Lost
Overall Average
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide them
Win/Lost
Last 6 game average
Spreadsheet: jeff_dasovich__14092__Scores99
Sheet: Total

 |  | Prior Rank | New Rank | Total | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Wk 15 | Wk 16 | Wk 17
 | [NAME]* | 1 | 1 |  | 74 | 84 | 93 | 97
 | Helmet* | 2 | 2 |  | 68 | 93 | 82 | 83
 | [NAME]* | 6 | 3 |  | 63 | 82 | 88 | 92
 | Eldon* | 12 | T 4 |  | 65 | 76 | 84 | 97
 | Mickey* | T 7 | T 4 |  | 57 | 93 | 81 | 91
 | Narvco* | 5 | 6 |  | 55 | 99 | 81 | 83
 | [NAME]* | 13 | 7 |  | 62 | 87 | 75 | 93
 | Prentice* | T 3 | 8 |  | 58 | 86 | 92 | 78
 | Barrie* | T 7 | 9 |  | 63 | 95 | 73 | 82
 | [NAME]* | 11 | 10 |  | 73 | 81 | 72 | 86
 | [NAME]* | 9 | T11 |  | 59 | 96 | 74 | 82
 | JAM* | T 3 | T 11 |  | 55 | 86 | 95 | 75
 | Carlton* | 14 | T13 |  | 69 | 75 | 77 | 86
 | [NAME]* | 10 | T13 |  | 58 | 93 | 76 | 80
 | Cary* | 18 | 15 |  | 52 | 77 | 80 | 96
 | Mike&Lisa* | 16 | 16 |  | 55 | 82 | 80 | 86
 | Cameron* | 17 | 17 |  | 64 | 71 | 78 | 86
 | Growney* | 19 | T18 |  | 35 | 89 | 84 | 89
 | Dennis* | 20 | T18 |  | 35 | 88 | 81 | 83
 | WAM | 15 | 20 |  | 66 | 77 | 75 | 61
Spreadsheet: 215075d1361258504-calculating-when-a-given-lot-quantity-is-finished-frozen-inventory
Sheet: apples

Lot | Exp Date | Date In | Quantity In (Tonnes | Date Out | Quantity Out (Tonnes)
02-02 |  | 2013-02-05 00:00:00 | 2.5 |  |  | [These lots are not finished yet, I want to highlight, and if possible calculate remaining quantity per lot]
02-01 |  | 2013-02-01 00:00:00 | 0.5 | 2013-01-28 00:00:00 | 0.25
02-01 |  |  |  | 2013-02-01 00:00:00 | 0.1
01-02 |  | 2013-01-15 00:00:00 | 1.2 | 2013-01-20 00:00:00 | 0.6 | [These Lots are finished now, no highlighting, if possible display o [NAME]
01-02 |  |  |  | 2013-01-28 00:00:00 | 0.6
01-01 |  | 2013-01-12 00:00:00 | 3 | 2013-01-20 00:00:00 | 3
Spreadsheet: 191043d1351880933-count-unique-values-in-column-a-according-to-a-criteria-in-column-b-unique-values-problem
Sheet: Sheet1

Clinician | Intake Date
Zoe | 2012-08-01 00:00:00 |  |  |  | Row Labels | Count of Clinician
Zoe | 2012-08-01 00:00:00 |  |  |  | 2012-08-01 00:00:00 | 6
Dale | 2012-08-01 00:00:00 |  |  |  | 2012-08-02 00:00:00 | 4
Cecile | 2012-08-01 00:00:00 |  |  |  | Grand Total | 10
Cecile | 2012-08-01 00:00:00
[NAME] | 2012-08-01 00:00:00
Izaak | 2012-08-02 00:00:00
Anne R | 2012-08-02 00:00:00
[NAME] | 2012-08-02 00:00:00
[NAME] | 2012-08-02 00:00:00
 | Unique Names
2012-08-01 00:00:00 | 4
2012-08-02 00:00:00 | 3
Spreadsheet: 863744d1711128615-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22
Sheet: Game 4

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 766419d1643890721-formula-to-determine-operating-date-starting-time-example
Sheet: Sheet1

 |  |  |  | [NAME] | Column1 |  | Currently, Excel "sorts" times with midnight (00:00) being the starting point
 |  |  |  |  |  |  | Ideal formula would evaluate cell B5 to determine new "starting point" that would "replace" midnight
 |  |  |  |  |  |  | I would assume some sort of "if" statement would be needed, I'm just not sure how
 | Starting Time
 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Or, if [NAME] said 17:00, then the new order would be
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 15:00:00
 |  |  |  |  |  |  | 1900-01-01 19:00:00 |  |  |  |  |  |  | 1900-01-01 16:00:00
Spreadsheet: 94101d1293942520-excel-2007-populate-invoice-fields-based-on-invoice-number-client_database_template-1-
Sheet: Post Codes

Suburb | Postcode
[NAME] | WA 6064
[NAME] | WA 6154
Alkimos | WA 6038
[NAME] | WA 6167
Applecross PO Boxes | WA 6953
Applecross | WA 6153
Ardross | WA 6153
Armadale PO Boxes | WA 6992
Armadale | WA 6112
Ascot | WA 6104
Ashby | WA 6065
Ashfield | WA 6054
Attadale | WA 6156
Atwell | WA 6164
[NAME] | WA 6164
Australind | WA 6233
Balcatta | WA 6021
Balcatta PO Boxes | WA 6914
Baldivis | WA 6171
Balga | WA 6061
Ballajura | WA 6066
Banjup | WA 6164
[NAME] | WA 6031
Banksiadale | WA 6213
[NAME] | WA 6210
Baskerville | WA 6056
Bassendean PO Boxes | WA 6934
Bassendean | WA 6054
[NAME] | WA 6150
Bayswater PO Boxes | WA 6933
Bayswater | WA 6053
Beaconsfield | WA 6162
Beckenham | WA 6107
Bedford | WA 6052
Bedfordale | WA 6112
Beechboro | WA 6063
Beeliar | WA 6164
Beldon | WA 6027
Belhus | WA 6069
Bellevue | WA 6056
Belmont PO Boxes | WA 6984
Belmont | WA 6104
Spreadsheet: 746157d1630531921-min-and-max-for-a-range-of-rows-that-are-not-predefined-min-column-example
Sheet: Sheet1

Employee | Sales | Revenue | Costs | Profit
[NAME] | 2000 | 1500 | 300 |  |  |  | Sales
[NAME] | 3000 | 2500 | 350 |  |  | Min
[NAME] | 5000 | 4500 | 450 |  |  | [NAME]
Epsilonus | 1500 | 1000 | 100