tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677526d1589384795-printing-the-result-with-min-vlookup-to-down-cells-earliest-deadline
Sheet: items

İtem  No. | item description | earliest deadline | BOM
1010332401002 | product 1 | 2020-05-15 00:00:00 | bom 1
 |  | 2020-05-15 00:00:00 | bom 2
 |  | 2020-05-15 00:00:00 | bom 3
 |  | 2020-05-15 00:00:00 | bom 4
 |  | 2020-05-15 00:00:00 | bom 5
 |  | 2020-05-15 00:00:00 | bom 6
 |  | 2020-05-15 00:00:00 | bom 7
 |  | 2020-05-15 00:00:00 | bom 8
 |  | 2020-05-15 00:00:00 | bom 9
 |  | 2020-05-15 00:00:00 | bom 10
 |  | 2020-05-15 00:00:00 | bom 11
 |  | 2020-05-15 00:00:00 | bom 12
 |  | 2020-05-15 00:00:00 | bom 13
 |  | 2020-05-15 00:00:00 | bom 14
1110601801002 | product 4 |  | BOM 9
 |  |  | BOM 10
 |  |  | BOM 11
 |  |  | BOM 12
 |  |  | BOM 13
 |  |  | BOM 14
 |  |  | BOM 15
 |  |  | BOM 16
 |  |  | BOM 17
 |  |  | BOM 18
 |  |  | BOM 19
 |  |  | BOM 20
 |  |  | BOM 21
1120640501001 | product 2 |  | BOM 90
 |  |  | BOM 12
 |  |  | BOM 13
 |  |  | BOM 14
 |  |  | BOM 15
 |  |  | BOM 16
 |  |  | BOM 17
 |  |  | BOM 18
 |  |  | BOM 19
 |  |  | BOM 20
 |  |  | BOM 21
 |  |  | BOM 22
1120619201034 | product 6 |  | [NAME]
 |  |  | BOM4
 |  |  | BOM5
 |  |  | BOM6
 |  |  | BOM7
 |  |  | [NAME]
 |  |  | BOM9
 |  |  | BOM10
 |  |  | BOM11
1020345201002 | product 3 |  | BOM12
 |  |  | BOM13
 |  |  | BOM14
1010320001002 | product 5 |  | BOM15
 |  |  | BOM16
 |  |  | BOM17
 |  |  | BOM18
 |  |  | BOM19
 |  |  | BOM20
 |  |  | BOM21
 |  |  | [NAME]
 |  |  | BOM23
 |  |  | BOM24
 |  |  | BOM25
 |  |  | BOM26
 |  |  | BOM27
 |  |  | BOM28
 |  |  | BOM29
 |  |  | BOM30
 |  |  | BOM31
 |  |  | BOM32
 |  |  | BOM33
 |  |  | BOM34
 |  |  | BOM35
 |  |  | BOM36
 |  |  | BOM37
 |  |  | BOM38
 |  |  | BOM39
 |  |  | BOM40
 |  |  | [NAME]
 |  |  | BOM42
 |  |  | BOM43
 |  |  | BOM44
 |  |  | BOM45
 |  |  | BOM46
 |  |  | BOM47
 |  |  | BOM48
 |  |  | BOM49
 |  |  | BOM50
Spreadsheet: andy_zipper__660__Broker & Exchange Detail 11-26-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 11/26/2001
Completed Transactions:
TODAY
Date | 2001-11-26 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
Grand Total
No Activity
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 91
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 131
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 13
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 326
Grand Total |  |  | 326
Spreadsheet: 746986d1631168739-accumulation-of-the-same-type-of-data-9-9
Sheet: Sheet1

Data
1 | 1
2 | 3
3 | 6
1A | 1A
4 | 10
5 | 15
2A | 3A
1B | 1B
6 | 21
7 | 28
8 | 36
3B | 4B
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: King

King of Queens
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | Cajun Coonasses
2 | Capo Crimini
3 | Thundermutts
4 | Pics Hitmen
5 | Deadbirds
6 | Wet Farts
7 | Mudcats
8 | [NAME]
9 | Muckdogs
10 | Gator Dawgs
11 | Sharks
12 | Mudcats
13 | Wet Farts
14 | Sharks
15 | Gator Dawgs
16 | Deadbirds
17 | Pics Hitmen
18 | Muckdogs
19 | [NAME]
20 | Thundermutts
21 | Capo Crimini
22 | Cajun Coonasses
Spreadsheet: 670232d1585793964-subtotal-question-stock-spreadsheet-stock-group-subtotals
Sheet: Sheet2

Name/Ticker | Shares Purchased | Purchase Price | Total Cost | Current Price | Shares to sell | Total Profit/Loss
#[NAME]! | 55.5 | 54.49 |  | 62.75 | 55.5
#[NAME]! | 130 | 61.76 |  | 62.75 | 130
#[NAME]! | 5 | 126.5 |  | 137 | 5
#[NAME]! | 10 | 73.5 |  | 91.37 | 10
#[NAME]! | 12 | 85 |  | 91.37 | 12
#[NAME]! | 19 | 25.86 |  | 7.45 | 19
#[NAME]! | 11 | 25.02 |  | 7.45 | 11
 |  |  |  |  |  |  | On the Data Tab I used Subtotals to get the below
Name/Ticker | Shares Purchased | Purchase Price | Total Cost | Current Price | Shares to sell | Total Profit/Loss
#[NAME]! | 55.5 | 54.49 | 3024.195 | 62.75 | 55.5 | 3482.625
#[NAME]! | 130 | 61.76 | 8028.8 | 62.75 | 130 | 8157.5
Vanguard Total Stock Market Index Fund;Admiral Total
#[NAME]! | 5 | 126.5 | 632.5 | 137 | 5 | 685
Zoom Video Communications Inc (XNAS:ZM) Total
#[NAME]! | 10 | 73.5 | 735 | 91.37 | 10 | 913.7
#[NAME]! | 12 | 85 | 1020 | 91.37 | 12 | 1096.44
United Technologies Corp (XNYS:UTX) Total
#[NAME]! | 19 | 25.86 | 491.34 | 7.45 | 19 | 141.55
#[NAME]! | 11 | 25.02 | 275.22 | 7.45 | 11 | 81.95
Under [NAME] (XNYS:UA) Total
Grand Total
Spreadsheet: 808260d1670372553-product-of-two-columns-if-column-a-is-entry-is-text-get-value-from-another-column-excelforum-short-solution
Sheet: Sheet1

 |  | any number | get this if column B is text |  |  |  |  | product
abc |  | 2 | 3 |  |  |  |  |  |  | <- problem if column is text , get value from column D
2 |  | 3
3 |  | 4
4 |  | 5
2 |  | 6
3 |  | 7
4 |  | 8 |  |  | column B x column E
 |  |  |  |  |  |  |  |  | expected output
 |  |  |  |  | single shot fromula
Spreadsheet: 2e55f3a1-9581-4153-9a4c-d50fb7f6bc63
Sheet: Sheet1

Hawaii Department of Health | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Covered Television (CTV) Manufacturer Reporting Form for 2011
Manufacturer: |  | Contact Name: |  | Title:
 |  | [NAME]: |  | Phone Number:
CTVs collected and recycled from Hawaii in 2011:
Section 1: Complete for brands registered under this manufacturer
Brand | TV Type - if known (CRT/Flat panel) | Pounds collected & recycled by Island:
 |  | [NAME] | Maui  (including Molokai & Lanai) | Oahu | Hawaii | Total Pounds
Section 2: Complete for brands not registered under this manufacturer
Brand | TV Type  - if known (CRT/Flat panel) | Pounds collected & recycled by Island:
 |  | [NAME] | Maui  (including Molokai & Lanai) | Oahu | Hawaii | Total Pounds
Section 3: Breakdown of pounds collected |  |  | Section 4: Certification.  I certify that the information submitted is, to the best of my knowledge and belief, true, accurate, and complete:
Collection Method | [NAME]
Mail-back
Collection Location(s)
Collection Event(s) |  |  | Signature |  | Date
Other (list): |  |  | Print Name & Title:
Completed forms are due by 1/31/2012 to the Hawaii Department of Health.   Forms may be emailed to [NAME]: [EMAIL] or mailed to: 919 Ala [NAME], Rm. 212; Honolulu, HI 96814
Spreadsheet: 48687f4d-4269-4edb-baea-014f6c2b03cf
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42337316 | 2014-07-17 12:25:08 | ALLIES | 0 | 4 | 5 | 436881 | hoppity | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42337456 | 2014-07-17 12:46:11 | AXIS | 1 | 5 | 2 | 436881 | hoppity | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42343887 | 2014-07-17 23:15:34 | AXIS | 0 | 3 | 5 | 335648 | Buidheo | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42344127 | 2014-07-17 23:25:38 | ALLIES | 0 | 2 | 5 | 335648 | Buidheo | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42344362 | 2014-07-17 23:46:04 | AXIS | 1 | 5 | 1 | 1599761 | Spud Gun | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42344505 | 2014-07-18 00:05:34 | ALLIES | 1 | 5 | 3 | 1599761 | Spud Gun | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42345763 | 2014-07-18 02:33:28 | AXIS | 1 | 6 | 3 | 1605687 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42350767 | 2014-07-18 14:25:50 | AXIS | 0 | 3 | 5 | 749869 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42350950 | 2014-07-18 14:50:57 | ALLIES | 1 | 5 | 3 | 749869 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42358210 | 2014-07-19 02:09:14 | ALLIES | 0 | 5 | 6 | 188507 | WiredNun | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42358428 | 2014-07-19 02:31:12 | AXIS | 1 | 6 | 3 | 188507 | WiredNun | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42453114 | 2014-07-25 23:29:33 | ALLIES | 1 | 4 | 1 | 445449 | SHUGARTH | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42453238 | 2014-07-25 23:56:53 | AXIS | 0 | 3 | 4 | 445449 | SHUGARTH | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
Spreadsheet: 232155d1367342915-sumif-help-0fotgrsp
Sheet: Sheet2

Names | jan | feb | [NAME] | apr
a
Spreadsheet: 32b45948-9589-40c6-8b4e-340a09061078
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
EOXD | Test | EOXD | Ethylene Oxide, IgE | Ethylene Oxide, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EOXD | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EOXD | Result | EOXD | Ethylene Oxide, IgE | Ethylene Oxide, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6112-7 | Ethylene oxide [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: louise_kitchen__24125__Netco_Status
Sheet: Sheet1

Status as of 6:00 pm Wednesday, January 2, 2002
Group |  | Who contacted |  | Status
Fin Ops |  | [NAME], [NAME] |  | Updated
Cash Operations |  | [NAME] |  | Waiting on # for Bank Fees & Related Charges
 |  |  |  | Open question re: Treasury Workstation
 |  |  |  | Will have revisions tomorrow afternoon.
Tax |  | [NAME] |  | Updated
Regulatory Affairs |  | [NAME] |  | Waiting on some open items.  Spoke to him a 6:00 pm.
 |  |  |  | Changes will be submitted first thing in the morning.
Credit |  | [NAME] |  | Significant Changes
 |  |  |  | Says he will have to me by tomorrow (Thurs.)
Research/Market Risk |  | [NAME] ([NAME]) |  | No changes per [NAME]. [NAME] out until Friday, but [NAME] was going to speak to him.
Energy Ops |  | [NAME] |  | Sent e:mail, left voice mail, no response today.
HR |  | [NAME] |  | Sent e:mail, left voice mail, left message with admin
 |  |  |  | In meeting all day, no reponse today.
IT - Infrastructure |  | [NAME] |  | Working on Plan, won't have today.
IT - Development/EOL |  | [NAME] ([NAME]) |  | Working on Plan, won't have until late today per [NAME].
Canada Support |  | [NAME] |  | Sent e:mail, contacted admin.
 |  |  |  | Out of office, but admin faxed e:mail to him.
Legal |  | [NAME] ([NAME]) |  | Updated
CABC |  | [NAME] |  | Sent e:mail, left voice mail, no response today.
Weather |  | [NAME] |  | Updated
Canada Commercial |  | [NAME] |  | Sent e:mail, contacted admin.
 |  |  |  | Out of office, but admin faxed e:mail to him.
East Power Trading |  | [NAME] |  | Updated
East Power Origination |  | [NAME] |  | Updated
Fundies |  | [NAME] |  | Waiting on response from West Fundies
 |  |  |  | They are in meetings all afternoon.
Structuring |  | [NAME] |  | Waiting on response from West Fundies
 |  |  |  | They are in meetings all afternoon.
Texas Gas Trading |  | [NAME] |  | Updated
East Gas Trading |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
Central Gas Trading |  | [NAME] |  | Updated
West Gas Trading |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
Financial Gas Trading |  | [NAME] |  | Updated
Texas Gas Origination |  | [NAME] |  | Updated
East Gas Origination |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
Central Gas Origination |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
 |  |  |  | [NAME] is out of the office
West Gas Origination |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
Derivatives |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
Mexico |  | [NAME] |  | Waiting for final approval;  by noon tomorrow
West Power Trading |  | [NAME] |  | Waiting for approval.  In meetings all afternoon
West Power Orig |  | [NAME] |  | Waiting for approval.  In meetings all afternoon
Spreadsheet: 866033d1712958421-assign-serial-numbers-to-each-product-code-assigning-serial-number-to-each-product-code
Sheet: Sheet1

ProdCode | Specification | Printing Category | Serial Number - manually THIS SHOULD BE THE RESULT FROM THE FORMULA | Serial Number - Automatik
Prod A | Spec.1 | A5 | 1
Prod A | Spec.2 | A5 | 1
Prod A | Spec.3 | A5 | 1
Prod B | Spec.1 | A5 | 2
Prod B | Spec.2 | A5 | 2
Prod B | Spec.3 | A5 | 2
Prod B | Spec.4 | A5 | 2
Prod C | Spec.1 | A6 | 1
Prod C | Spec.2 | A6 | 1
Prod C | Spec.3 | A6 | 1
Prod C | Spec.4 | A6 | 1
Prod C | Spec.5 | A6 | 1
Prod C | Spec.6 | A6 | 1
Prod D | Spec.1 | A6 | 2
Prod D | Spec.2 | A6 | 2
Prod D | Spec.3 | A6 | 2
Prod D | Spec.4 | A6 | 2
Prod D | Spec.5 | A6 | 2
Prod D | Spec.6 | A6 | 2
Prod E | Spec.1 | A5 | 3
Prod E | Spec.2 | A5 | 3
Prod E | Spec.3 | A5 | 3
Prod E | Spec.4 | A5 | 3
Prod E | Spec.5 | A5 | 3
Prod E | Spec.6 | A5 | 3
[NAME] | Spec.1 | A7 | 1
[NAME] | Spec.2 | A7 | 1
[NAME] | Spec.3 | A7 | 1
[NAME] | Spec.4 | A7 | 1
[NAME] | Spec.5 | A7 | 1
[NAME] | Spec.6 | A7 | 1
[NAME] | Spec.1 | A7 | 2
[NAME] | Spec.2 | A7 | 2
[NAME] | Spec.3 | A7 | 2
[NAME] | Spec.4 | A7 | 2
[NAME] | Spec.5 | A7 | 2
[NAME] | Spec.6 | A7 | 2
Prod H | Spec.1 | A7 | 3
Prod H | Spec.2 | A7 | 3
Prod H | Spec.3 | A7 | 3
Prod H | Spec.4 | A7 | 3
Prod H | Spec.5 | A7 | 3
Prod H | Spec.6 | A7 | 3
Prod I | Spec.1 | A7 | 4
Prod I | Spec.2 | A7 | 4
Prod I | Spec.3 | A7 | 4
Prod I | Spec.4 | A7 | 4
Prod I | Spec.5 | A7 | 4
Prod I | Spec.6 | A7 | 4
Prod J | Spec.1 | A5 | 4
Prod J | Spec.2 | A5 | 4
Prod J | Spec.3 | A5 | 4
Prod J | Spec.4 | A5 | 4
Prod J | Spec.5 | A5 | 4
Prod J | Spec.6 | A5 | 4
Spreadsheet: 751387d1634069649-delayed-holidays-in-calendar-sample
Sheet: Data

January | 2021 |  | New Year's Day / Nouvel an | 2021-01-01 00:00:00
February | 2022 |  | Good Friday / Vendredi saint
March | 2023 |  | Easter Monday / Lundi de pâques
April | 2024 |  | [NAME] | 2021-05-24 00:00:00
May | 2025 |  | Canada Day / Fête de Canada | 2021-07-01 00:00:00
June | 2026 |  | Labour Day / Fête du travail | 2021-09-06 00:00:00
July | 2027 |  | Thanksgiving / Action de grâce | 2021-10-11 00:00:00
August | 2028 |  | Christmas Day / Noël | 2021-12-25 00:00:00
September | 2029 |  | Boxing Day / Lendemain de Noël | 2021-12-26 00:00:00
October | 2030
November | 2031
December | 2032
 | 2033
 | 2034
 | 2035
 | 2036
 | 2037
 | 2038
 | 2039
 | 2040
 | 2041
 | 2042
 | 2043
 | 2044
 | 2045
 | 2046
 | 2047
 | 2048
 | 2049
 | 2050
 | 2051
 | 2052
 | 2053
 | 2054
 | 2055
 | 2056
 | 2057
 | 2058
 | 2059
 | 2060
 | 2061
 | 2062
 | 2063
 | 2064
 | 2065
 | 2066
 | 2067
 | 2068
 | 2069
 | 2070
 | 2071
 | 2072
 | 2073
 | 2074
 | 2075
 | 2076
 | 2077
 | 2078
 | 2079
 | 2080
 | 2081
 | 2082
 | 2083
 | 2084
 | 2085
 | 2086
 | 2087
 | 2088
 | 2089
 | 2090
 | 2091
 | 2092
 | 2093
 | 2094
 | 2095
 | 2096
 | 2097
 | 2098
 | 2099
 | 2100
 | 2101
 | 2102
 | 2103
 | 2104
 | 2105
 | 2106
 | 2107
 | 2108
 | 2109
 | 2110
 | 2111
 | 2112
 | 2113
 | 2114
 | 2115
 | 2116
 | 2117
 | 2118
 | 2119
 | 2120
 | 2121
 | 2122
 | 2123
 | 2124
 | 2125
 | 2126
 | 2127
 | 2128
 | 2129
 | 2130
 | 2131
 | 2132
 | 2133
 | 2134
 | 2135
 | 2136
 | 2137
 | 2138
 | 2139
 | 2140
 | 2141
 | 2142
 | 2143
 | 2144
 | 2145
 | 2146
 | 2147
 | 2148
 | 2149
 | 2150
 | 2151
 | 2152
 | 2153
 | 2154
 | 2155
 | 2156
 | 2157
 | 2158
 | 2159
 | 2160
 | 2161
 | 2162
 | 2163
 | 2164
 | 2165
 | 2166
 | 2167
 | 2168
 | 2169
 | 2170
 | 2171
 | 2172
 | 2173
 | 2174
 | 2175
 | 2176
 | 2177
 | 2178
 | 2179
 | 2180
 | 2181
 | 2182
 | 2183
 | 2184
 | 2185
 | 2186
 | 2187
 | 2188
 | 2189
 | 2190
 | 2191
 | 2192
 | 2193
 | 2194
 | 2195
 | 2196
 | 2197
 | 2198
 | 2199
 | 2200
Spreadsheet: 34ccb36a-a4e3-4c1a-846d-2fc637c18db6
Sheet: Sheet1

[NAME] der Bevölkerungsentwicklung 2011, 2015, 2020 und 2025 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
[NAME] I/Dresden II - Bautzen II
Jahr | Durchschnittsalter der [NAME] in Jahren |  | Männer je 100 Frauen |  | [NAME]
 | insgesamt | im [NAME](20 bis unter 65 Jahre) | insgesamt | im [NAME]bis unter 30 Jahren
2011 | 43.33096293933479 | 40.66376034881365 | 97.15362820122837 | 106.1459716369374 | 1156.78099684831
[NAME]
2015 | 43.9314240951244 | 41.83843219250944 | 97.36094139251017 | 101.8213716844803 | 1172.479133315271
2020 | 44.38892963171661 | 42.48845262937332 | 97.62161982482091 | 98.93593681439228 | 1192.230148397424
2025 | 44.92888466353782 | 42.94490640256498 | 97.67273352898165 | 98.75057138503733 | 1198.119957646717
[NAME]
2015 | 44.25867151334173 | 42.07142277130097 | 97.37527928970044 | 103.7272103509116 | 1149.714027902274
2020 | 45.01226750742824 | 42.78711292505524 | 97.76347679581282 | 103.4252445547773 | 1148.711336508115
2025 | 45.87597880753479 | 43.23137563254185 | 98.1672080937212 | 104.3024625567959 | 1134.011880669737
Vergleichszahlen des Freistaates Sachsen
2011 | 46.36510584471886 | 43.48353887047681 | 96.1594101539811 | 110.169542239693 | 224.5992682073618
[NAME]
2015 | 47.47405559302833 | 44.7541860028457 | 96.60268151512932 | 108.5219656957959 | 218.5239247542564
2020 | 48.44299231814101 | 45.20016192420698 | 97.15852782085713 | 105.5733671975991 | 212.2298480895935
2025 | 49.33827922671833 | 45.3116111527177 | 97.64878423460567 | 105.2602865746362 | 205.0799485539964
[NAME]
2015 | 47.70671138647563 | 44.90992032354383 | 96.45977664738218 | 110.3636319054508 | 216.1966337855173
2020 | 48.92637892823755 | 45.43037531413505 | 96.97644004003324 | 109.7167821633022 | 207.6078942633453
2025 | 50.1172324548799 | 45.58901535632479 | 97.6318078479085 | 110.3448880985528 | 197.9789097506907
Gebietsstand: |  | 1. Januar 2012
Quelle: |  | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 |  | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 47867d1247037815-cant-delete-a-table-without-deleting-the-data-demo
Sheet: Sheet2

 |  | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun | Total
 | Red | 3 | 4 | 8 | 2 | 3 | 4 | 6
 | Green | 12 | 5 | 6 | 8 | 34 | 5 | 6
 | Blue | 13 |  | 45 | 7 | 24 | 0 | 0
 | Yellow | 23 | 34 | 67 | 86 | 6 | 9 | 56
 | [NAME] | 32 | 11 | 89 | 45 | 78 | 2 | 78
 | Purple | 12 | 38 | 92 | 23 | 3 | 45 | 89
Spreadsheet: 73737d1274335115-how-to-highligh-some-required-values-in-excel-award-sheet-2006
Sheet: Sheet1

 | 0620 |  | Highlight Values
 | 0640 |  | 0642
 | 0641 |  | 0649
 | 0642 |  | 0652 |  |  |  |  |  | in column B, I want that some valuse for example 0642, 0649, 0654 could be highlight if these valuse are present in this column… please provide me formula for it….. Thanks
 | 0643
 | 0644
 | 0645
 | 0646
 | 0647
 | 0648
 | 0649
 | 0650
 | 0651
 | 0652
 | 0653
Spreadsheet: 762365d1641513102-two-dimensional-sumifs-in-one-spilled-formula-sample-2d-sumifs-amended
Sheet: Sheet1

 |  |  |  |  |  |  |  | Not working if I passed an Array as the number of [NAME] ({1,2})
Customer | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 |  | Customer | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00
A | 967 | 680 | 602 | 601 | 193 | 472 |  | A |  | 680 | 602 | 601 | 193 | 472
 | 136 | 362 | 688 | 998 | 329 | 25 |  | B | 136 | 362 | 688 | 998 | 329 | 25
B | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 |  | C | 851 | 64 | 113 | 364 | 153 | 634
 | 851 | 64 | 113 | 364 | 153 | 634 |  | D | 305 | 458 | 185 | 435 | 889 | 935
 | 305 | 458 | 185 | 435 | 889 | 935 |  | E | 947 | 94 | 96 | 31 | 469 | 355
 | 947 | 94 | 96 | 31 | 469 | 355 |  | F | 561 | 706 | 247 | 890 | 563 | 36
 | 561 | 706 | 247 | 890 | 563 | 36 |  | G | 250 | 799 | 335 | 277 | 243 | 509
 | 250 | 799 | 335 | 277 | 243 | 509
 |  |  |  |  |  |  |  | Working if in I inputed the Column in Jan as 1, and in Feb as 2
 |  |  |  |  |  |  |  | Customer | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  | B | 10136 | 10362
 |  |  |  |  |  |  |  | C | 851 | 64
 |  |  |  |  |  |  |  | D | 305 | 458
 |  |  |  |  |  |  |  | E | 947 | 94
 |  |  |  |  |  |  |  | F | 561 | 706
 |  |  |  |  |  |  |  | G | 250 | 799