tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 755617d1636994736-matching-repetitive-numbers-that-are-in-sequential-order-ask-q-matching-nos-that-repeat
Sheet: Matching nos that repeat

 |  |  |  |  |  |  |  |  |  | Matching Numbers | Count | >0 Seq Order | >1 Seq Order |  | Data Set |  |  |  | No. of matching nos in 1st sequence
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 22 | 44 |  |  |  | Here we have formula to return the number of Matching numbers in sequential order appearing in the data set
 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  | 44 | 42 | 49 |  |  |  | In this example, there are four Matching numbers in sequential order (yellow highlighted), so the formular returns "4"
 |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  | 45 | 69 | 131
 |  |  |  |  |  |  |  |  |  | 69 |  |  |  |  | 67 | 44 | 81
 |  |  |  |  |  |  |  |  |  | 81 |  |  |  |  | 69 | 93 | 92 |  | No. of matching nos in 2nd sequence
 |  |  |  |  |  |  |  |  |  | 93 |  |  |  |  | 69 | 157 | 158
 |  |  |  |  |  |  |  |  |  | 101 |  |  |  |  | 165 | 101 | 56 |  | 3 |  | Some Matching numbers appear more than once in the Data Set. i.e., they repeat themselves
 |  |  |  |  |  |  |  |  |  | 133 |  |  |  |  | 88 | 130 | 133 |  |  |  | In this example: 44,69,81  (green highlighted) are the repetitive Matching numbers in sequential order
 |  |  |  |  |  |  |  |  |  | 210 |  |  |  |  | 210 | 81 | 141 |  |  |  | We like a formula to return the number of repetitive Matching numbers that are in sequential order
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Can this be done?
 |  |  |  |  |  |  |  |  |  |  | Answers ==>
Spreadsheet: 760674d1640379730-highlighting-items-in-a-column-that-add-up-to-a-variable-number-book1-etaf
Sheet: Sheet1

ITEM | COST |  |  |  | LOSS | 36.39
box cutter | 0.87
furniture mover | 1.01 |  |  |  | I WANT TO ENTER A DOLLAR AMOUNT OF LOST ITEMS IN G1.
pry tools 5 | 1.2 |  |  |  | THEN I WANT ITEMS IN A:B THAT ADD UP TO OR CLOSELY APPROACH
padlock | 1.85 |  |  |  | [NAME]. THAT WILL ALLOW ME TO SHOW SOMEONE
glove cut resistant | 2.8 |  |  |  | THAT 35 DOLLARS IN MISSING ITEMS IS THE SAME AS NOT ORDERING
claw flex spring | 4.2 |  |  |  | THIS OR THAT AMOUNT OF STUFF BECAUSE WE HAVE TO USE
magnet retreiving | 4.31 |  |  |  | BUDGETED FUNDS TO REPLACE THE LOST ITEMS FIRST.
lockout circuit breaker | 4.98
cup measuring | 4.99
jumper leads | 5.15 |  |  |  | FORMATTING IN A:B IS TO ILLUSTRATE HOW IT SHOULD LOOK WHEN A NUMBER
awl | 5.94 |  |  |  | IS ENTERED IN G1.
pencil with sharpener | 5.96
brush snake | 6.18
lifter suction cup | 6.49
blanket moving | 6.77
mirror inspection | 6.79
pliers channellock | 9.01
dryer vent brush | 14.14
bucket | 15.22
flashlight mini mag | 16.34
microwave microbar | 16.5
microwave leakage detector | 17.99
pliers [NAME] clamp | 18.28
leads fine point | 18.75
pliers ear | 23.45
bag tool | 29.63
cable [NAME] SVC;-,-,HOME APPLIANCE,-,-,- | 33.37
multimeter | 52.99
meter ESR | 54.94
dolly - hand truck multiposition | 64.95
Spreadsheet: 756158d1637313717-can-i-dynamically-reference-the-same-cell-across-multiple-worksheets-in-if-and-textjoin-therapists-availability-dj
Sheet: Consolidation

Time | Person | Monday | Tuesday | Wednesday | Thursday | Friday
07:30:00 | Person1 | e/o week | Weekly |  | Filled
08:15:00 | Person1 | Filled | Filled |  | Filled
09:00:00 | Person1 | Filled | Weekly |  | Filled
09:45:00 | Person1 | unavailable | unavailable |  | unavailable
10:30:00 | Person1 | unavailable | unavailable |  | unavailable
11:15:00 | Person1 | Filled | Filled |  | Weekly
12:00:00 | Person1 | unavailable | unavailable |  | unavailable
01:00:00 | Person1 | Filled | Filled |  | Filled
01:45:00 | Person1 | Weekly | Filled |  | e/o week
02:30:00 | Person1 | Filled | Filled |  | Filled
03:15:00 | Person1 | Filled | e/o week |  | Filled
04:00:00 | Person1 | Filled | Filled |  | Filled
04:45:00 | Person1 | Filled | Filled |  | Filled
05:30:00 | Person1 | Filled | Filled |  | Weekly
07:30:00 | Person2 | Weekly |  | Weekly | Filled | Weekly
08:15:00 | Person2 | Weekly |  | Filled | Filled | Filled
09:00:00 | Person2 | Filled |  | Weekly | Filled | Filled
09:45:00 | Person2 | Weekly |  | unavailable | unavailable | unavailable
10:30:00 | Person2 | Filled |  | unavailable | unavailable | unavailable
11:15:00 | Person2 | Filled |  | Filled | Weekly | Weekly
12:00:00 | Person2 | unavailable |  | unavailable | unavailable | unavailable
01:00:00 | Person2 | Filled |  | Filled | Filled | Weekly
01:45:00 | Person2 | Weekly |  | Filled | e/o week | e/o week
02:30:00 | Person2 | Filled |  | Filled | Filled | Filled
03:15:00 | Person2 | e/o week |  | e/o week | Filled | Filled
04:00:00 | Person2 | Filled |  | Filled | Filled | e/o week
04:45:00 | Person2 | Filled |  | Filled | Filled | Filled
05:30:00 | Person2 | Filled |  | Filled | Weekly | Weekly
07:30:00 | Person3 |  | e/o week | Weekly |  | Filled
08:15:00 | Person3 |  | Filled | Filled |  | Filled
09:00:00 | Person3 |  | Filled | Weekly |  | Filled
09:45:00 | Person3 |  | unavailable | unavailable |  | unavailable
10:30:00 | Person3 |  | unavailable | unavailable |  | unavailable
11:15:00 | Person3 |  | Filled | Filled |  | Weekly
12:00:00 | Person3 |  | unavailable | unavailable |  | unavailable
01:00:00 | Person3 |  | Filled | Filled |  | Filled
01:45:00 | Person3 |  | Weekly | Filled |  | e/o week
02:30:00 | Person3 |  | Filled | Filled |  | Filled
03:15:00 | Person3 |  | Filled | e/o week |  | Filled
04:00:00 | Person3 |  | Filled | Filled |  | Filled
04:45:00 | Person3 |  | Filled | Filled |  | Filled
05:30:00 | Person3 |  | Filled | Filled |  | Weekly
Spreadsheet: 699583d1602672369-trying-to-return-a-large-range-of-vlookup-based-on-dates-new-budget-sheet-2-2-
Sheet: Main Budget

PAY | Monthly BILLS | DUE DATES |  | Date | PAY | Bi-Weekly | TYPE
2600 | Mortgage (3755): | ([NAME]) Auto - 1st |  | 1 | 1300 | Mortgage (3755): | ([NAME]) Auto
90.98 | FuboTV | (6307 Discover) Auto - 3th |  | 3 | 90.98 | FuboTV | (6307 Discover) Auto
85 | FedLoan: | (Main Chase Checking) Auto - 4th |  | 4 | 85 | FedLoan: | (Main Chase Checking) Auto
13.93 | [NAME]: | (6307 Discover) Auto - 4th |  | 4 | 13.93 | [NAME]: | (6307 Discover) Auto
0 | Discover (6195): | 5th |  | 5 | 0 | Discover (6195):
0 | BlueCash CC (): | 7th |  | 7 | 0 | BlueCash CC ():
0 | SavorOne (4972): | 8th |  | 8 | 0 | SavorOne (4972):
493.18 | Ascent: | (Main Chase Checking) Auto - 9th |  | 9 | 493.18 | Ascent: | (Main Chase Checking) Auto
250 | WJ Utilities: | (9486 Chase Credit) Auto - 10th |  | 10 | 250 | WJ Utilities: | (9486 Chase Credit) Auto
76 | Dominion Gas: | (Main Chase Checking) Auto - 12th |  | 12 | 76 | Dominion Gas: | (Main Chase Checking) Auto
65.16 | Auto Ins: | (6307 Discover) Auto - 16th |  | 16 | 65.16 | Auto Ins: | (6307 Discover) Auto
0 | Citi CC (3588): | 21st |  | 21 | 0 | Citi CC (3588):
0 | Chase Freedom CC (9486): | 21st |  | 21 | 0 | Chase Freedom CC (9486):
50.5 | Xfinity Internet: | (6307 Discover) Auto - 21st |  | 21 | 50.5 | Xfinity Internet: | (6307 Discover) Auto
140 | Rocky Power: | (Main Chase Checking) Auto - 29th |  | 29 | 140 | Rocky Power: | (Main Chase Checking) Auto
5.35 | Apple Music: | (6307 Discover) Auto - 29th |  | 29 | 5.35 | Apple Music: | (6307 Discover) Auto
140 | Koda School: | ([NAME]) - 30th |  | 30 | 140 | Koda School: | [NAME]
1000 | Groceries (9786): |  |  |  | 500 | Groceries (9786):
180 | Gas (5138): |  |  |  | 90 | Gas (5138):
60 | Medical (9809): |  |  |  | 30 | Medical (9809):
300 | Shopping (9122): |  |  |  | 150 | Shopping (9122):
300 | Date Night (9528): |  |  |  | 150 | Date Night (9528):
0 | Extra (5321): |  |  |  | 0 | Extra (5321):
0 | [NAME] (6560): |  |  |  | 0 | [NAME] (6560):
0.1 | Tithing (5989): |  |  |  | 0.1 | Tithing (5989):
50 | [NAME] (0528): |  |  |  | 25 | [NAME] (0528):
50 | [NAME] (9927): |  |  |  | 25 | [NAME] (9927):
50 | Kenai Sav (0846): |  |  |  | 25 | Kenai Sav (0846):
20 | Emergency Sav (1501): |  |  |  | 10 | Emergency Sav (1501):
0 | Debts (0179): |  |  |  | 0 | Debts (0179):
 | TOTAL: |  |  |  |  | TOTAL:
Spreadsheet: 161234d1339451156-pivot-table-question-finding-percentages-of-counts-sample-pivot
Sheet: Sample Pivot

 | Values
Row Labels | Sum of Count | Sum of Money | Average of Reaction Time
00:00:00 | 4 | 2278 | 9120.75
[NAME] | 2 | 1103 | 9659
Moe | 2 | 1175 | 8582.5
01:00:00 | 3 | 2007 | 5283
[NAME] | 1 | 698 | 2032
Moe | 1 | 413 | 7594
[NAME] | 1 | 896 | 6223
02:00:00 | 2 | 1787 | 5319.5
[NAME] | 1 | 903 | 6813
[NAME] | 1 | 884 | 3826
03:00:00 | 4 | 2644 | 14128.25
[NAME] | 3 | 1810 | 13479.33333333333
[NAME] | 1 | 834 | 16075
04:00:00 | 5 | 2607 | 11923.2
[NAME] | 2 | 1133 | 10771 |  |  | 5
Greg | 1 | 655 | 12037
Moe | 1 | 292 | 8092
[NAME] | 1 | 527 | 17945
05:00:00 | 4 | 1418 | 9259.25
Greg | 3 | 1323 | 8330
[NAME] | 1 | 95 | 12047
06:00:00 | 4 | 1287 | 7055.75
Greg | 3 | 1224 | 8964.333333333334
[NAME] | 1 | 63 | 1330
07:00:00 | 4 | 1541 | 9920
Greg | 2 | 848 | 12303
[NAME] | 2 | 693 | 7537
08:00:00 | 6 | 1911 | 10202.33333333333
[NAME] | 3 | 1778 | 10598
[NAME] | 2 | 90 | 5529
[NAME] | 1 | 43 | 18362
09:00:00 | 5 | 2149 | 8326.2
[NAME] | 1 | 127 | 1738
Greg | 1 | 360 | 18855
[NAME] | 1 | 891 | 4936
Moe | 2 | 771 | 8051
10:00:00 | 4 | 1527 | 9443.5
[NAME] | 1 | 360 | 2887
Greg | 2 | 643 | 14579
[NAME] | 1 | 524 | 5729
11:00:00 | 3 | 1256 | 13229.66666666667
[NAME] | 1 | 186 | 9508
Moe | 1 | 942 | 19391
[NAME] | 1 | 128 | 10790
12:00:00 | 4 | 1618 | 12776
[NAME] | 1 | 13 | 6765
[NAME] | 2 | 828 | 16393.5
[NAME] | 1 | 777 | 11552
13:00:00 | 3 | 2058 | 14828.66666666667
[NAME] | 2 | 1635 | 15308
Greg | 1 | 423 | 13870
14:00:00 | 4 | 2837 | 7482.75
[NAME] | 2 | 1261 | 7897
[NAME] | 1 | 942 | 8756
[NAME] | 1 | 634 | 5381
15:00:00 | 1 | 434 | 12272
[NAME] | 1 | 434 | 12272
16:00:00 | 4 | 1686 | 8122.5
Greg | 1 | 975 | 8216
[NAME] | 3 | 711 | 8091.333333333333
17:00:00 | 1 | 913 | 1067
[NAME] | 1 | 913 | 1067
18:00:00 | 4 | 1626 | 11585.5
[NAME] | 2 | 1034 | 10743.5
[NAME] | 1 | 85 | 9844
Moe | 1 | 507 | 15011
19:00:00 | 2 | 933 | 7361.5
[NAME] | 2 | 933 | 7361.5
20:00:00 | 1 | 777 | 18455
Moe | 1 | 777 | 18455
21:00:00 | 4 | 2015 | 8764.75
[NAME] | 1 | 615 | 12499
[NAME] | 1 | 955 | 4023
Moe | 1 | 368 | 16484
[NAME] | 1 | 77 | 2053
22:00:00 | 2 | 1433 | 5934
[NAME] | 1 | 597 | 10352
Greg | 1 | 836 | 1516
23:00:00 | 6 | 3986 | 12397.83333333333
[NAME] | 1 | 608 | 9023
Greg | 3 | 1995 | 10716.66666666667
[NAME] | 1 | 616 | 19153
Moe | 1 | 767 | 14061
Grand Total | 84 | 42728 | 9958.714285714286
Spreadsheet: 152429d1335378269-word-search-copy-of-word-search
Sheet: table

make | model | eed# | Desc |  | make | model | eed# | Desc |  | make | model | eed# | Desc
WWFK1 | BB14 | 11223344 | Welk For night Black 14" |  | WWFK9 |  |  |  |  | WWFK9 | BB22 | 11223352 | Welk For night Black 22"
WWFK2 | BB15 | 11223345 | Welk For night Black 15"
WWFK3 | BB16 | 11223346 | Welk For night Black 16"
WWFK4 | BB17 | 11223347 | Welk For night Black 17"
WWFK5 | BB18 | 11223348 | Welk For night Black 18"
WWFK6 | BB19 | 11223349 | Welk For night Black 19"
WWFK7 | BB20 | 11223350 | Welk For night Black 20"
[NAME] | BB21 | 11223351 | Welk For night Black 21"
WWFK9 | BB22 | 11223352 | Welk For night Black 22"
WWFK10 | BB23 | 11223353 | Welk For night Black 23"
WWFK11 | BB24 | 11223354 | Welk For night Black 24"
Spreadsheet: 696552d1600878754-trying-to-use-the-date-in-an-if-function-with-vlookup-to-retain-previous-days-scheduled-minutes-example
Sheet: Scheduled Minutes

Name | Location |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
 |  | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00 | 2020-09-09 00:00:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00 | 2020-09-14 00:00:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | 2020-09-17 00:00:00 | 2020-09-18 00:00:00 | 2020-09-21 00:00:00 | 2020-09-22 00:00:00 | 2020-09-23 00:00:00 | 2020-09-24 00:00:00 | 2020-09-25 00:00:00 | 2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2020-09-30 00:00:00
Grand Total
Spreadsheet: 539864d1506412103-sum-using-multipul-vookup-mz-sales-budget-plan-2018-working
Sheet: MZ Sales

MZ Sales Total | Plan FY | Actual YTD | [NAME] | 4Q OL | [NAME] | [NAME]
[PHONE] SHOPPING TRIPS | 0 | 22100
[PHONE] STAFF MEETINGS,ENTT | 250000 | 152296
[PHONE] RENT | 3071000 | 2100714
[PHONE] UTILITIES | 730000 | 693465
[PHONE] OFFICE RENT/UPKEEP | 35000 | 25463
[PHONE] OFF M&R-MATRILALS | 34000 | 40844
[PHONE] OFFICE M&R CONTR OUT | 996000 | 893414
[PHONE] OTH-REPAIRS/MAINT | 188000 | 143279
[PHONE] GH RENT RECOVERY | 0 | 48000
[PHONE] PRINTING/STATIONERY | 36000 | 25091
[PHONE] BOOKS PERIODICALS | 40000 | 21385
[PHONE] NON-CAP FURN/EQP | 70000 | 38298
[PHONE] OFF FUR/EQP RENTAL | 6000 | 3000
[PHONE] OFF FURN/EQP M&R | 65000 | 70238
[PHONE] COMPUTER MAINT | 30000 | 29690
[PHONE] REPRODUCTION CHG | 30000 | 16365
[PHONE] UPS MAINT. | 12000 | 0
[PHONE] POSTAGE CHG | 150000 | 130772
[PHONE] TELEPHONES CHG | 369000 | 382552
[PHONE] FAX CHARGES | 3000 | 0
[PHONE] INTERNET FIXED MNT | 13000 | 2300
[PHONE] INTERNET USAG CHG | 200000 | 196313
[PHONE] RECOV FOR PVT.TEL | -4000 | -21087
[PHONE] DATA COMM LINK | 750000 | 548505
[PHONE] LOCAL-BUSS TRAVEL | 995000 | 873536
[PHONE] REGIS & TAXES | 47000 | 44810
[PHONE] POL & SERVICES | 1952000 | 1462664.92
[PHONE] REP  PARTS & ACCESS | 196000 | 174427
[PHONE] PRIVATR MILEAGE | -313000 | -419772
[PHONE] HIRED VEHICLES | 30000 | 98304
[PHONE] OTH-VEH-TRAV EXP | 0 | 300
[PHONE] OTHERS-GR/PR EXP. | 120000 | 15910
[PHONE] BUS. MEETING & ENT. | 274000 | 203137
[PHONE] OTH PURCHASE SERVICE | 700000 | 233186.2
[PHONE] INSURANCE EXPENSE | 0 | 560.42
[PHONE] INSURANCE EXPENSE MA | 0 | 4063
[PHONE] BANK CHARGES | 15000 | 3400
[PHONE] TAXES STAMPS & LICS | 80000 | 101615
Spreadsheet: 97071d1296260701-excel-2007-conditional-formatting-multiple-sheets-test
Sheet: Results

Competitor No: |  |  |  |  | Time Penalties
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
Spreadsheet: 368eb37c-7fac-4c9b-b56b-5568ae228bfe
Sheet: ID-CPA-018

 |  |  |  | Prescribed Grazing - 528 |  |  |  |  |  |  |  |  |  |  | ID-CPA-018
 |  |  |  | Upland Wildlife Habitat Management - 645
 |  |  |  | Gap Intercept |  |  |  |  |  |  |  |  |  |  | Idaho
Natural Resources Conservation Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January 2014
Monitoring Plot: |  |  |  | Line: |  |  |  | Date:
Data Collectors: |  |  |  |  |  |  |  | Line Length: |  |  | ft | Page |  | of
Conservationist:
Canopy gaps:  Minimum size = |  |  |  |  |  | ft |  | Basal gaps:  Minimum size = |  |  |  |  |  |  | ft
Starts | Ends | [NAME] (ft) | 1.0-2 | 2.1 - 3 | 3.1-6 | >6 |  | Starts |  | Ends | [NAME] (ft) | 1.0-2 | 2.1 - 3 | 3.1-6 | >6
SUM (ft) |  |  |  |  |  |  |  | SUM (ft)
LINE LENGTH (ft) |  |  |  |  |  |  |  | LINE LENGTH (ft)
SUM ÷ LINE LENGTH |  |  |  |  |  |  |  | SUM ÷ LINE LENGTH
% of line by canopy gap size |  |  |  |  |  |  |  | % of line by basal gap size
Spreadsheet: 1b495d7a-91ba-499b-81af-30a884beab40
Sheet: Sheet1

Table 1.1: Population etimates by age groups, nationality, residence and sex in Egypt,  2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Nationals |  | Non- Nationals |  | Urban |  | Rural |  | Total
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 4282316 | 4071818 | ... | ... | 1613963 | 1538701 | 2668353 | 2533117 | 4282316 | 4071818 | 8354134
5-9 | 4265412 | 4007172 | ... | ... | 1658136 | 1567766 | 2607276 | 2439406 | 4265412 | 4007172 | 8272584
10-14 | 4330443 | 4023320 | ... | ... | 1650222 | 1547350 | 2680221 | 2475970 | 4330443 | 4023320 | 8353763
15-19 | 4738218 | 4500674 | ... | ... | 1914006 | 1847308 | 2824212 | 2653366 | 4738218 | 4500674 | 9238892
20-24 | 4358058 | 4155045 | ... | ... | 1883403 | 1858929 | 2474655 | 2296116 | 4358058 | 4155045 | 8513103
25-29 | 3411636 | 3498432 | ... | ... | 1493576 | 1558600 | 1918060 | 1939832 | 3411636 | 3498432 | 6910068
30-34 | 2613911 | 2502494 | ... | ... | 1185148 | 1152912 | 1428763 | 1349582 | 2613911 | 2502494 | 5116405
35-39 | 2498485 | 2535871 | ... | ... | 1124866 | 1119158 | 1373619 | 1416713 | 2498485 | 2535871 | 5034356
40-44 | 2236659 | 2186333 | ... | ... | 1050210 | 1041440 | 1186449 | 1144893 | 2236659 | 2186333 | 4422992
45-49 | 2029328 | 1941694 | ... | ... | 959754 | 921826 | 1069574 | 1019868 | 2029328 | 1941694 | 3971022
50-54 | 1667511 | 1639886 | ... | ... | 849355 | 821918 | 818156 | 817968 | 1667511 | 1639886 | 3307397
55-59 | 1312016 | 1135920 | ... | ... | 639304 | 551518 | 672712 | 584402 | 1312016 | 1135920 | 2447936
60-64 | 971087 | 871006 | ... | ... | 524548 | 435464 | 446539 | 435542 | 971087 | 871006 | 1842093
65-69 | 692772 | 597495 | ... | ... | 331613 | 252281 | 361159 | 345214 | 692772 | 597495 | 1290267
70-74 | 434889 | 418810 | ... | ... | 211403 | 186224 | 223486 | 232586 | 434889 | 418810 | 853699
75+ | 407699 | 391919 | ... | ... | 181063 | 161226 | 226636 | 230693 | 407699 | 391919 | 799618
Not stated | … | … | … | … | … | … | … | … | … | … | …
Total | 40250440 | 38477889 | ... | ... | 17270570 | 16562621 | 22979870 | 21915268 | 40250440 | 38477889 | 78728329
Spreadsheet: 828880d1683780612-filter-formula-but-only-return-certain-columns-sample24
Sheet: Sheet1

 | LOAD # | SHIPPER | DRIVER | [NAME] | PAY | SHIFT
 | 1 | [NAME] | [NAME] | 400 | 1500 | SHIFT 1
 | 2 | X91 | PHIL | 500 | 1900 | SHIFT 2
 | 3 | X002 | TOM | 490 | 2200 | SHIFT 5
 | 4 | 3XL | [NAME] | 412 | 1500 | SHIFT 4
 | 5 | 3XL | [NAME] | 902 | 3400 | SHIFT 1
 | 6 | X91 | CHUCK | 910 | 3250 | SHIFT 3
 | SEARCH | 4
 | LOAD # | SHIPPER | [NAME] | PAY
 |  | 3XL | 412 | 1500 |  |  | 3XL | 412 | 1500
Spreadsheet: 114062d1309926000-formula-to-create-a-random-date-essay-practice-schedule-1-
Sheet: Sheet1

Exam / Year / Question | Question | Date
July 2001 / 1 |  | 2011-07-11 00:00:00
July 2001 / 2 |  | 2011-07-11 00:00:00
July 2001 / 3 |  | 2011-07-11 00:00:00
July 2001 / 4 |  | 2012-07-12 00:00:00
July 2001 / 5 |  | 2012-07-12 00:00:00
July 2001 / 6 |  | 2012-07-12 00:00:00
Feb 2002 / 1 |  | 2011-07-13 00:00:00
Feb 2002 / 2 |  | 2011-07-13 00:00:00
Feb 2002 / 3 |  | 2011-07-13 00:00:00
Feb 2002 / 4 |  | 2011-07-14 00:00:00
Feb 2002 / 5 |  | 2011-07-14 00:00:00
Feb 2002 / 6 |  | 2011-07-14 00:00:00
July 2002 / 1 |  | 2011-07-15 00:00:00
July 2002 / 2 |  | 2011-07-15 00:00:00
July 2002 / 3 |  | 2011-07-15 00:00:00
July 2002 / 4 |  | 2011-07-16 00:00:00
July 2002 / 5 |  | 2011-07-16 00:00:00
July 2002 / 6 |  | 2011-07-16 00:00:00
July 2003 / 1 |  | 2011-07-17 00:00:00
July 2003 / 2 |  | 2011-07-17 00:00:00
July 2003 / 3 |  | 2011-07-17 00:00:00
July 2003 / 4 |  | 2011-07-18 00:00:00
July 2003 / 5 |  | 2011-07-18 00:00:00
July 2003 / 6 |  | 2011-07-18 00:00:00
Feb 2004 / 1 |  | 2011-07-19 00:00:00
Feb 2004 / 2 |  | 2011-07-19 00:00:00
Feb 2004 / 3 |  | 2011-07-19 00:00:00
Feb 2004 / 4 |  | 2011-07-20 00:00:00
Feb 2004 / 5 |  | 2011-07-20 00:00:00
Feb 2004 / 6 |  | 2011-07-20 00:00:00
July 2004 / 1 |  | 2011-07-21 00:00:00
July 2004 / 2 |  | 2011-07-21 00:00:00
July 2004 / 3 |  | 2011-07-21 00:00:00
July 2004 / 4 |  | 2011-07-22 00:00:00
July 2004 / 5 |  | 2011-07-22 00:00:00
July 2004 / 6 |  | 2011-07-22 00:00:00
Feb 2005 / 1 |  | 2011-07-23 00:00:00
Feb 2005 / 2 |  | 2011-07-23 00:00:00
Feb 2005 / 3 |  | 2011-07-23 00:00:00
Feb 2005 / 4 |  | 2011-07-24 00:00:00
Feb 2005 / 5 |  | 2011-07-24 00:00:00
Feb 2005 / 6 |  | 2011-07-24 00:00:00
July 2006 / 1 |  | 2011-07-25 00:00:00
July 2006 / 2 |  | 2011-07-25 00:00:00
July 2006 / 3 |  | 2011-07-25 00:00:00
July 2006 / 4
July 2006 / 5
July 2006 / 6
Feb 2007 / 1
Feb 2007 / 2
Feb 2007 / 3
Feb 2007 / 4
Feb 2007 / 5
Feb 2007 / 6
July 2007 / 1
July 2007 / 2
July 2007 / 3
July 2007 / 4
July 2007 / 5
July 2007 / 6
Feb 2008 / 1
Feb 2008 / 2
Feb 2008 / 3
Feb 2008 / 4
Feb 2008 / 5
Feb 2008 / 6
July 2008 / 1
July 2008 / 2
July 2008 / 3
July 2008 / 4
July 2008 / 5
July 2008 / 6
Feb 2009 / 1
Feb 2009 / 2
Feb 2009 / 3
Feb 2009 / 4
Feb 2009 / 5
Feb 2009 / 6
July 2009 / 1
July 2009 / 2
July 2009 / 3
July 2009 / 4
July 2009 / 5
July 2009 / 6
Feb 2010 / 1
Feb 2010 / 2
Feb 2010 / 3
Feb 2010 / 4
Feb 2010 / 5
Feb 2010 / 6
July 2010 / 1
July 2010 / 2
July 2010 / 3
July 2010 / 4
July 2010 / 5
July 2010 / 6
Feb 2011 / 1
Feb 2011 / 2
Feb 2011 / 3
Feb 2011 / 4
Feb 2011 / 5
Feb 2011 / 6
Spreadsheet: 766142d1643780948-counting-merged-cells-or-making-identical-cells-appear-as-if-merged-copy-of-schedule-example
Sheet: Sheet1 (2)

 |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Manually merged and centered. Possible to properly count? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count AAA | Count BBB | Count CCC
 | Work unit #1 |  | AAA job description |  |  |  |  |  |  | . | . | . | BBB job description |  |  |  | . | . | CCC job description
Identical values in each cell, calculations like countifs work. Possible to make it appear merged?
 | Work unit #2 |  | AAA job description | AAA job description |  | BBB job description | BBB job description | BBB job description | BBB job description | BBB job description |  | CCC job description | CCC job description | CCC job description |  |  | BBB job description | BBB job description | BBB job description
Spreadsheet: 819388d1677483439-generate-table-from-table-with-random-in-mind-test_v2
Sheet: Sheet1

Article | Amount |  | Document | A | B | C | D | E
A | 29 |  | 1
B | 30 |  | 2
C | 25 |  | 3
D | 15 |  | 4
E | 10 |  | 5
Spreadsheet: 781934d1653651898-formula-needed-to-get-course-dates-per-employee-course-dates
Sheet: Sheet1

 | Attendees per Course
 | Course1 | Course2 | Course3 | Course1 | Course2 | Course3 | Course1 | Course2 | Course3
 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-01-15 00:00:00 | 2022-02-15 00:00:00 | 2022-03-15 00:00:00 | 2022-01-28 00:00:00 | 2022-02-28 00:00:00 | 2022-03-28 00:00:00
 | [NAME] | [NAME] | [NAME] | Callum | [NAME] | [NAME] | Derek | [NAME] | Callum
 | [NAME] | Callum | Derek |  | Derek |  | [NAME] |  | [NAME]
 | Course Schedule per Employee
 |  | Course1 | Course2 | Course3
 | [NAME] | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
 | [NAME] | 2022-01-01 00:00:00 | 2022-02-15 00:00:00 | 2022-03-15 00:00:00
 | Callum | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-03-28 00:00:00 |  | [NAME] needed to get dates
 | Derek | 2022-01-28 00:00:00 | 2022-02-15 00:00:00 | 2022-03-01 00:00:00
 | [NAME] | 2022-01-28 00:00:00 | 2022-02-28 00:00:00 | 2022-03-28 00:00:00
Spreadsheet: 144721d1331117482-hyperlink-vlookup-copying-different-columns-by-order-from-hyperlink-doc-to-another-m_oioisju1
Sheet: Sheet1

1 | 0512-15 | 200 | 200 | 20 |  | 2500 | TF |  | 0.8 | 2012-03-02 00:00:00 | 37 | 2012-03-02 00:00:00 | KIR
2 | 1112-14 | 180 | 100 | 100 |  | 5800 | TF |  | 1.8 | 2012-03-06 00:00:00 | 75 | 2012-03-07 00:00:00 | F-KA
3 | 0112-25 | 150 | 140 | 25 |  | 1700 | TD |  | 0.525 | 2012-03-03 00:00:00 | 77 | 2012-03-06 00:00:00 | F-KA
Spreadsheet: 820253d1677954084-highlight-based-on-two-criteria-dual-condition-highlighting
Sheet: Sheet1

First | Last
[NAME] | Doe
[NAME] | Parker | It's a match
[NAME] | Parker | It's a match
Mister | Peanut
[NAME] | Smith | We have another [NAME], but not [NAME]
[NAME] | Smith | We have another [NAME] and another Smith, but not [NAME]
[NAME] | Teller | These are different Tellers - no highlighting
[NAME] | Teller | These are different Tellers - no highlighting