tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59686d1260273271-displaying-multiple-results-with-vlookup-copy-of-example
Sheet: Sheet1

abc 123 | 34973 | G Smith | Ford | 199 | This is where Im at at the moment, this only gives me one result for the registration abc 123, I want it to give me all the occurences where this registration appears
abc 123 | 35570 | G Smith | Ford | 145
abc 123 | 37226 | G Smith | Ford | 212
abc 123 | 39140 | G Smith | Ford | 45
#N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  | This is how I want the data to come out, if needs be I can place a button in to have it search for the registration that I am looking for
 |  | abc 123
abc 123 | 1995-10-01 00:00:00 | G Smith | Ford | 199
abc 123 | 1997-05-20 00:00:00 | G Smith | Ford | 145
abc 123 | 2001-12-01 00:00:00 | G Smith | Ford | 212
abc 123 | 2007-02-27 00:00:00 | G Smith | Ford | 45
Spreadsheet: kate_symes__18534__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-29 00:00:00 |  | 420.48 | 19824 | 407.62 | 3832
 | 2001-01-28 00:00:00 |  | 450 | 800 | 350 | 0 | 488.38 | 355 | 460.46 | 416 |  | 408.68 | 12240
 | 2001-01-27 00:00:00 |  | 294.85 | 19024 | 254.41 | 4032 | 456.54 | 845 | 457.01 | 236
 | 2001-01-26 00:00:00 |  | 295.64 | 17424 | 254.65 | 3832 | 369.4 | 402 | 350 | 75
 | 2001-01-25 00:00:00 |  | 319.38 | 15024 | 295.88 | 1272 | 296.66 | 437 | 234.61 | 965
 | 2001-01-24 00:00:00 |  | 307.59 | 18224 | 261.91 | 2872 | 290.03 | 291 | 291.18 | 807
 | 2001-01-23 00:00:00 |  | 329.11 | 18624 | 254.24 | 4712 | 309.54 | 1107 | 305 | 200
 | 2001-01-22 00:00:00 |  | 393.64 | 26784 | 333.06 | 3312 | 351.61 | 465 | 314.65 | 1500
 | 2001-01-21 00:00:00 |  | 300 | 800 | 337.5 | 0 | 367 | 625 | 318.16 | 435 |  | 335.88 | 8736
 | 2001-01-20 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 362.89 | 291 | 286.58 | 300
 | 2001-01-19 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344 | 376.11 | 836 | 283.47 | 546
 | 2001-01-18 00:00:00 |  | 481.44 | 21424 | 392.14 | 5112 | 454.07 | 393 | 294.21 | 380
 | 2001-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312 | 428.17 | 196 | 285.3 | 495
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 422.32 | 6337 | 190 | 50
 | 2001-01-15 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 205.96 | 83 | 210 | 22
 | 2001-01-14 00:00:00 |  | 158.5 | 0 | 152.5 | 0 | 175.38 | 920 | 157.2 | 820 |  | 152.44 | 15000
 | 2001-01-13 00:00:00 |  | 158.65 | 17648 | 151.85 | 6600 | 180.04 | 1330 | 158.51 | 865
 | 2001-01-12 00:00:00 |  | 171.71 | 16368 | 147.69 | 5432 | 181.08 | 185 | 149.35 | 575
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936 | 157.64 | 254 | 119.48 | 1146
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 |  |  |  |  |  | ..
Spreadsheet: 41457d1239914510-formula-help-example
Sheet: Sheet1

 |  |  |  |  |  | TOTAL
9 | 50 | 24 | 15 | 38 | 2 | 2
48 | 36 | 21 | 12 | 5 | 3 | 2
 |  |  |  |  |  |  |  | 24 | 12 | 3 | 30 | 46 | 9
30 | 54 | 18 | 25 | 39 | 46 | 1
Spreadsheet: 833836d1687273377-vlookup-2-columns-to-get-result-vlookup-twice-ans
Sheet: TotalInvoices

A | B | C | D | Corrected Invoice number | Original Invoice Number | Nature of Supply | your formula
1 |  |  |  |  | 8220005 | Invoice
2 |  |  |  |  | 8220006 | Invoice
67318 |  |  |  |  | TLCKA22230008037 | CreditNote
67319 |  |  |  |  | TLCKA22230008037 | Invoice
67320 |  |  |  |  | TLCKA22230008038 | CreditNote |  | When the Invoice number is same, I need to add R to if same row column G = credit note only.
67321 |  |  |  |  | TLCKA22230008038 | Invoice |  | Yellow cells should not contain R in the beginning as per the expected result.
67322 |  |  |  |  | TLCKA22230008039 | CreditNote
67323 |  |  |  |  | TLCKA22230008039 | Invoice
67324 |  |  |  |  | TLCKA22230008043 | CreditNote
67363 |  |  |  |  | TLCKA22230008085 | CreditNote
67364 |  |  |  |  | TLCKA22230008089 | Invoice
67378 |  |  |  |  | TLCKA22230008105 | CreditNote
67379 |  |  |  |  | TLCKA22230008106 | CreditNote
67380 |  |  |  |  | [NAME] | Invoice
67381 |  |  |  |  | TLCKA22230008108 | CreditNote
67382 |  |  |  |  | TLCKA22230008109 | CreditNote
67408 |  |  |  |  | TLCWB22230000049 | CreditNote
67409 |  |  |  |  | [NAME] | Invoice
Spreadsheet: 856217d1705551710-count-total-number-of-months-not-counting-overlapping-months-calculatemonths-1-
Sheet: Sheet1

Project Name | Start Period | End Period
ABC | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
DDD | 2022-05-01 00:00:00 | 2023-02-03 00:00:00
EEE | 2023-01-01 00:00:00 | 2023-12-31 00:00:00
FFF | 2024-09-02 00:00:00 | 2024-12-31 00:00:00
EFG | 2000-01-01 00:00:00 | 2000-06-30 00:00:00
Total number of days taken |  |  | [How to calculate the total number of days, not counting overlapping period]
Total number of months
Spreadsheet: 49225d1248457905-working-with-scaling-prices-slidingscale
Sheet: Sheet1

INPUT
# OF ADS |  |  |  | COST
1 | - | 5 |  | 12000
6 | - | 10 |  | 11000
11 | - | 20 |  | 10000
21 | - | 1000 |  | 9000
PURCHASED |  |  |  | 4
OUTPUT
TOTAL COST
AVG. COST
Spreadsheet: 01c10492-9a39-4b49-956e-3b864544c3cd
Sheet: Course Totals

MSJC Dual Enrollment Total by Course | [NAME]
Click Back to Subject Totals
Course | AY11-12 |  |  | AY12-13
Dual enrollment Courses | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
ART-101 |  | 1
ART-102 |  |  | 1
ASL-103 |  | 1 |  |  | 0.9583333333333334
ASL-104 |  |  | 1 |  |  | 1
BADM-103 |  |  |  |  |  | 1
BIOL-117 |  |  | 1 |  |  | 1
ENGL-101 |  | 0.9655172413793104 |  |  | 0.97
ENGL-103 |  |  | 0.9910714285714286 |  |  | 0.953125
ENVS-101 |  | 1 |  |  | 1
GUID-100 |  |  |  |  | 1
HIST-111 |  | 0.9615384615384616 |  |  | 0.9841269841269841
HIST-112 |  |  | 0.96 |  |  | 0.9841269841269841
HS-121 |  |  |  |  | 1
HS-123 |  |  |  |  |  | 0.9047619047619048
MATH-105 |  | 0.9745222929936306 |  |  | 0.9752650176678446
MATH-110 |  | 1 | 0.9727891156462585 |  | 0.95 | 0.9717741935483871
MATH-211 |  | 0.6923076923076923 | 1 |  | 0.9761904761904762 | 1
MATH-212 |  |  | 1 |  |  | 0.8888888888888888
MUL-110 |  | 1 |  |  | 1 | 1
MUL-123 |  |  |  |  |  | 1
[NAME] |  | 1 |  |  | 1
MUL-137 |  |  |  |  |  | 1
MUS-100 |  |  |  |  |  | 1
MUS-103 |  |  |  |  | 0.9333333333333333
PS-101 |  |  |  |  | 1
PSYC-101 |  | 1 | 0.875 |  | 0.9736842105263158 | 0.96
SPAN-101 |  | 0.9789473684210527 |  |  | 1
SPAN-102 |  |  | 0.9891304347826086 |  |  | 1
Spreadsheet: 89282d1289043658-auto-sorting-left-to-right-sort
Sheet: Sheet1

 | 0 | 3 | 1 | 5 | / | 0 | 3 | 1 | 3 | / | 0 | 3 | 1 | 6
 | 5 | 3 | 9 | 1 | / | 5 | 3 | 9 | 6 | / | 5 | 3 | 9 | 3
 | 8 | 0 | 6 | 1 | / | 8 | 0 | 6 | 0 | / | 8 | 0 | 6 | 9
 | 6 | 1 | 7 | 2 | / | 6 | 1 | 7 | 1 | / | 6 | 1 | 7 | 8
 | 8 | 2 | 2 | 4 | / | 8 | 2 | 2 | 5 | / | 8 | 2 | 2 | 4
 | 2 | 0 | 7 | 4 | / | 2 | 0 | 7 | 1 | / | 2 | 0 | 7 | 8
 | 4 | 8 | 8 | 7 | / | 4 | 8 | 8 | 0 | / | 4 | 8 | 8 | 9
 | 7 | 7 | 2 | 8 | / | 7 | 7 | 2 | 4 | / | 7 | 7 | 2 | 5
 | 8 | 3 | 3 | 6 | / | 8 | 3 | 3 | 4 | / | 8 | 3 | 3 | 5
 | 2 | 5 | 1 | 6 | / | 2 | 5 | 1 | 7 | / | 2 | 5 | 1 | 2
 | 0 | 2 | 1 | 8 | / | 0 | 2 | 1 | 0 | / | 0 | 2 | 1 | 9
 | 6 | 1 | 7 | 5 | / | 6 | 1 | 7 | 4 | / | 6 | 1 | 7 | 5
 | 0 | 4 | 2 | 6 | / | 0 | 4 | 2 | 5 | / | 0 | 4 | 2 | 4
 | 1 | 1 | 3 | 3 | / | 1 | 1 | 3 | 2 | / | 1 | 1 | 3 | 7
 | 0 | 7 | 5 | 6 | / | 0 | 7 | 5 | 2 | / | 0 | 7 | 5 | 7
 | 8 | 9 | 2 | 3 | / | 8 | 9 | 2 | 6 | / | 8 | 9 | 2 | 3
 | 2 | 3 | 0 | 3 | / | 2 | 3 | 0 | 2 | / | 2 | 3 | 0 | 7
 | 7 | 2 | 6 | 8 | / | 7 | 2 | 6 | 3 | / | 7 | 2 | 6 | 6
 | 1 | 3 | 3 | 3 | / | 1 | 3 | 3 | 0 | / | 1 | 3 | 3 | 9
 | 6 | 5 | 3 | 8 | / | 6 | 5 | 3 | 2 | / | 6 | 5 | 3 | 7
 | 9 | 3 | 1 | 5 | / | 9 | 3 | 1 | 5 | / | 9 | 3 | 1 | 4
 | 1 | 8 | 3 | 4 | / | 1 | 8 | 3 | 5 | / | 1 | 8 | 3 | 4
 | 1 | 3 | 2 | 1 | / | 1 | 3 | 2 | 1 | / | 1 | 3 | 2 | 8
Spreadsheet: 823827d1680158861-if-specific-number-then-specific-text-maxwell-fes-2023-run-data-test-etaf
Sheet: Totals

 | Annual Response Data Tracker |  |  |  |  |  |  |  |  |  |  |  |  | Mr. [NAME], Maxwell AFB, AL
 | Fire Demand Zone | # Responses | Dispatch Time | Fractile Rate | [NAME] | Fractile Rate | Travel Time | Fractile Rate | Aggregate Response Time | Fractile Rate | Full Responses | ERF Time | Fractile Rate
 | 1 Maxwell Main Base | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 2 Federal Prison Camp | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 3 Maxwell Privatized Housing | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 4 Maxwell Airfield | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 5 Off-Base Facilities | #N/A | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A
 | 6 Gunter Privatized Housing | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 7 Gunter Annex Main Base | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Totals | #N/A | 1900-01-01 00:00:00 | #N/A | #N/A | #N/A | 1900-01-01 00:00:00 | #N/A | 1900-01-01 00:00:00 | #N/A | #N/A | 1900-01-01 00:00:00 | #N/A
 | 90th Percentile |  | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A |  | #N/A | #N/A
 | Fire District/Demand Zone | Structural | ARFF | EMS | HazMat | Tech Rescue | Totals | [NAME] |  | CFAI 90th Percentile Response Time Table
 | 1 Maxwell Main Base | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 2 Federal Prison Camp | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | [NAME] | [NAME] | Travel(1st Unit) | Travel (ERF) | ART (1st Unit) | ART (ERF)
 | 3 Maxwell Privatized Housing | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | Structural | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 4 Maxwell Airfield | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | ARFF | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 5 Off-Base Facilities | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | EMS | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Fire District 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | HazMat | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 6 Gunter Privatized Housing | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | Tech Rescue | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 7 Gunter Annex Main Base | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Fire District 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Limit
 | Totals by Type | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 103
 | INCIDENT TYPE | SUN | MON | TUE | WED | THU | FRI | SAT | Totals
 | STRUCTURAL | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | ARFF | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | EMS | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | HAZMAT | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | TECH RESCUE | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | TOTAL | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Low
 | Moderate
 | High
Spreadsheet: tracy_geaccone__40377__Corp Opex Detail
Sheet: Cost Type

 |  | EREC RENEWABLE ENERGY CORP.
 |  | CONSOLIDATED
 |  | 2002 PLAN OPERATING COSTS
 |  | By Cost Type
 |  | ($ thousands)
 |  | Cost Type |  | Total
 |  | Labor & related |  | 49822.164
 |  | Professional & outside services |  | 22957.1
 |  | Occupancy & office |  | 5448
 |  | Maintenance & asset |  | 2456
 |  | Travel & entertainment |  | 8020.6
 |  | Land & royalty |  | 748
 |  | Wind turbine development |  | 3149
 |  | Allocations |  | 1177
 |  | Other |  | 750
 |  | Wind turbine development capitalized |  | -1200
 |  | [NAME] reimbursements |  | -1702
 |  | Total Operating Costs
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: Duke

Duke Energy Field Services
Contract  24268
2002-01-31 00:00:00 |  | 1529476.6
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-02-19 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 1898
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -1
500267
Duke Energy Trading and Marketing
Contract  24693
2002-01-31 00:00:00 |  | 275313.72
2002-02-17 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 377700 | 117857 | 193435
2002-01-31 00:00:00 |  | 855876.1
2002-02-23 00:00:00
500241
500391 | 1180
500392 | 2095
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
24268
24693
24361
21665
22664
23995
22051
20379
26357
21544
24532
Spreadsheet: 62019d1262911973-excel-2007-range-selection-in-multiple-worksheets-formrexcel-2
Sheet: Summary

 |  | Summary |  |  |  | Date | 2010-01-07 00:00:00 | [NAME] fields Auto Complete
 |  | Ref (Auto) | Priority (Auto) | Status (Auto) | [NAME] | Action Title | Brief Description and Benefit | Success Criteria | Impact |  | Impact Justification | Difficulty |  | Total Score | Difficulty Justification | Owner | Sub-Actions | Initial Planned Completion Date | Forecast Completion Date | Days Late | Actual Completion Date |  | ROM Cost (if more than just FTE hours) | Breakdown of Cost (if applicable) | Summary of Updates (create in Notepad and copy in to achieve carriage returns)
Spreadsheet: 598485d1542534128-how-dsum-criterias-work-example-dsum
Sheet: Blad1

Data |  |  |  | Criteria table 1 |  |  |  | Yadda | Yadda yadda
Country | City | Population |  | Country | City | Population |  | Country | City | Population
Finland | Helsinki | 1000 |  |  | Helsinki |  |  |  | Helsinki
Spain | Madrid | 3000 |  |  | Madrid |  |  |  | Madrid
Australia | Canberra | 2500
Germany | Berlin | 5000
 |  |  |  |  |  |  |  | Result
Spreadsheet: chris_germany__2017__TRBL Status
Sheet: TRBL-Invoice Status

Pipeline | [NAME]
Contact Name
Contact Number
Status
Legal
Commercial | [NAME]
ENA
 |  |  | Pre-Petition |  |  |  | Post Petition
Contract No. | Rate Schedule | Expiration | Other Past Due Amounts | Nov. 2001 | Dec. 2, 2001 | Total Pre-Petition | Dec. 3-31,2001 | Jan. 2002 | Feb.2002 | Feb.2002 | Total Post Petition | Notes
903145 | FTS |  |  | 92721.71 |  |  |  | 90107.5
903145 | Cashout-Nov |  |  |  | 2.19
903145 | Interest
 |  |  |  |  |  |  |  |  |  |  | 0
Other:
Total Post Petition
Totla Capacity Release Revenue
Trailblazer claim of Release Revenue |  | 1295000
 | Difference
Spreadsheet: 0102b9d3-e111-4d80-8865-a6dda805201f
Sheet: Sheet1

Release: State Leading Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=208
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-11-23 7:48 AM CST
 | Real-Time | Period
Name: | Start | End
State Leading Indexes | 2011-02-01 00:00:00 | Current
Link:
http://www.philadelphiafed.org/research-and-data/regional-economy/indexes/leading/ | 2011-02-01 00:00:00 | Current
Source:
Federal Reserve Bank of Philadelphia | 2011-02-01 00:00:00 | Current
Notes:
The leading index for each state predicts the six-month growth rate of | 2011-02-01 00:00:00 | Current
the models include other variables that lead the economy: state-level
housing permits (1 to 4 units), state initial unemployment insurance
claims, delivery times from the Institute for Supply Management (ISM)
manufacturing survey, and the interest rate spread between the 10-year
Treasury bond and the 3-month Treasury bill.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-02-01 00:00:00
2011-03-22 00:00:00
2011-03-31 00:00:00
2011-04-28 00:00:00
2011-05-31 00:00:00
2011-06-28 00:00:00
2011-08-02 00:00:00
2011-08-30 00:00:00
2011-09-29 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2011-12-29 00:00:00
2012-02-02 00:00:00
2012-03-20 00:00:00
2012-04-03 00:00:00
2012-04-27 00:00:00
2012-05-29 00:00:00
2012-06-28 00:00:00
2012-07-31 00:00:00
2012-08-28 00:00:00
2012-10-02 00:00:00
2012-10-30 00:00:00
2012-12-04 00:00:00
2013-01-03 00:00:00
2013-01-31 00:00:00
2013-03-26 00:00:00
2013-04-04 00:00:00
2013-04-30 00:00:00
2013-05-28 00:00:00
2013-07-02 00:00:00
2013-07-30 00:00:00
2013-08-29 00:00:00
2013-10-01 00:00:00
2013-12-04 00:00:00
2014-01-02 00:00:00
2014-02-04 00:00:00
2014-03-24 00:00:00
2014-04-03 00:00:00
2014-04-28 00:00:00
2014-05-29 00:00:00
2014-06-27 00:00:00
2014-07-29 00:00:00
2014-08-29 00:00:00
2014-09-29 00:00:00
2014-10-29 00:00:00
Spreadsheet: 40077d1238416861-sumif-unique-values-sample
Sheet: Sheet1

MANAGER | USER | TIME (s) |  |  | MANAGER | TOTAL
HUMPTY | MICKEY | 6076 |  |  | HUMPTY | 101648 | û
HUMPTY | MINNIE | 16940
HUMPTY | MINNIE | 16940 |  |  | HUMPTY | 56086 | ü
HUMPTY | DAFFY | 4448
HUMPTY | [NAME] | 10222
HUMPTY | [NAME] | 10222
HUMPTY | TWEETY | 18400
HUMPTY | TWEETY | 18400
Spreadsheet: 827494d1682739225-conditionally-skip-or-continue-auto-numbering-numbering-sheet
Sheet: Sheet1

[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | Krystal McLasky
[NAME] |  |  | Amanda Biele
Anand Liliah |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | Brenna Berenholz
[NAME] |  |  | [NAME]
Amanda Printon |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | Amanda Printon
[NAME] |  |  | [NAME]
[NAME] |  |  | Emely Cruz
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
Krystal McLasky |  |  | [NAME]
[NAME] |  |  | [NAME]
Emely Cruz |  |  | [NAME]
[NAME] |  |  | [NAME]
Amanda Biele |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | Anand Liliah
Brenna Berenholz |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
Rinkal Rana |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | Rinkal Rana
[NAME] |  |  | [NAME]
[NAME]
Spreadsheet: 291834d1390417129-user-cannot-add-rows-to-password-protected-table-addrowstoprotectedtable
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5
[NAME] | [NAME] | [NAME] | User Entry | User Entry
[NAME] | [NAME] | [NAME] | User Entry | User Entry
[NAME] | [NAME] | [NAME] | User Entry | User Entry
[NAME] | [NAME] | [NAME] | User Entry | User Entry
[NAME] | [NAME] | [NAME] | User Entry | User Entry
The Worksheet is protected like this: |  |  |  |  |  |  | Add Rows Grayed on Home/Insert |  |  |  |  |  | Add Rows Grayed on Context Menu
Spreadsheet: 783889d1655279036-pick-unique-values-from-column-list-count-fruit-aligw
Sheet: Sheet1

Order Date | Fruit | Quantity |  |  | Fruit | Quantity
2022-06-14 00:00:00 | Apple | 2 |  | 2022-06-14 00:00:00 | Apple | 5
2022-06-14 00:00:00 | Apple | 3 |  | 2022-06-14 00:00:00 | Orange | 4
2022-06-14 00:00:00 | Orange | 4 |  | 2022-06-13 00:00:00 | Apple | 2
2022-06-13 00:00:00 | Apple | 2 |  | 2022-06-12 00:00:00 | Apple | 4
2022-06-12 00:00:00 | Apple | 4 |  | 2022-06-12 00:00:00 | Orange | 3
2022-06-12 00:00:00 | Orange | 3 |  | 2022-06-11 00:00:00 | Apple | 1
2022-06-11 00:00:00 | Apple | 1 |  | 2022-06-10 00:00:00 | Apple | 5
2022-06-10 00:00:00 | Apple | 2
2022-06-10 00:00:00 | Apple | 3
Spreadsheet: 106905d1304041599-lookup-with-multiple-criteria-and-matches-example
Sheet: Sheet1

Transaction date | Inception date | Type | Amount | [NAME] | Result
28/07/2010 | 28/07/2010 | New | 30000 | 11 | 28/07/2010 | I need the match pair to follow New - with highest amount - and inception date
31/05/2010 | 01/02/2010 | Oth | -2000 | 11 | 28/07/2010
17/06/2010 | 17/06/2010 | [NAME] | 1000 | 11 | 28/07/2010
29/04/2010 | 29/04/2010 | [NAME] | 5000 | 12 | 29/04/2010 | If there is no New in the match pair - the date should follow [NAME] - with highest amount - and transaction date
24/02/2011 | [NAME] | Oth | 2000 | 12 | 29/04/2010
07/03/2011 | 07/03/2011 | Oth | 3000 | 12 | 29/04/2010
24/02/2011 | [NAME] | New | 5000 | 13 | 07/03/2011 | Follow New - highest amount - Inception date
07/03/2011 | 07/03/2011 | New | 80000 | 13 | 07/03/2011
23/07/2009 | 23/07/2009 | [NAME] | 200 | 13 | 07/03/2011
[NAME] | 01/11/2009 | New | -200 | 14 | 29/04/2010 | Follow New - since there's no positive amount for New - to follow the highest negative amount - inception date
29/04/2010 | 29/04/2010 | New | -50000 | 14 | 29/04/2010
24/02/2011 | [NAME] | [NAME] | 5000 | 14 | 29/04/2010
17/12/2008 | 15/08/2005 | Oth | 300 | 14 | 29/04/2010
07/03/2011 | 07/03/2011 | Oth | 2000 | 15 | 07/03/2011 | If there is no New or [NAME], follow the highest amount - transaction date
24/02/2011 | [NAME] | Oth | -200 | 15 | 07/03/2011
[NAME] | 01/11/2009 | [NAME] | -100000 | 16 | [NAME] | If there's no New, follow [NAME] transaction date - highest negative amount
29/04/2010 | 29/04/2010 | [NAME] | -20000 | 16 | [NAME]
24/02/2011 | [NAME] | Oth | 5000 | 16 | [NAME]
Criteria
1. Same match pair - to follow New (highest amount) Inception Date
2. If there's no New in the Match pair - to follow [NAME] (highest amount) Transaction date
3. If there is no New or [NAME] in the match pair - follow the Oth (highest amount) Transaction Date
Spreadsheet: 793989d1661843266-formula-to-find-row-number-book1
Sheet: Sheet1

 |  |  |  |  | Time |  | 08:00:00 |  | Expected Result
 |  |  |  |  | 02:05:00 |  |  |  | 11
 |  |  |  |  | 03:15:00
 |  |  |  |  | 03:55:00
 |  |  |  |  | 04:50:00
 |  |  |  |  | 06:50:00
 |  |  |  |  | 07:15:00
 |  |  |  |  | 08:45:00
 |  |  |  |  | 09:45:00
 |  |  |  |  | 10:25:00
 |  |  |  |  | 11:35:00
 |  |  |  |  | 12:15:00
 |  |  |  |  | 13:45:00
 |  |  |  |  | 14:10:00
 |  |  |  |  | 16:50:00
 |  |  |  |  | 17:45:00
 |  |  |  |  | 18:10:00
 |  |  |  |  | 19:35:00
 |  |  |  |  | 20:15:00