tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871626d1718050085-sum-of-first-three-populated-columns-test1
Sheet: Sheet1

Lookup ID | Name | Raffle1 | Raffle2 | Raffle3 | Raffle4 | Raffle5 | Raffle6 | Raffle7 | Raffle8 | Raffle9 | Raffle10 | Raffle11 | Raffle12 | Raffle13 | total tickets | Total of first three raffles purchased (include all raffles if less than 4 raffles played)
1 | A | 2 | 2 | 3 | 3 | 2 | 3 | 3 |  | 2 | 2 | 2 |  |  |  | 7
2 | B |  | 1 |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  | 3
3 | C |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
4 | D |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
5 | E |  | 1 |  | 1 |  |  |  |  | 1 |  |  | 2
6 | F | 2 |  |  |  |  | 2
7 | G |  | 3 |  |  |  |  | 2 |  |  |  | 5 | 6
8 | H |  |  | 6 | 3 |  |  | 3 |  | 4 |  | 6
9 | I |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 6 |  | 8
10 | J |  |  |  |  |  |  | 3 | 6 | 1 | 2 | 4 |  | 10
Spreadsheet: e309bbf5-9663-4f67-a67c-e4b8daf3da6c
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
NEZPP | Test | NEZPP | Zinc Protoporphyrin, Blood | Zinc Protoporphyrin, B | Hematofluorometry |  |  |  | 1 | mL | Container/Tube:  Preferred: Royal, blue-top Monoject trace element blood collection tube, product #8881-307022 (Supply T183), containing EDTA as an anticoagulant Acceptable: Heparin (<24 hours old) [NAME]: 1 mL | 0.1 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild reject; Gross reject Icterus	NA Other	NA | <70 mcmol ZPP/mol heme | Monday through Friday; 3rd shift | 1 day | 3 days | 1 | 84202 |  |  |  |  | New England
NEZPP | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 14 days
NEZPP | Result | 300009 | Zinc Protoporphyrin, B | Zinc Protoporphyrin, B | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2893-6 | Protoporphyrin.zinc:ACnc:Pt:[NAME]:Ord:
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: T8

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
8 | Sexy Strikers | Player23 |  |  |  |  |  |  | Week 1
 |  | Player24 |  |  |  |  |  |  | Week 2
 |  | Player25 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player23 | 132 |  |  |  |  |  | Week 11
 |  | Player24 | 73 |  |  |  |  |  | Week 12
 |  | Player25 | 108 |  |  |  |  |  | Week 13
 |  |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 0289f0c2-2805-4b99-b98c-5ecb4d85f401
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | FDC USE | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
 |  |  |  |  | Project Summary Sheet |  |  |  |  |  |  |  |  | Project Number |  |  |  | PM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Account Number
 | *Building: |  |  |  |  |  |  |  | *Floor:
 | *Description:
 | *Department:
 | *Dept. Head/Nurse Mgr: |  |  |  |  |  |  |  | *Extension: |  |  |  |  | *Date:
*Approved for Estimate: |  |  |  |  |  |  |  | Funding Source:
 |  |  | Dept. Head              Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  | Capital Budget Code |  |  |  |  |  |  | Account
 |  |  | Vice President         Date |  |  |  |  |  |  |  |  |  | % |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  | Account |  |  |  |  |  |  | Account
FDC USE ONLY
 | [NAME] |  | BUDGET ESTIMATE |  |  | FIRM PRICE |  |  |  |  |  |  | ACTUAL PRICE
 | Construction
 | Consultants
 | Equipment
 | Furnishings
 | Facilities Services
 | Hazardous Waste
 | Miscellaneous
 | Printing
 | Trash Removal
 | Voice / Data
 | Environmental Services
 | Contingency
 | FDC Fee
 | TOTAL
 | Reviewed By / Date
Comments: |  |  | Approved for Firm Price |  |  | Approved for Construction
 |  |  | _____________________ |  |  | _____________________ |  |  |  |  |  |  | _____________________
 |  |  | Vice President / Date |  |  | Vice President / Date |  |  |  |  |  |  | Financial Officer /Date
 |  |  | _____________________ |  |  | _____________________ |  |  |  |  |  |  | _____________________
 |  |  |  |  |  | Executive VP/COO / Date
Spreadsheet: 668413d1584806568-ascending-order-first-column-contains-blank-cells-and-second-column-does-not-blank-cells-dont-sort-like-you-want
Sheet: Sheet1

Fruits | Apple |  |  |  | Car | Toyota |  | Cars | Toyota
Fruits | Mango |  |  |  |  | Nissan |  | Cars | Nissan
Fruits | [NAME] |  | Accending order> |  |  | Ford |  | Cars | Honda
Cars | Toyota |  |  |  | Car | Honda |  | Cars | Toyota | << This is what you get
Cars | Nissan |  | I want like this |  | Fruits | Apple |  | Cars | Nissan
Cars | Ford |  | in red colour |  |  | Mango |  | Cars | Honda
Fruits | Pinapple |  | Without loosing |  |  | [NAME] |  | Cars | Ford
Fruits | Grapes |  | blank cells |  | Fruits | Pinapple |  | Fruits | Pinapple
Fruits | Pear |  |  |  |  | Grapes |  | Fruits | Pear
Cars | Honda |  |  |  |  | Pear |  | Fruits | Grapes
 |  |  | Blank Cells don't Sort based on what is above them.
 |  |  | You need to fill in those blanks to sort by them.
Spreadsheet: 826670d1682148231-hardcode-text-to-spilled-array-spilled-range-aligw
Sheet: text to spill range

unit_price | terms | currency
1165
922 |  | USD
1100 |  | USD
1100 |  | USD
865 |  | USD
1000 |  | USD
830 |  | USD
940 |  | USD
780 |  | USD
46 |  | USD
33 |  | USD
29 |  | USD
71 |  | USD
39 |  | USD
7.5 |  | USD
7 |  | USD
120 |  | USD
106 |  | USD
92 |  | USD
71 |  | USD
71 |  | USD
41 |  | USD
2.87 |  | USD
2.58 |  | USD
596 |  | USD
156 |  | USD
114 |  | USD
34.9 |  | USD
150 |  | USD
141 |  | USD
131 |  | USD
 | [NAME]
 | [NAME]
 | FOB Shanghai
 | [NAME]
Spreadsheet: eric_saibi__9799__091801R
Sheet: Huntington Canyon 01

Owner Name |  | PacifiCorp
Station Name |  | Huntington Canyon Power Station
Unit Name |  | [NAME] 01
NERC Region |  | WSCC
State |  | UT
Fuel Type |  | Coal
Capacity |  | 498 MW
Start Date |  | 2002-10-01 00:00:00
End Date |  | 2002-11-11 00:00:00
Prv. Start Date |  | 2002-04-05 00:00:00
Prv. End Date |  | 2002-04-11 00:00:00
Comments |  | Boiler Inspection
SIC |  | 4911
Plant ID |  | 1016356
Unit ID |  | 1007388
Outage ID |  | 16627
Spreadsheet: 755795d1637092666-how-to-assign-a-number-for-item-tracking-flight-saturday-producing-a-list-of-unique-numbers-dexter2-
Sheet: Data

Flight: | 443
Day: | Saturday
 | Flight # | Start | End | Duration |  |  |  | Weekday |  |  | Saturday |  |  | Sunday
 |  | 05:50:00 | 13:16:00 |  |  |  |  | 00:00:00 | 0 |  | 00:00:00 | 1 |  | 00:00:00 | 2
 |  | 06:20:00 | 13:46:00 |  |  |  |  | 0:00:00 | 3 |  | 12:00:00 | 4 |  | 12:00:00 | 5
 |  | 06:50:00 | 14:16:00 |  |  |  |  | 0:00:00 | 6 |  | Extra | 9 |  | Extra | 9
 |  | 07:20:00 | 12:16:00 |  |  |  |  | 12:00:00 | 7
 |  | 07:50:00 | 15:26:00 |  |  |  |  | 12:00:00 | 8
 |  | 08:00:00 | 10:36:00 |  |  |  |  | Extra | 9
 |  | 08:20:00 | 15:56:00
 |  | 08:30:00 | 11:06:00
 |  | 08:50:00 | 18:56:00
 |  | 09:00:00 | 19:06:00
44390 |  | 09:20:00 | 14:26:00
44391 |  | 09:30:00 | 19:55:00
44392 |  | 09:50:00 | 14:56:00
44393 |  | 10:00:00 | 15:06:00
44394 |  | 10:10:00 | 15:16:00
44395 |  | 10:30:00 | 20:25:00
44396 |  | 11:00:00 | 21:05:00
 |  | 12:10:00 | 19:35:00
44397 |  | 13:10:00 | 15:46:00
 |  | 13:30:00 | 23:14:00
 |  | 14:10:00 | 23:34:00
 |  | 14:20:00 | 23:54:00
44398 |  | 14:30:00 | 17:08:00
 |  | 14:50:00 | 1900-01-01 00:14:00
 |  | 15:10:00 | 1900-01-01 00:34:00
 |  | 15:20:00 | 1900-01-01 00:54:00
 |  | 15:40:00 | 22:54:00
44399 |  | 15:50:00 | 20:45:00
44300 |  | 17:00:00 | 19:25:00
Spreadsheet: 93437d1293021029-formula-needed-to-fetch-data-from-different-worksheets-and-include-adjacent-cells-copy-of-core-staff-leave-2010
Sheet: DD

DD
HOLIDAYS TAKEN
2010
Thursday | 1900-03-11 00:00:00 | DD
Tuesday | 1900-05-04 00:00:00 | DD
Monday | 1900-07-19 00:00:00 | DD
Tuesday | 1900-07-20 00:00:00 | DD
Wednesday | 1900-07-21 00:00:00 | DD
Thursday | 1900-07-22 00:00:00 | DD
Friday | 1900-07-23 00:00:00 | DD
Tuesday | 1900-12-07 00:00:00 | DD
Wednesday | 1900-12-08 00:00:00 | DD
STATUTORY |  | 8
Spreadsheet: 41921d1240476976-row-matching-and-duplicates-help-example
Sheet: Sheet1

Column 1 | Column 2
000099 | M
000099 | M
000039 | T
000070 | B
000067 | T
000070 | D
000093 | X
000031 | D
000010 | R
000088 | B
000035 | O
000053 | M
000080 | V
000059 | T
000014 | V
000061 | E
000064 | J
000064 | B
000031 | L
000097 | E
000055 | O
000082 | I
000093 | C
000055 | W
000095 | N
000021 | S
000069 | O
000065 | W
000042 | W
000029 | W
000031 | D
000094 | M
000060 | W
000079 | U
000075 | J
000029 | T
000016 | Y
000066 | O
000082 | W
000048 | K
000026 | M
000020 | Q
000047 | F
000031 | L
000079 | O
000076 | J
000064 | F
000022 | J
000085 | D
000035 | Z
000024 | K
000018 | S
000028 | R
000073 | N
000039 | S
000091 | D
000050 | R
000012 | A
000080 | R
000087 | M
000092 | F
Spreadsheet: kate_symes__18144__EESSales_dailyfeb
Sheet: 2-4

NP15 | 2001-02-04 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  |  | ZP26
Fixed Peak |  | Fixed Off Peak |  |  |  |  | Fixed Peak | 176.25 |  | Fixed Off Peak | 176.25 |  |  |  | Fixed Peak | 176.25 | Fixed Off Peak | 176.25
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 0 | 0 | -8.11 | -8.11 |  |  | 1 | -258.22 | 0 | -54 | -247.22 |  |  | 1 | -1.95 | 0 | 0 | -1.95
2 | 0 | 0 | -7.18 | -7.18 |  |  | 2 | -259.46 | 0 | -54 | -237.46 |  |  | 2 | -1.91 | 0 | 0 | -1.91
3 | 0 | 0 | -6.39 | -6.39 |  |  | 3 | -261.54 | 0 | -54 | -233.54 |  |  | 3 | -1.87 | 0 | 0 | -1.87
4 | 0 | 0 | -6.25 | -6.25 |  |  | 4 | -261.61 | 0 | -54 | -232.61 |  |  | 4 | -1.87 | 0 | 0 | -1.87
5 | 0 | 0 | -6.31 | -6.31 |  |  | 5 | -260 | 0 | -54 | -238 |  |  | 5 | -1.87 | 0 | 0 | -1.87
6 | 0 | 0 | -6.89 | -6.89 |  |  | 6 | -259.94 | 0 | -54 | -253.94 |  |  | 6 | -1.9 | 0 | 0 | -1.9
7 | 0 | 0 | -8.03 | -8.03 |  |  | 7 | -309.29 | 0 | -54 | -276.29 |  |  | 7 | -1.94 | 0 | 0 | -1.94
8 | 0 | 0 | -9.95 | -9.95 |  |  | 8 | -307.44 | 0 | -54 | -285.44 |  |  | 8 | -2.03 | 0 | 0 | -2.03
9 | 0 | 0 | -12.36 | -12.36 |  |  | 9 | -303.67 | 0 | -54 | -297.67 |  |  | 9 | -2.12 | 0 | 0 | -2.12
10 | 0 | 0 | -14.02 | -14.02 |  |  | 10 | -301.92 | 0 | -54 | -311.92 |  |  | 10 | -2.2 | 0 | 0 | -2.2
11 | 0 | 0 | -14.39 | -14.39 |  |  | 11 | -302.86 | 0 | -54 | -323.86 |  |  | 11 | -2.21 | 0 | 0 | -2.21
12 | 0 | 0 | -14.6 | -14.6 |  |  | 12 | -302.87 | 0 | -54 | -330.87 |  |  | 12 | -2.22 | 0 | 0 | -2.22
13 | 0 | 0 | -14.45 | -14.45 |  |  | 13 | -302.19 | 0 | -54 | -337.19 |  |  | 13 | -2.21 | 0 | 0 | -2.21
14 | 0 | 0 | -14.24 | -14.24 |  |  | 14 | -303.29 | 0 | -54 | -338.29 |  |  | 14 | -2.2 | 0 | 0 | -2.2
15 | 0 | 0 | -13.6 | -13.6 |  |  | 15 | -303.25 | 0 | -54 | -337.25 |  |  | 15 | -2.18 | 0 | 0 | -2.18
16 | 0 | 0 | -13.74 | -13.74 |  |  | 16 | -303.12 | 0 | -54 | -333.12 |  |  | 16 | -2.19 | 0 | 0 | -2.19
17 | 0 | 0 | -14.09 | -14.09 |  |  | 17 | -302.13 | 0 | -54 | -336.13 |  |  | 17 | -2.2 | 0 | 0 | -2.2
18 | 0 | 0 | -16.2 | -16.2 |  |  | 18 | -301 | 0 | -54 | -350 |  |  | 18 | -2.29 | 0 | 0 | -2.29
19 | 0 | 0 | -17.66 | -17.66 |  |  | 19 | -299.28 | 0 | -54 | -346.28 |  |  | 19 | -2.35 | 0 | 0 | -2.35
20 | 0 | 0 | -17.49 | -17.49 |  |  | 20 | -299.44 | 0 | -54 | -338.44 |  |  | 20 | -2.34 | 0 | 0 | -2.34
21 | 0 | 0 | -16.22 | -16.22 |  |  | 21 | -299.65 | 0 | -54 | -326.65 |  |  | 21 | -2.29 | 0 | 0 | -2.29
22 | 0 | 0 | -14.54 | -14.54 |  |  | 22 | -302.86 | 0 | -54 | -308.86 |  |  | 22 | -2.22 | 0 | 0 | -2.22
23 | 0 | 0 | -12.14 | -12.14 |  |  | 23 | -254.71 | 0 | -54 | -284.71 |  |  | 23 | -2.12 | 0 | 0 | -2.12
24 | 0 | 0 | -9.63 | -9.63 |  |  | 24 | -257.59 | 0 | -54 | -263.59 |  |  | 24 | -2.01 | 0 | 0 | -2.01
Spreadsheet: 161759d1339616032-excel-2007-how-to-extend-if-formula-sample
Sheet: ESTSR

[NAME]
HOJA DE NOTAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00
ESCUELA : |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
GRUPO: |  | 2ndo R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00
MAESTRO: |  | [NAME] |  |  |  |  |  | Firma del padre o encargado |  |  |  |  |  |  | _____________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
CLASE DE: |  | Ingles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
HORA: |  |  |  |  |  |  |  | Entregado en la libreta en la fecha: |  |  |  |  |  |  |  | ________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
AÑO: |  | 2012-2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-01 00:00:00
Número del estudiante |  |  | 1 |  | [NAME]: | 2012-08-01 00:00:00 |  |  | Nombre del Estudiante: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00
Puntos Total de Trabajo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-01 00:00:00
[NAME] obtenida |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
Puntos Total de Exam o Proyectos
[NAME] obtenida
 |  |  |  |  |  |  |  |  |  |  | can I combine your formula with this so I can call for the student
 |  |  | this is your formula |  |  |  |  |  |  | IF(OR($D$9="",$D$9=0,D9>35),"",IF(INDEX(N1SR!H14:H48,$D$9,1)="","",INDEX(N1SR!H14:H48,$D$9,1)))
I just noticed that the formula is adding the cell if they have
dates in the same range can I just have the formula to put what's on the cell with no adding?
in other words once it founds one within the dates puts that and stop looking or adding
 |  |  |  |  |  | This is a sample wb  the real one has 18 tabs
Spreadsheet: 110550d1307155486-vlookup-results-cannot-be-summed-sample2
Sheet: Jan

 | Number of Completed Surveys |  | - | 70 |  |  | - |  |  | - |  |  | 70 |  |  |  |  | 1520
 | Guest Loyalty & Behavior
 | Overall Experience |  | - | 81.14 |  |  | - |  |  | - |  |  | 81.14 |  |  |  |  | 79.31
 | Likely to Recommend |  | - | 83.00 |  |  | - |  |  | - |  |  | 83.00 |  |  |  |  | 80.30
 | Likely to Return to Hotel |  | - | 84.14 |  |  | - |  |  | - |  |  | 84.14 |  |  |  |  | 81.27
 | Likely to Return to Brand |  | - | 79.86 |  |  | - |  |  | - |  |  | 79.86 |  |  |  |  | 80.15
 | Value Relative to Price Paid |  | - | 73.00 |  |  | - |  |  | - |  |  | 73.00 |  |  |  |  | 73.83
Spreadsheet: 266313d1379581135-trying-to-display-the-names-using-if-statement-multiple-if-criteria
Sheet: Sheet1

Name0 | Name1 | [NAME] | Name3 | If_Formula | Final | Comments
KURT.KIM | 0 | KURT.KIM | KURT.KIM |  | KURT.KIM | if the first column is 0, it should look into next column and take that data…
0 | VALERIE.SMOLAR | 0 | VALERIE.SMOL |  | VALERIE.SMOLAR | if the first column is a name, it should give that data
VALERIE.SMOLAR | 0 | 0 | KURT.KIM |  | KURT.KIM | if the first column is 0, it should look into next column and if its again 0, then it looks into 3rd column. If it has name, then it must take that data
MATTHEW.MAHA | FELINA.PINDER | [NAME] | [NAME] |  | [NAME] | if the first column is a name, it should give that data
0 | 0 | KURT.KIM | KURT.KIM |  | KURT.KIM | if the first column is 0, it should look into next column and take that data…
[NAME] | MATTHEW.MAHAFFY | MATTHEW.MAHA | 0 |  | MATTHEW.MAHAFFY | if the first column is a name, it should give that data
Spreadsheet: 858271d1706995293-worksheet-with-dynamic-cell-references-example-excel
Sheet: Sheet1

 |  | Main Data Table
 |  |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20 | Day 21
 |  | Area 1 | 80 | 75 | 64 | 73 | 69
 |  | Area 2 | 64 | 65 | 73 | 66 | 53
 |  | Area 3 | 72 | 64 | 66 | 50 | 67
 |  | Area 4 | 63 | 66 | 51 | 77 | 80
 |  | Area 5 | 74 | 50 | 63 | 53 | 60
 |  | Area 6 | 59 | 68 | 79 | 77 | 50
 |  | Area 7 | 76 | 50 | 64 | 75 | 51
 |  | Area 8 | 64 | 57 | 68 | 75 | 78
 |  | Area 9 | 56 | 69 | 75 | 75 | 61
 |  |  |  |  |  |  |  |  |  |  |  | Everyday, a new column of values will be added to this main data table
 |  | This Summary Section will be used to present the area values each day - it only needs to show that Days Values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter Day | Day 5
 |  |  | Sector A |  |  |  | Sector B |  |  |  | Sector C
 |  |  | Area 1 | 73 |  |  | Area 5 | 53 |  |  | Area 7 | 75 |  |  |  |  |  | "=formula that return the column [NAME] from Cell T20"
 |  |  | Area 2 | 66 |  |  | Area 6 | 77 |  |  | Area 8 | 75
 |  |  | Area 3 | 50 |  |  |  |  |  |  | Area 9 | 75
 |  |  | Area 4 | 77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  | Sector A
 |  |  |  |  |  | Area 1
 |  |  |  |  |  | Area 2
 |  |  |  |  |  | Area 3
 |  |  |  |  |  | Area 4
 |  |  |  | TARGET  Summary Section
 |  |  |  |  | Sector A |  |  |  | Sector B |  |  |  | Sector C
 |  |  |  |  | Area 1 |  |  |  | Area 5 |  |  |  | Area 7
 |  |  |  |  | Area 2 |  |  |  | Area 6 |  |  |  | Area 8
 |  |  |  |  | Area 3 |  |  |  |  |  |  |  | Area 9
 |  |  |  |  | Area 4
Spreadsheet: 438020d1451682030-putting-data-in-another-worksheet-filter-dates
Sheet: Sheet1

Day | Date | Day Off
vrijdag | 2016-01-01 00:00:00
zaterdag | 2016-01-02 00:00:00 |  |  |  |  | zaterdag
zondag | 2016-01-03 00:00:00 |  |  |  |  | zondag
maandag | 2016-01-04 00:00:00 |  |  |  |  | 2016-01-01 00:00:00
dinsdag | 2016-01-05 00:00:00 |  |  |  |  | 2016-12-25 00:00:00
woensdag | 2016-01-06 00:00:00
donderdag | 2016-01-07 00:00:00
vrijdag | 2016-01-08 00:00:00
zaterdag | 2016-01-09 00:00:00
zondag | 2016-01-10 00:00:00
vrijdag | 2016-01-11 00:00:00
zaterdag | 2016-01-12 00:00:00
zondag | 2016-01-13 00:00:00
maandag | 2016-01-14 00:00:00
dinsdag | 2016-01-15 00:00:00
woensdag | 2016-01-16 00:00:00
donderdag | 2016-01-17 00:00:00
vrijdag | 2016-01-18 00:00:00
zaterdag | 2016-01-19 00:00:00
zondag | 2016-01-20 00:00:00
vrijdag | 2016-01-21 00:00:00
zaterdag | 2016-01-22 00:00:00
zondag | 2016-01-23 00:00:00
maandag | 2016-01-24 00:00:00
dinsdag | 2016-01-25 00:00:00
woensdag | 2016-01-26 00:00:00
donderdag | 2016-01-27 00:00:00
vrijdag | 2016-01-28 00:00:00
zaterdag | 2016-01-29 00:00:00
zondag | 2016-01-30 00:00:00
Spreadsheet: 135878d1326289980-application-of-array-or-fetch-functions-based-on-number-ranking-af_11012012
Sheet: Sheet1

600 | -100 | 0 | 800 | -500 |  | original
600 | 100 | 0 | 800 | 500 |  | absolute values
4 | 2 | 0 | 5 | 3 |  | rankings
 |  |  |  |  |  | "0" not ranked i.e. ranked as 0.
 |  |  |  |  |  | lowest rank is 2.
 |  |  |  |  |  | highest rank is the count of numbers - here 5th
600 | 0 | 0 | 700 | -500 |  | FINAL VALUES
 |  |  |  |  |  | "0" values to be ignored.
 |  |  |  |  |  | value of 2nd rank (-100) = 0
 |  |  |  |  |  | value of 5th rank (800)  = net value of 2nd and 5th rank
 |  |  |  |  |  | Rest of values to be kept the same
 |  |  |  |  |  | Conditions :
 |  |  |  |  |  | value of highest and lowest rank to be different.
 |  |  |  |  |  | If > 1 case of same rank, the first value to be considered.
Spreadsheet: 5ae22310-ae48-4d76-9529-ea15651730d0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Housing Opportunity Index: 3rd Quarter 2014
 |  | Areas with Population of 500,000 or more in 2013
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Youngstown-Warren-Boardman, OH-PA |  |  | 1 | San Francisco-San Mateo-Redwood City, CA ^^^
 | 2 | Syracuse, NY |  |  | 2 | Los Angeles-Long Beach-Glendale, CA ^^^
 | 3 | Indianapolis-Carmel, IN |  |  | 3 | Santa Ana-Anaheim-Irvine, CA ^^^
 | 4 | Harrisburg-Carlisle, PA |  |  | 4 | San Jose-Sunnyvale-Santa Clara, CA
 | 5 | Dayton, OH |  |  | 5 | New York-White Plains-Wayne, NY-NJ ^^^
 | 6 | Scranton--Wilkes-Barre, PA |  |  | 6 | San Diego-Carlsbad-San Marcos, CA
 | 7 | Lakeland-Winter Haven, FL |  |  | 7 | Oakland-Fremont-Hayward, CA ^^^
 | 8 | Wichita, KS |  |  | 8 | Oxnard-Thousand Oaks-Ventura, CA
 | 9 | Grand Rapids-Wyoming, MI |  |  | 9 | Honolulu, HI
 | 10 | Toledo, OH |  |  | 10 | Bridgeport-Stamford-Norwalk, CT
 |  | Areas with Population under 500,000 in 2013
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Kokomo, IN |  |  | 1 | Napa, CA
 | 1 | Cumberland, MD-WV |  |  | 2 | Santa Cruz-Watsonville, CA
 | 3 | Davenport-Moline-Rock Island, IA-IL |  |  | 3 | Salinas, CA
 | 4 | Mansfield, OH |  |  | 4 | [NAME], CA
 | 5 | Springfield, OH |  |  | 5 | [NAME], CA
 | 6 | Utica-Rome, NY |  |  | 6 | Santa Barbara-Santa Maria-Goleta, CA
 | 7 | Lima, OH |  |  | 7 | Laredo, TX
 | 8 | Monroe, MI |  |  | 8 | Ocean City, NJ
 | 9 | Binghamton, NY |  |  | 9 | [NAME], OR
 | 10 | Salisbury, MD |  |  | 10 | Barnstable Town, MA
 |  | Sales Transaction Data:  Core Logic
 |  | Interest Rates: Federal Housing Finance Agency
 |  | Median Household Income: Housing & Urban Development Department (HUD)
 |  | Property Taxes & Insurance:  Bureau of the Census
 |  | Population:  Bureau of the Census
 |  | ^^^  Indicate Metropolitan Divisions.  All others are Metropolitan Statistical Areas.
Spreadsheet: 151171d1334821241-excel-2007-grouping-in-pivot-tables-pivot_grouping_example
Sheet: Data

Name | PayAmount | BillAmount | BillExportCode
[NAME] | 10 | 12 | A
[NAME] | 20 | 24 | C
[NAME] | 30 | 36 | D
[NAME] | 10 | 12 | B
[NAME] | 20 | 24 | A
[NAME] | 20 | 24 | C
[NAME] | 20 | 24 | D
[NAME] | 20 | 24 | B
[NAME] | 30 | 36 | A
[NAME] | 40 | 48 | C
[NAME] | 50 | 60 | D
[NAME] | 10 | 13 | C
[NAME] | 20 | 26 | D
[NAME] | 30 | 39 | A
[NAME] | 10 | 13 | B
[NAME] | 20 | 26 | C
[NAME] | 20 | 26 | D
[NAME] | 20 | 26 | A
[NAME] | 20 | 26 | B
[NAME] | 30 | 39 | C
[NAME] | 40 | 52 | D
[NAME] | 50 | 65 | A
[NAME] | 10 | 14 | D
[NAME] | 20 | 28 | A
[NAME] | 30 | 42 | B
[NAME] | 10 | 14 | C
[NAME] | 20 | 28 | D
[NAME] | 20 | 28 | A
[NAME] | 20 | 28 | B
[NAME] | 20 | 28 | C
[NAME] | 30 | 42 | D
[NAME] | 40 | 56 | A
[NAME] | 50 | 70 | B