tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120101d1314978981-how-to-sum-cells-that-share-same-ssn-dummy
Sheet: Sheet1

Name | Balance | SSN_TIN | Relationship Balance
[NAME] | 156.24 | 123456789
[NAME] | 500 | 123456789
Jake | 514.16 | 234567890
[NAME] | 548.25 | 345678901
[NAME] | 1547.25 | 567890123
[NAME] | 1558.21 | 456789012
[NAME] | 2458.24 | 345678901
[NAME] | 2465.15 | 456789012
[NAME] | 2554.49 | 567890123
Jake | 15485.24 | 234567890
[NAME] | 24564.59 | 567890123
[NAME] | 245684.2 | 456789012
[NAME] | 954854.24 | 345678901
Spreadsheet: 864310d1711534795-producing-sales-history-on-point-of-sale-pos-trial
Sheet: Point of Sale

I.'m kindly requesting excel formula to produce point of sale |  |  |  |  |  | Happy Eater (Pvt) Ltd
When I print the invoice it automatically save the invoice transactions in the sales history, |  |  |  |  |  | 5 Street, Bulawayo
and moves the next invoice. It should automatically insert invoiice numbers staring from 1 |  |  |  |  |  | [NAME]: [PHONE]
It sould refuse to print when the name of cashier and the amount received is not entered. |  |  |  |  |  | [NAME]: 200590456
 | POINT OF SALE |  |  |  |  | FISCAL TAX INVOICE
 |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  | Cashier | [NAME]
 | TOTAL AMOUNT
 |  |  |  |  |  |  | Custmer Details |  |  | Inv # | 1
 | CASH RECEIVED |  |  | 30000 |  |  | CHANNON
 | CHANGE |  |  |  |  |  | VAT
 |  |  |  |  |  |  | TIN
 |  |  |  |  |  |  | Item | Qty | Price | VAT | Amount |  | In Stock | VAT
 |  |  |  |  |  |  | Coke | 2
 |  |  |  |  |  |  | Bottled Water | 2
 |  |  |  |  |  |  | Coke | 3
 |  |  |  |  |  |  | Heater | 1
 |  |  |  |  |  |  |  |  | Subtotal
 |  |  |  |  |  |  |  |  | Tax
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Cash Received
 |  |  |  |  |  |  |  |  | Change
 |  |  |  |  |  |  | Thank you. Come again!
Spreadsheet: 688830d1595974239-looking-for-values-in-a-list-before-and-after-the-target-data-in-that-list-stlookup1
Sheet: Data

Sample
41126 | <---This will change based on what |  |  |  | Level | Sample Name | CPS
 | sample I'm looking at. |  |  |  |  | Blank | 465.16
 |  |  |  |  |  | Blank | 410.82
Result |  |  |  |  |  | Blank | 419.99
 |  |  |  |  |  | Blank | 398.16
 |  |  |  |  |  | Blank | 386.66
Is standard before or after the sample? |  |  |  |  |  | Blank | 375.82
Input 1 for before, 0 for after ----> |  |  | 0 | <--user defined |  | Blank | 378.49
 |  |  |  |  |  | Blank | 381.66
Standard Values |  |  |  |  |  | Blank | 377.66
1 |  | <--- Formulae in these cells |  |  |  | 41125 | 51286.35
2 |  | <--- |  |  |  | Blank | 567.49
3 |  | <--- |  |  | 1 | Standard 1 | 59727.16
4 |  | <--- |  |  | 2 | Standard 2 | 69341.85
 |  |  |  |  | 3 | Standard 3 | 88247.56
 |  |  |  |  | 4 | Standard 4 | 109053.59
If I change D9 to 1, B12 to B15 should read the |  |  |  |  |  | Blank | 874.49
standard immediately before the sample named, and |  |  |  |  |  | 41126 | 20043.41
[NAME] if D9 is 0. |  |  |  |  |  | Blank | 601.16
 |  |  |  |  | 1 | Standard 1 | 29977.84
 |  |  |  |  | 2 | Standard 2 | 39291.51
 |  |  |  |  | 3 | Standard 3 | 58952.04
What I want it to return if D9 is 0: |  |  |  |  | 4 | Standard 4 | 78784.79
Standard Values |  |  |  |  |  | Blank | 844.99
1 | 59727.16 |  |  |  |  | 41111 | 61297.38
2 | 69341.85 |  |  |  |  | Blank | 706.51
3 | 88247.56 |  |  |  | 1 | Standard 1 | 72016.05
4 | 109053.59 |  |  |  | 2 | Standard 2 | 82638.91
 |  |  |  |  | 3 | Standard 3 | 103289.56
 |  |  |  |  | 4 | Standard 4 | 122948.21
What I want it to return if D9 is 1: |  |  |  |  |  | Blank | 825.16
Standard Values |  |  |  |  |  | 41975 | 37364.73
1 | 29977.84 |  |  |  |  | 41196 | 34850.86
2 | 39291.51 |  |  |  |  | Blank | 597.99
3 | 58952.04 |  |  |  | 1 | Standard 1 | 47170.13
4 | 78784.79 |  |  |  | 2 | Standard 2 | 57513.19
 |  |  |  |  | 3 | Standard 3 | 78737.92
 |  |  |  |  | 4 | Standard 4 | 100335.73
 |  |  |  |  |  | Blank | 750.16
 |  |  |  |  |  | 41197 | 35271.79
 |  |  |  |  |  | Blank | 649.16
 |  |  |  |  | 1 | Standard 1 | 42377.72
 |  |  |  |  | 2 | Standard 2 | 53590.81
 |  |  |  |  | 3 | Standard 3 | 71294.81
 |  |  |  |  | 4 | Standard 4 | 92787.58
 |  |  |  |  |  | Blank | 890.99
 |  |  |  |  |  | 41202 | 20573.19
 |  |  |  |  |  | 41203 | 21220.35
 |  |  |  |  |  | Blank | 653.82
 |  |  |  |  | 1 | Standard 1 | 29532.21
 |  |  |  |  | 2 | Standard 2 | 39114.01
 |  |  |  |  | 3 | Standard 3 | 57228.94
 |  |  |  |  | 4 | Standard 4 | 75115.68
 |  |  |  |  |  | Blank | 836.16
 |  |  |  |  |  | 41987 | 26767.46
 |  |  |  |  |  | Blank | 610.16
 |  |  |  |  | 1 | Standard 1 | 36916.97
 |  |  |  |  | 2 | Standard 2 | 46972.76
 |  |  |  |  | 3 | Standard 3 | 66892.41
 |  |  |  |  | 4 | Standard 4 | 87222.6
 |  |  |  |  |  | Blank | 604.49
Spreadsheet: 364268d1418308789-how-to-count-the-order-of-occurrence-of-duplicates-count-occurence-number
Sheet: Sheet1

 |  |  |  |  |  | 4567
 |  |  |  |  |  | 1234
 |  |  |  |  |  | 4567
 |  |  |  |  |  | 8900
 |  |  |  |  |  | 3456
 |  |  |  |  |  | 4567
 |  |  |  |  |  | 1234
Spreadsheet: 44920d1243667350-simple-ledger-examplebook1-1-
Sheet: Sheet1

Date | Description | Credit | Debit | Balance | Monthly
2009-01-05 00:00:00 |  |  | 300 | -300 | -300
2009-01-12 00:00:00 |  |  | 400 | -700
2009-01-19 00:00:00 |  |  | 250 | -950
2009-01-26 00:00:00 |  |  | 300 | -1250
2009-02-02 00:00:00 |  |  | 425 | -1675 | -1675
2009-02-05 00:00:00 |  | 1250 |  | -425
Spreadsheet: 112819d1308811422-count-formula-based-on-text-mock
Sheet: Sheet1

 | Names | Dept | Dept | Housekeeping | Compactor | [NAME] | Generator | Manual
 | Mark
 | [NAME]
 | Wayne | GM | SER
 | Kylie |  | REP
 | [NAME] | GM | SER |  |  | 1 |  | 1
 | [NAME]
 |  |  | TOTAL |  |  | 1 |  | 1
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R3

Ime artikla
Spreadsheet: 864563d1711691073-weeknum-and-countif-book6
Sheet: Sheet1

DATE | [WEEKNUM] but generally I don't want this |  | WEEK | COUNT
2024-03-08 00:00:00 |  |  | 11 | 3
2024-03-08 00:00:00
2024-03-14 00:00:00
2024-03-15 00:00:00
2024-03-15 00:00:00
2024-03-19 00:00:00
2024-03-19 00:00:00
2024-03-25 00:00:00
2024-03-25 00:00:00
2024-03-25 00:00:00
Spreadsheet: 713436d1610716793-formula-to-return-multiple-matches-from-a-reference-list-excel_help-1-ans
Sheet: Sheet1

groups_listed | categories_listed |  |  |  |  |  | categories_listed
Group A; Group M; Group T; Group B |  |  |  |  |  |  | Red | Blue | GREEN | TURQUOISE
Group J; Group S; Group C; Group T |  |  |  |  |  |  | YELLOW | Red | Red | GREEN
Group M; Group Q |  |  |  |  |  |  | Blue | Blue
Group C; Group J; Group Q |  |  |  |  |  |  | Red | YELLOW | Blue
Group F; Group A |  |  |  |  |  |  | Red | Red
Group B; Group C; Group D |  |  |  |  |  |  | TURQUOISE | Red | Red
Group W; Group Z |  |  |  |  |  |  | Red | Red
Group T |  |  |  |  |  |  | GREEN
Group O; Group Y |  |  |  |  |  |  | Blue | Red
Spreadsheet: 755319d1636772296-how-to-assign-a-number-for-item-tracking-flight-saturday-producing-a-list-of-unique-numbers-dexter2-
Sheet: Data

Flight: | 443
Day: | Saturday
 | Flight # | Start | End | Duration |  |  |  | Weekday |  |  | Saturday |  |  | Sunday
 |  | 05:50:00 | 13:16:00 |  |  |  |  | 00:00:00 | 0 |  | 00:00:00 | 1 |  | 00:00:00 | 2
 |  | 06:20:00 | 13:46:00 |  |  |  |  | 0:00:00 | 3 |  | 12:00:00 | 4 |  | 12:00:00 | 5
 |  | 06:50:00 | 14:16:00 |  |  |  |  | 0:00:00 | 6 |  | Extra | 9 |  | Extra | 9
 |  | 07:20:00 | 12:16:00 |  |  |  |  | 12:00:00 | 7
 |  | 07:50:00 | 15:26:00 |  |  |  |  | 12:00:00 | 8
 |  | 08:00:00 | 10:36:00 |  |  |  |  | Extra | 9
 |  | 08:20:00 | 15:56:00
 |  | 08:30:00 | 11:06:00
 |  | 08:50:00 | 18:56:00
 |  | 09:00:00 | 19:06:00
44390 |  | 09:20:00 | 14:26:00
44391 |  | 09:30:00 | 19:55:00
44392 |  | 09:50:00 | 14:56:00
44393 |  | 10:00:00 | 15:06:00
44394 |  | 10:10:00 | 15:16:00
44395 |  | 10:30:00 | 20:25:00
44396 |  | 11:00:00 | 21:05:00
 |  | 12:10:00 | 19:35:00
44397 |  | 13:10:00 | 15:46:00
 |  | 13:30:00 | 23:14:00
 |  | 14:10:00 | 23:34:00
 |  | 14:20:00 | 23:54:00
44398 |  | 14:30:00 | 17:08:00
 |  | 14:50:00 | 1900-01-01 00:14:00
 |  | 15:10:00 | 1900-01-01 00:34:00
 |  | 15:20:00 | 1900-01-01 00:54:00
 |  | 15:40:00 | 22:54:00
44399 |  | 15:50:00 | 20:45:00
44300 |  | 17:00:00 | 19:25:00
Spreadsheet: 09eec516-9640-48ac-9740-65ff05b9f8d7
Sheet: TABLE

#1 Access | 5 Year MSJC MVC Data |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Gender | # | % | # | % | # | % | # | % | # | % | # | % | %
Female |  |  |  |  |  |  |  |  |  |  | 425726
Male |  |  |  |  |  |  |  |  |  |  | 411136
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Total
click here for graph
 |  |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Ethnicity | # | % | # | % | # | % | # | % | # | % | # | % | %
White |  |  |  |  |  |  |  |  |  |  | 398271
Hispanic |  |  |  |  |  |  |  |  |  |  | 318674
African American |  |  |  |  |  |  |  |  |  |  | 43085
Asian |  |  |  |  |  |  |  |  |  |  | 21251
Native American |  |  |  |  |  |  |  |  |  |  | 6071
Filipino |  |  |  |  |  |  |  |  |  |  | 23365
Pacific Islander |  |  |  |  |  |  |  |  |  |  | 2305
Multi-Race |  |  |  |  |  |  |  |  |  |  | 22553
Unknown |  |  |  |  |  |  |  |  |  |  | 1287
click here for graph
 |  |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Age | # | % | # | % | # | % | # | % | # | % | # | % | %
<18 |  |  |  |  |  |  |  |  |  |  | 245217
18 & 19 |  |  |  |  |  |  |  |  |  |  | 25706
20 to 24 |  |  |  |  |  |  |  |  |  |  | 52893
25 to 29 |  |  |  |  |  |  |  |  |  |  | 52166
30 to 34 |  |  |  |  |  |  |  |  |  |  | 52145
35 to 39 |  |  |  |  |  |  |  |  |  |  | 55384
40 to 49 |  |  |  |  |  |  |  |  |  |  | 116401
50 + |  |  |  |  |  |  |  |  |  |  | 236950
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Average Age | 26.51373712144864 |  | 26.19821328866555 |  | 26.34498671514474 |  | 26.37160571338879 |  | 26.08614043908161
Median Age | 22 |  | 22 |  | 22 |  | 22 |  | 22
click here for graph
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Riverside County |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 ACS* |  | Recent AY
DSPS | # | % | # | % | # | % | # | % | # | % | # | % | #
Disabilities |  |  |  |  |  |  |  |  |  |  | 105412
 |  |  |  |  |  |  |  |  |  |  | 1299857
Service Area Comparison Data from MSJC official [NAME] codes in the 2010 Census Data.
* note: DSPS comparison data is from the 2010 ACS for Riverside County, disability count for ages 18 to 64
http://www.census.gov/acs/www/about_the_survey/american_community_survey/
Spreadsheet: 50361d1249750708-automatic-sheet-name-for-pivot-table-reports-stock-report
Sheet: NonStandard

BIN # | Description | Programme | FSC | Unit | Unit Cost | Starting Balance | Total In | Total Out | Balance | Value
1 | Pens | Health |  | Pcs | 3 | 1 | 5 | 2 | 4 | 12
2 | Cement | Education |  | [NAME] | 4 | 2 | 4 | 2 | 4 | 16
4 | Fuel | [NAME] |  | [NAME] | 6 | 4 | 12 | 9 | 7 | 42
5 | Tyres | [NAME] |  | Pcs | 7 | 5 | 67 | 54 | 18 | 126
8 | desktop | Education |  | Pcs | 10 | 8 | 23 | 12 | 19 | 190
15 | laptop | Education |  | Pcs | 17 | 15 | 78 | 67 | 26 | 442
16 | desktop | [NAME] |  | Pcs | 18 | 16 | 54 | 34 | 36 | 648
17 | Pens | Education |  | Pcs | 19 | 17 | 32 | 21 | 28 | 532
18 | Cement | Health |  | [NAME] | 20 | 18 | 21 | 21 | 18 | 360
19 | Cartridge | Education |  | Pcs | 21 | 19 | 76 | 43 | 52 | 1092
20 | Fuel | Health |  | [NAME] | 22 | 20 | 87 | 54 | 53 | 1166
21 | Tyres | Education |  | Pcs | 23 | 21 | 65 | 45 | 41 | 943
22 | Education packs | Education |  | Pack | 24 | 22 | 54 | 32 | 44 | 1056
23 | laptop | Health |  | Pcs | 25 | 23 | 43 | 43 | 23 | 575
Spreadsheet: 764376d1642702921-sliding-dynamic-formula-for-only-last-year-of-data-test
Sheet: Sheet1

2022-01-01 00:00:00 | 1
2022-01-02 00:00:00 | 2
2022-01-03 00:00:00 | 3
2022-01-04 00:00:00 | 4
2022-01-05 00:00:00 | 5
2022-01-06 00:00:00 | 6
2022-01-07 00:00:00 | 7
2022-01-08 00:00:00 | 8
2022-01-09 00:00:00 | 9
2022-01-10 00:00:00 | 10
2022-01-11 00:00:00 | 11
2022-01-12 00:00:00 | 12
2022-01-13 00:00:00 | 13
2022-01-14 00:00:00 | 14
2022-01-15 00:00:00 | 15
2022-01-16 00:00:00 | 16
2022-01-17 00:00:00 | 17
2022-01-18 00:00:00 | 18
2022-01-19 00:00:00 | 19
2022-01-20 00:00:00 | 20
2022-01-21 00:00:00 | 30
2022-01-22 00:00:00 | 40
Spreadsheet: 1c651887-05da-4a4f-add5-19f310a75e01
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
STATUS INSTALADORES MADRID |  | LAS ROZAS | ALCALA | ALCORCON | SSRR | MAJADAHONDA | RIVAS | GETAFE | LEGANES
ELECTRIC | ANTENAS
MADERA | ARMARIOS BAJO PEDIDO | DIFASA | DIFASA | DIFASA |  | DIFASA | DIFASA | DIFASA | DIFASA
MATERIALES | BARBACOAS
FERRETERIA | CAJAS FUERTES
FONTANERIA | CALDERAS (CALEFACCION) | ADAME | SERVIHOGAR |  | ROJASAN
JARDIN | CASETAS Y COBERTIZOS | D-LIS | D-LIS |  |  |  |  | D-LIS
CERAMICA | CERAMICA
MATERIALES | CHIMENEAS
ELECTRIC | CLIMATIZACIÓN | ADAME - SCC -  JORCASA ING |  |  | TALBON -  SIERRA SPLIT |  | CAPRA
MADERA | COCINAS BAJO PEDIDO | EDYAN LADY | HNOS BREA | HNOS BREA | HNOS BREA | HNOS BREA | HNOS BREA | HNOS BREA
MADERA | COCINAS EN STOCK | EDYAN LADY |  |  | ROALCAR | ISRAEL VAZQUEZ
DECOR | CONFECCIÓN | PAYRO  ALBERTO SERRANO
MADERA | [NAME] | COOP SAN PEDRO | COOP SAN PEDRO | COOP SAN PEDRO | COOP SAN PEDRO | COOP SAN PEDRO | COOP SAN PEDRO | COOP SAN PEDRO | COOP SAN PEDRO
MADERA | ESCALERAS
FERRETERIA | ESTANTERIAS
MADERA | ARMARIOS STOCK | ROALCAR | [NAME] LOPEZ |  | ROALCAR
MADERA | FRISO | ROALCAR | ROALCAR |  | ROALCAR
SANITARIO | HIDROMASAJE (CABINAS Y BAÑERAS) | JB | EUROSSER | EUROSSER | EUROSSER | EUROSSER | EUROSSER | EUROSSER | EUROSSER
SANITARIO | MAMPARAS Y BIOMBOS | INSTALBAÑO | VELAZQUEZ |  | ROJASAN | INSTALBAÑO
MOQUETA | MOQUETA Y VINILO |  |  | [NAME] | GALEANO
SANITARIO | MUEBLES DE BAÑO | INSTALBAÑO | VELAZQUEZ |  | ROJASAN | INSTALBAÑO
 | OTROS
DECOR | PAPEL PINTADO
JARDIN | PERGOLAS | D-LIS | D-LIS |  |  |  |  | D-LIS
PINTURA | PINTURA
ELECTRIC | PLACAS SOLARES
MATERIALES | PLADUR
MATERIALES | PLAQUETA DECORATIVA
ELECTRIC | PORTEROS Y VIDEOPORTEROS
MADERA | PUERTAS | ROALCAR | ROALCAR |  | ROALCAR
ELECTRIC | PUERTAS DE GARAJE
 | REFORMAS
JARDIN | RIEGO | D-LIS | D-LIS |  |  |  |  | D-LIS
SANITARIO | SANITARIO PESADO
MADERA | TARIMA | AGECAR | ROALCAR |  | ROALCAR - DAYMA
MADERA | [NAME]
FONTANERIA | TRATAMIENTO DEL AGUA
MADERA | VENTANAS | VELUX
Spreadsheet: 525826d1498938717-conditional-formatting-future-dates-on-cell-tobe-formatted-hr-template
Sheet: 4

 | Mandatory Training |  |  | Induction |  | Customer Complaints |  | Data Protection |  | Anti-Money Laundering |  | Bribery |  | Health & Safety
 | 4 | Director |  | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due
 |  |  |  | 2014-10-15 00:00:00 | 2015-04-15 00:00:00
 |  |  |  | 2015-10-15 00:00:00 | 2016-04-15 00:00:00
 |  |  |  | 2017-04-15 00:00:00 | 2017-01-01 00:00:00
Spreadsheet: 46da561c-e3a5-4124-888c-35881070339e
Sheet: Sheet1

Colorectal [NAME], by Year, Maine, 1999-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Year | Number of Deaths | Crude Rate |  | Age-adjusted Rate
 |  | Rate | 95% CI | Rate | 95% CI
1999 | 343 | 27.1 | 24.3 - 30.1 | 24.1 | 21.7 - 26.8
2000 | 335 | 26.2 | 23.5 - 29.2 | 23 | 20.6 - 25.6
2001 | 313 | 24.4 | 21.7 - 27.2 | 21.3 | 19.0 - 23.8
2002 | 326 | 25.2 | 22.5 - 28.1 | 21.8 | 19.5 - 24.3
2003 | 295 | 22.6 | 20.1 - 25.4 | 19.4 | 17.2 - 21.7
2004 | 279 | 21.3 | 18.9 - 24.0 | 18.1 | 16.0 - 20.3
2005 | 278 | 21.2 | 18.8 - 23.8 | 17.8 | 15.7 - 20.0
2006 | 275 | 20.9 | 18.5 - 23.5 | 17.1 | 15.2 - 19.3
2007 | 313 | 23.8 | 21.2 - 26.5 | 19 | 16.9 - 21.3
2008 | 270 | 20.5 | 18.1 - 23.1 | 16.3 | 14.4 - 18.4
US 2009 |  |  |  | 16.4 | 16.2 - 16.5
Data Source: Surveillance, Epidemiology, and End Results SEER Program, National Cancer Institute, Underlying mortality data provided by National Center for Health Statistics. [NAME]: Deaths with malignant cancer as the underlying cause of death. Colorectal Cancer: SEER Cause of Death Recode: 21040-21050 (which include 1999-2009: ICD-10 codes C18, C26.0,C19-C20; 1993-1998: ICD-9 codes 153, 159.0,154.0-154.1). Crude rates are deaths per 100,000 population. Age-adjusted rates are deaths per 100,000 population age-adjusted to the U.S. 2000 standard population. 95% CI: 95% confidence interval of the rate. Rates are calculated using SEER*Stat Version 7.0.5. NA = Not available
Spreadsheet: 79660d1279872906-how-to-sumproduct-with-non-repeated-serial-number-item-test
Sheet: Sheet1

Serial number | Item Type
1 | Apple
1 | Apple
1 | Apple
2 | Apple
2 | Apple
3 | Apple
4 | Apple
5 | Orange
6 | Orange
7 | Orange
Total Fruits Used: | 7
Total Apples Used: | ??
Total Orange Used: | ??
Spreadsheet: 170925d1343508955-complicated-split-number-then-produce-table-and-copy-the-data-in-a-certain-assortment-result
Sheet: RES

 | 8
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 880
 | 8810
 | 8811
 | 8812
 | 8813
 | 8814
 | 8816
 | 8817
 | 8818
 | 8819
 | 882
 | 883
 | 884
 | 885
 | 886
 | 887
 | 888
 | 889
 | 89
Spreadsheet: 799714d1665228925-case-sensitive-with-match-while-using-arrays-excel_help-hd
Sheet: control-1array

UNMATCH: |  | (case-unsensitive) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1)
 |  | (case-sensitive) |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0))))
grade |  |  |  | grade
A |  |  |  | A
A |  |  |  | B
B |  |  |  | b
C |  |  |  | C
D
a
F
A
A
B
B
D
A
B
Spreadsheet: 111132d1307598005-returning-a-lookup-value-based-on-multiple-criteria-sample
Sheet: RETURNQUERY

RMA No | Center No | Center Name | Model No | Model Desc | Lot/Serial No | Receipt Date | SHIP DATE
x | x | x | CI-5230-100 | silver | 1230 | 2006-01-31 00:00:00 | 2005-09-23 00:00:00 | NEED TO SELECT 1/12/06, CLOSEST SHIP DATE TO RECEIPT DATE
x | x | x | CI-5235-100 | [NAME] | 10020 | 2006-12-31 00:00:00 | 2006-12-07 00:00:00 | NEED TO SELECT 12/8/06, CLOSEST SHIP DATE TO RECEIPT DATE
x | x | x | CI-5235-100 | [NAME] | 10024 | 2011-01-10 00:00:00
x | x | x | CI-5235-100 | [NAME] | 10025 | 2011-01-10 00:00:00
x | x | x | CI-5235-300 | gold | 66737 | 2011-05-02 00:00:00
Criteria | For Dates: 01-01-2011 to 06-02-2011
Spreadsheet: 763584d1642258764-look-for-last-instance-of-a-phrase-and-return-column-header-dashboard-setup
Sheet: Dashboard

Feature | Site1 | Site2 | Site3 | [NAME] | Site5 | Site6 | Site7 | Site8 | Site9
GLOBAL RELEASE
Environment Setup |  | 4-QA | 3-Development
Set up AWS Integration Infrastructure |  | 4-QA | 2-TSD
DAX Integration |  | 3-Development | 3-Development
B2C Customer Group |  |  | 3-Development
B2B Customer Group |  | 5-UAT | 4-QA
Initial Data Loads |  | 2-TSD | 1-BRD
Global Elements
Home Page
Global Cart
SHOPPING RELEASE
Product [NAME]
Product Listing Page & Search Results
Category Gateway Page
Login/Registration
Facets
Site Search
Inventory messaging
Product Kits (BOM)
Serialized Products & Core Charges
Product groups (Collections)
Product image zoom
Video in alt images
PowerReviews (Q&A / Customer reviews)
Pricing
Recently Viewed Products
Backorder Messaging
Kibo Personalization
Product Comparison NEW
CHECKOUT RELEASE
Cart
Checkout
Shipping Calculation
PayPal
Authorize.net
Avalara Tax / Tax Exempt / Address validation
Transactional emails
Coupons
Guest Checkout
Kount
Shipping Restrictions to HI and AK NEW
MY ACCOUNT RELEASE
Customer Service
GDPR + CCPA Compliance
My Account: Settings
My Account: Order History
Address book
My Account: Order Details
My Account: Order History shipping tracking
My Account: Favorite Parts (Wishlist) Management
My Account: Payment Methods
My Account: Returns
Google Analytics & GTM
DataLayer Support
Static Content Pages
301 Redirects
Google Shopping
Formstack
[NAME]
Klaviyo
My Account: Re-order
Blog
Test
Spreadsheet: 838233d1690833434-email-assigned-seating-from-excel-final_2023-copy-good-copy
Sheet: Seating Chart

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 1 | Table 2 | Table 3 | Table 4 | Table 5 | Table 6 | Table 7 | Table 8 | Table 9 | Table 10 | Table 11 | Table 12 | Table 13 | Table 14 | Table 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 16 | Table 17 | Table 18 | Table 19 | Table 20 | Table 21 | Table 22 | Table 23 | Table 24 | Table 25 | Table 26 | Table 27 | Table 28 | Table 29 | Table 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 31 | Table 32 | Table 33 | Table 34 | Table 35 | Table 36 | Table 37 | Table 38 | Table 39 | Table 40 | Table 41 | Table 42 | Table 43 | Table 44 | Table 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chart
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1