tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__15991__Forwards Detail_AIG 
Sheet: value

 | Gas | Power | Crude | Total
Sum of Value
Period | Total
2001-12-01 00:00:00 | 7769322.901600001 |  | -142941
2002-01-01 00:00:00 | 9200679.131600002 |  | -87234
2002-02-01 00:00:00 | 7253930.012999997 |  | -78792
2002-03-01 00:00:00 | 11130972.7906 |  | -87234
2002-04-01 00:00:00 | 3307059.6426 |  | -84420
2002-05-01 00:00:00 | 3138710.476900001 |  | -87234
2002-06-01 00:00:00 | 3173076.234 |  | -84420
2002-07-01 00:00:00 | 3131996.1796 | 64915.81229596463 | -87234
2002-08-01 00:00:00 | 2860216.745299999 | 64764.32333935203 | -87234
2002-09-01 00:00:00 | 3198983.4379 |  | -84420
2002-10-01 00:00:00 | 3145808.040500001 |  | -87234
2002-11-01 00:00:00 | 750663.7735000006 |  | -84420
2002-12-01 00:00:00 | 1076991.8292 |  | -134664
2003-01-01 00:00:00 | -466.396
2003-02-01 00:00:00 | -8485.5958
2003-03-01 00:00:00 | -21210.8449
2003-04-01 00:00:00 | -36158.4314
2003-05-01 00:00:00 | -34886.9735
2003-06-01 00:00:00 | -31321.1254
2003-07-01 00:00:00 | -27208.6987
2003-08-01 00:00:00 | -23119.8085
Grand Total | 58955553.32210001
Spreadsheet: 140037d1328604798-excel-2007-score-the-similarity-of-the-characters-between-several-cells-sample_glux
Sheet: Oil and gas deals 10 years

Target Industry code | Target-to-target similarity
1321 | 2 | 2 | 2 |  | 1
1311 | 6 | 4 | 4 |  | 1
1311 | 2 | 4 | 4 |  | 1
3533 | 0 | 0 | 0 |  | 1
4925 | 4 | 3 | 3 |  | 1
1389 | 0 | 2 | 2 |  | 1
4922 | 0 | 3 | 3 |  | 1
Spreadsheet: 85800d1285841235-and-or-in-formulas-book1
Sheet: Recruitment Consultant

 |  |  |  |  |  |  |  |  |  | Completed | On Going
 | EXAMPLE 1 | RECRUITMENT CONSULTANT |  |  | BIRMINGHAM | START  DATE |  | 2009-08-17 00:00:00 | PROBATIONARY PERIOD |  | 2010-02-18 00:00:00
 | 0 |  |  |  |  |  |  |  |  |  |  | MAN (T) | OG (T) | MAN (L) | OG (L)
 | 6 MONTHS SKILLS ASSESSMENT |  |  | MODULES |  |  |  |  | STATUS | DATE COMPLETED |  | 0 | 0 | 0 | 0
 | Sections completed | 0 |  |  |  |  |  | Application for Credit Account | 0 |  |  |  | 0 | 0 | 0
 | GENERAL | 0 |  | TEAM CONSULTANT |  |  |  | Arranging Sales & Service Visit | 0 |  |  | 0 | 0 |  | 0
0 | INDUCTION | 0 |  | MANDATORY | ON GOING |  |  | Art of Marketing Candidates | 0 |  |  | 0 | 0 |  | 0
0 | PRE-INTERVIEW | 0 |  | 0 | 0 |  |  | Business Development - Good Practice | 0 |  |  | 0 | 0 |  | 0
0 | INTERVIEW | 0 |  | LEAD CONSULTANT |  |  |  | Business Etiquette | 0 |  |  | 0 | 0 |  | 0
0 | RETURNER | 0 |  | MANDATORY | ON GOING |  |  | Business Plan Writing | 0 |  |  |  | 0 | 0 | 0
0 | CANDIDATES | 0 |  | 0 | 0 |  |  | Candidate – Clearance | 0 |  |  |  | 0 | 0 | 0
0 | CLIENTS | 0 |  |  |  |  |  | Candidate – Deployment | 0 |  |  | 0 | 0 |  | 0
0 | ADAPT | 0 |  | 0 | 0 |  |  | Candidate – Interview | 0 |  |  | 0 | 0 |  | 0
0 | REPORTS | 0 |  |  |  |  |  | Candidate – Pre-Interview | 0 |  |  | 0 | 0 |  | 0
0 |  |  |  |  |  |  |  | Candidate - Registered | 0 |  |  |  | 0 | 0 | 0
0 |  |  |  | Date Attended |  |  |  | Canvas Calling | 0 |  |  | 0 | 0 |  | 0
 | 0 |  | REQUIRED |  |  |  |  | CER Telephone Skills | 0 |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | Conducting a Sales and Service Visit | 0 |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | Cover Supervisors | 0 |  |  | 0 | 0 |  | 0
 | 0 |  | REQUIRED |  |  |  |  | CRB - Disclosure Application Form |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | Cross Selling | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | Daily Figures - Light Bulb | 0 |  |  | 0 | 0 |  | 0
 | 0 |  |  |  |  |  |  | DS - All Procedures |  |  |  |  | 0 |  | 0
0 | 0 |  |  |  |  |  |  | Guide to Long Terms | 0 |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | How to Lose a Booking | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | Internet Adverts | 0 |  |  |  | 0 | 0 | 0
 | DATA PROTECTION AWARENESS |  | 0 |  |  |  |  | Interviewing Tips | 0 |  |  | 0 | 0 |  | 0
 | SECURITY INFORMATION AWARENESS |  | 0 | Completed | 0 |  |  | Maximising day to day business | 0 |  |  | 0 | 0 |  | 0
 | [NAME] |  | 0 |  |  |  |  | Maximising Perms | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | Meet & Greet | 0 |  |  | 0 | 0 |  | 0
 | TRAINING COMMENTS / OBJECTIVES |  |  |  |  |  |  | Negotiating Skills | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | Objection Handling | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | DIVISIONAL SUPPORT |  | MANAGER
Spreadsheet: 50764d1250244407-pivot-double-entries-book1
Sheet: Sheet2

NAME | VALUE1 | VALUE2
A | 1 | 10 |  |  |  | Data
A | 2 | 10 |  |  | NAME | Sum of VALUE2 | Count of VALUE2_2 |  | Result I'm looking for:
B | 1 | 5 |  |  | A | 20 | 2 |  | 10
C | 1 | 15 |  |  | B | 5 | 1 |  | 5
C | 2 | 15 |  |  | C | 30 | 2 |  | 15
Spreadsheet: 668999d1585156865-move-rows-to-separate-sheets-new-budget-test
Sheet: 2100 21 7310

Date | Vendor | Item | P.O.# | Amount | Acct Code
Spreadsheet: 889876d1740864915-determine-ranges-from-another-cell-example-workbook-rob-goins_2
Sheet: Sheet1

 | [NAME] |  | 2025-01-31 00:00:00 |  | Range | Difference |  | 2025-02-07 00:00:00 |  | Range | Difference |  | 2025-02-14 00:00:00 |  | Range | Difference
 | 20 | 30 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
 | 5 | 30 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
 | 15 | 50 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
 | 50 | 80 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
 | 5 | 60 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
 | 15 | 80 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
 | 5 | 80 | 10 | U/L |  |  |  | 40 | U/L |  |  |  | 70 | U/L
Spreadsheet: 825943d1681670393-need-formula-to-calculate-total-pool-of-valid-bonus-shares-each-year-bonus-allotments
Sheet: Sheet1

 |  |  | Person A | Person B | Person C | Person D | Person E |  |  |  | Person A | Person B | Person C | Person D | Person E
 |  | Shares | 3 | 2 | 1 | 0.5 | 0.5 |  |  | Shares | 3 | 2 | 1 | 0.5 | 0.5
Tax Year | Bonus Pool | Retires | 2036 | 2044 | 2038 | 2041 | 2037 |  |  | Retires | 2036 | 2044 | 2038 | 2041 | 2050
2023 | 2583117 |  |  |  |  |  |  |  |  | 7
2024 | 2929598 |  |  |  |  |  |  |  |  | 7
2025 | 1563824 |  |  |  |  |  |  |  |  | 7
2026 | 2014128 |  |  |  |  |  |  |  |  | 7
2027 | 2842995 |  |  |  |  |  |  |  |  | 7
2028 | 2376467 |  |  |  |  |  |  |  |  | 7
2029 | 2734862 |  |  |  |  |  |  |  |  | 7
2030 | 2400661 |  |  |  |  |  |  |  |  | 7
2031 | 2326007 |  |  |  |  |  |  |  |  | 7
2032 | 2264461 |  |  |  |  |  |  |  |  | 7
2033 | 1556641 |  |  |  |  |  |  |  |  | 7
2034 | 2354345 |  |  |  |  |  |  |  |  | 7
2035 | 473212 |  |  |  |  |  |  |  |  | 7
2036 | 2802091 |  |  |  |  |  |  |  |  | 7
2037 | 2410652 |  |  |  |  |  |  |  |  | 4
2038 | 968729 |  |  |  |  |  |  |  |  | 3.5
2039 | 2713389 |  |  |  |  |  |  |  |  | 2.5
2040 | 1719546 |  |  |  |  |  |  |  |  | 2.5
2041 | 2700802 |  |  |  |  |  |  |  |  | 2.5
2042 | 2791823 |  |  |  |  |  |  |  |  | 2.5
2043 | 260403 |  |  |  |  |  |  |  |  | 2.5
2044 | 629985 |  |  |  |  |  |  |  |  | 2.5
2045 | 190031 |  |  |  |  |  |  |  |  | 0.5
2046 | 765755 |  |  |  |  |  |  |  |  | 0.5
 |  | Formulae in Col C should count total "valid" Shares each year (Employee is still working)
 |  | (E.g in 2036 the "pool" totals seven shares. In 2037 it becomes four, because Person A has retired)
 |  | Formulae in Cols D - H can then divide [NAME] by the valid Shares
 |  | (E.g each year Person A received (3/Total Shares) until they become ineligible in 2037)
 |  | Cols K - P show what the formulae should show
Spreadsheet: 53827d1253750762-variable-number-format-before-value-entered-variable-number-format-without-value
Sheet: Data Input

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift length | Days on | Days off | Working hours / shift | Factor | Analysis required | Flow [NAME]. + | Flow [NAME]. - | Cassette number | Sample Equip Code | Pump Asset Number | Calibrator Asset Number | Start Time | Finish Time | Total Minutes | Initial Flow rate | Final Flow rate | Average Flow rate | Flow rate variance % | Volume (Litres) |  | Reduction Factor | Contaminant 1 | [NAME]. 1 | NES 1 | Adjusted Standard 1 | Action  Level 1 | Sample Result 1 |  |  | Contaminant 2 | [NAME]. 2 | NES 2 | Adjusted Standard 2 | Action Level 2 | Sample Result 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 9 | 5 |  |  | DP |  |  |  |  |  |  | 08:00:00 | 12:00:00 |  | 2 | 2.2 |  |  |  |  |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 5 | 5 |  |  | MEK |  |  |  |  |  |  | 08:03:00 | 12:00:00 |  | 2.23 | 2.2 |  |  |  |  |  |  |  |  |  |  | 16.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 8 | 6 |  |  | TRI / TOL |  |  |  |  |  |  | 07:00:00 | 12:00:00 |  | 2.24 | 2.2 |  |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 16 | 4 |  |  | ASB |  |  |  |  |  |  | 08:35:00 | 12:00:00 |  | 2.1 | 2.2 |  |  |  |  |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 14 | 7 |  |  | NH3 |  |  |  |  |  |  | 06:43:00 | 12:00:00 |  | 2.43 | 2.2 |  |  |  |  |  |  |  |  |  |  | 8.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 2 |  |  | WLD |  |  |  |  |  |  | 08:57:00 | 12:00:00 |  | 2.111 | 2.2 |  |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  | 0.003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 7 | 7 |  |  | RES / SIL |  |  |  |  |  |  | 05:00:00 | 12:00:00 |  | 2.234 | 2.1 |  |  |  |  |  |  |  |  |  |  | 2.4 |  |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 8 | 6 |  |  | TRI / TOL |  |  |  |  |  |  | 06:21:00 | 12:00:00 |  | 1.987 | 2.1 |  |  |  |  |  |  |  |  |  |  | 12.4 |  |  |  |  |  |  |  | 55
Spreadsheet: 781299d1653166039-trying-to-create-spreadsheet-that-uses-3-different-criteria-to-return-a-value-sample
Sheet: Sheet1

Payroll | Rank | Station | Shift | Assign To | Position Status | Choice | Seniority  Date | Class Rank |  | Stations that are open to be picked
12 | FIREFIGHTER | 38 | A | Apparatus | P | 1 | 2018-03-13 00:00:00 | 6 |  | 38 | A | P | Apparatus
12 | FIREFIGHTER | 38 | C | Apparatus | P | 2 | 2018-03-13 00:00:00 | 6 |  | 38 | C | P | Apparatus
12 | FIREFIGHTER | 62 | C | Apparatus | P | 3 | 2018-03-13 00:00:00 | 6 |  | 38 | C | P | Apparatus
12 | FIREFIGHTER | 38 | D | Apparatus | P | 4 | 2018-03-13 00:00:00 | 6 |  | 38 | D | P | Apparatus
13 | FIREFIGHTER | 38 | A | Apparatus | P | 5 | 2018-03-13 00:00:00 | 6 |  | 62 | C | P | Apparatus
13 | FIREFIGHTER | 38 | C | Apparatus | P | 6 | 2018-03-13 00:00:00 | 6
13 | FIREFIGHTER | 62 | C | Apparatus | P | 1 | 2018-03-27 00:00:00 | 48
13 | FIREFIGHTER | 38 | D | Apparatus | P | 2 | 2018-03-27 00:00:00 | 48 |  | Results
14 | FIREFIGHTER | 38 | A | Apparatus | P | 1 | 2018-03-27 00:00:00 | 44 |  | 12 | 38 | A | Apparatus
14 | FIREFIGHTER | 38 | C | Apparatus | P | 2 | 2018-03-27 00:00:00 | 44 |  | 13 | 38 | C | Apparatus
14 | FIREFIGHTER | 62 | C | Apparatus | P | 3 | 2018-03-27 00:00:00 | 44 |  | 14 | 38 | C | Apparatus
14 | FIREFIGHTER | 38 | D | Apparatus | P | 4 | 2018-03-27 00:00:00 | 44 |  | 15 | 62 | C | Apparatus
15 | FIREFIGHTER | 38 | A | Apparatus | P | 5 | 2018-03-27 00:00:00 | 44
15 | FIREFIGHTER | 38 | C | Apparatus | P | 6 | 2018-03-27 00:00:00 | 44
15 | FIREFIGHTER | 62 | C | Apparatus | P | 1 | 2020-11-18 00:00:00 | 15
15 | FIREFIGHTER | 38 | D | Apparatus | P | 2 | 2020-11-18 00:00:00 | 15
Spreadsheet: 106453d1303745665-sumifs-across-sheets-copy-of-central-office-2010-2011-w-formulas
Sheet: Sups Conf

FIRST NAME | EMP # | 2010-07-09 00:00:00 | 2010-08-10 00:00:00 | 2010-09-10 00:00:00 | 2010-10-10 00:00:00 | 2010-11-10 00:00:00 | 2010-12-10 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total Hours | COMMENTS
Jeanette | 424683 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 424683
Antania | 646058 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 646058
[NAME] | 495042 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 495042
[NAME] | 71949 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71949
[NAME] | 439185 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 439185
[NAME] | 608039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 608039
[NAME] | 462816 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 462816
Arleathia | 25374 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25374
[NAME] | 72385 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72385
Meri | 544272 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 544272
[NAME] | 647210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 647210
[NAME] | 608513 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 608513
[NAME] | 438766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 438766
[NAME] | 494815 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 494815
[NAME] | 71810 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71810
[NAME] | 525136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 525136
[NAME] | 45967 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45967
[NAME] | 56717 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56717
Daryl | 515249 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 515249
Michelle | 49776 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49776
George | 489089 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 489089
Avery | 628970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 628970
[NAME] | 432011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 432011
[NAME] | 392020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 392020
Becky | 620673 | 12:00:00 |  |  | 06:00:00 |  |  | 12:00:00 |  |  |  |  |  |  |  |  | 620673
[NAME] | 87575 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87575
[NAME] | 194488 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 194488
[NAME] | 35716 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35716
[NAME] | 679339 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 679339
[NAME] | 515575 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 515575
[NAME] | 455242 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 455242
Spreadsheet: 40730d1239129410-adding-column-with-corresponding-names-target-recap2-2-
Sheet: Sheet1 (2)

 |  |  |  | TARGET RECAP |  |  |  | STORE | 2
 |  |  |  |  |  | W/E DATE | __________
 |  |  | MEAT | CHICKEN | GRILLED | NUGGET | POTATO | BACON | CRISPY | CMILK | WMILK | SPICY
MON | CHRIS | D | 2 |  | 30
 | RENE | N | 1
TUE | CHRIS | D | 1 |  | -15
 | RENE | N | 1
WED | CHRIS | D | 5
 |  | N
THU |  | D
 |  | N
FRI |  | D
 |  | N
SAT |  | D
 |  | N
SUN |  | D
 |  | N
 |  | D | 8 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | WEEK | N | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | T | 10 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOT | CHRIS |  | should =8
 | RENE |  | should=2
 | GABE
 | GREIMY
 | + MEANS USED MORE THAN TARGET
Spreadsheet: 80454d1280676981-extracting-values-from-a-single-cell-example
Sheet: Sheet5

original content |  |  | desirable outcome
14-3-3 |  | 14 | 3 | 3
9-2-3 |  | 9 | 2 | 3
8-2-2 |  | 8 | 2 | 2
6-56-1 |  | 6 | 56 | 1
9-2-1 |  | 9 | 2 | 1
7-5-0 |  | 7 | 5 | 0
8-5-1 |  | 8 | 5 | 1
Spreadsheet: 770447d1646074535-vlookup-or-index-match-possibly-book1
Sheet: P&L 2018-Dec2021

Classification | Sub-Classification | [NAME].
Revenue | Service line 1
Revenue | Service line 2
Revenue | Service line 3
COS | People
COS | Bonuses
COS | Owner's Salary | Adj 1
SG&A | Rent
SG&A | Utilities
Summary
Adjustments
Spreadsheet: 54971d1255013445-email-filtered-data-from-lotus-notes-ci-card-database-2009-new
Sheet: Email

 | 1st |  |  |  | , | 2nd | 3rd
[NAME] | [EMAIL] | [NAME] | [EMAIL] | HisBoss | [EMAIL] | [EMAIL],[EMAIL] | [EMAIL],[EMAIL],[EMAIL]
[NAME] | [EMAIL] | Johns Boss | [EMAIL] | HisBoss | [EMAIL] | [EMAIL],[EMAIL] | [EMAIL],[EMAIL],[EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL] | HerBoss | [EMAIL] | [EMAIL],[EMAIL] | [EMAIL],[EMAIL],[EMAIL]
Spreadsheet: 733077d1621376017-formulas-for-store-inventory-sheets-store-inv-tracker
Sheet: Requirements

item Name | Weekend Days(Sat-Sun) | Total | Used | New
P32000 |  |  | 0 | 0
P34000 |  |  | 0 | 0
P36000 |  |  | 0 | 0
P38000 |  |  | 0 | 0
P1000 |  |  | 0 | 0
P2000 |  |  | 0 | 0
P30000T |  |  | 0 | 0
P31000T |  |  | 0 | 0
P33000T |  |  | 0 | 0
P37000E |  |  | 0 | 0
P39000E |  |  | 0 | 0
P41000E |  |  | 0 | 0
The Above fields - Weekend Days/Used/New should automatically updated from Tracker Sheet.
Spreadsheet: 94137d1294002331-help-with-making-a-function-kaiouji-ef758422-sdg10
Sheet: Sheet1

 |  | Prices of Item |  |  |  | But if-->
 |  | HP Direct | 110.99 |  |  |  |  | HP Direct | 110.99
 |  | Office Depot | 110.99 |  |  |  |  | Office Depot | #N/A
 |  | Staples | 109.99 |  |  |  |  | Staples | 109.99
 |  |  | Result |  |  |  |  |  | Result |  |  | =MIN(IF(ISNUMBER(J9:J11),J9:J11))
 |  |  |  |  |  |  |  | [NAME] SDG10.xlsx
 |  |  |  |  |  |  |  | I want this to spit the min of the other two prices instead of N/A
 |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/758422-help-with-making-a-function.html
 |  |  |  |  |  |  |  | jeffreybrown
 |  |  |  | '=MIN(IF(ISNUMBER(D9:D11),D9:D11))
Spreadsheet: 84847d1284941524-index-and-match-or-lookup-formula-copy-of-demo-3
Sheet: DEMO Sheet (2)

 |  | Date | Name | In coming | Out going | Balance |  |  |  | Date | Name | In coming | Out going | Balance
Spreadsheet: 161325d1339498810-conditional-formatting-not-automatically-changing-0cff
Sheet: Φύλλο1

S.NO | CORRESPONDENCE NUMBER | RECEIVING DATE | DOCUMENTS TITLE / SUBJECT | REPLY. REQD. | DOC. TYPE | ACTION | Target Date | COMPANY REPLY NO | DATE OF REPLY | STATUS | REMARKS
1 | 12 | 2012-04-02 00:00:00 | A |  |  | PM | 2012-05-04 00:00:00
2 | 12 | 2012-04-16 00:00:00 | B | Yes |  | PM | 2012-04-19 00:00:00
3 | 12 | 2012-04-17 00:00:00 | B | No
4 | 12 | 2012-04-18 00:00:00 | B | Yes |  | PM
5 | 12 | 2012-04-19 00:00:00 | B | No |  |  |  |  |  | Closed
6 | 12 | 2012-04-22 00:00:00 | B | Yes |  | PM |  |  | 2012-05-21 00:00:00 | Closed
7 | 12 | 2012-04-24 00:00:00 | B | No |  |  |  |  |  | Closed
8 | 12 | 2012-04-25 00:00:00 | B | No |  | PM |  |  |  | Closed
9 | 12 | 2012-05-03 00:00:00 | B | Yes |  | PM | 2012-08-05 00:00:00
10 | 12 | 2012-05-06 00:00:00 | B | Yes |  | PM |  |  | 2012-05-20 00:00:00 | Closed
11 | 12 | 2012-05-08 00:00:00 | B | No |  |  |  |  |  | Closed
12 | 12 | 2012-05-08 00:00:00 | B | No
13 | 12 | 2012-05-08 00:00:00 | B | Yes |  | PM | 2012-05-13 00:00:00
14 | 12 | 2012-05-09 00:00:00 | B | No
15 | 12 | 2012-05-10 00:00:00 | B | No
 |  |  | Conditional Formatting | =AND($E4="Yes",$K4<>"Closed",$H4<TODAY(),$H4<>"")
Spreadsheet: 697289d1601300231-sorting-with-grouping-sorting_with_array_fomula
Sheet: Sheet1

Date | Customer | Min date for customer
2020-01-01 00:00:00 | 1111
2020-01-01 00:00:00 | 2222
2020-01-01 00:00:00 | 4123
2020-06-01 00:00:00 | 4123
2020-01-05 00:00:00 | 1234
2020-08-01 00:00:00 | 1234
2020-01-09 00:00:00 | 7456
2020-10-01 00:00:00 | 7456
2020-03-01 00:00:00 | 345
2020-05-01 00:00:00 | 567
2020-07-01 00:00:00 | 2343
2020-09-01 00:00:00 | 3445
Spreadsheet: 847694d1698541156-consolidating-different-pieces-of-data-on-same-dates-help
Sheet: INPUT

Date | CREATION_DATE | ACFT | Serial Number | Flight No | MS_ID | From | LOC_INTM | To | [NAME] | FLT_INTM | [NAME] | FLT_HRS | Landings/takeoffs | LAND_NON_STD | INT_LOAD | EXT_LOAD | PAX | PID_CAT | SOURCE_STATUS | ACFT_ORG_NAME | ACFT_STATION | LNAME | FNAME | MNAME | SUFFIX | RANK | EDI_PI | SEQ_NUM | operational conditions | pilot functions | hours | SEAT | LABOR_CODE | WPN_762 | WPN_20MM | WPN_30MM | WPN_40MM | WPN_ROCKET | WPN_TOW | WPN_HELLFIRE
2022-02-02 00:00:00 |  | UH-60L | 1111111 | 1 |  | A |  | B | 14:05 |  | 16:35 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | D | IP | 1.8
2022-02-02 00:00:00 |  | UH-60L | 1111111 | 1 |  | A |  | B | 14:05 |  | 16:35 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | H | IP | 0.7
2022-02-12 00:00:00 |  | UH-60L | 1111111 | 1 |  | A |  | B | 15:15 |  | 17:15 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | D | IP | 2
2022-02-12 00:00:00 |  | UH-60L | 1111111 | 2 |  | A |  | B | 19:25 |  | 21:25 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | NG | IP | 1
2022-02-12 00:00:00 |  | UH-60L | 1111111 | 2 |  | A |  | B | 19:25 |  | 21:25 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | N | IP | 1
Spreadsheet: errol_mclaughlin_jr__10114__Rpt PMA Gas Two RM
Sheet: RM 1200

As of December 2000
Resp | Bookcode | Month | Code | Type | Description | Risk
[NAME] | APEA Prepay (QZ) | Jun | RM | E | June MTM Beginning Balance on DPR for Price Deals does not = May MTM Ending Balance on DPR, Rolling Error | -77553.24
[NAME] | APEA Prepay (QZ) | Sep | RM | E | MTM, Total value of Schedule B does not tie to Controls Group Schedule. | -207242.9
[NAME] | Chase Mahonia IV  (QK) | Jun | RM | E | June MTM Beginning Balance on DPR for Price Deals does not = May MTM Ending Balance on DPR, Rolling Error | -9677.61
[NAME] | Chase Mahonia IV  (QK) | Sep | RM | E | MTM, Total value of Schedule B does not tie to Controls Group Schedule. | 6910.77
[NAME] | Chase V (QL) | Jun | RM | E | June MTM Beginning Balance on DPR for Price Deals does not = May MTM Ending Balance on DPR, Rolling Error | -23606.96
[NAME] | Chase V (QL) | Sep | RM | E | MTM, Total value of Schedule B does not tie to Controls Group Schedule. | -333301.62
[NAME] | Chase VIII | Jun | RM | E | June MTM Beginning Balance on DPR for Price Deals does not = May MTM Ending Balance on DPR, Rolling Error | -1605418.67
[NAME] | Chase VIII | Sep | RM | E | MTM, Total value of Schedule B does not tie to Controls Group Schedule. | 24637.5
[NAME] | FPL Hedge (G&) | Aug | RM | E | One Liquidation came through for Aug NT4811; Not in DPR | -159803
[NAME] | FT Texas Online | Oct | RM | O | Rounding | -134.35
[NAME] | FT Texas Online | Sep | RM | O | Gas Daily Variances | 2094.96
[NAME] | NG CANADIAN | Dec | RM | E | Value of Deals changed per Canada. NH6815.3, [NAME], NH6815.5, Q19197.6, Q19198.6 | 5040.96
[NAME] | NG Gas Hedge (QN, W( ) | Dec | RM | E | Gas Daily Variances, Prices incorrect in Erms for last two days of the month of December | 2095584
[NAME] | NG Gas Hedge (QN, W( ) | Various | RM | E | [NAME] | -66.74
[NAME] | NG PRICE | Aug | RM | E | NQ6582.1 not in DPR | -2370000
[NAME] | NG PRICE | Dec | RM | E | NYMEX Options/Futures | -8900
[NAME] | NG PRICE | Dec | RM | E | Gas Daily Variances, Prices incorrect in Erms for last two days of the month of December | -360663.74
[NAME] | NG PRICE | Dec | RM | E | NK998.2, Deal should have been in PG book as a swap with P& book, per Canada. Corrected in TAGG by [NAME] on 1/9/01 | 300080
[NAME] | NG PRICE | Dec | RM | E | Broker Fees | -278075
[NAME] | Options (GN) | Dec | RM | E | Post ID 994810. Variance from liquidation value on Roll 3 of DPR (E30), versus Accrued value of Post ID out of Erms. | -4284070
[NAME] | Options (GN) | Dec | RM | E | Broker Fees | -5655
[NAME] | Options (GN) | Dec | RM | E | Gas Daily Variances, Prices incorrect in Erms for last two days of the month of December | 159307
[NAME] | Strategic Energy Prepay (QP) | Jun | RM | E | June MTM Beginning Balance on DPR for Price Deals does not = May MTM Ending Balance on DPR, Rolling Error | -3905.32
[NAME] | Strategic Energy Prepay (QP) | Sep | RM | E | MTM, Total value of Schedule B does not tie to Controls Group Schedule. | -19859.41