tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 121268d1315959439-using-match-or-lookup-to-narrow-down-a-mailing-list-match-problem-set
Sheet: Sheet 1

OWNER1 | OWNER2 | OWNER3 | OWNERADD | ownercity | OWNERSTAT | OwnerZip | SITEADDR | SiteCity
DURSLEY, DUDLEY | 100 NE PENSIEVE RD |  |  | MOSSY LAWN | OR | 97124 | 100 NE PENSIEVE RD | [NAME]
RIDDLE JR, TOM | 666 S INFERI LN |  |  | MOSSY LAWN | OR | 97123 | 102 NE PENSIEVE RD | [NAME]
DUMBLEDORE, A & | MCGONAGALL, M | 108 NE PENSIEVE RD |  | MOSSY LAWN | OR | 97124 | 108 NE PENSIEVE RD | [NAME]
LUPIN, R & | BLACK, S | 786 NE 1st Ave |  | MOSSY LAWN | OR | 97124 | 786 NE 1st Ave | [NAME]
LONGBOTTOM, NEVILLE | 2100 NE HOGWARTS AVE |  |  | MOSSY LAWN | OR | 97124 | 2100 NE HOGWARTS LN | [NAME]
HAGRID, R | 45 W HOGSHEAD CT |  |  | MOSSY LAWN | OR | 97124 | 99 NE POTTER LN | [NAME]
DELACOUER FLEUR & | [NAME], CEDRIC | 22 BEAUXBATONS BLVD |  | MOSSY LAWN | OR | 97124 | 22 BEAUXBATONS BLVD | [NAME]
WEASLEY, FRED & | WEASLEY, GEORGE & | FRIENDS | 9 DIAGON ALLEY | MOSSY LAWN | OR | 97124 | 9 DIAGON ALLEY | [NAME]
MINISTRY OF MAGIC, THE | ATTN: MUGGLE ARTIFACTS | ARTHUR WEASLEY | PO BOX 9 3/4 | ROSE ARBOR | OR | 97218 | 10 KINGS CROSS | [NAME]
GRANGER, H | 2200 NE HOGWARTS AVE |  |  | MOSSY LAWN | OR | 97124 | 2200 NE HOGWARTS LN | [NAME]
LOVEGOOD, L | 2150 SE HOGWARTS AVE |  |  | MOSSY LAWN | OR | 97124 | 2150 SE HOGWARTS AVE | [NAME]
TRELAWNEY, S | & FIRENZE, C | 1900 S DIVINE DR |  | MOSSY LAWN | OR | 97123 | 1900 S DIVINE DR | [NAME]
FLITWICK, F | 1970 N CHARMED CT |  |  | MOSSY LAWN | OR | 97124 | 1970 N CHARMED CT | [NAME]
SPROUT, C | 2020 S GREEN GARDEN ST |  |  | MOSSY LAWN | OR | 97124 | 2020 S GREEN GARDEN ST | [NAME]
POTTER, H & | LESTRANGE, B | TRUSTEES | PO BOX 12 | MOSSY LAWN | OR | 97123 | 12 GRIMMAULD PL | [NAME]
1. I have a mailing list from property tax assessor records of about 20,000 with data on owner address and site address.
Details: | I want to narrow it to owner-occupied homes. There are many renter occupied homes and other types of absentee owner situations.
 | This means, I need the list to just show records where the owner and site addresses match. This should be easy enough, but …
 | The list has owner name and owner address info spread across multiple columns!
 | Only Column A (OWNER1) and Column D (OWNERADD) are discrete and explicit with just names in the former and just addresses in the latter
 | Columns B (OWNER2) and C (OWNER3) mix names and addresses often
2. I think my problem statement is this:
How to eliminate the rows where there are NO matches in values between Column H and Columns B, C or D?
How would I do it? I have experience running formulas but none in writing macros. I've never used VLOOKUP or MATCH.
Note: In this test dummy set of made-up data, 11 owner-occupied records would be preserved, and 4 absentee owners would be eliminated. Blown away by a curse, as it were.
Spreadsheet: 789a16df-b05c-4056-b9d5-81645d2c2445
Sheet: 1.5 Youth unemployment

1.5 Youth unemployment
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014–15
Young unemployed (a) (b) – '000
July | 241.8512901 | 231.8973622 | 244.0704121 | 252.9916306 | 280.7705678
August | 241.5673686 | 233.1483316 | 244.7335953 | 257.1863538 | 283.13282
September | 241.7041406 | 234.6326742 | 245.4123577 | 259.9720141 | 284.9973426
October | 242.1012745 | 236.409785 | 246.3291024 | 260.4285046 | 286.1390272
November | 242.0751463 | 237.7348104 | 247.6672364 | 258.7354297
December | 241.4007802 | 238.4323126 | 249.0848243 | 256.5731628
January | 240.1927647 | 238.6886537 | 249.3038529 | 255.735195
February | 238.3026945 | 239.2302491 | 248.2782716 | 257.4416838
March | 235.9936352 | 240.0653858 | 246.6604562 | 261.8127499
April | 234.0443292 | 240.9860283 | 245.6791587 | 267.5185931
May | 232.6719915 | 242.0830993 | 246.2423422 | 273.1460433
June | 231.7226042 | 243.2381423 | 248.8479608 | 277.562801
Annual average | 238.6356683 | 238.0455695416667 | 246.8591308833333 | 261.592013475
Unemployment rate (b) – per cent
July | 11.6380044 | 11.1570257 | 11.7817892 | 12.2063191 | 13.5419023
August | 11.6373083 | 11.2013529 | 11.8299313 | 12.4168444 | 13.6494863
September | 11.6424523 | 11.2731271 | 11.8633395 | 12.570411 | 13.7372311
October | 11.6457097 | 11.3768912 | 11.8940786 | 12.6128711 | 13.7916512
November | 11.6228833 | 11.471105 | 11.9373004 | 12.5462884
December | 11.572287 | 11.5324068 | 11.9875806 | 12.4507621
January | 11.5064934 | 11.5538336 | 11.9981447 | 12.4120994
February | 11.4261579 | 11.5633224 | 11.9609148 | 12.4876092
March | 11.3424872 | 11.5750406 | 11.8969911 | 12.6855897
April | 11.2757502 | 11.597202 | 11.8581225 | 12.9433844
May | 11.2221605 | 11.6469569 | 11.8880877 | 13.1979923
June | 11.1685949 | 11.7176766 | 12.0091756 | 13.3977125
Annual average | 11.47502409166667 | 11.47216173333334 | 11.908788 | 12.66065696666667
(a) People classified as unemployed and aged 15 to 24 years. |  |  |  |  |  |  |  | Update
(b) Monthly figures are trend. Annual figures are from the original series. |  |  |  |  |  |  |  | 2014-12-11 00:00:00
Source: ABS, Labour force, Cat. no. 6202.0
Spreadsheet: 857278d1706288156-conditional-formatting-excel-help-conditional-formatting-template-etaf
Sheet: Sheet1

 | 90
Follow Up | State | Client Name | CAR
 | WY | [NAME], [NAME] | 2023-06-21 00:00:00
 | WY | Jordan, [NAME] | 2023-11-12 00:00:00
 | WY | [NAME], [NAME] | 2023-09-12 00:00:00
 | WY | [NAME], [NAME]
 | WY | Doe, [NAME] | 2024-01-10 00:00:00
 | WY | [NAME], [NAME]
 | WY | Gump, Forest | 2023-07-26 00:00:00
Spreadsheet: 753590d1635540257-convert-alphanumeric-string-to-numbers-convert-letters-to-numeric-code-tms
Sheet: Sheet1

0KCB |  |  | A - 0 | A | 0 |  | =IFERROR(VLOOKUP(MID($A2,1,1),$E:$F,2,FALSE),MID($A2,1,1))&IFERROR(VLOOKUP(MID($A2,2,1),$E:$F,2,FALSE),MID($A2,2,1))&IFERROR(VLOOKUP(MID($A2,3,1),$E:$F,2,FALSE),MID($A2,3,1))&IFERROR(VLOOKUP(MID($A2,4,1),$E:$F,2,FALSE),MID($A2,4,1))
[NAME] |  |  | B - 1 | B | 1
LB8A |  |  | C - 2 | C | 2
9BGA |  |  | D - 3 | D | 3
D9EA |  |  | E - 4 | E | 4
 |  |  | F - 5 | F | 5
 |  |  | G - 6 | G | 6
 |  |  | H - 7 | H | 7
 |  |  | I - 8 | I | 8
 |  |  | J - 9 | J | 9
 |  |  | K - 10 | K | 10
 |  |  | L - 11 | L | 11
 |  |  | M - 12 | M | 12
 |  |  | N - 13 | N | 13
 |  |  | O - 14 | O | 14
 |  |  | P - 15 | P | 15
 |  |  | Q - 16 | Q | 16
 |  |  | R - 17 | R | 17
 |  |  | S - 18 | S | 18
 |  |  | T - 19 | T | 19
 |  |  | U - 20 | U | 20
 |  |  | V - 21 | V | 21
 |  |  | W - 22 | W | 22
 |  |  | X - 23 | X | 23
 |  |  | Y - 24 | Y | 24
 |  |  | Z - 25 | Z | 25
 |  |  |  | 0 | 0
 |  |  |  | 1 | 1
 |  |  |  | 2 | 2
 |  |  |  | 3 | 3
 |  |  |  | 4 | 4
 |  |  |  | 5 | 5
 |  |  |  | 6 | 6
 |  |  |  | 7 | 7
 |  |  |  | 8 | 8
 |  |  |  | 9 | 9
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: ALA Guide to Reference

ALA Guide to Reference
2009-2010
COUNTER-Compliant?: | No
 | Jul-2009 | Aug-2009 | Sep-2009 | Oct-2009 | Nov-2009 | Dec-2009 | [NAME] | [NAME] | Mar-2010 | Apr-2010 | [NAME] | [NAME] | Total | 2009-2010 price | Price per unit
ALA Guide to Reference
Logins | 2 | 0 | 3 | 3 | 0 | 0 | 2 | 4 | 4 | 0 | 2 | 0 |  | 1238
Spreadsheet: a1a67168-a416-44ac-8859-6f8636fc8f66
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
SSAB | Test | SSAB | SS-A and SS-B Antibodies, IgG, Serum | SSA/SSB | [NAME] | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | SS-A/Ro ANTIBODIES, IgG <1.0 U (negative) > or =1.0 U (positive) Reference values apply to all ages.  SS-B/La ANTIBODIES, IgG <1.0 U (negative) > or =1.0 (positive)  Reference values apply to all ages. | Monday through Saturday; 4p.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
SSAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
SSAB | Component | SSA | SS-A/Ro Antibodies, IgG, Serum | SS-A/Ro Ab, IgG, S | [NAME] | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <1.0 U (negative) > or =1.0 U (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | 1 day | 3 days | 1 | 86235 |  |  | Yes | Yes
SSA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
SSA | Result | SSA | SS-A/Ro Ab, IgG, S | SS-A/Ro Ab, IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 33610-7
SSAB | Component | SSB | SS-B/La Antibodies, IgG, Serum | SS-B/La Ab, IgG, S | [NAME] | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <1.0 U (negative) > or =1.0 U (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | 1 day | 3 days | 1 | 86235 |  |  | Yes | Yes
SSB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
SSB | Result | SSB | SS-B/La Ab, IgG, S | SS-B/La Ab, IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 33613-1
Spreadsheet: 26e94d0b-23ce-4a53-b176-57e2dd217b72
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Wholesale Trade: Sales and Inventories
 |  | 42: Total [NAME], Except Manufacturers' Sales Branches and Offices: U.S. Total
 |  | Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: March 7, 2014 (9:47 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 142980 | 144206 | 145306 | 145381 | 144000 | 145989 | 148808 | 147427 | 149251 | 149276 | 149801 | 148469
1993 | 153497 | 152528 | 149841 | 153239 | 156085 | 152751 | 154732 | 154879 | 155380 | 155866 | 156094 | 152929
1994 | 156983 | 157654 | 160546 | 160114 | 161206 | 162652 | 164247 | 168414 | 168187 | 171258 | 171528 | 174127
1995 | 175771 | 177369 | 175256 | 178210 | 178565 | 180181 | 180081 | 181324 | 182123 | 182966 | 184854 | 186968
1996 | 184352 | 185286 | 187580 | 187462 | 188032 | 189016 | 190819 | 191939 | 191679 | 193329 | 194369 | 192137
1997 | 194379 | 199102 | 197622 | 196608 | 197677 | 197465 | 197978 | 197328 | 200474 | 199698 | 199693 | 199039
1998 | 201068 | 200976 | 202223 | 202434 | 202077 | 200992 | 202201 | 200940 | 202070 | 203185 | 203149 | 204997
1999 | 204181 | 206856 | 209359 | 210145 | 214770 | 216526 | 217499 | 218978 | 220899 | 223817 | 226182 | 227783
2000 | 229981 | 228836 | 231770 | 233194 | 233522 | 236320 | 235530 | 235262 | 237462 | 238481 | 237269 | 239633
2001 | 239105 | 237667 | 233729 | 233385 | 234208 | 229971 | 231315 | 232185 | 231714 | 227666 | 227707 | 227165
2002 | 228701 | 230362 | 229907 | 234201 | 235268 | 236963 | 237915 | 240254 | 240018 | 239034 | 242421 | 239492
2003 | 244231 | 244668 | 247026 | 242509 | 241342 | 245208 | 247730 | 247580 | 249137 | 253320 | 255007 | 257524
2004 | 257933 | 264030 | 272232 | 272470 | 274033 | 274340 | 275696 | 279126 | 279754 | 283407 | 286744 | 290646
2005 | 292644 | 294156 | 292935 | 297777 | 296190 | 297441 | 300892 | 305683 | 311409 | 316756 | 312100 | 316580
2006 | 318375 | 320454 | 320953 | 323062 | 327295 | 329714 | 331249 | 334783 | 329820 | 328698 | 330156 | 337437
2007 | 332204 | 337461 | 340908 | 345927 | 348969 | 349918 | 347483 | 351521 | 355137 | 359546 | 366555 | 363954
2008 | 371829 | 370423 | 373774 | 381374 | 387685 | 397213 | 393965 | 386774 | 376380 | 358899 | 327837 | 315840
2009 | 305193 | 308998 | 297716 | 299157 | 302384 | 306104 | 309717 | 312582 | 314281 | 317249 | 325325 | 327428
2010 | 329337 | 334260 | 338983 | 344243 | 343534 | 344126 | 347679 | 350288 | 351457 | 360432 | 365069 | 367587
2011 | 380752 | 377678 | 388292 | 391280 | 388788 | 392904 | 394865 | 398688 | 396381 | 400094 | 397048 | 402860
2012 | 402937 | 406916 | 408993 | 413567 | 408031 | 403238 | 403285 | 405744 | 414234 | 408958 | 417169 | 418133
Spreadsheet: 689512d1596471664-sum-ifs-function-bbltd
Sheet: Fuel-Bakery

 | Bread Boutique Limited
 | Fuel Allocation Recors
 | Description | QTY | Amount | Branch | Day | Week-ending
 | Gas | 25kg | 1500 | Spintex | Monday | 31st July 2020
 | Electricity | 4 | 600 | Dansoman | Tuesday | 31st July 2020
 | Water | 5 | 56 | UPSA | Wednesday | 31st July 2020
Spreadsheet: 710067d1608703142-lookup-issues-lookupissues
Sheet: XLookup

 |  |  |  |  | ID | ID Working | FLAG | Region | ID |  | My Comments
 |  |  |  |  | 2361 | 2361
ID | Flag | Product ID | ID2 |  |  |  | XLOOKUP(F2 & "",Test[[#All],[ID]:[ID2]],Test[[#All],[Flag]]) |  |  |  | Does not work
2024 | Yes | 202 | 2024 |  |  |  | XLOOKUP($F$2&" ",Test[ID],Test[[Flag]:[ID2]]) |  |  |  | Does not work
2024 | Yes |  | 2024 |  |  |  | XLOOKUP($G$2,Test[ID],Test[[Flag]:[ID2]]) |  |  |  | Working
2024 | Yes | 406 | 2024 |  |  |  | VLOOKUP(F2,Test[[ID]:[ID2]],3)
2269 | Show? | 701 | 2269 |  |  |  | VLOOKUP(F2&" ",Test[[ID]:[ID2]],2) |  |  |  | Wrong and Does not change
2361 | Adam | 703 | 2361 |  |  |  | VLOOKUP($G$2,Test,2) |  |  |  | Working
2361 | Yes | 202 | 2361
2361 | Yes | 280 | 2361 |  |  | https://www.excelforum.com/excel-formulas-and-functions/1336108-lookup-issues.html
2361 | Yes |  | 2361
2361 | Yes |  | 2361
2361 | Yes | 202 | 2361
2361 | Yes |  | 2361
2361 | Yes | 280 | 2361
Spreadsheet: 777432d1650378299-attendance-rolling-12-month-calculator-attendance-example-aligw
Sheet: Sheet1

 | Employee Name | Total Points  this year | Total Points | 2022-04-11 00:00:00
 | Employee A |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  | 1 | 1
 | Employee B |  |  |  | 0.5 | 0.5 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
Spreadsheet: 9657ac0b-9f62-4c9a-b017-78d84e195ab7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Employer Electronic Contribution Form
 | Instructions:
 | Please complete this form and using a computer.  Fax this form along with the signed Employer Authorization Agreement for ACH Transfer to (608) 654-5297.  Be sure to save a completed copy for future changes.  Account Numbers must be provided.
Company Name:
Company Address: (Street, City, State, Zip)
Contact Name: (First, Last)
[NAME]:
Phone: |  |  | Ext:
 | Employee Name |  | Account # (7 digits req.) | Contribution Amount *Please note column order*
 | First | Last |  | Employee | Employer
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
 | Sub Total Page 1: |  |  | 0 | 0
 | Total Page 1: |  |  | 0
 | Grand Total: | 0 |  |  | Page 1
 | Employee Name |  | Account # (7 digits req.) | Contribution Amount *Please note column order*
 | First | Last |  | Employee | Employer
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
 | Sub Total Page 2: |  |  | 0 | 0
 | Total Page 2: |  |  | 0
 |  |  |  |  | Page 2
 | Employee Name |  | Account # (7 digits req.) | Contribution Amount *Please note column order*
 | First | Last |  | Employee | Employer
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
 | Sub Total Page 3: |  |  | 0 | 0
 | Total Page 3: |  |  | 0
 |  |  |  |  | Page 3
 | Employee Name |  | Account # (7 digits req.) | Contribution Amount *Please note column order*
 | First | Last |  | Employee | Employer
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
 | Sub Total Page 4: |  |  | 0 | 0
 | Total Page 4: |  |  | 0
 |  |  |  |  | Page 4
Spreadsheet: 205009d1357718908-incentive-with-start-date-and-end-date-2013-sales-report-master-
Sheet: 2013 Monthly Sales

 | 2013 MONTHLY REPORT
 | Monthly Sales
 | January |  |  |  |  | February |  |  |  |  | March
 | No. | Date | Name | FYP |  | No. | Date | Name | FYP |  | No. | Date | Name | FYP
 | 1 |  |  | - |  | 1 |  |  | - |  | 1 |  |  | -
 | 2 |  |  | - |  | 2 |  |  | - |  | 2 |  |  | -
 | 3 |  |  | - |  | 3 |  |  | - |  | 3 |  |  | -
 | 4 |  |  | - |  | 4 |  |  | - |  | 4 |  |  | -
 | 5 |  |  | - |  | 5 |  |  | - |  | 5 |  |  | -
 | 6 |  |  | - |  | 6 |  |  | - |  | 6 |  |  | -
 | 7 |  |  | - |  | 7 |  |  | - |  | 7 |  |  | -
 | 8 |  |  | - |  | 8 |  |  | - |  | 8 |  |  | -
 | 9 |  |  | - |  | 9 |  |  | - |  | 9 |  |  | -
 | 10 |  |  | - |  | 10 |  |  | - |  | 10 |  |  | -
 | 11 |  |  | - |  | 11 |  |  | - |  | 11 |  |  | -
 | 12 |  |  | - |  | 12 |  |  | - |  | 12 |  |  | -
 | April |  |  |  |  | May |  |  |  |  | June
 | No. | Date | Name | FYP |  | No. | Date | Name | FYP |  | No. | Date | Name | FYP
 | 1 |  |  | - |  | 1 |  |  | - |  | 1 |  |  | -
 | 2 |  |  | - |  | 2 |  |  | - |  | 2 |  |  | -
 | 3 |  |  | - |  | 3 |  |  | - |  | 3 |  |  | -
 | 4 |  |  | - |  | 4 |  |  | - |  | 4 |  |  | -
 | 5 |  |  | - |  | 5 |  |  | - |  | 5 |  |  | -
 | 6 |  |  | - |  | 6 |  |  | - |  | 6 |  |  | -
 | 7 |  |  | - |  | 7 |  |  | - |  | 7 |  |  | -
 | 8 |  |  | - |  | 8 |  |  | - |  | 8 |  |  | -
 | 9 |  |  | - |  | 9 |  |  | - |  | 9 |  |  | -
 | 10 |  |  | - |  | 10 |  |  | - |  | 10 |  |  | -
 | 11 |  |  | - |  | 11 |  |  | - |  | 11 |  |  | -
 | 12 |  |  | - |  | 12 |  |  | - |  | 12 |  |  | -
 | July |  |  |  |  | August |  |  |  |  | September
 | No. | Date | Name | FYP |  | No. | Date | Name | FYP |  | No. | Date | Name | FYP
 | 1 |  |  | - |  | 1 |  |  | - |  | 1 |  |  | -
 | 2 |  |  | - |  | 2 |  |  | - |  | 2 |  |  | -
 | 3 |  |  | - |  | 3 |  |  | - |  | 3 |  |  | -
 | 4 |  |  | - |  | 4 |  |  | - |  | 4 |  |  | -
 | 5 |  |  | - |  | 5 |  |  | - |  | 5 |  |  | -
 | 6 |  |  | - |  | 6 |  |  | - |  | 6 |  |  | -
 | 7 |  |  | - |  | 7 |  |  | - |  | 7 |  |  | -
 | 8 |  |  | - |  | 8 |  |  | - |  | 8 |  |  | -
 | 9 |  |  | - |  | 9 |  |  | - |  | 9 |  |  | -
 | 10 |  |  | - |  | 10 |  |  | - |  | 10 |  |  | -
 | 11 |  |  | - |  | 11 |  |  | - |  | 11 |  |  | -
 | 12 |  |  | - |  | 12 |  |  | - |  | 12 |  |  | -
 | October |  |  |  |  | November |  |  |  |  | December
 | No. | Date | Name | FYP |  | No. | Date | Name | FYP |  | No. | Date | Name | FYP
 | 1 |  |  | - |  | 1 |  |  | - |  | 1 |  |  | -
 | 2 |  |  | - |  | 2 |  |  | - |  | 2 |  |  | -
 | 3 |  |  | - |  | 3 |  |  | - |  | 3 |  |  | -
 | 4 |  |  | - |  | 4 |  |  | - |  | 4 |  |  | -
 | 5 |  |  | - |  | 5 |  |  | - |  | 5 |  |  | -
 | 6 |  |  | - |  | 6 |  |  | - |  | 6 |  |  | -
 | 7 |  |  | - |  | 7 |  |  | - |  | 7 |  |  | -
 | 8 |  |  | - |  | 8 |  |  | - |  | 8 |  |  | -
 | 9 |  |  | - |  | 9 |  |  | - |  | 9 |  |  | -
 | 10 |  |  | - |  | 10 |  |  | - |  | 10 |  |  | -
 | 11 |  |  | - |  | 11 |  |  | - |  | 11 |  |  | -
 | 12 |  |  | - |  | 12 |  |  | - |  | 12 |  |  | -
 | HAPPY SELLING
Spreadsheet: 726557d1617291349-named-range-weekday-and-hours-book1-6-
Sheet: Sheet1

start |  | 2021-06-01 22:00:00
end |  | 2021-06-03 22:00:00
Begin | Einde | Begin | Einde | Begin | Einde
14:00:00 | 19:00:00 |  |  |  |  | 0
22:00:00 | 23:00:00
18:00:00 | 19:00:00
20:00:00 | 21:00:00
 |  |  |  |  |  |  |  |  | the intention is to make a schedule by coloring cells if the time falls between the
 |  |  |  |  |  |  |  |  | given time in column A + B, C + D, E + F.
 |  |  |  |  |  |  |  |  | the hour in H5 is the hour in C1 - 6 hours.
 |  |  |  |  |  |  |  |  | I have now got this in order for A + B via conditional formatting.
 |  |  |  |  |  |  |  |  | but if I want to change the time in C1 to for example 18 hours, then the last part no longer
 |  |  |  |  |  |  |  |  | works.
 |  |  |  |  |  |  |  |  | I also want to use different colors for the different dates (A + B, C + D and E + F).
Spreadsheet: 875440d1722004493-multiple-if-statements-excel-if-statement-help
Sheet: Sheet1

 |  |  |  |  |  | Month in number | 7
Reference | January | February | March | April | May | June | July | August | September | October | November | December |  | SUM | SUM
2 | 20 | 50 | 41 | 61 | 71 | 82 | 94 | 105 | 110 | 80 | 50 | 63
3 | 20 | 50 | 41 | 61 | 71 | 82 | 94 | 105 | 110 | 80 | 50 | 63
2 | 20 | 50 | 41 | 61 | 71 | 82 | 94 | 105 | 110 | 80 | 50 | 63
 |  |  | If [NAME] is month "7" (July), then it needs to SUM  the previous 3 or 4 months, depending on A column. If I then change H1 to 12, it needs to SUM L, K, J and I, depending on A.
 |  |  | 2 = past 3 months, 3 = past 4 months.
Spreadsheet: chris_dorland__1641__12-13 1600
Sheet: MAIN

MAIN
 |  | Fuel | [NAME] | Full | Current Output | Change | Current Output | Change | Current Output | Change | Current Output | Change
OPERATOR | PLANT | Type | Heat Rate | Capacity | @ 0630 |  | @ 0900 |  | @ 1200 |  | @1600
ILLC | [NAME] (IL) | Coal | 9817 | 1892.05 | 1595 |  | 1700 |  | 1870 |  | 1720
AEE | Coffeen | Coal | 9875 | 1005.46 | 730 |  | 875 |  | 1010 |  | 940
EEI | [NAME] | Coal | 10344 | 1100 | 995 |  | 970 |  | 970 |  | 975
AEE | Labadie | Coal | 10298 | 2389.5 | 1525 |  | 1905 |  | 1955 |  | 1725
AEE | Rush Island | Coal | 10192 | 1242 | 1140 |  | 1205 |  | 1210 |  | 1220
ALIANT | Columbia (WI) - WPL | Coal | 10257 | 1070
AEE | Newton | Coal | 9474 | 1234.8 | 1210 |  | 1225 |  | 1205 |  | 1150
Dominion Resources | Kincaid | Coal | 10449 | 1319 | 815 |  | 900 |  | 715 |  | 715
UCM | Powerton | Coal | 10665 | 1785.6 | 1415 |  | 1445 |  | 1480 |  | 1430
WIEC | Oak Creek South | Coal | 8898 | 1216 | 1216 |  | 1216 |  | 1216 |  | 1216
WIEC | Pleasant Prairie | Coal | 10806 | 1235 | 1235 |  | 1235 |  | 1235 |  | 1235
Spreadsheet: 462374d1464021567-find-reference-in-one-ws-in-an-column-that-contains-cell-with-string-of-references-gta-tv58-sample
Sheet: Documents

DE ID | Main Reference | Related RE ID
DE-28 | 15000-XX-KN-XXX-000055 | RE-268, RE-308
DE-336 | 15100-00-RG-301-000001 | RE-141, RE-163, RE-261, RE-264, RE-266, RE-535, RE-734, RE-808, RE-809, RE-864, RE-865, RE-954, RE-958, RE-1132, RE-1195, RE-1236, RE-1298, RE-1301, RE-1302, RE-1368, RE-1955, RE-1957, RE-1958, RE-1969, RE-2005, RE-2016
DE-337 | 15100-00-GA-401-000001 | RE-163, RE-264, RE-271, RE-340, RE-341, RE-744, RE-808, RE-952, RE-954, RE-974, RE-1236, RE-1298, RE-1301, RE-1302, RE-1311, RE-1443, RE-1474, RE-1475, RE-1493, RE-1503, RE-1957, RE-1958, RE-1975, RE-2005, RE-2017, RE-2119, RE-2122, RE-2123
DE-338 | 15100-00-GA-263-000004 | RE-163, RE-264, RE-340, RE-341, RE-744, RE-954, RE-974, RE-2016
DE-339 | 15100-00-GA-301-000001 | RE-141, RE-163, RE-261, RE-264, RE-265, RE-266, RE-271, RE-340, RE-341, RE-770, RE-809, RE-977, RE-1195, RE-1236, RE-1298, RE-1311, RE-1368, RE-1955, RE-1957, RE-1958, RE-1969, RE-1975, RE-2005, RE-2017, RE-2119, RE-2120, RE-2122, RE-2123, RE-2654, RE-2656
DE-340 | 15100-00-GA-301-000002 | RE-163, RE-264, RE-340, RE-341, RE-808, RE-809, RE-954, RE-977, RE-1443, RE-1474, RE-1475, RE-1493, RE-1503, RE-2005, RE-2016, RE-2119, RE-2123
DE-341 | 15100-00-DE-736-000005 | RE-340, RE-341, RE-952
DE-342 | 15100-00-DE-736-000006
DE-343 | 15100-00-M3-736-000001
DE-344 | 15100-00-GA-922-000005 | RE-340, RE-341
DE-371 | 15000-XX-PD-911-000001 | RE-269
DE-639 | 15100-00-RD-223-000002
DE-640 | 15100-00-GA-223-000006 | RE-269, RE-769, RE-977, RE-981, RE-1369, RE-1955, RE-1969, RE-1973, RE-1975
DE-641 | 15100-00-SE-223-000003 | RE-269, RE-769, RE-977, RE-981, RE-1369, RE-1955, RE-1969, RE-1973, RE-1975
DE-642 | 15100-00-DE-224-000001 | RE-269, RE-1955, RE-1973, RE-1975
DE-1757 | 15000-XX-BD-301-000126
DE-1795 | 15100-00-M3-301-000001
DE-1796 | 15100-00-M3-301-000004
DE-1815 | 15100-00-M2-223-000005
DE-1816 | 15100-00-M2-263-000002
DE-1817 | 15100-00-M2-301-000001
DE-1818 | 15100-00-M2-301-000002
DE-1819 | 15100-00-M2-401-000001
DE-1820 | 15100-00-SK-736-000001
DE-1821 | 15100-00-GA-223-000003
DE-1822 | 15100-00-GA-911-000001
[NAME] | 15100-00-SE-301-000002