tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274701d1383196882-randomly-select-from-a-table-with-blank-cell-problem
Sheet: Sheet1

 | WORLD ANNUAL NUMBER OF EARTHQUAKES FROM 5.0 TO 9.9 RICHTER
 |  | 1970 | 1980 | 1990 | 2000 | 2010
 | 0 | 1325 | 1418 | 1744 | 1505 | 2136
 | 1 | 1463 | 1271 | 1569 | 1361 | 1805
 | 2 | 1441 | 1520 | 1677 | 1341
 | 3 | 1439 | 1813 | 1575 | 1358
 | 4 | 1425 | 1678 | 1701 | 1672
 | 5 | 1569 | 1798 | 1521 | 1844
 | 6 | 1780 | 1760 | 1386 | 1865
 | 7 | 1788 | 1560 | 1249 | 2270
 | 8 | 1635 | 1586 | 1108 | 1948
 | 9 | 1479 | 1530 | 1238 | 2057
 | Source: http://www.johnstonsarchive.net/other/quake1.html
 | Source: US Geological Survey
Spreadsheet: 106303d1303480376-data-lookup-or-anything-goes-rail-assembly
Sheet: Rails

Standard Rail Assembly Chart
Sign Height--> | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Rail 1 | 2 | 3 | 4 | 3 | 6 | 3 | 6 | 4 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
Rail 2 |  |  |  | 2 |  | 2 | 2 | 3 | 4 | 3 | 6 | 4 | 4 | 6 | 6 | 6 | 6 | 6 | 6
Rail 3 |  |  |  |  |  | 2 |  | 2 |  | 2 |  | 3 | 4 | 3 | 4 | 3 | 6 | 4 | 6
Rail 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 | 2
Rail 5
Rail 6
Rail 7
Rail 8
Rail 9
Rail 10
Rail 11
Thin Rail Assembly Chart
Sign Height--> | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Rail 1 | 2 | 3 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Rail 2 |  |  |  | 2 | 2 | 3 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Rail 3 |  |  |  |  |  |  |  | 2 | 2 | 3 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Rail 4 |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 4 | 3 | 4 | 4 | 4
Rail 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 4
Rail 6
Rail 7
Rail 8
Rail 9
Rail 10
Rail 11
Rail 12
Rail 13
Rail 14
Rail 15
Spreadsheet: 715955d1611934460-pull-x-information-from-another-page-excel-example
Sheet: Data

Code | Site Name | Address | Postcode | Heading 1 | Heading 2 | Delivered | Delivery Date | Notes
101 | Name 1 | [NAME] | [NAME] |  |  | Y | 2021-01-01 00:00:00 | Note for Delivery
102 | Name 2 | Stoneleigh Road | [NAME] |  |  |  | 2021-01-02 00:00:00 | Delivery has not taken place
103 | Name 3 | Name Road | [NAME] |  |  | Y | 2021-01-03 00:00:00
104 | Name 4 | Example Road | [NAME] |  |  |  | 2021-01-04 00:00:00 | Possible Note
105 | Name 5 | Road Name | [NAME] |  |  | Y | 2021-01-05 00:00:00 | Notes to self
106 | Name 6 | Site six Add | [NAME] |  |  |  | 2021-01-06 00:00:00
Spreadsheet: 093863e0-b606-4614-b306-20c2593f1c91
Sheet: Price Reductions

Price Reductions Spreadsheet
SIN | Manufacturer | Manufacturer Part # | GSA or Dealer Part # | Product Description | Current Approved Commercial Price List | Proposed Commercial Price List | $ Change | % Change | [NAME] | [NAME] | Current GSA Price Including IFF | Proposed  GSA Price Including IFF | COO | Reason for Decrease
302-49 | ACME | 123ABC | Same | Ice Machine | 2000 | 2100 |  |  | 0.05 | 0.1
Spreadsheet: 96041d1295520787-netting-down-amount-using-available-figures-simplegoalseektofindatotal-1-
Sheet: data

409437.73 | 1
-1425178.32 | 0 | 3.744667212202346e+60 |  | To run this model:
-362034.95 |  |  |  | Data.What_if.Goal_Seek
-92279.73
-9168 |  |  |  | • | Set cell: A
-700 |  |  |  | • | To: 0
-244790 |  |  |  | • | By changing: C2
-62500 |  |  |  | • | Click: OK
-45418.75
-207000
-424695
-1984.03
6750
 |  |  | Green when summed wiht highlighted yellow comes down to 0, but I have manually inserted one of those yellow figures to make it balance. As a test, surely the Goal Seek should give me a 0 figure.
Spreadsheet: 704504d1605605856-multiple-if-formulas-in-1-cell-calculator-sheet
Sheet: Sheet1

 | Prijs calculatie
 |  |  |  |  |  |  | Service | Product | Amount (Min) | Amount ([NAME]) | Contract Fee
 | Aantal services | 251 |  |  |  |  | cAlarm | Home | 0 | 50 | 26.86
 |  |  |  |  |  |  |  |  | 51 | 150 | 28.93
 | Total fee |  |  |  |  |  |  |  | 151 | 250 | 30.99
 |  |  |  |  |  |  |  |  | 251 | 251 | 33.06
 | < 50 | 50 | for 26,86
 | 50 < 150 | 100 | for 28,93
 | 150 < 250 | 100 | for 30,99
 | > 250 | 1 | for 33,06
 | Input 251 services
Spreadsheet: 767743d1644600478-populating-a-list-example
Sheet: Sheet1

Product
XL Candle Cluster | 1 x XL Vase | 3 x 50cm Vase | 3 x 10.5" Vase | 6 x 7.5" Vase
[NAME] | 10 x Branches | 1 x Trunk | 1 x Logslice | 4 x Globes
[NAME] | 10 x Branches | 1 x Trunk | 1 x Logslice | 4 x Globes
Candle Trio | 1 x 10.5" Vase | 1 x 9" Vase | 1 x 7.5" Vase
Spreadsheet: 08ebd7a6-e211-4f32-b48d-5928b94f872c
Sheet: High School Science

2013 Minnesota Comprehensive Assessments-Series III (MCA-III)
High School Science
Raw Score | Scale Score | Level | Percentile Rank
0 | 1001 | D | 1
1 | 1001 | D | 1
2 | 1001 | D | 1
3 | 1001 | D | 1
4 | 1001 | D | 1
5 | 1001 | D | 1
6 | 1001 | D | 1
7 | 1001 | D | 1
8 | 1001 | D | 1
9 | 1001 | D | 1
10 | 1003 | D | 1
11 | 1008 | D | 1
12 | 1012 | D | 1
13 | 1015 | D | 1
14 | 1017 | D | 2
15 | 1019 | D | 2
16 | 1021 | D | 3
17 | 1023 | D | 4
18 | 1025 | D | 5
19 | 1026 | D | 6
20 | 1028 | D | 7
21 | 1029 | D | 8
22 | 1030 | D | 9
23 | 1031 | D | 10
24 | 1033 | D | 11
25 | 1034 | D | 13
26 | 1035 | D | 14
27 | 1036 | D | 15
28 | 1037 | D | 17
29 | 1038 | D | 19
30 | 1039 | D | 20
31 | 1040 | P | 22
32 | 1041 | P | 24
33 | 1042 | P | 26
34 | 1043 | P | 28
35 | 1044 | P | 30
36 | 1045 | P | 33
37 | 1046 | P | 35
38 | 1047 | P | 39
39 | 1047 | P | 39
40 | 1048 | P | 43
41 | 1049 | P | 46
42 | 1050 | M | 48
43 | 1051 | M | 51
44 | 1052 | M | 54
45 | 1053 | M | 57
46 | 1054 | M | 60
47 | 1055 | M | 63
48 | 1056 | M | 67
49 | 1057 | M | 70
50 | 1058 | M | 73
51 | 1059 | M | 76
52 | 1060 | M | 79
53 | 1061 | M | 82
54 | 1062 | M | 84
55 | 1063 | E | 87
56 | 1064 | E | 89
57 | 1066 | E | 91
58 | 1067 | E | 93
59 | 1069 | E | 95
60 | 1070 | E | 96
61 | 1072 | E | 97
62 | 1074 | E | 98
63 | 1076 | E | 99
64 | 1078 | E | 99
65 | 1082 | E | 99
66 | 1086 | E | 99
67 | 1094 | E | 99
68 | 1099 | E | 99
End of Worksheet
Spreadsheet: 47678d1246862813-reorganize-data-reorgiznied-data
Sheet: Sheet2

Date | Name | Level | A | B | C
2009-06-11 00:00:00 | A | 65.12
2009-06-12 00:00:00 | A | 65.84
2009-06-13 00:00:00 | A | 24.65
2009-06-14 00:00:00 | A | 24.95
2009-06-15 00:00:00 | A | 12.95
2009-06-16 00:00:00 | A | 74.65
2009-06-17 00:00:00 | A | 54.32
2009-06-18 00:00:00 | A | 41.95
2009-06-19 00:00:00 | A | 65.54
2009-06-11 00:00:00 | B | 25.13
2009-06-12 00:00:00 | B | 43.21
2009-06-13 00:00:00 | B | 65.12
2009-06-14 00:00:00 | B | 43.12
2009-06-15 00:00:00 | B | 64.24
2009-06-16 00:00:00 | B | 65.12
2009-06-17 00:00:00 | B | 65.84
2009-06-18 00:00:00 | B | 24.65
2009-06-19 00:00:00 | B | 24.95
2009-06-11 00:00:00 | C | 12.95
2009-06-12 00:00:00 | C | 74.65
2009-06-13 00:00:00 | C | 54.32
2009-06-14 00:00:00 | C | 41.95
2009-06-15 00:00:00 | C | 65.54
2009-06-16 00:00:00 | C | 25.13
2009-06-17 00:00:00 | C | 43.21
2009-06-18 00:00:00 | C | 65.12
2009-06-19 00:00:00 | C | 43.12
 |  | 1277.34 | Using Advanced Filter got the unique value from Date and then put formula's in E,F& G columns
 |  |  | Date | A | B | C
 |  |  | 2009-06-11 00:00:00 | 65.12 | 25.13 | 12.95
 |  |  | 2009-06-12 00:00:00 | 65.84 | 43.21 | 74.65
 |  |  | 2009-06-13 00:00:00 | 24.65 | 65.12 | 54.32
 |  |  | 2009-06-14 00:00:00 | 24.95 | 43.12 | 41.95
 |  |  | 2009-06-15 00:00:00 | 12.95 | 64.24 | 65.54
 |  |  | 2009-06-16 00:00:00 | 74.65 | 65.12 | 25.13
 |  |  | 2009-06-17 00:00:00 | 54.32 | 65.84 | 43.21
 |  |  | 2009-06-18 00:00:00 | 41.95 | 24.65 | 65.12
 |  |  | 2009-06-19 00:00:00 | 65.54 | 24.95 | 43.12
 |  |  |  | 429.97 | 421.3799999999999 | 425.99
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: VLookup 3

Month | Date | Object Code | Category | Amount |  |  | Object Code Description Lookup
January | 2004-01-08 00:00:00 | 3209 | Computer equipment | 389 |  |  | Enter Code
January | 2004-01-12 00:00:00 | 4100 | Office supplies | 28.19 |  |  | Code Description
January | 2004-01-15 00:00:00 | 1909 | Salary faculty | 289872
January | 2004-01-15 00:00:00 | 2999 | [NAME] staff | 98983
February | 2004-02-02 00:00:00 | 4100 | Office supplies | 55.98
February | 2004-02-15 00:00:00 | 1909 | Salary faculty | 198772
February | 2004-02-15 00:00:00 | 2999 | [NAME] staff | 109871
February | 2004-02-19 00:00:00 | 3209 | Computer equipment | 218.2
February | 2004-02-25 00:00:00 | 4100 | Office supplies | 109.8
March | 2004-03-03 00:00:00 | 3209 | Computer equipment | 18.84
March | 2004-03-07 00:00:00 | 4100 | Office supplies | 256.78
March | 2004-03-15 00:00:00 | 1909 | Salary faculty | 325098
March | 2004-03-15 00:00:00 | 2999 | [NAME] staff | 100982
March | 2004-03-15 00:00:00 | 4100 | Office supplies | 134
March | 2004-03-18 00:00:00 | 4100 | Office supplies | 128.75
March | 2004-03-21 00:00:00 | 4100 | Office supplies | 289
March | 2004-03-22 00:00:00 | 4100 | Office supplies | 309
March | 2004-03-29 00:00:00 | 3209 | Computer equipment | 189.21
March | 2004-03-29 00:00:00 | 3219 | Computer software | 589
April | 2004-04-03 00:00:00 | 3209 | Computer equipment | 278.21
April | 2004-04-04 00:00:00 | 3219 | Computer software | 219
April | 2004-04-05 00:00:00 | 3219 | Computer software | 489
April | 2004-04-07 00:00:00 | 4100 | Office supplies | 89.1
April | 2004-04-15 00:00:00 | 1909 | Salary faculty | 309876
April | 2004-04-15 00:00:00 | 2999 | [NAME] staff | 97098
April | 2004-04-28 00:00:00 | 3209 | Computer equipment | 3897
April | 2004-04-29 00:00:00 | 3209 | Computer equipment | 47
May | 2004-05-05 00:00:00 | 4100 | Office supplies | 87.45
May | 2004-05-15 00:00:00 | 1909 | Salary faculty | 215988
May | 2004-05-15 00:00:00 | 2999 | [NAME] staff | 95009
May | 2004-05-15 00:00:00 | 3209 | Computer equipment | 58.9
May | 2004-05-15 00:00:00 | 3209 | Computer equipment | 289
May | 2004-05-15 00:00:00 | 3209 | Computer equipment | 190
May | 2004-05-16 00:00:00 | 4100 | Office supplies | 44.7
May | 2004-05-17 00:00:00 | 4100 | Office supplies | 35.9
May | 2004-05-20 00:00:00 | 4100 | Office supplies | 29.9
May | 2004-05-22 00:00:00 | 4100 | Office supplies | 10.77
June | 2004-06-05 00:00:00 | 3219 | Computer software | 453
June | 2004-06-15 00:00:00 | 1909 | Salary faculty | 250921
June | 2004-06-15 00:00:00 | 2999 | [NAME] staff | 90021
June | 2004-06-25 00:00:00 | 3209 | Computer equipment | 189
June | 2004-06-28 00:00:00 | 4100 | Office supplies | 9.76
June | 2004-06-29 00:00:00 | 4100 | Office supplies | 100.87
Spreadsheet: 4b20551e-c663-4b5d-ab9e-ee1af64373fe
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
FALCO | Test | FALCO | Alcohol, [NAME] | Alcohol, Methyl (Methanol) | Gas Chromatography/Flame Ionization Detection (GC-FID) | Gray-Top Tube (Potassium Oxalate/Sodium Fluoride): GryPOSF |  |  | 1 | mL | Draw blood in a grey top (NaF/oxalate) tube(s). Send 1 mL of whole blood refrigerate.   Note:  [NAME] should be filled to prevent loss of volatile compound into headspace. | 0.25 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Units:    mg/dL   Methanol (methyl alcohol) concentrations greater than 3 mg/dL are potentially toxic.                     Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN  55112 | Monday through Sunday | 1 day | 3 - 5 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc.
FALCO | [NAME] | WBNAFL | [NAME] NaFl-KOx |  |  |  | Refrigerated | 7 days
FALCO | Result | Z1129 | Alcohol, Methyl (Methanol) | Alcohol, Methyl (Methanol) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 482238d1474978410-find-number-of-days-without-inventory-test-file
Sheet: Sheet1

Product | Ship Date | Sold Date |  | Desired Values
A | 2016-03-28 00:00:00 | 2016-05-15 00:00:00 |  | Product A | 18
A | 2016-03-28 00:00:00 | 2016-06-03 00:00:00 |  | Product B | 7
A | 2016-03-28 00:00:00 | 2016-07-15 00:00:00 |  | Product C | 127
B | 2016-03-29 00:00:00 | 2016-07-18 00:00:00
A | 2016-04-15 00:00:00 | 2016-07-15 00:00:00
C | 2016-04-30 00:00:00 | 2016-05-05 00:00:00
B | 2016-06-30 00:00:00 | 2016-08-25 00:00:00
A | 2016-07-27 00:00:00 | 2016-08-18 00:00:00
A | 2016-07-27 00:00:00 | 2016-08-26 00:00:00
C | 2016-08-11 00:00:00 | 2016-09-25 00:00:00
Spreadsheet: 877492d1724318737-index-only-visible-data-mamishgulu-test-198-365-aligw
Sheet: Sheet2

 |  |  | I want this
 |  |  | Car model
 | volkswagen |  | mercedes-benz
 | hyundai |  | volkswagen
 | kia |  | hyundai |  |  | please enter the id
 |  |  | kia |  |  | C001A | When entering the ID, extract only the visible data that is filtered to show (C001A) in Sheet1 and transfer it to the table in Sheet2
 | kia
 | mercedes-benz
 | volkswagen
 |  |  | but my formula give me this instead
 |  |  | car model
 |  |  | mercedes-benz
 |  |  | volkswagen
 |  |  | hyundai
 |  |  | #N/A
 |  |  | kia
Spreadsheet: 219288d1362699741-make-a-list-from-items-not-checked-off-isolation-blinds-tracker
Sheet: Dashboard

BLIND List
February 2013 Refinery Shutdown
 | Total Blinds |  |  |  |  | % Complete
 | Total Blinded
Unit | Total Blinds | [NAME] | [NAME] | [NAME] | Needs Insulation Removed | Ready to Blind | Blinded
500
600
700
800
900
1100
1400
1700 & 2200
1800
2800
2900
4200
4300
Spreadsheet: 219898d1363008842-how-to-find-missing-numbers-from-a-list-in-excel-2010-book1
Sheet: Sheet1

PROFORMA-F
Department wise  [NAME]  Both Financial&Non-Financial Reports
S.No | Name of the Dept. |  | Recived |  | Disposed |  | Pending |  | Remarks
 |  |  | Fin | Non-Fin | Fin | Non-Fin | Fin | Non-fin
1 | MPDO |  | 151 | 2 | 151 | 2 | 0 | 0
2 | Revenew |  | 11 | 84 | 11 | 11 | 74 | 10 | Remaining will be Disposed with in two months
3 | RWS |  | 64 | 0 | 61 | 0 | 3 | 0 | Dispose after Govt. [NAME]
4 | Housing |  | 21 | 0 | 20 | 0 | 1 | 0 | Remaining will be Disposed after Govt. [NAME]
5 | AP Transco |  | 14 | 0 | 5 | 0 | 9 | 0 | Remaining will be Disposed after Govt. [NAME]
6 | BSNL |  | 1 | 0 | 0 | 0 | 0 | 0 | Reply not recived from the concerned Dept.
7 | ICDS |  | 19 | 4 | 19 | 4 | 0 | 0
8 | NREGS |  | 47 | 7 | 47 | 7 | 0 | 0
9 | IKP |  | 6 | 2 | 6 | 1 | 0 | 1 | Pending with APM IKP
10 | SMI |  | 2 | 0 | 0 | 0 | 2 | 0 | Reply not recived from the concerned Dept.
11 | APSRTC |  | 1 | 1 | 0 | 0 | 1 | 1 | Reply not recived from the concerned Dept.
12 | Medical & Health |  | 3 | 0 | 0 | 0 | 3 | 0 | Reply not recived from the concerned Dept.
13 | PO ITDA |  | 5 | 0 | 0 | 0 | 5 | 0 | Reply not recived from the concerned Dept.
14 | DPO |  | 1 | 0 | 1 | 0 | 0 | 0
15 | MEO |  | 5 | 1 | 5 | 1 | 0 | 0
16 | Forest |  | 1 | 1 | 0 | 0 | 1 | 1 | Reply not recived from the concerned Dept.
17 | veternery |  | 1 | 0 | 0 | 0 | 1 | 0 | Reply not recived from the concerned Dept.
18 | Tribal Welfare |  | 19 | 0 | 12 | 0 | 7 | 0 | Dispose after Govt. [NAME]
 | TOTAL
Spreadsheet: 740333d1626281272-countif-not-working-with-true-criterion-rush-detailed-cs-schedule-sample
Sheet: Days of the Week

 |  | Days of the Week
 | Phone | Sun. | Mon. | [NAME]. | Wed. | Thurs. | Fri. | Sat.
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | False | True | True | True | True | True | False
 |  | True | True | True | True | True | False | False
 |  | True | True | True | True | True | False | False
 |  | True | True | True | True | False | False | True
 |  | True | True | True | True |  |  | True
Spreadsheet: 8accbc81-801d-48f7-8689-fc817169c909
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Upper Bay for 2010
Indicator | 2010
Chlorophyll a | 44.958
Aquatic Grasses | 91.38
[NAME] | 80.543
[NAME] | 72
Water Clarity | 27.743
Phytoplankton Index | 23.87
Water Quality Index | 51.08133333
Biotic Index | 62.41666667
Bay Health Index | 56.749
Spreadsheet: 738404d1625018479-lookup-from-a-table-book2
Sheet: Lookup_MultipleValues

 | Plant | Size | Normal |  |  | Overtime
 |  |  | [NAME] | Night | Weekend | [NAME] | Night | Weekend
 | Excavator | 12T | 105 | 126 | 138.6 | 115.5 | 138.6 | 152.46
 | Excavator | 15T | 120 | 144 | 158.4 | 132 | 158.4 | 174.24
 | Excavator | 20T | 130 | 156 | 171.6 | 143 | 171.6 | 188.76
 | Compactor | 12T | 115 | 138 | 151.8 | 126.5 | 151.8 | 166.98
 | Compactor | 15T | 130 | 156 | 171.6 | 143 | 171.6 | 188.76
 | Compactor | 20T | 140 | 168 | 184.8 | 154 | 184.8 | 203.28
 | Plant | Size | Time | Hours
 | Compactor | 12T | Night | Overtime
Spreadsheet: 845866d1697191807-conditional-formatting-with-or-and-indirect-functions-not-working-forum_question-conditional-formatting-with-or-and-indirect
Sheet: Blad1

 | 1 | 2 | 3 | 4 | 5 |  | Choose: | Discipline |  | Discipline | Relatie | Locatie | Description
1 | IT | Traffic |  |  |  |  | The cell above decides the  formatting |  |  | Construction | Company1 | Netherlands | Building Houses
2 | Company3 | Company2 |  |  |  |  |  |  |  | HR | Company2 | England | Hiring
3 | America | Netherlands |  |  |  |  |  |  |  | IT | Company3 | America | Server maintenance
4 | Server maintenance | Replacing traffic lights |  |  |  |  |  |  |  | Traffic | Company2 | Netherlands | Replacing traffic lights
5 |  | HR | Construction | IT |  |  |  |  |  | Construction | Company2 | Netherlands | Demolition
6 |  | Company2 | Company2 | Company2 |  |  |  |  |  | IT | Company3 | England | Head Office
7 |  | England | Netherlands | Germany |  |  |  |  |  | IT | Company2 | Germany | On site technical support
8 |  | Hiring | Demolition | On site technical support
9 | Construction |  |  |  | IT
10 | Company1 |  |  |  | Company3 |  | Below this cell the type of conditional the formatting
11 | Netherlands |  |  |  | England |  |  |  | IF(OR(B2:B4)=H12) - then Color 1
12 | Building Houses |  |  |  | Head Office |  | HR |  | IF(OR(B2:B4)=H13) - then Color 2
 |  |  |  |  |  |  | IT |  | IF(OR(B2:B4)=H14) - then Color 3
 |  |  |  |  |  |  | Traffic |  | IF(OR(B2:B4)=H15) - then Color 4
Explanation of the problem:
 | Above you'll find the general layout of my excel workbook recreated in a manner to simplify the problem. I have a table of base data, which is automatically placed in the right place in a planner-like overview (Top left of this sheet is a simple represantation without the automatic functions)
 | Now, what I want is a way to format the cells in the planner, colorcode them. However, depending on the value in cell $I$2 i want to colorcode in different ways, to do this I created the dynamic array in cell H12.
 | The formula that I have in mind to use in conditional formatting is written out below. (Sidenote: I work in a dutch version of excel, therefore the formula written out below might not be accurate. However, below the formula I have written out the same formula in dutch - which is working - this one should translate automatically)
 | =OR(INDIRECT(ADRESS(FLOOR((ROW(B2)-2)/4)*4+2;COLUMN(B2);1;1)&":"&ADRESS(FLOOR((ROW(B2)-2)/4)*4+5;COLUMN(B2);1;1))=$H$12)
 | Below here the formula written out in a matrix corresponding the matrix above
 | The formula used to create the values of TRUE and FALSE in the cell B26 has been copied and applied as a formula in conditional formatting over $B$2:$F$13. For some reason the yellow formatting doesnt apply however.
 |  | Sidenote: I have entered the formula without the OR statement in conditional formatting to only check for INDIRECT(ADRES(FLOOR((ROW(B2)-2)/4)*4+2);COLUMN(B2);1;1))=$H$12. For some reason this does work, the cells turn red. (Only works when $[NAME] is set to "Discipline")
The question:
 | Can anyone help me with this problem? How do I get the formatting to succeed in the way I want it to.
Spreadsheet: 329697d1404386395-help-to-prepare-dynamic-table-in-excel-dummy
Sheet: Sheet2

 | Current week | 23
 | current week | 22 |  |  |  |  |  |  | Row Labels | week-22 | week-23 | week-24 | Grand Total
 |  |  |  |  |  |  |  |  | a | 19 |  |  | 19
 | Product | week 23 Quantity | week 23 Quantity |  |  |  |  |  | b | 20 |  |  | 20
 | a | 0 |  |  |  |  |  |  | c | 30 | 12 | 18 | 60
 | b | 0 |  |  |  |  |  |  | d | 28 | 11 | 29 | 68
 | c |  |  |  |  |  |  |  | e | 14 | 26 | 20 | 60
 | d |  |  |  |  |  |  |  | f | 16 | 11 | 14 | 41
 | e |  |  |  |  |  |  |  | g |  | 29 | 13 | 42
 | f |  |  |  |  |  |  |  | i |  | 18 |  | 18
 | g |  | 0 |  |  |  |  |  | m |  |  | 24 | 24
 | i |  | 0 |  |  |  |  |  | Grand Total | 127 | 107 | 118 | 352
P.S | If I change current and previous week it will automatically get updated.
Spreadsheet: 826744d1682238069-add-one-lines-after-a-result-is-satisfied-book2
Sheet: Sheet1

o | A
 | B |  |  | A
 | C |  |  | B
 | D |  |  | C
o | E |  |  | D
 | F |  | o
o | G |  |  | E
 | H |  |  | F
 | I |  | o
 | J |  |  | G
o | K |  |  | H
 | L |  |  | I
 | M |  |  | J
o | N |  | o
 | O |  |  | K
 | P |  |  | L
 | Q |  |  | M
 |  |  | o
 |  |  |  | N
 |  |  | o
 |  |  |  | P
 |  |  |  | Q
Spreadsheet: 714799aa-0dd6-474a-ab69-d4bec28d8f28
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
FHSU | Test | FHSU | MVista Histoplasma Antigen, [NAME] | MVista Histoplasma Ag, U | Enzyme Immunoassay (EIA) | Plastic, urine tube: PlUrTb |  |  | 10 | mL | 2 mL from a random urine collection shipped refrigerate. | 0.5 mL | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reference interval:  None Detected   Results reported as ng/mL in 0.4 - 19 ng/mL   Results above the limit of detection but below 0.4 ng/mL are reported as Positive, Below the Limit of Quantification.    Results above 19 ng/mL are reported as 'Positive, Above the Limit of Quantification'.    Test Performed by :  MiraVista Diagnostics                                 4705 Decatur Blvd.                                 Indianapolis, IN 46241 | Monday through Friday | 2 days | 4 - 8 days | 1 | 87385 |  |  |  |  | MiraVista Diagnostics
FHSU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FHSU | Result | Z1710 | Result: | Result: | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FHSU | Result | Z1036 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 137734d1327338487-combining-two-or-more-excel-tables-copy-of-arnab-2-
Sheet: KOL

 | Particulars | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct
 | Avg. Courier Cost/ # Trans | 82.2394366197183 | 66.70550161812298 | 61.85054347826087 | 80.78731343283582 | 86.37735849056604 | 123.3833333333333 | 90.6832298136646 | 63.36088154269972 | 113.5135135135135 | 102.9082774049217 | 108.9285714285714 | 111.3490364025696
 | Total Dispatches/ No. of Dist. | 3.872727272727273 | 5.15 | 5.661538461538462 | 6.380952380952381 | 4.416666666666667 | 3.934426229508197 | 4.953846153846154 | 11 | 5.692307692307693 | 6.573529411764706 | 8.235294117647058 | 6.671428571428572
 | % Instances of not receiving material within TAT | 0.008 | 0.004 | 0.006 | 0.005 | 0.008 | 0.007 | 0.008 | 0.007 | 0.007 | 0.006 | 0.007 | 0.007