tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: MAA

Raw Material |  | MAA
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 670
Total
Spreadsheet: mark_taylor__25052__CanHunter ISDA cw 071801
Sheet: Collateral Threshold Matrix

Canadian Hunter Exploration (Based upon Sr. Unsecured L-T Debt Rating)*
 | S&P/Moody's | Threshold | CBRS | Threshold
 | A- and above/A3 and above | 25000000 | A | 25000000
 | BBB+/Baa1 | 20000000 | A- | 20000000
 | BBB/Baa2 | 15000000 | BBB+ | 15000000
 | BBB-/Baa3 | 10000000 | BBB | 10000000
 | BB+/Ba1 | 5000000 | BBB- | 5000000
 | Below BB+/Ba1 | 0 | Below BBB- | 0
Note* Should split ratings apply to S&P and Moody's, the lower of the two ratings shall govern.
Enron Canada Corporation (Based upon Sr. Unsecured L-T Debt Rating of Guarantor)*
 | S&P/Moody's | Threshold
 | A- and above/A3 and above | 25000000
 | BBB+/Baa1 | 20000000
 | BBB/Baa2 | 15000000
 | BBB-/Baa3 | 10000000
 | BB+/Ba1 | 5000000
 | Below BB+/Ba1 | 0
Note* Should split ratings apply to S&P and Moody's, the lower of the two ratings shall govern.
Spreadsheet: 27526d1220850128-lookup-sumifs-test
Sheet: Summary

2008 |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec
Income
 | Whatever
 | Total
Spreadsheet: 213265d1360415670-daily-receipt-log-dailylog2013
Sheet: Receipt

 |  |  |  | ACCOUNT'S COPY |  |  |  | RECEIPT
 |  |  |  |  |  |  |  | DATE: | 2013-02-09 00:00:00
 |  |  | ABB FREIGHT (INDIA) PVT LTD |  |  |  | RECEIPT NO |  | 1111
EVEREST CHAMBERS, NEXT TO STAR, [NAME],
ANDHERI (EAST), [NAME]. TEL +91 22 88888888
FAX +91 22 9999 0000 (A) / 333 (O) www.abblogistics.com
Received with thanks from |  |  | ABC   & Co Ltd
 | Customer Code |  | [PHONE]
Cheque / Draft / Pay order No. |  |  |  | 888888 |  | DATE | 2013-02-09 00:00:00 | ON: | sbi
for Rs. | 12345
on account of
Incoice No |  | Date |  | Amount
1 |  | 2013-02-09 00:00:00 |  | 900
2 |  | 2013-02-09 00:00:00 |  | 2223
3 |  | 2013-02-09 00:00:00 |  | 2134
4 |  | 2013-02-09 00:00:00 |  | 2334
5 |  | 2013-02-09 00:00:00 |  | 5000
 |  |  |  |  |  | TDS
Cheque subject to realisation |  |  |  |  |  |  | For ABB Freight (India) Pvt Ltd.
Regd. Office :
Spreadsheet: 836714d1689604039-search-and-return-multiple-results-search-mm
Sheet: Blad1

 | [NAME]
 | Search for value A2 in 'column C' on 'sheet2' and return the corresponding value located in 'column A' on 'sheet2'. If multiple values are found, they will be concatenated together.
4.1
4.2
4.3
4.4
5.1 | 1,
5.2
5.3 | 1,
6.1
6.1.1
6.1.2 | 4, 5,
6.1.3
6.2
6.3
7.1
7.2
7.3
7.4
7.5
7.5.1
7.5.2
7.5.3
8.1
8.2
8.3
9.1 | 2,
9.2
9.2.1
9.2.2
9.3
9.3.1
9.3.2
9.3.3
10.1
10.2
Spreadsheet: louise_kitchen__23102__0112MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2001-12-11 00:00:00
2001-12-10 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
BANK ONE |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN
FIMAT |  |  |  | 0 |  |  |  | 1
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
JP Morgan |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 275806d1383653172-index-match-w-2-criteria-adminsalaryscale2013
Sheet: Salary

 | L/G | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
230 | 1 | 3000
265 | 2 | 3300
300 | 3 | 3500
335 | 4 | 4000
370 | 5 | 4500
405 | 6 | 5700
440 | 7 | 6700
475 | 8 | 8200
510 | 9 | 10500
540 | 10 | 13500
575 | 11 | 18000
Spreadsheet: 849171d1699690680-averageifs-dynamic-row-and-column-test
Sheet: Sheet1

Team | Manager | Agent | Week | Days | Sale | Call | Work Hours
Department | [NAME] | Tia | 44 | 2023-11-10 00:00:00 | 3 | 60 | 8 |  |  | [NAME] |  | Tia |  | Sale |  | [NAME] | Tia
Department | [NAME] | [NAME] | 44 | 2023-11-10 00:00:00 | 4 | 58 | 8.2 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Department | [NAME] | Amanda | 44 | 2023-11-10 00:00:00 | 2 | 55 | 7.8 |  |  | Week | 44 | 45 |  |  |  | [NAME] | Amanda
Department | [NAME] | Grace | 44 | 2023-11-10 00:00:00 | 3 | 59 | 7.9 |  | Agent |  |  |  |  |  |  |  | Grace
Department | [NAME] | [NAME] | 44 | 2023-11-10 00:00:00 | 1 | 48 | 7.9 |  | Manager |  |  |  |  |  |  |  | [NAME]
Department | [NAME] | [NAME] | 44 | 2023-11-10 00:00:00 | 2 | 47 | 8.1 |  | Department |  |  |  |  |  |  |  | [NAME]
Department | [NAME] | Tia | 44 | 2023-11-12 00:00:00 | 3 | 50 | 7.8
Department | [NAME] | [NAME] | 44 | 2023-11-12 00:00:00 | 8 | 57 | 7.7
Department | [NAME] | Amanda | 44 | 2023-11-12 00:00:00 | 4 | 42 | 5.9
Department | [NAME] | Grace | 44 | 2023-11-12 00:00:00 | 6 | 57 | 8.3
Department | [NAME] | [NAME] | 44 | 2023-11-12 00:00:00 | 7 | 60 | 7.9
Department | [NAME] | [NAME] | 44 | 2023-11-12 00:00:00 | 5 | 58 | 7.9
Department | [NAME] | Tia | 45 | 2023-11-10 00:00:00 | 3 | 60 | 8
Department | [NAME] | [NAME] | 45 | 2023-11-17 00:00:00 | 7 | 58 | 7.8
Department | [NAME] | Amanda | 45 | 2023-11-17 00:00:00 | 2 | 63 | 7.2
Department | [NAME] | Grace | 45 | 2023-11-17 00:00:00 | 3 | 48 | 7.7
Department | [NAME] | [NAME] | 45 | 2023-11-17 00:00:00 | 4 | 33 | 7.9
Department | [NAME] | [NAME] | 45 | 2023-11-17 00:00:00 | 6 | 72 | 8
Department | [NAME] | Tia | 45 | 2023-11-18 00:00:00 | 2 | 58 | 7.9
Department | [NAME] | [NAME] | 45 | 2023-11-18 00:00:00 | 1 | 64 | 8.3
Department | [NAME] | Amanda | 45 | 2023-11-18 00:00:00 | 4 | 63 | 7.2
Department | [NAME] | Grace | 45 | 2023-11-18 00:00:00 | 6 | 48 | 7.7
Department | [NAME] | [NAME] | 45 | 2023-11-18 00:00:00 | 9 | 33 | 7.9
Department | [NAME] | [NAME] | 45 | 2023-11-18 00:00:00 | 2 | 72 | 8
Spreadsheet: 0c69b9ea-0f6a-41d7-bcde-246e199f2a1c
Sheet: Tested predictions

Gene | Name | CRM Rank | Location | Tested region | Activity | Mesodermal?
CG16738 | slp1 | 3099 | upstream | chr2L:3,822,921-3,824,093 | dorsal mesoderm including FCs | Yes
CG6534 | slou | 4961 | upstream | chr3R:17,390,942-17,392,193 | 2 Slou-expressing FCs | Yes
CG9786 | hb | 2062 | intronic | chr3R:4,520,912-4,522,555 | longitudinal visceral muscle | Yes
CG3830 | vg | 5341 | intronic | chr2R:8,777,357-8,778,655 | vg-expressing peripheral neurons | No
CG4029 | jumu | 408 | intronic | chr3R:6,179,947-6,181,571 | none | No
CG5799 | dve | 57 | intronic | chr2R:18,134,411-18,136,065 | expressed in somatic myotubes after the FC stage | Yes
CG8965 | CG8965 | 37 | upstream | chr2L:5,881,464-5,883,149 | none | No
CG17046 | klar | 63 | intronic | chr3L:522,945-524,581 | epidermis, endoderm | No
CG10250 | nau | 323 | intronic | chr3R:19,540,896-19,542,078 | ectoderm | No
CG4722 | bib | 116 | intronic | chr2L:9,989,940-9,991,999 | neurons, ectoderm | No
CG9398 | king-tubby | 883 | intronic | chr2R:16,990,432-16,991,559 | neurons, ectoderm | No
CG3036 | CG3036 | 2649 | intronic | chr2L:4,894,024-4,895,095 | none | No
Spreadsheet: 78569d1278950694-problem-with-convert-to-text-columns-wizard-example-file
Sheet: Tabelle1

10001	"Africa | Total"	"820"	"New Zealand"	"D"	"Constant Prices (2008 USD millions)"	"201"	"ODA Grants | Disbursements"	"1986"	"1986"	1.24
10001	"Africa | Total"	"8"	"Norway"	"D"	"Constant Prices (2008 USD millions)"	"201"	"ODA Grants | Disbursements"	"1971"	"1971"	89.66
10001	"Africa | Total"	"8"	"Norway"	"D"	"Constant Prices (2008 USD millions)"	"201"	"ODA Grants | Disbursements"	"1986"	"1986"	856.82
10001	"Africa | Total"	"2"	"Belgium"	"A"	"Current Prices (USD millions)"	"201"	"ODA Grants | Disbursements"	"1971"	"1971"	86.41
10001	"Africa | Total"	"2"	"Belgium"	"A"	"Current Prices (USD millions)"	"201"	"ODA Grants | Disbursements"	"1986"	"1986"	204.32
10001	"Africa | Total"	"20001"	"DAC Countries | Total"	"D"	"Constant Prices (2008 USD millions)"	"201"	"ODA Grants | Disbursements"	"1961"	"1961"	11167.1
10001	"Africa | Total"	"20001"	"DAC Countries | Total"	"D"	"Constant Prices (2008 USD millions)"	"201"	"ODA Grants | Disbursements"	"1976"	"1976"	7196.65
10001	"Africa | Total"	"20001"	"DAC Countries | Total"	"D"	"Constant Prices (2008 USD millions)"	"201"	"ODA Grants | Disbursements"	"1982"	"1982"	12066.7
Spreadsheet: 769437d1645539057-highlighting-a-cell-if-the-text-in-a-range-matches-the-text-in-a-separate-workbook-range-book2test
Sheet: Sheet1

4
3
4
6
7
21
9
10
Spreadsheet: 683068d1592474010-hr-dashboard-question_countifs-sample-data
Sheet: Sheet1

Employee # | Country | Employee Class | Department | Gender | Nationality | Name | Contract Start Date | Contract End Date |  | Current Headcount (as of today 18th June 2020)
81000018 | Germany | Expat - Germany | Brand | Male | Germany | Bear | 2019-12-16 00:00:00 | 2021-06-15 00:00:00
81000005 | Germany | Expat - Germany | Operations | Male | China | Lion | 2019-10-01 00:00:00 |  |  | 14
81000020 | Germany | Expat - Germany | Sales | Male | Netherlands | Parrot | 2020-08-01 00:00:00
11065424 | Germany | Expat - Germany | Product | Female | China | Swallow | 2019-11-16 00:00:00 | 2020-05-27 00:00:00
81000011 | Germany | Expat - Germany | Operations | Male | Ghana | Finch | 2019-12-01 00:00:00
81000019 | Germany | Expat - Germany | Brand | Female | Bulgaria | Panda | 2020-03-01 00:00:00 | 2022-02-28 00:00:00
81100002 | Germany | Internship | Sales | Male | China | Tiger | 2019-12-02 00:00:00 | 2020-08-01 00:00:00
11097384 | Germany | Fulltime - Germany | Operations | Male | China | Crow | 2019-11-24 00:00:00 | 2021-11-23 00:00:00 |  | Males vs Females
11103053 | Germany | Fulltime - Germany | Brand | Male | South Korea | Deer | 2019-11-01 00:00:00 | 2022-10-31 00:00:00
81000007 | Germany | Fulltime - Germany | Brand | Male | Italy | Gorilla | 2019-10-15 00:00:00
10946714 | Germany | Fulltime - Germany | Sales | Male | China | Monkey | 2019-11-23 00:00:00
81000023 | Germany | Fulltime - Germany | Operations | Male | China | Ostrich | 2020-03-09 00:00:00 | 2022-03-08 00:00:00
81000034 | Germany | Fulltime - Germany | Sales | Male | Germany | Snake | 2020-07-01 00:00:00
81000016 | Germany | Fulltime - Germany | Brand | Male | Great Britain | Elephant | 2020-03-01 00:00:00 | 2022-02-28 00:00:00
81000012 | Spain | Fulltime - Germany | Sales | Male | Spain | Cat | 2019-10-13 00:00:00
11091473 | Germany | Fulltime - Germany | Operations | Male | China | Dog | 2020-02-25 00:00:00 | 2020-06-24 00:00:00
11002573 | Germany | Fulltime - Germany | Brand | Male | China | [NAME] | 2019-11-23 00:00:00 | 2022-02-25 00:00:00
Spreadsheet: dad0ed39-b262-4cab-8595-b610497fd4c5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8776 | 68920 | Debbie | Trafford | GBR | 107 | 00:20:55 | 00:00:47 | 00:36:44 | 00:01:31 | 00:22:12 | 1 | 01:22:12
8776 | 69396 | Valentina | Mela | ITA | 106 | 00:20:49 | 00:00:55 | [NAME] | 00:01:11 | 00:25:47 | 2 | 01:31:27
Spreadsheet: louise_kitchen__22833__Credit List Additions1
Sheet: Additions

Counterparty Name | Counterparty ID
AEC Marketing | 53368
AEC Marketing (USA), Inc. | 58009
AEC Storage and Hub Services, a business unit of Alberta Energy Company Ltd | 56586
ATCO Midstream Ltd. | 56624
BC Gas Utility Ltd. | 46749
Cross Alta Gas Storage &  Services Ltd. | 29763
ERCOT Imbalance | 111776
IGI Resources, Inc. | 1799
Nexen Marketing | 57251
Nova Gas Transmission Ltd. (NGTL) | 11330
Petro-Canada Oil and Gas | 52868
Puget Sound Energy, Inc. | 54279
Sabine Hub Services, a division of Texaco Canada Petroleum Inc. | 53342
SaskEnergy Incorporated | 5177
TransCanada Energy Financial Products Limited | 48528
TransCanada Energy Marketing USA, Inc. | 54480
TransCanada Gas Services Inc. | 45829
TransCanada Gas Services, a division of TransCanada Energy Ltd. | 54461
TransCanada PipeLines Limited | 6223
Unocal Canada Limited | 26342
Westcoast Energy Inc. | 11324
Spreadsheet: darron_c_giron__8016__Rho_Drift_3rd_Quarter_deals
Sheet: Sheet2

 | NOTIONAL |  | PRESENT VALUE
 | MEH INCOME |  | MEH INCOME
38 SPECIAL | 392744 |  | 392744
TRUNKLINE | 2286634 |  | 2341454
TRUNKLINE | 363 |  | -4871
[NAME] | 37445 |  | 40303
ANR ROLLING THUNDER | 512234 |  | 485514
MEH SHARE OF ROLLING THUNDER | 128045 |  | 128045
NSS TIDAL WAVE | 463701 |  | 464703
MEH SHARE OF TIDAL WAVE | 115925 |  | 115925
[NAME] | 16423 |  | 6719
Hub Bailout (Original Deal booked 6-27) | 2002753 |  | 1593628
Reserve taken out of MEH for Hub Bailout | -1250000 |  | -1250000
Unwinding of the first third (Deal done 7-13) | -451455 |  | -454252
Releasing part of the Bailout Reserve | 451455 |  | 451455
Unwinding of the second third (Deal done 7-20) | -359839 |  | -361160
Releasing part of the Bailout Reserve | 359839 |  | 359839
Rehedging 1/3 (Deal done 8-21) | 575157 |  | 576533
Reserved in the book | -575157 |  | -575157
Rehedging 1/3 (Deal done 9-15) | 612584 |  | 614265
Reserved in the book | -612584 |  | -612584
[NAME] | 95000 |  | 95000
PGL Hub Deals | 344000 |  | 344000
EMW HUB Deals | 175505 |  | 175505
Alliance Deal | 22800 |  | 22800
NSS Bailout | 1200000 |  | 1200000
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -9175
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -543926
58710 | -9364 | -330
60921 |  | 307368
78026 |  | 7000
500084 |  | -5000
500085
500097
INDEX
2001-05-31 00:00:00 |  |  | 597448.83
2001-06-05 00:00:00
Spreadsheet: 195259d1353461300-look-up-the-lowest-price-from-column-k-for-each-item-named-in-column-a-price-list
Sheet: ATLNATA COFFEE SUPPLY GROUP

Desc | Pack | Size |  | Unit | Unit Counted | Unit Price | Case $ | Measurement | Total number of OZ per case | Price per. OZ/EA
COFFEE, SUNDOWN DECAF (2.25 OZ) | 1 | 42 | EA | CS | EA |  | 63.85 | EACH
TEA, ICED, BLUE DURANGO "CLASSIC" (4 OZ) | 1 | 24 | EA | CS | EA |  | 44.95 | EACH
MIGHTY LEAF TEA, MIXED CASE GREEN TEA - WHOLE LEAF | 1 | 90 | EA | CS | CS |  | 41.75 | SCALE OZ
COFFEE, COLOMBIAN (2.5 OZ) | 1 | 42 | EA | CS | EA |  | 63.66 | SCALE OZ
SINGLE PODS | 1 | 150 | EA | CS | EA |  | 68.25 | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
Spreadsheet: 844005d1695813107-ratio-where-sum-100-a-million-ways-to-skin-a-cat-no-offense-to-cats-excel_forum_example_red-blue
Sheet: Sheet1

 |  |  | Ratio
 | Red | Blue | A:B
 | 1819 | 981
 | 2229 | 1112 |  |  |  | 67:33 | 67:33
 | 2497 | 1147 |  |  |  | 69:31 | 69:31
 | 4086 | 1649 |  |  |  | 72:28 | 72:28
 | 3806 | 2511 |  |  |  | 61:39 | 61:39
 | 3680 | 3206 |  |  |  | 54:46 | 54:46
 | 3535 | 3017 |  |  |  | 54:46 | 54:46
 | 3076 | 2995 |  |  |  | 51:49 | 51:49
 | 2288 | 2284 |  |  |  | 51:49 | 51:49
 | Columns B & C are Data Input: Red & Blue
 | My want is Column D to be the Ratio     Red:Blue
 | Where Ratio Numbers are Integers  &  Sum of Red & Blue = 100
 | In Example above, that is achieved…
 | I gotta believe there's a better, more straightforward way to get there.
 | Help…  :-)
 | TY    _[NAME]
Spreadsheet: 7cf33dc7-9d0e-46d0-a76c-cbce8a2d96d2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4983 | 16778 | [NAME] | Law | GBR | 526 | 00:55:19 | 00:02:09 | 01:32:36 | [NAME] | 00:28:07 | 1 | 03:00:53
Spreadsheet: 271997d1382126931-excel-problem-with-worksheet-need-to-know-which-function-for-penny-a-day-doubled-problem-book3
Sheet: Sheet1

 | 0.01
Spreadsheet: 722592d1615323125-autofill-column-values-based-on-values-at-regular-intervals-sampledatabase
Sheet: Sheet1

department name | name | date
circus | ronny | 2021-01-01 00:00:00
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-01-08 00:00:00
 |  | 2021-01-09 00:00:00
 |  | 2021-01-10 00:00:00
 |  | 2021-01-11 00:00:00
farm | [NAME] | 2021-01-01 00:00:00
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-01-08 00:00:00
 |  | 2021-01-09 00:00:00
 |  | 2021-01-10 00:00:00
 |  | 2021-01-11 00:00:00
club | donny | 2021-01-01 00:00:00
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-01-08 00:00:00
 |  | 2021-01-09 00:00:00
 |  | 2021-01-10 00:00:00
 |  | 2021-01-11 00:00:00
zoo | hetty | 2021-01-01 00:00:00
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-01-08 00:00:00
 |  | 2021-01-09 00:00:00
 |  | 2021-01-10 00:00:00
 |  | 2021-01-11 00:00:00
bar | lemmy | 2021-01-01 00:00:00
 |  | 2021-01-02 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-04 00:00:00
 |  | 2021-01-05 00:00:00
 |  | 2021-01-06 00:00:00
 |  | 2021-01-07 00:00:00
 |  | 2021-01-08 00:00:00
 |  | 2021-01-09 00:00:00
 |  | 2021-01-10 00:00:00
 |  | 2021-01-11 00:00:00
Spreadsheet: 88571d1288361043-excel-2007-combining-numerous-data-from-many-cells-into-one-cell-udf-concatenate-range-rick-k-
Sheet: Sheet1

103080 | 103739 | 104137 | 105506 | 105802 | 106909 | 233857 | 264508 | 264580 | 291826 | 305519 | 308150 | 322649 | 322653 | 322657 |  | ACCOUNT NUMBERS TO COMBINE INTO ONE CELL
103080,103739,104137 |  |  | RESULTS IF I USE THE =& FUNCTION (STOPPED AFTER COMBINING 3 NUMBERS)
103080, 103739, 104137, 105506, 105802, 106909, 233857, 264508, 264580, 291826, 305519, 308150, 322649, 322653, 322657
103080, 103739, 104137, 105506, 105802, 106909, 233857, 264508, 264580, 291826, 305519, 308150, 322649, 322653, 322657
Spreadsheet: 118016d1313352824-linking-2-cells-together-premier-league-fun
Sheet: Teams

Shop 1 | Margeret | Newcastle |  | Shop 12 | [NAME] | [NAME] |  | Shop 15 | Nick | Arsenal |  | Shop 17 | [NAME] | Man Utd
 | Lynda | Newcastle |  |  |  |  |  |  | Lesley | Man Utd
 | [NAME] | Newcastle |  |  |  |  |  |  | Lynda | Tottenham
 | [NAME] | Newcastle |  |  |  |  |  |  | Ellen | Liverpool
 | Rachel | Newcastle
 | [NAME] | Newcastle
 | Emma | Newcastle
Shop 18 | Kingston | Arsenal |  | Shop 20 | Croydon | Arsenal |  | Shop 23 | [NAME] | Chelsea |  | Shop 27 | Mark | West Brom |  | Not Selected | Wolves
 |  |  |  |  |  |  |  |  |  |  |  |  | Vince | Everton |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  | Sunderland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoke
Shop 28 | Cribbs | [NAME] |  | Shop 29 | Gerard | Man Utd |  | Shop 32 | Natasha | Man Utd |  | Shop 33 | Swansea | Swansea City |  |  | Fulham
 |  |  |  |  | [NAME] | Tottenham |  |  | [NAME] | Arsenal
 |  |  |  |  | [NAME] | Liverpool |  |  | [NAME] | Man Utd
 |  |  |  |  | [NAME] | [NAME]
Shop 34 | Sheena | QPR |  | Shop 35 |  | Arsenal |  | Shop 37 | Lakeside | Arsenal |  | Shop 39 | Watford | Man City
 | [NAME] | [NAME]
 | Keaton | Arsenal
 | [NAME] | Man Utd
Shop 40 | Jemma | Arsenal |  | Shop 41 | [NAME] | Man Utd |  | Shop 42 | Ant | Arsenal |  | Shop 64 | [NAME] | Liverpool
 | Stacy | Arsenal |  |  | [NAME] | Liverpool |  |  | Amal | Man Utd |  |  | [NAME] | Tottenham
 | [NAME] | Man Utd |  |  | [NAME] | Chelsea |  |  | Sheriff | Liverpool |  |  | [NAME] | West Brom
 | Charmaine | Man Utd |  |  | [NAME] | Arsenal
 | [NAME] | Man Utd |  |  | [NAME] | Liverpool
 |  |  |  |  | [NAME] | Newcastle
Shop 81 |  | Man City |  | Shop 82 | Candy | Liverpool |  | Shop 83 |  | Newcastle |  | Shop 84 | Gateshead | Newcastle
Spreadsheet: 298131d1392719743-matching-and-painting-the-matches-cf
Sheet: Sheet1

2014-02-21 00:00:00 | 5000 | 1000 | 2014-02-23 00:00:00
2014-02-22 00:00:00 | 2500 | 1200 | 2014-02-20 00:00:00
2014-02-23 00:00:00 | 1000 | 2400 | 2014-02-12 00:00:00
2014-02-24 00:00:00 | 1000 | 5000 | 2014-02-22 00:00:00
2014-02-24 00:00:00 | 1200 | 1100 | 2014-02-22 00:00:00
Spreadsheet: 126987d1320093009-countif-on-mismatch-data-countifsample
Sheet: Report

Physician Name | Count
Birdsall, [NAME] | 4
[NAME], [NAME] | 3
[NAME], [NAME] | 3
Grand Total | 10
Physcian | Short Name | Count
Bhargava, Shalini
Birdsall, [NAME]
[NAME], [NAME] D
Chu, Garvin K
Spreadsheet: 111022d1307543026-excel-2007-pivot-table-issue-ptwidgetfilter
Sheet: Table

Reference Number | (All)
Sum of Quantity | Column Labels
Row Labels | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 2011-05-23 00:00:00 | 2011-05-25 00:00:00 | 2011-05-26 00:00:00 | 2011-06-01 00:00:00 | 2011-06-03 00:00:00 | 2011-06-06 00:00:00 | 2011-06-07 00:00:00 | Grand Total
Widget 05 | 10 | 8 | 10 | 0 | 2 | 20 | 8 | 21 | 39 | 118
Widget 09 | 10 | 0 | 12 | 6 | 0 | 13 | 0 | 8 | 5 | 54
Widget 10 | 0 | 0 | 0 | 0 | 45 | 0 | 3 | 0 | 4 | 52
Grand Total | 20 | 8 | 22 | 6 | 47 | 33 | 11 | 29 | 48 | 224
Spreadsheet: 800547d1665736496-lookup-with-multiple-criteria-example5
Sheet: Sheet1

Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender |  | Daily H'cap |  | Male
1 | Carol | 26 | 23.1 | 93 | 67 | Female | A Grade (M) | 0 | 12
2 | Garry | 30 | 29.2 | 98 | 68 | Male | B Grade (M) | 12 | 18
3 | Trevor | 14 | 14.5 | 83 | 69 | Male | C Grade (M) | 18 | 54
4 | [NAME] | 5 | 3.6 | 76 | 71 | Male
5 | [NAME] | 3 | 1.7 | 74 | 71 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 13 | 10.7 | 84 | 71 | Male | A Grade (F) | 0 | 20
7 | [NAME] | 18 | 18.0 | 89 | 71 | Male | B Grade (F) | 20 | 54
8 | Billy | 14 | 11.5 | 86^^ | 72^^ | Male
9 | Martina | 16 | 14.1 | 88 | 72 | Female
10 | [NAME] | 5 | 3.2 | 77 | 72 | Male
11 | [NAME] | 13 | 13.6 | 86 | 73 | Male
12 | [NAME] | 9 | 7.6 | 82 | 73 | Male
13 | [NAME] | 12 | 9.6 | 85 | 73 | Male
14 | [NAME] | 13 | 11.0 | 86 | 73 | Male
15 | [NAME] | 18 | 18.2 | 91 | 73 | Male
Spreadsheet: 683751d1592925297-incremental-formulas-filling-horizontal-issue-copy-of-summary
Sheet: SUMMARY

CSL | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00
Working | 5 | 3 | 4 | 5 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 4
Sick | 0 | 1 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
Holiday | 0 | 1 | 1 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 1
Helper
 | 2020-06-22 00:00:00 |  |  | 2020-06-23 00:00:00 |  |  | 2020-06-24 00:00:00
 | Working | Sick | Holiday | Working | Sick | Holiday | Working | Sick | Holiday
CSL
Total