tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d650f92a-144c-47b3-b4f5-dde448c099e4
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
FPGNG | Test | FPGNG | Pea Green IgG | Pea Green IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPGNG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPGNG | Result | FPGNG | Pea Green IgG | Pea Green IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 178998 | 177703 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 179049 | 178823 |  | -643 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 200325 | 201502 |  | -1041 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 198276 | 198103 |  | -1127 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 182664 | 181182 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 185625 | 184935 |  | -64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 180945 | 182612 |  | -413 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 171448 | 170921 |  | -766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 167085 | 165766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 180242 | 185290 |  | -5992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 156730 | 168069 |  | -2752 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 161920 | 162390 |  | -1246 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 168860 | 168387 |  | -785 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 176296 | 175896 |  | -227
15 | 178640 | 178477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 174560 | 173631 |  | -412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-12-31 00:00:00 |  |  |  | -22389
 | 2002-01-16 00:00:00
 | CBS Dollars
 |  |  |  | -507608
Spreadsheet: 191198d1351966412-how-to-skip-blanks-in-col-b-to-return-list-items-from-col-a-example-attached-skippingblanksproblem
Sheet: Sheet1

ITEMS | QTYS |  |  | DESIRED RESULT
A | 22 |  |  | A
B |  |  |  | C
C | 3 |  |  | F
D |  |  |  | J
E |  |  |  | K
F | 56 |  |  | L
G |  |  |  | O
H
I
J | 3
K | 4
L | 5
M
N
O | 9
P
Spreadsheet: 205435d1357814956-dynamic-range-that-stops-after-a-white-row-test-dynamic
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | is on another workbook in the real set up
January |  |  |  |  |  |  |  |  |  |  |  |  |  | January
1900-07-31 00:00:00 | [NAME] | 213 |  | 32432343 |  | 4 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | 2423342 |  | 5 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -27585659 |  | 6 | 3 |  |  |  | I want a dynamic range that picks up the address in L4 and selects (in this case) het january table
1900-07-31 00:00:00 | kjjsafj | 213 |  | -57594660 |  | 7 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -87603661 |  | 8 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -117612662 |  | 9 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -147621663 |  | 10 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -177630664 |  | 11 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -207639665 |  | 12 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -237648666 |  | 13 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -267657667 |  | 14 | 3
February
1900-07-31 00:00:00 | [NAME] | 213 |  | 32432343 |  | 4 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | 2423342 |  | 5 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -27585659 |  | 6 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -57594660 |  | 7 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -87603661 |  | 8 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -117612662 |  | 9 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -147621663 |  | 10 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -177630664 |  | 11 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -207639665 |  | 12 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -237648666 |  | 13 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -267657667 |  | 14 | 3
march
1900-07-31 00:00:00 | [NAME] | 213 |  | 32432343 |  | 4 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | 2423342 |  | 5 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -27585659 |  | 6 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -57594660 |  | 7 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -87603661 |  | 8 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -117612662 |  | 9 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -147621663 |  | 10 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -177630664 |  | 11 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -207639665 |  | 12 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -237648666 |  | 13 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -267657667 |  | 14 | 3
april
1900-07-31 00:00:00 | [NAME] | 213 |  | 32432343 |  | 4 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | 2423342 |  | 5 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -27585659 |  | 6 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -57594660 |  | 7 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -87603661 |  | 8 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -117612662 |  | 9 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -147621663 |  | 10 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -177630664 |  | 11 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -207639665 |  | 12 | 3
1900-07-31 00:00:00 | kjjsafj | 213 |  | -237648666 |  | 13 | 3
1900-07-31 00:00:00 | [NAME] | 213 |  | -267657667 |  | 14 | 3
Spreadsheet: 757228d1638135960-reset-countif-after-specific-date-is-reached-student-tracker
Sheet: Tracker v1

 |  |  | Excused |  | Free
 |  |  | Trial |  | Free
 |  |  | Yes |  | Pay
 |  |  | No |  | Pay
 |  |  | Comp |  | Pay
 |  |  | Total
 |  |  | Paid on
 |  |  | Today
 |  |  | Next statatic:
 |  |  | Payment in number of weeks
 |  |  | Next dynamic:
 |  |  | count excused
 |  |  | Week: | 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
 |  |  | Date | 2021-11-21 00:00:00
 |  |  | Student 1 | Trial | Yes | Yes | Yes | Excused | Comp | No | Excused | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  | Student 2 |  | Trial | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  | Student 3 |  |  | Trial | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  |  | Student 4 |  |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Spreadsheet: 888167d1738613904-conditional-formatting-highlight-duplicates-but-different-color-per-instance-team-square-1
Sheet: List of Names

 | Player | Sold to | $ Collected
1 | Brantley | Brantley
2 | Brantley | Brantley
3 | Braxton | Braxton
4 | Braxton | Braxton
5 | Braxton | Braxton
6 | Braxton | Braxton
7 | Braxton | Braxton
8 | Braxton | Braxton
9 | Braxton | Braxton
10 | Braxton | Braxton
11 | Easton | Easton
12 | Easton | Easton
13 | Easton | Easton
14 | Easton | Easton
15 | Easton | Easton
16 | Easton | Easton
17 | Easton | Easton
18 | Easton | Easton
19 | Easton | Easton
20 | Easton | Easton
21 | Easton | Easton
22 | Easton | Easton
23 | Easton | Easton
24 | Easton | Easton
25 | Easton | Easton
26 | Easton | Easton
27 | Easton | Easton
28 | Easton | Easton
29 | Easton | Easton
30 | Gavin | Gavin
31 | Gavin | Gavin
32 | Gavin | Gavin
33 | Gavin | Gavin
34 | Gavin | Gavin
35 | Gavin | Gavin
36 | Gavin | Gavin
37 | Gavin | Gavin
38 | Gavin | Gavin
39 | Gavin | Gavin
40 | [NAME] | [NAME]
41 | [NAME] | [NAME]
42 | [NAME] | [NAME]
43 | [NAME] | [NAME]
44 | [NAME] | [NAME]
45 | [NAME] | [NAME]
46 | [NAME] | [NAME]
47 | [NAME] | [NAME]
48 | [NAME] | [NAME]
49 | [NAME] | [NAME]
50 | [NAME] | [NAME]
51 | [NAME] | [NAME]
52 | [NAME] | [NAME]
53 | Nathan | Nathan
54 | Nathan | Nathan
55 | Nathan | Nathan
56 | Nathan | Nathan
57 | Nathan | Nathan
58 | Nathan | Nathan
59 | Nathan | Nathan
60 | Nathan | Nathan
61 | Nathan | Nathan
62 | Nathan | Nathan
63 | Nathan | Nathan
64 | Nathan | Nathan
65 | Nathan | Nathan
66 | Nathan | Nathan
67 | Nathan | Nathan
68 | Nathan | Nathan
69 | Nathan | Nathan
70 | [NAME] | [NAME]
71 | [NAME] | [NAME]
72 | [NAME] | [NAME]
73 | [NAME] | [NAME]
74 | [NAME] | [NAME]
75 | [NAME] | [NAME]
76 | [NAME] | [NAME]
77 | [NAME] | [NAME]
78 | [NAME] | [NAME]
79 | [NAME] | [NAME]
80 | [NAME] | [NAME]
81 | [NAME] | [NAME]
82 | [NAME] | [NAME]
83 | [NAME] | [NAME]
84 | [NAME] | [NAME]
85 | [NAME] | [NAME]
86 | [NAME] | [NAME]
87 | [NAME] | [NAME]
88 | [NAME] | [NAME]
89 | [NAME] | [NAME]
90 | [NAME] | [NAME]
91 | [NAME] | [NAME]
92 | [NAME] | [NAME]
93 | [NAME] | [NAME]
94 | [NAME] | [NAME]
95 | [NAME] | [NAME]
96
97
98
99
100
Spreadsheet: 113492d1309373317-cannot-solve-vlookup-mid-function-problem-autodecode
Sheet: DDR3 Decode

Part # | M393B2G70AH0-CH9Q5
Reference | Code | Description
(1) Memory Module(M)
(2) Module Configuration
(3)~(4) Data bit
(5) Feature,Voltage
(6)~(7) Depth
(8) # of bank in Comp.,Interface,[NAME]
(9) Composition Component
(10) Component Generation
(11) Package
(12) PCB Revision &Type
(13) "-" |  | -
(14) Power
(15)~(16) Speed
(17)~(18) Customer (Special Handling) |  | -
Spreadsheet: 879581d1727170911-need-help-to-bifurcate-number-of-days-year-wise-from-date-ranges-based-on-criteria-count-number-of-days-1
Sheet: Sheet2

Employee ID |  |  |  |  |  |  |  | Leave Type | From Date | To Date |  |  | Status
86920 |  |  |  |  |  |  |  | EL | 2023-08-07 00:00:00 | 2023-08-09 00:00:00 |  |  | APPROVED |  | In Excel Sheet1 there is Employee ID in Cell I6. From Cell E37 to Cell I37 Contains Years in YYYY manner. In Cell D39 and In Cell D40 there is Leave Type I.e. SL and EL. In Sheet2 there is Employee ID in Column A from Cell A2 onwards, In Column I There are Leave Type, In Column J and Column K Respectively contains [NAME] dates and [NAME]. And in Column N Contains Leave Status Whether It is Approved or Cancelled or Rejected etc. I Want to SUM Employee ID wise Total Numbers of Approved Leaves in Sheet1 Based on Leave Type and Year wise. In Column L I have try formula but it gives only Cell Wise results. I expect the Standalone formula without helper column to achieve the desired results.
86920 |  |  |  |  |  |  |  | SL | 2023-09-04 00:00:00 | 2023-09-16 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2024-03-05 00:00:00 | 2024-03-16 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2023-12-26 00:00:00 | 2024-01-14 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | SL | 2023-09-04 00:00:00 | 2023-09-14 00:00:00 |  |  | REJECTED
86920 |  |  |  |  |  |  |  | SL | 2021-05-17 00:00:00 | 2021-05-29 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2022-05-16 00:00:00 | 2022-05-21 00:00:00 |  |  | APPROVED
86920 |  |  |  |  |  |  |  | EL | 2019-12-19 00:00:00 | 2020-01-12 00:00:00 |  |  | APPROVED
Spreadsheet: 273175d1382629725-sumif-problem-117
Sheet: Payroll Matrix

 | Labor Matrix - New
 | Sales From | Sales Up To | Hrs/wk
 | 0 | 8000 | 92
 | 8001 | 10000 | 97
 | 10001 | 12000 | 102
 | 12001 | 14000 | 107
 | 14001 | 16000 | 112
 | 16001 | 18000 | 117
 | 18001 | 20000 | 122
 | 20001 | 22000 | 127
 | 22001 | 24000 | 132
 | 24001 | 26000 | 137
 | 26001 | 28000 | 142
 | 28001 | 30000 | 147
 | 30001 | 32000 | 152
 | 32001 | 34000 | 157
 | 34001 | 36000 | 162
 | 36001 | 38000 | 167
 | 38001 | 40000 | 172
 | 40001 | 42000 | 177
 | 42001 | 44000 | 182
 | 44001 | 46000 | 187
 | 46001 | 48000 | 192
 | 48001 | 50000 | 197
 | 50001 | 52000 | 202
 | 52001 | 54000 | 207
 | 54001 | 56000 | 212
 | 56001 | 58000 | 217
 | 58001 | 60000 | 222
 | 60001 | 62000 | 227
 | 62001 | 64000 | 232
 | 64001 | 66000 | 237
 | 66001 | 68000 | 242
 | 68001 | 70000 | 247
Spreadsheet: 754233d1636037672-sheet2-b-get-number-reference-from-another-cell-example-sheet
Sheet: Sheet1

Example 1 |  |  | Example 2 |  |  | Example 3
Group |  |  | Group 2 |  |  | Group 3
N = | Text | ID | N = | Text | ID | N = | Text | ID
1 |  | 18 | 1 |  | 10 | 1 |  | 3
2 |  | 20 | 2 |  | 12 | 2 |  | 15
3 |  | 5 | 3 |  | 8 | 3 |  | 6
4 |  | 2 | 4 |  | 1 | 4 |  | 14
5 |  | 9
6 |  | 13
Spreadsheet: 79547d1279791221-non-duplicate-drop-down-list-and-non-blank-lists-grahams-template-new
Sheet: Charts

Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Question 21
Question 22
Question 23
Question 24
Question 25
Question 26
Question 27
Question 28
Question 29
Question 30
Question 31
Question 32
Question 33
Question 34
Question 35
Question 36
Question 37
Question 38
Question 39
Question 40
Question 41
Question 42
Question 43
Question 44
Question 45
Question 46
Question 47
Question 48
Question 49
Question 50
Question 51
Question 52
Question 53
Question 54
Question 55
Question 56
Question 57
Question 58
Question 59
Question 60
Question 61
Question 62
Question 63
Question 64
Question 65
Question 66
Question 67
Question 68
Question 69
Question 70
Question 71
Question 72
Question 73
Question 74
Question 75
Spreadsheet: 884776d1734038436-conditional-formatting-question-losguapos1-sample-data
Sheet: Sheet1

 | Written Exams
 | #1 | #2 | #3 | Final
 | 0.98 | 0.96 | 0.98 | 0.95
 | 0.8 | 0.82 | 0.7 | 0.75
 | 0.84 | 0.53 | 0 | 0
 | 0.83 | 0.77 | 0.55 | 0.76
 | 0.79 | 0.65 | 0.56 | 0.72
 | 0.37 | 0.28 | 0 | 0
 | 0.05 | 0 | 0 | 0
 | 0.72 | 0 | 0 | 0
 | 0.59 | 0.59 | 0.67 | 0.62
 | 0.82 | 0.8 | 0.91 | 0.95
 | 0.88 | 0.77 | 0.42 | 0.56
 | 0.71 | 0.28 | 0 | 0.52
 | 0 | 0 | 0 | 0
 | 0.73 | 0.78 | 0.9 | 0.85
 | 0.94 | 0.97 | 0.78 | 0.8
 | 0.93 | 0.95 | 0.76 | 0.79
 | 0.86 | 0.86 | 0.57 | 0.84
 | 0.65 | 0.73 | 0.79 | 0.6
 | 0.82 | 0.92 | 0.87 | 0.86
 | 0.78 | 0.46 | 0.37 | 0.32
 | 0 | 0 | 0 | 0
 | 0.7 | 0.71 | 0 | 0
 | 0.67 | 0.88 | 0.98 | 0.86
Spreadsheet: 794642d1662185189-8x8-matrix-solving-random-linair-equations-8-with-matrices-hd
Sheet: Example solving equation

Press F9 for solving an other equination system
EQUANATION SYSTEM
 | X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 | C
EQ1
EQ2
EQ3
EQ4
EQ5
EQ6
EQ7
EQ8
CALCULATE INVERSE
 |  | X2 | X3 | X4 | X5 | X6 | X7 | X8
Multipy the inverse by the origin equation matrix (inclusive Column with the constante C)
 |  | X2 | X3 | X4 | X5 | X6 | X7 | X8 | C
EQ2
EQ3
EQ4
EQ5
EQ6
EQ7
EQ8
SOLUTION
 | EQ1: X1=
 | EQ2: X2=
 | EQ3: X3=
 | EQ4: X4=
 | EQ5: X5=
 | EQ6: X6=
 | EQ7: X7=
 | EQ8: X8=
CHECK SOLUTION
 |  | X2 | X3 | X4 | X5 | X6 | X7 | X8 | C |  | CHECK FORMULA
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
 |  |  |  |  |  |  |  |  |  | =
Press F9 for solving an other equination system
Spreadsheet: 44932d1243677070-excel-2007-match-a-name-on-one-worksheet-with-a-name-on-another-work-sheet-aimmarketstatistics2008-ver-2
Sheet: Delisted

Cancellation of admission |  |  | From 31/01/2008
Company | Date | Reason
ELCOM INTERNATIONAL INC. | 2008-04-01 07:00:00 | Pursuant to AIM Rule 41
ELEKSEN GROUP PLC | 2008-04-07 07:00:00 | Pursuant to AIM Rule 41
Elephant Loans & Mortgages Plc | 2008-10-13 07:00:00 | PURSUANT TO AIM RULE 41
E-Pay Asia Ltd | 2008-09-30 07:00:00 | PURSUANT TO AIM RULE 41
ETHANOL INVESTMENTS PLC | 2008-05-20 08:00:00 | Approval of a reverse takeover
Spreadsheet: 717672d1612797706-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Schedule

Day | Monday | Monday | Monday | Tuesday | Tuesday
System | System 1 | System 2 | System 3 | System 4 | System 5
Extract Names from Roster tab List which are not in listed above based on day for multiple columns
Monday | Tuesday | Wednesday
Test 7 | Test 1 | Test 1 |  | Everything to the left will be formulas which can auto update based on data entered above. It should also alow for columns to be added or deleted above without having to change the formulas to the left. For example if a new system is added in between column B and C there would then be 6 systems showing from colums B to G. The formulas to the left should also account for the new system automatically based on the day for that system.
Test 8 | Test 2 | Test 2
Test 9 | Test 3 | Test 3
Test 10 | Test 4 | Test 4
Blank | Test 5 | Test 5
Blank | Test 6 | Test 6
Blank | Blank | Test 7
Blank | Blank | Test 8
Blank | Blank | Test 9
Blank | Blank | Test 10
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Blank | Blank | Blank
Spreadsheet: 698742d1602155728-lookup-with-return-sum-value-book1
Sheet: Sheet2

Name | Valoare nescadentă | 0-30 | 31-60 | 61-90 | >90
ADR BEST TRANS SRL | 1785
ALCALIN FARM SRL |  |  | 1154.3
ALCALIN FARM SRL |  |  | 1368.5
ALCALIN FARM SRL |  |  | 1190
ALCALIN FARM SRL | 1071
ALCALIN FARM SRL | 1190
ALCALIN FARM SRL | 1309
ALCODA SERVICE SRL |  | 1958.26
ALCODA SERVICE SRL |  | 1800.47
ALCODA SERVICE SRL |  | 1683.14
ALCODA SERVICE SRL | 2261.71
ALCODA SERVICE SRL | 1683.14
ALCODA SERVICE SRL | 1683.14
ALCODA SERVICE SRL | 1229.98
[NAME] | 1719.07
Spreadsheet: 702722d1604502972-modify-formula-so-that-it-works-with-alphanumeric-data-modify-formula-so-that-it-works-with-alphanumeric-data
Sheet: Alphanumeric formula

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Table 3 |  |  |  |  | Table 4 |  |  |  |  | Table 5 |  |  |  |  | Table 6
 | 1 | 2 | 3 |  |  | 1 | 2 | 3 |  |  | A | B | C |  |  |  | 2 | 3 |  |  | 1 | 2 | 3 |  |  | A | B | C
 | 4 |  | 6 |  |  | 4 |  | 6 |  |  | D |  | F |  |  | 4 |  | 6 |  |  | 4 |  | 6 |  |  | D |  | F
 | 4 | 5 |  |  |  | 4 | 5 |  |  |  | D | E |  |  |  | 4 | 5 |  |  |  | 4 | 5 |  |  |  | D | E
 | 7 |  | 9 |  |  | 7 |  | 9 |  |  | G |  | I |  |  | 7 | 8 | 9 |  |  | 7 | 8 | 9 |  |  | G | H | I
 |  | 8 | 9 |  |  |  | 8 | 9 |  |  |  | H | I |  |  |  | 8 | 9 |  |  |  | 8 | 9 |  |  |  | H | I
 | 10 | 11 |  |  |  | 10 | 11 |  |  |  | J | K |  |  |  | 10 | 11 |  |  |  | 10 | 11 |  |  |  | J | K
 |  | 11 | 12 |  |  |  | 11 | 12 |  |  |  | K | L |  |  | 10 | 11 | 12 |  |  | 10 | 11 | 12 |  |  | J | K | L
 | 13 | 14 |  |  |  | 13 | 14 |  |  |  | M | N |  |  |  | 13 | 14 |  |  |  | 13 | 14 |  |  |  | M | N
 |  | 14 |  |  |  |  | 14 |  |  |  |  | N |  |  |  | 13 | 14 |  |  |  | 13 | 14 |  |  |  | M | N
 |  | 17 | 18 |  |  |  | 17 | 18 |  |  |  | Q | R |  |  |  | 17 | 18 |  |  |  | 17 | 18 |  |  |  | Q | R
 |  |  | 18 |  |  |  |  | 18 |  |  |  |  | R |  |  |  | 17 | 18 |  |  |  | 17 | 18 |  |  |  | Q | R
 | 19 | 20 |  |  |  | 19 | 20 |  |  |  | S | T |  |  |  | 19 | 20 |  |  |  | 19 | 20 |  |  |  | S | T
 | 19 |  |  |  |  | 19 |  |  |  |  | S |  |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | S
 |  | 23 | 24 |  |  |  | 23 | 24 |  |  |  | W | X |  |  |  | 23 | 24 |  |  |  | 23 | 24 |  |  |  | W | X
 |  | 23 |  |  |  |  | 23 |  |  |  |  | W |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  | W
 | 25 |  | 27 |  |  | 25 |  | 27 |  |  | Y |  | AA |  |  | 25 |  | 27 |  |  | 25 |  | 27 |  |  | Y |  | AA
 | 28 | 29 |  |  |  | 28 | 29 |  |  |  | AB | AC |  |  |  | 28 | 29 |  |  |  | 28 | 29 |  |  |  | AB | AC
 |  | 32 | 33 |  |  |  | 32 | 33 |  |  |  | AF | AG |  |  |  | 32 | 33 |  |  |  | 32 | 33 |  |  |  | AF | AG
 | 34 |  |  |  |  | 34 |  |  |  |  | AH |  |  |  |  | 34 |  |  |  |  | 34 |  |  |  |  | AH
 |  | 38 |  |  |  |  | 38 |  |  |  |  | AL |  |  |  |  | 38 |  |  |  |  | 38 |  |  |  |  | AL
 |  |  | 42 |  |  |  |  | 42 |  |  |  |  | AP |  |  |  |  | 42 |  |  |  |  | 42 |  |  |  |  | AP