tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 793398d1661445336-looking-for-help-on-min-function-returning-wrong-value-exceltest2
Sheet: Sheet1

ID | CreatedDateTime |  | LeadID | Earliest Date
00Q5G00000a2BUP | 16/02/2022 4:21 PM |  | 00Q5G00000a2BUP
00Q5G00000a2C5A | 11/02/2022 4:21 PM |  | 00Q5G00000a2C5A
00Q5G00000a2kHI | 21/06/2022 12:01 PM |  | 00Q5G00000a2kHI
00Q5G00000a2m5v | 07/04/2022 10:51 AM |  | 00Q5G00000a2m5v
00Q5G00000a2mdW | 21/03/2022 10:45 AM |  | 00Q5G00000a2mdW
00Q5G00000a2wTy | 27/05/2022 9:53 AM |  | 00Q5G00000a2wTy
00Q5G00000a3fag | 01/04/2022 12:03 PM |  | 00Q5G00000a3fag
00Q5G00000a3fag | 01/04/2022 12:03 PM |  | 00Q5G00000a3oVM
00Q5G00000a3fag | 05/04/2022 2:00 PM |  | 00Q5G00000a3oXI
00Q5G00000a3fag | 07/04/2022 10:38 AM |  | 00Q5G00000a3pci
00Q5G00000a3fag | 07/04/2022 10:39 AM |  | 00Q5G00000a3ppT
00Q5G00000a3fag | 11/04/2022 9:53 AM |  | 00Q5G00000a3qh8
00Q5G00000a3fag | 12/04/2022 1:01 PM |  | 00Q5G00000a3tVV
00Q5G00000a3fag | 14/04/2022 3:01 PM |  | 00Q5G00000a3twH
00Q5G00000a3fag | 18/04/2022 1:51 PM |  | 00Q5G00000a3uiw
00Q5G00000a3fag | 26/04/2022 4:38 PM |  | 00Q5G00000a41fC
00Q5G00000a3fag | 26/04/2022 4:40 PM |  | 00Q5G00000a4DVS
00Q5G00000a3fag | 26/04/2022 4:40 PM |  | 00Q5G00000a4Lbw
00Q5G00000a3fag | 28/04/2022 4:36 PM |  | 00Q5G00000a5HW9
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 44785 | 0 | 25079
Cross-Currency Fixed-Fixed | 0 | 447 | 0 | 457
Cross-Currency Fixed-Float | 0 | 12638 | 0 | 5713
TOTAL | -
Spreadsheet: 684787d1593535217-calculate-increase-by-date-range-with-multiple-worksheets-attempt-v1
Sheet: Report

Goal Met | 2020-06-29 00:00:00 | 2020-07-13 00:00:00 | 2020-07-27 00:00:00 | 2020-08-10 00:00:00 | 2020-08-24 00:00:00 | 2020-09-07 00:00:00 | 2020-09-21 00:00:00 | 2020-10-05 00:00:00 | 2020-10-19 00:00:00 | 2020-11-02 00:00:00 | 2020-11-16 00:00:00 | 2020-11-30 00:00:00 | 2020-12-14 00:00:00 | 2020-12-28 00:00:00 | 2021-01-11 00:00:00 | 2021-01-25 00:00:00 | 2021-02-08 00:00:00 | 2021-02-22 00:00:00 | 2021-03-08 00:00:00 | 2021-03-22 00:00:00 | 2021-04-05 00:00:00 | 2021-04-19 00:00:00 | 2021-05-03 00:00:00 | 2021-05-17 00:00:00 | 2021-05-31 00:00:00 | 2021-06-14 00:00:00 | 2021-06-28 00:00:00
Goal Not Met | 2020-07-10 00:00:00 | 2020-07-24 00:00:00 | 2020-08-07 00:00:00 | 2020-08-21 00:00:00 | 2020-09-04 00:00:00 | 2020-09-18 00:00:00 | 2020-10-02 00:00:00 | 2020-10-16 00:00:00 | 2020-10-30 00:00:00 | 2020-11-13 00:00:00 | 2020-11-27 00:00:00 | 2020-12-11 00:00:00 | 2020-12-25 00:00:00 | 2021-01-08 00:00:00 | 2021-01-22 00:00:00 | 2021-02-05 00:00:00 | 2021-02-19 00:00:00 | 2021-03-05 00:00:00 | 2021-03-19 00:00:00 | 2021-04-02 00:00:00 | 2021-04-16 00:00:00 | 2021-04-30 00:00:00 | 2021-05-14 00:00:00 | 2021-05-28 00:00:00 | 2021-06-11 00:00:00 | 2021-06-25 00:00:00 | 2021-07-09 00:00:00
Facility | BW1 | BW2 | BW3 | BW4 | BW5 | BW6 | BW7 | BW8 | BW9 | BW10 | BW11 | BW12 | BW13 | BW14 | BW15 | BW16 | BW17 | BW18 | BW19 | BW20 | BW21 | BW22 | BW23 | BW24 | BW25 | BW26 | BW27
Aventura
Highlands
[NAME]
[NAME]
Kendall
Lawnwood
Mercy
Northwest
PalmWest
Plantation
[NAME]
St Lucie
University
Westside
Yes
Spreadsheet: 117905d1313203246-latest-date-with-qualifications-last-date
Sheet: Sheet1

Date | 1st Common | 2nd Common | Date | 1st Common | 2nd Common | Date | 1st Common | 2nd Common | Date | 1st Common | 2nd Common | Date | 1st Common | 2nd Common | Date | 1st Common | 2nd Common |  | 1st Common | 2nd Common
2011-01-05 00:00:00 | X |  | 2011-02-17 00:00:00 |  | X | 2011-06-05 00:00:00 | X |  | 2011-04-02 00:00:00 |  | X | 2011-04-17 00:00:00 | X |  | 2011-05-01 00:00:00 |  | X
Spreadsheet: 774670d1648604713-golf-score-averaging-average-golf-scores
Sheet: Sheet1

Averaging Golf Score
Name | Last Rd | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Average
[NAME] | 85 | 85 | 87 | 93 | 96 | 88 | 90 | 88
[NAME] | 101 | 101 | 105 | 95 | 98 | 93 | 100 | 110
[NAME] | 79 | 79 | 88 | 77 | 76 | 74 | 79 | 76
Walter | 82 | 82 | 81 | 80 | 82 | 82 | 81 | 82
Fred | 79 | 79 | 85 | 95 | 100 | 83 | 104 | 98
Each time we play around of golf, we keep our last 7 rounds and average out our score.
I manually input the last score in column B.
I then manually copy and paste from C4 to H4 into D4.  What this does is to move the scores over to the right and dropping the oldest score out.
Questions: | 1. Can the copying & pasting happen automatically when I input a score in column B?  Is there a formula that can do this?
 | 2. In column J, can it average only the 5 scores and drop the lowest & highest score?  Looking formula the remove the highest & lowest?
 | 3. Also looking to add in column K, if theres a way it can put rate the lowest to highest score with a 1 to 5 automatically after inputing the scores?
Spreadsheet: 676642d1588907309-if-question-tough-one-pretty-convoluted-master-co-log
Sheet: CO Log

 |  |  |  |  |  |  |  |  |  | Wade Metal Products Change Order Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change Order Summary
 |  |  |  |  |  |  |  |  |  | Structural • Miscellaneous • Architectural • Ornamental Metals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base Contract:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Issued Change Orders:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Contract Amount:
 |  |  |  |  |  |  |  |  |  |  |  |  | Contractor: | Webcore |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contractor PM:
 |  |  |  |  |  |  |  |  |  |  |  |  | Project: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pending change orders:
 |  |  |  |  |  |  |  |  |  |  |  |  | Location: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Priced:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Credits:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contractor job No: |  |  |  |  |  |  |  |  |  |  |  |  |  | Wade PM: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Voided:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wade job No: |  |  |  |  |  |  |  |  |  |  |  |  |  | Phone: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priced: |  |  |  |  |  | Credits: |  |  |  |  |  | Issued:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not priced: |  |  |  |  |  | Voided: |  |  |  |  |  | Pending:
Wade C/O |  |  | Rev No. |  | Status |  |  |  | G.C.    C/O |  |  | Date [NAME] |  |  |  | RFI / Reference |  |  |  |  |  |  |  |  | Change Order Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date C/O Sent |  |  |  | [NAME]
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
26
27
28
29
30
31
32
Wade C/O |  |  | Rev No. |  | Status |  |  |  | G.C.    C/O |  |  | Date [NAME] |  |  |  | RFI / Reference |  |  |  |  |  |  |  |  | Change Order Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date C/O Sent |  |  |  | [NAME]
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
76
77
Spreadsheet: 824533d1680642562-how-to-add-formula-to-show-bank-holiday-book1
Sheet: Sheet1

 | 2023
 | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 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 | 26 | 27 | 28 | 29 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 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 | 26 | 27 | 28 | 29 | 30 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 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 | 26 | 27 | 28 | 29 | 30 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 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 | 26 | 27 | 28 | 29 | 30 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 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 | 26 | 27 | 28 | 29 | 30 | 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 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 155009d1336651250-simple-if-formua-for-searching-for-a-word-in-a-cell-book1
Sheet: Sheet1

String |  | Result |  |  |  | Words to find
its a beautiful day | now | now |  |  |  | beautiful
its a dark night | now | now |  |  |  | day
its a beautiful day | now | now |  |  |  | night
its cold today | now
its a cold wind | now
its a beautiful sky | now | now
it was a cold night and a beautiful day | yesterday | yesterday
Spreadsheet: ca5bda17-3cb9-429f-a5cf-5c6ce40a4a17
Sheet: Sheet1

Table S1-1: Primer sequences for genotyping T-DNA mutant insertions | Unnamed: 1 | Unnamed: 2
T-DNA insertion | primer | sequence  5’ > 3’
cdka;1 | J504-Salk_LB | GCGTGGACCGCTTGCTGCAACTCTCTCAGG
 | SALK_106809LP | TTTGGCTGGCTGCATTCCTTA
fbl17 | FBL17 T-DNA | ATATTGACCATCATACTCATTGC
 | FBL17R | CAGATGTTCAAGGGATTACC
rbr1-2 | J504-SALK_LB | GCGTGGACCGCTTGCTGCAACTCTCTCAGG
 | RBR1-2R | GTGGTTGCTTCCGGTAGTTG
e2fa | E2FA T-DNA | CCCATTTGGACGTGAATGTAGACAC
 | E2FAF1 | TTCCAGGTCTGTCTTTCCTATTTC
krp1 | [NAME] T-DNA | ATTTTGCCGATTTCGGAAC
 | KRP1F2 | GTTTCGTCGTCTTGTAGTGG
krp2 | KRP2 T-DNA | ATTTTGCCGATTTCGGAAC
 | KRP2 R1 | AGACTCTTCCTTAACCTGCGG
krp3 | KRP3 T-DNA | AACGTCCGCAATGTGTTATTAAGTTGTC
 | KRP3F1 | TCAAACCAAAACCAAACATCC
krp4 | KRP4 T-DNA | TAGCATCTGAATTTCATAACCAATCTCGATACAC
 | KRP4F1 | TGGGTTTGTTTATGTCAAAAGC
[NAME] | KRP5 T-DNA | ATTTTGCCGATTTCGGAAC
 | [NAME] | CCAGAAAACAGCAGAAGCAAC
krp6 | [NAME] T-DNA | TAGCATCTGAATTTCATAACCAATCTCGATACAC
 | KRP6 RP | ATTCATCACCGGACTCTCATG
krp7 | KRP7 T-DNA | ATATTGACCATCATACTCATTGC
 | KRP7R2 | AAGTCATCAAGCTCTGCCTG
Wild type allele | primer | sequence  5’ > 3’
cdka;1 | SALK_106809LP | TTTGGCTGGCTGCATTCCTTA
 | SALK_106809RP | CGCCGGCTCTTGATGACTTTA
fbl17 | FBL17F | GGTGGCATTCAATTTGCTAC
 | FBL17R | CAGATGTTCAAGGGATTACC
rbr1-2 | RBRF1 | GGTGGAGGAGAAACTTGTGC
 | RBRR1 | GTGGTTGCTTCCGGTAGTTG
e2fa | E2FAF1 | TTCCAGGTCTGTCTTTCCTATTTC
 | E2FAR2 | CAAATTCGCTGAACATGAAG
krp1 | KRP1F2 | GTTTCGTCGTCTTGTAGTGG
 | KRP1R2 | TTGAGTTGTTTCTCAGCTTCC
krp2 | KRP2F1 | GATTTATTGGAAAAGCCAGCC
 | KRP2R1 | AGACTCTTCCTTAACCTGCGG
krp3 | KRP3F1 | TCAAACCAAAACCAAACATCC
 | KRP3R1 | CATGTGTACTTCATTGCAGAG
krp4 | KRP4F1 | TGGGTTTGTTTATGTCAAAAGC
 | KRP4R1 | TTCCAAGTTAGACGTGTTTG
[NAME] | KRP5F1 | GATTCAATCCGGATGAGCAAATG
 | [NAME] | CCAGAAAACAGCAGAAGCAAC
krp6 | [NAME] | TCACTCACTGGACTCGTCTC
 | KRP6RP | ATTCATCACCGGACTCTCATG
krp7 | KRP7F1 | CTTCCATTTTCAGATCTGGAGGTG
 | KRP7R2 | AAGTCATCAAGCTCTGCCTG
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet: East

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | East Midstream
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 24
+ Entrances |  | 0 | 1 | 0 | 0
- Exits |  | 1 | 1 | 1 | 0
- Executions |  | 0 | 0 | 0 | 1
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 1 | 0.4 | 0.4 |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 12 | 35.925 |  |  | 9 | 68.325 |  |  |  |  | 0 | 0 |  | 0 | 0
Identified Margin
Budget |  | 20.493
$ Coverage
Spreadsheet: 744146d1629018422-find-missing-hours-within-a-day-sample-57-ans1
Sheet: MISSING TIME

Hours |  | Need to get this missing Hours | FORMULA |  | HELPER Column | Result by formula
2021-08-14 02:00:00 |  | 2021-08-14 02:00:00 |  | To enter ARRAY formula
2021-08-14 03:00:00 |  | 2021-08-14 03:00:00 |  | Copy and paste the formula in cell
2021-08-14 05:00:00 |  | 2021-08-14 04:00:00 |  | Press F2
2021-08-14 06:00:00 |  | 2021-08-14 13:00:00 |  | Press Ctrl+Shift+Enter together
2021-08-14 07:00:00 |  | 2021-08-14 16:00:00 |  | Excel covers the formula with {}.
2021-08-14 08:00:00 |  | 2021-08-14 19:00:00
2021-08-14 09:00:00
2021-08-14 10:00:00
2021-08-14 11:00:00
2021-08-14 12:00:00
2021-08-14 14:00:00
2021-08-14 15:00:00
2021-08-14 17:00:00
2021-08-14 18:00:00
2021-08-14 20:00:00
Spreadsheet: 66471d1267115987-finding-duplicates-and-totalling-values-list
Sheet: Sheet4

Sum of Quantity
Description | Total
DIN 913-45H (GE5) 1/4IN UNCX3/4 GEW-STIFT | 42
DIN 916-45H (GE5) 3/8IN UNCX1/2 GEW-STIFT | 480
INT-LOCK-WASH-SIM6797-(A2K)-3/8 | 432
PIPCLMP-MULTIFIX-RBR-B12MM-D6MM | 21
PIPCLMP-MULTIFIX-RBR-B15MM-D10MM | 36
SCR-DIN7991-12.9-(GE5A)-3/8UNFX2 1/4IN | 1530
SCR-DIN7991-12.9-(GE5A)-5/8UNCX1 1/4IN | 1870
SCR-DIN7991-8.8-(A2K)-UNC-1/2X2IN | 378
SCR-DIN7991-8.8-(A2K)-UNC-5/16X2IN | 66
SCR-DIN84-4.8-(A2K)-6BAX5/16IN | 408
SCR-DIN912-12.9-(GE3A/VL)-UNC-1/2X2IN | 378
SCR-DIN912-12.9-(GE3A/VL)-UNC-5/16X2IN | 40
SCR-DIN912-12.9-GE3A//VL-UNC-1/4X3 1/4IN | 120
SCR-DIN912-12.9-GE3A/VL-UNC-5/16X1 3/4IN | 80
SCR-DIN912-12.9-GE3A/VL-UNF-1/2X1 3/4IN | 80
SCR-DIN912-12.9-GE3A/VL-UNF-1/4X2 3/4IN | 60
SCR-HEX-DIN931-8.8-WS17-(A2K)-M10X100 | 84
SCR-RSD-ISO7380-10.9-(A2K)-UNC-3/8X1IN | 40
SCR-SIM.DIN933-8.8-(A2K)-UNS-5/8X1.1/2ZO | 3740
SHB-ZAHN-AE DIN6797-ST-(A2K)-3/4 | 132
SHR-6KT-DIN933-8.8-(A2K)-5/16UNFX1 1/4ZO | 647
SHR-6KT-DIN933-8.8-(A2K)-5/16UNFX3/4ZO | 770
SHR-CYL-SI.DIN912-12.9-UNF-NO.10X1/2IN | 830
STI-KGLKUP-DIN913-(GE5)-45H-UNC 1/4"X1/2" | 1084
STI-KGLKUP-DIN913-(GE5)-45H-UNC 5/16"X1/2" | 480
WSH-DIN125-A-140HV-D8,4 | 24
Grand Total | 13852
Spreadsheet: 166879d1341839127-transposing-date-values-sample
Sheet: Sheet1

Card number | Date
Card A | 2012-06-27 17:29:46
Card A | 2012-06-29 19:36:43
Card A | 2012-06-29 19:59:55
Card B | 2012-06-23 05:47:36
Card B | 2012-06-28 02:15:07
Card C | 2012-06-23 12:41:59
Card C | 2012-06-23 12:51:13
Card D | 2012-06-21 20:11:05
Card D | 2012-06-21 20:16:01
Card E | 2012-06-24 22:46:50
Card E | 2012-06-25 16:01:40
Card F | 2012-06-18 16:53:20
Card F | 2012-06-18 18:21:45
Card F | 2012-06-18 18:54:53
Card F | 2012-06-30 19:41:26
Card G | 2012-06-09 01:30:59
Card G | 2012-06-09 14:32:02
Card G | 2012-06-09 22:53:18
Card G | 2012-06-23 17:06:20
Card G | 2012-06-25 23:51:54
Card H | 2012-06-23 17:59:42
Card H | 2012-06-26 21:35:10
Card I | 2012-06-22 14:12:49
Card I | 2012-06-22 14:19:16
Card J | 2012-06-26 05:07:02
Card K | 2012-06-26 05:11:05
Card L | 2012-06-21 02:26:23
Card L | 2012-06-26 19:47:38
Card L | 2012-06-30 18:24:02
Spreadsheet: 57764d1257972145-automatically-make-new-tables-doctor
Sheet: Total Book

1
 |  | Nr. Book/Page | Date | Payment | code or [NAME] |  |  | vb: 1=regular
 |  | 09*0102/01 | 31-12-2009 | 25 | 3 |  |  | 2= after 7
 |  | 09*0102/02 |  | 22 | 1 |  |  | 3=weekend
 |  | 09*0102/03 |  | 23 | 2 |  |  | etc
 |  | 09*0102/04 |  | 25 | 3
 |  | 09*0102/05
 |  | 09*0102/06
 |  | 09*0102/07
 |  | 09*0102/08
 |  | 09*0102/09
 |  | 09*0102/10
 |  | 09*0102/11
 |  | 09*0102/12
 |  | 09*0102/13
 |  | 09*0102/14
 |  | 09*0102/15
 |  | 09*0102/16
 |  | 09*0102/17
 |  | 09*0102/18
 |  | 09*0102/19
 |  | 09*0102/20
 |  | 09*0102/21
 |  | 09*0102/22
 |  | 09*0102/23
 |  | 09*0102/24
 |  | 09*0102/25
 |  | 09*0102/26
 |  | 09*0102/27
 |  | 09*0102/28
 |  | 09*0102/29
 |  | 09*0102/30
 |  | 09*0102/31
 |  | 09*0102/32
 |  | 09*0102/33
 |  | 09*0102/34
 |  | 09*0102/35
 |  | 09*0102/36
 |  | 09*0102/37
 |  | 09*0102/38
 |  | 09*0102/39
 |  | 09*0102/40
 |  | 09*0102/41
 |  | 09*0102/42
 |  | 09*0102/43
 |  | 09*0102/44
 |  | 09*0102/45
 |  | 09*0102/46
 |  | 09*0102/47
 |  | 09*0102/48
 |  | 09*0102/49
 |  | 09*0102/50
 |  |  | Total: | 95
1
 |  | Nr. Book/Page | Date | Payment
 |  | 09*0103/01
 |  | 09*0103/02
 |  | 09*0103/03
 |  | 09*0103/04
 |  | 09*0103/05
 |  | 09*0103/06
 |  | 09*0103/07
 |  | 09*0103/08
 |  | 09*0103/09
 |  | 09*0103/10
 |  | 09*0103/11
 |  | 09*0103/12
 |  | 09*0103/13
 |  | 09*0103/14
 |  | 09*0103/15
 |  | 09*0103/16
 |  | 09*0103/17
 |  | 09*0103/18
 |  | 09*0103/19
 |  | 09*0103/20
 |  | 09*0103/21
 |  | 09*0103/22
 |  | 09*0103/23
 |  | 09*0103/24
 |  | 09*0103/25
 |  | 09*0103/26
 |  | 09*0103/27
 |  | 09*0103/28
 |  | 09*0103/29
 |  | 09*0103/30
 |  | 09*0103/31
 |  | 09*0103/32
 |  | 09*0103/33
 |  | 09*0103/34
 |  | 09*0103/35
 |  | 09*0103/36
 |  | 09*0103/37
 |  | 09*0103/38
 |  | 09*0103/39
 |  | 09*0103/40
 |  | 09*0103/41
 |  | 09*0103/42
 |  | 09*0103/43
 |  | 09*0103/44
 |  | 09*0103/45
 |  | 09*0103/46
 |  | 09*0103/47
 |  | 09*0103/48
 |  | 09*0103/49
 |  | 09*0103/50
 |  |  | Total: | 0
Spreadsheet: 886946d1737044693-search-for-specific-text-and-then-use-that-text-to-do-vlookup-test-data-formula
Sheet: Sheet1

 |  |  | [NAME] | What I want
 |  | Upper Music Scholarship 10% |  | 127E |  |  | List
 |  | Sports Scholarship 10% |  | 113A
 |  | Prep Academic Scholarship 5% |  | 125E |  |  | Head Masters | 123A
 |  |  |  |  |  |  | HM | 124A
 |  |  |  |  |  |  | Service | 123B
 |  |  |  |  |  |  | Upper Scholarship | 124C
 |  |  |  |  |  |  | Academic Scholarship | 125E
 |  |  |  |  |  |  | Music Scholarship | 127E
 |  |  |  |  |  |  | Sports Scholarship | 113A
 |  |  |  |  |  |  | [NAME] | 145B
 |  |  |  |  |  |  | [NAME] | 118C
Spreadsheet: 18e1cdb0-170c-46b4-9751-d3697c17ecc2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
OKRES BLANSKO
P.Č. | [NAME] (lékaře) | JMÉNO (lékaře) | ADRESA | PSČ | OBEC | TELEFON
1. | Bednaříková | Kateřina | [NAME] 2 | 679 74 | Olešnice | 516463233
2. | Doležel | Pavel | [NAME] | 679 63 | Velké Opatovice | 720611700
3. | [NAME] | Hana | Havlíčkova 624 | 679 02 | [NAME] | 516432102
4. | Henková | Jindřiška | Sadová 33 | 678 01 | [NAME] | 516488461
5. | Ivánková | [NAME] | Budovatelská 443 | 679 21 | [NAME] | 516437380
6. | [NAME] |  |  |  |  | 608110556
7. | [NAME] | Eva | Sadová 33 | 678 01 | [NAME] | 516488462
8. | Klíma | Miroslav | [NAME] | 680 01 | Boskovice | 516454584
9. | Korousová | [NAME] | Komenského 3 | 680 01 | Boskovice | 516454475
10. | Košťálová | Lenka | [NAME] | 679 04 | [NAME] | 516446208
11. | Kotlánová | Helena | Sadová 33 | 678 01 | [NAME] | 516488463
12. | [NAME] | Eva | [NAME] nám. 493 | 679 06 | Jedovnice | 516442817
13. | Lukeš, mladší | Petr | nám. ČSČK 38 | 679 72 | [NAME] | 774708260
14. | Lukeš, starší | Petr | [NAME] 24 | 680 01 | Boskovice | 516455078
15. | Lukešová | [NAME] | Smetanova 24 | 680 01 | Boskovice | 723014465
16. | Machačová | [NAME] | Šebetov 117 | 679 35 | Šebetov | 602886144
17. | Machatová | [NAME] | Sadová 33 | 678 01 | [NAME] | 516488397
18. | Mokrošová | [NAME] | Komenského 429 | 679 71 | Lysice | 516472132
19. | Musilová | [NAME] | Palackého nám. 16 | 679 23 | Lomnice | 549450219
20. | Podlipná | Alena | [NAME] | 680 01 | Boskovice | 516491231
21. | Pořízková | [NAME] | Sloup 221 | 679 13 | Sloup | 516435411
22. | Přichystalová | Martina | [NAME] 457 | 679 32 | [NAME] | 516471211
23. | Stejskalová | Věra | Sadová 33 | 678 01 | [NAME] | 516488460
24. | Šponerová | Ivana | [NAME] 1a | 679 61 | Letovice | 516474367
25. | Švec | Libor | Benešov u Boskovice | 679 53 | Benešov | 724226805
26. | Trnečková | [NAME] | [NAME] 72 | 679 05 | Křtiny | 516439190
27. | Vašková | [NAME] | [NAME] 1a | 679 61 | Letovice | 516474363
Spreadsheet: 739617d1625826818-fuzzy-match-without-fuzzy-lookup-add-in-power-query-and-vba-sample-data
Sheet: Sheet1

Samsung | Samsung
The Samsung | The | Samsung
LG | LG
LG Inc | General | Inc
General | Sony
Sony | Philips
Philips | Acer
Philips Co. | [NAME] | Co.
Acer
Samsung Inc |  | Inc
Samsung Co. |  | Co.
[NAME] |  | Philps
The LG |  | LG
LG Co. |  | Co.
General & Co. |  | & | Co.
General Co. |  | Co.
Sony Inc |  | Inc
Sony Corp. |  | Corp.
Philips Inc. |  | Inc.
The Philips |  | Philips
Acer Co. |  | Co.
Spreadsheet: 225157d1364913766-conditional-formating-to-match-a-list-conditional-formating-bracket
Sheet: Players

 | Name | Round 1 |  |  |  |  |  |  |  | Round 2 |  |  |  | Round 3 |  | Winner
 |  | Pick 1 | Pick 2 | Pick 3 | Pick 4 | Pick 5 | Pick 6 | Pick 7 | Pick 8 | Pick 1 | Pick 2 | Pick 3 | Pick 4 | Pick 1 | Pick 2
 | Player 1 | Team A | Team C | Team F | Team H | Team I | Team K | Team M | Team O | Team A | Team F | Team I | Team M | Team A | Team I | Team A
 | Player 2 | Team B | Team D | Team E | Team G | Team J | Team L | Team N | Team P | Team D | Team G | Team J | Team P | Team D | Team P | Team D
 | Player 3 | Team A | Team C | Team F | Team G | Team J | Team K | Team N | Team O | Team C | Team G | Team K | Team N | Team C | Team N | Team N
 | Player 4 | Team A | Team D | Team E | Team H | Team I | Team L | Team M | Team N | Team A | Team E | Team L | Team M | Team E | Team L | Team E
 | Player 5 | Team B | Team C | Team F | Team G | Team J | Team K | Team N | Team O | Team C | Team G | Team J | Team N | Team G | Team J | Team J