tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2fbfd3b6-f562-4ac3-8dad-218d684ea784
Sheet: Sheet1

[church name] SDA CHURCH | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
CHECK REQUEST FORM
Please Make Check Out To:_______________________________________________ |  |  |  |  | Date of Request: ___________________
 |  | Name: Please Print
RECORD OF RECEIPTS
 | Date | Store/Vendor | Items Purchased | Account to Charge | Amount
1
2
3
4
5
6
7
8
9
10
 |  |  |  | Total Amount Requested
 | Signature: ________________________________________
To be filled out by treasurer.
Date of Church Payment: __________________________
Directions:
1) Complete the top of this form, listing each receipt on a separate line .
2) Attach all receipts to this form.
 |  | A) If one receipt, tape to the bottom of this form
 |  | B) If more than one receipt, tape to the bottom and back of this form.
 |  | C) If additional space is needed, please tape to 8 ½ X 11 sheets of paper, then staple all sheets to this form.
General Guidelines for Reimbursements:
1) Church purchases should not be co-mingled with personal purchases on the same receipt.
 | Have the cashier ring up personal purchases on one receipt and church purchases on another.
2)  To be eligible for reimbursement, receipts must be turned in within 30 days of the date on the receipt
3)  Purchaser must write the purpose, department, and/or project on each receipt
4)  IMPORTANT:  For all restaurant receipts [including fast food or take-out]: Write the name(s) of those who ate.
 |  | If a large group was fed, list the name of the group followed by the number that were fed.
 |  | EXAMPLE: "Youth Group; 3 sponsors & 6 kids"
Spreadsheet: 272274d1382329732-working-schedule-test
Sheet: Days

 | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 2013-11-19 00:00:00 | 2013-11-20 00:00:00 | 2013-11-21 00:00:00 | 2013-11-22 00:00:00 | 2013-11-23 00:00:00 | 2013-11-24 00:00:00 | 2013-11-25 00:00:00 | 2013-11-26 00:00:00 | 2013-11-27 00:00:00 | 2013-11-28 00:00:00 | 2013-11-29 00:00:00 | 2013-11-30 00:00:00 | 2013-12-01 00:00:00 | 2013-12-02 00:00:00 | 2013-12-03 00:00:00 | 2013-12-04 00:00:00 | 2013-12-05 00:00:00 | 2013-12-06 00:00:00 | 2013-12-07 00:00:00 | 2013-12-08 00:00:00 | 2013-12-09 00:00:00 | 2013-12-10 00:00:00 | 2013-12-11 00:00:00 | 2013-12-12 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
[NAME]
[NAME]
Deb
[NAME]
[NAME]
Spreadsheet: 70487d1271212403-applying-condition-if-to-a-range-of-cells-test
Sheet: Sheet2

challenge
RPI-MEX
IPADE-MEX
IPADE-MEX1
UPADE-MEX
CL
RPI-MEX-1
RPI-SUBS
HI-12
FOUR-CA
BHHB-CA
DCR-SAN
RCC-SD
GGSDSU
RCC-SNA
GI-007
GGPEP3
GGUI
CNUS-LOS
IMD-22
MOS-BA
RBW-CA
RCC-LAX
U839-LAX
U891-LAX
U934-LOSA
UARC-LAX
DCR-LAX
FOU-CA
MILAIR-BUR
BMI-UT
GGUSCM
GGPEP1
GGPEP2
GGPEP4
GGPEP5
DEL-283
DEL-017
DCH-NV
DHSA-CA
Spreadsheet: 755310d1636769311-how-to-use-the-base-of-a-mround-in-a-calculation-data
Sheet: curiouscat

 | Problem 1 |  | Problem 2 |  | Problem 3 |  | Problem 4 |  | Problem 5 |  | Problem 5 |  | Problem 6 |  | Problem 7 |  | Problem 8 |  | Problem 9 |  | Problem 10 |  | Problem 11 |  | Problem 12 |  | Problem 13 |  | Problem 14 |  | Problem 15 |  | Problem 16 |  | Problem 17 |  | Problem 18 |  | Problem 19 |  | Problem 20 |  | Problem 21 |  | Problem 22 |  | Problem 23 |  | Problem 24 |  | Problem 25 |  | Problem 26 |  | Problem 27 |  | Problem 28 |  | Problem 29 |  | Problem 30
Work:
Paid time:
Day Span
Report | 03:43:00 |  | 03:46:00 |  | 04:15:00 |  | 04:20:00 |  | 04:26:00 |  | 04:48:00 |  | 04:50:00 |  | 04:55:00 |  | 05:18:00 |  | 05:20:00 |  | 05:25:00 |  | 05:39:00 |  | 05:40:00 |  | 05:50:00 |  | 05:51:00 |  | 05:56:00 |  | 06:00:00 |  | 06:00:00 |  | 06:15:00 |  | 06:17:00 |  | 06:20:00 |  | 06:23:00 |  | 06:40:00 |  | 06:41:00 |  | 07:11:00 |  | 07:15:00 |  | 04:20:00 |  | 07:15:00 |  | 07:15:00 |  | 07:20:00 |  | 07:30:00
Start
End | 08:37:00 |  | 09:17:00 |  | 08:40:00 |  | 08:39:00 |  | 09:08:00 |  | 06:43:00 |  | 08:25:00 |  | 09:39:00 |  | 10:12:00 |  | 12:27:00 |  | 09:33:00 |  | 12:53:00 |  | 09:54:00 |  | 10:59:00 |  | 10:19:00 |  | 11:08:00 |  | 10:09:00 |  | 08:39:00 |  | 10:58:00 |  | 08:12:00 |  | 09:39:00 |  | 10:49:00 |  | 09:15:00 |  | 11:47:00 |  | 08:45:00 |  | 11:49:00 |  | 08:05:00 |  | 11:12:00 |  | 11:19:00 |  | 10:39:00 |  | 10:19:00
Half Day
Report | 09:40:00 |  | 10:40:00 |  | 11:20:00 |  | 10:20:00 |  | 10:35:00 |  | 07:20:00 |  | 11:35:00 |  | 10:55:00 |  | 13:13:00 |  | 15:00:00 |  | 11:55:00 |  | 15:00:00 |  | 12:33:00 |  | 14:30:00 |  | 14:25:00 |  | 14:20:00 |  | 13:20:00 |  | 11:25:00 |  | 14:35:00 |  | 11:20:00 |  | 13:50:00 |  | 14:42:00 |  | 13:25:00 |  | 14:45:00 |  | 12:00:00 |  | 15:00:00 |  | 10:10:00 |  | 14:45:00 |  | 14:24:00 |  | 14:00:00 |  | 13:44:00
Start
11th hr
End | 12:39:00 |  | 13:19:00 |  | 16:14:00 |  | 13:59:00 |  | 13:49:00 |  | 13:47:00 |  | 16:33:00 |  | 14:09:00 |  | 16:53:00 |  | 16:15:00 |  | 16:14:00 |  | 16:07:00 |  | 17:07:00 |  | 17:21:00 |  | 17:59:00 |  | 17:48:00 |  | 17:51:00 |  | 17:39:00 |  | 18:46:00 |  | 18:12:00 |  | 19:19:00 |  | 18:59:00 |  | 19:39:00 |  | 18:32:00 |  | 19:05:00 |  | 19:06:00 |  | 15:50:00 |  | 19:31:00 |  | 19:35:00 |  | 19:29:00 |  | 19:13:00
ST
OT
Spreadsheet: 706101d1606472195-single-reference-with-multiple-return-values-sample
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  | expected result
fruits | type | place | status
apple | a | abc1 | good |  |  |  |  |  |  | find value | value return
 | b | abc2 | good |  |  |  |  |  |  | orange |  |  |  |  |  | banana | a | abc6 | good
 | c | abc3 | bad |  |  |  |  |  |  |  |  |  |  |  |  |  | b | [NAME] | good
 | d | abc4 | bad |  |  |  |  |  |  |  |  |  |  |  |  |  | c | abc8 | bad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d | abc9 | bad
banana | a | abc6 | good |  |  |  |  |  |  |  |  |  |  |  |  |  | c | abc10 | bad
 | b | [NAME] | good
 | c | abc8 | bad
 | d | abc9 | bad
 | c | abc10 | bad
pineapple | a | abc12 | good
 | b | abc13 | good
 | c | abc14 | bad
 | d | abc15 | bad
mango | a | abc17 | good
 | b | abc18 | good
 | c | abc19 | bad
 | d | abc20 | bad
 | c | [NAME] | bad
 | d | [NAME] | bad
 | c | abc23 | bad
orange | a | [NAME] | good
 | b | abc23 | good
 | c | abc24 | bad
 | d | abc25 | bad
Spreadsheet: 752720d1634910730-reorganize-data-as-new-sheets-are-added-copy-stretch-list-wed-thurs
Sheet: Copy Stretch List Wed-Thurs

Spreadsheet name | Teachername | Student Names
Oct. 18-22 | Sweat | Student 182
Oct. 18-22 | Sweat | Student 235 | I didn't add all the teacher names.  Just enough to get the idea.  I am hoping this list will grow automatically as other sheets get added.
Oct. 18-22 | Sweat | Student 36
Oct. 18-22 | Sweat | Student 176
Oct. 18-22 | Sweat | Student 316
Oct. 18-22 | Sweat | Student 171
Oct. 18-22 | Sweat | Student 336
Oct. 18-22 | Sweat | Student 349
Oct. 18-22 | Sweat | Student 254
Oct. 18-22 | Sweat | Student 96
Oct. 18-22 | Sweat | Student 353
Oct. 18-22 | Sweat | Student 279
Oct. 18-22 | Sweat | Student 121
Oct. 18-22 | Sweat | Student 291
Oct. 18-22 | Sweat | Student 65
Oct. 18-22 | Sweat | Student 257
Oct. 18-22 | Sweat | Student 193
Oct. 18-22 | Sweat | Student 353
Oct. 18-22 | Sweat | Student 271
Oct. 18-22 | Sweat | Student 172
Oct. 18-22 | [NAME] | Student 182
Oct. 18-22 | [NAME] | Student 328
Oct. 18-22 | [NAME] | Student 314
Oct. 18-22 | [NAME] | Student 331
Oct. 18-22 | [NAME] | Student 137
Oct. 18-22 | [NAME] | Student 176
Oct. 18-22 | [NAME] | Student 300
Oct. 18-22 | [NAME] | Student 131
Oct. 18-22 | [NAME] | Student 303
Oct. 18-22 | [NAME] | Student 296
Oct. 18-22 | [NAME] | Student 5
Oct. 18-22 | [NAME] | Student 176
Oct. 18-22 | [NAME] | Student 129
Oct. 18-22 | [NAME] | Student 346
Oct. 18-22 | [NAME] | Student 44
Oct. 18-22 | [NAME] | Student 250
Oct. 18-22 | [NAME] | Student 51
Oct. 18-22 | [NAME] | Student 306
Oct. 18-22 | [NAME] | Student 165
Spreadsheet: 86678d1286632408-eliminate-duplicates-in-worksheets-samplebook1
Sheet: Sheet1

Name | Address | City | Zip Code | [NAME] | Payment Status |  | [NAME] | Concatenated
[NAME] | 123 Elm | St. Louis | 65431 | [EMAIL] | Paid |  | Paid | [NAME]
[NAME] | 456 Pine | New York | 32145 | [EMAIL] |  |  |  | [NAME] New York
[NAME] | 879 Oak | Los Angeles | 98888 | [EMAIL] | Paid |  | Paid | [NAME]
[NAME] | 987 Redwood | [NAME] | 65432 | [EMAIL] |  |  |  | [NAME] 987 [NAME]
[NAME] | 576 Dogwood | Salt Lake City | 55555 | [EMAIL] | Paid |  | Paid | [NAME] 576 Dogwood Salt Lake City
Sue | 762 Main | Tempi | 46263 | [EMAIL] | Not Paid |  |  | Sue 762 Main Tempi
[NAME] | 987 Jasper | Dallas | 87654 | [EMAIL] | Paid |  | Paid | [NAME] Jasper Dallas
Spreadsheet: 110991d1307520895-nested-if-function-complex-if-and-or-function-3-
Sheet: Sheet1

Conditions |  |  | Example
a>0,b>0,c>0 | All |  | E | F | A | B | C | REMARK
a>0 | b1 |  | -9 | 0 | 0 | 0 | 0 | ap,ac,all | ap
a>0,b>0 | b1,b2 |  | 2 | 1 | 0 | 0 | 0 | ac,[NAME] | ac
a>0,c>0 | b1b3 |  | -1 | 0 | 0 | 0 | 0 | ap | ap
b>0 | b2
b>0,c>0 | b2,b3
c>0 | b3
e<0 | ap
f | ac
Spreadsheet: 158602d1338315924-excel-2007-conditional-formatting-dates-weeks-sample
Sheet: Launches

requested delivery week |  | Expected stock
Collis | Display | Greve
1 | 4 | 2
1 | 5 | 1
1 | 6 | 3
4 | 7 | 2
5 | 8 | 2
6 | 4 | 3
7 | 9 | 4
8 | 4 | 1
9 | 15 | 2
Spreadsheet: a0db147c-ae87-4d0b-8c45-7a802771e692
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3732 | 11578 | Carol | Killick | GBR | 478 | 00:39:27 | 00:03:35 | [NAME] | 00:01:53 | 00:57:22 | 1 | 03:15:56
Spreadsheet: 6ff9f825-0ff7-4bb5-a887-f38b3019695c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-08-08 09:23:06.260000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.933 | 101.808 | 101.683 | 101.308
4.5 | 101.127 | 101.002 | 100.877 | 100.502 |  | Note: | Refer To Price [NAME]
4.375 | 100.281 | 100.156 | 100.031 | 99.656 |  |  | For all Price Adjs
4.25 | 99.693 | 99.568 | 99.443 | 98.818
4.125 | 98.977 | 98.852 | 98.727 | 98.102
4 | 98.086 | 97.961 | 97.836 | 97.211
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 102.111 | 101.986 | 101.861 | 101.486
3.75 | 101.658 | 101.533 | 101.408 | 101.033
3.625 | 101.305 | 101.18 | 101.055 | 100.68
3.5 | 100.834 | 100.709 | 100.584 | 99.959
3.375 | 100.143 | 100.018 | 99.893 | 99.268
3.25 | 99.377 | 99.252 | 99.127 | 98.502 |  | Minimum loan amount:
3.125 | 98.553 | 98.428 | 98.303 | 97.678 |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-08-22 09:23:06.260000
30 DAY | 2013-09-06 09:23:06.260000
45 DAY | 2013-09-21 09:23:06.260000
60 DAY | 2013-10-06 09:23:06.260000
90 DAY | 2013-11-05 09:23:06.260000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 678491d1589913295-combine-vlookup-with-or-function-with-three-options-2020-05-19-oeldere-kibbles-vlookup-678489d1589912258-combine-vlookup-with-or-function-with-th
Sheet: WORKING TAB

Element
T3-1P293-00W-DB2
T3-1P293-00Z-FA3
T3-1P293-00Z-FC1
T3-1P293-00T
VLOOKUP(LEFT(A2,12),'SLIN rev'!A:B,2,FALSE) = Lookup against this cell through 12 characters
IF it doesn't exist
VLOOKUP(A2,'SLIN rev'!A:B,2,FALSE)) = Lookup against this cell through the entire character field
If it doesn't exist
VLOOKUP(LEFT(A2,12),'UB SLINs'!$A:B,2,FALSE) = Lookup against a different tab (UB SLINs) and bring that value back
Hello! I'm frustrated because I cannot figure out how to do the following:
I want my VLOOKUP to bring back a value if it exists; if it doesn't, look in the same table for a different combination; if that doesn't exist, look on another tab; if it doesn't exist there, bring back #N/A
My formula is:
=IFERROR(OR(VLOOKUP(LEFT(A2,12),'SLIN rev'!A:B,2,FALSE),VLOOKUP(A2,'SLIN rev'!A:B,2,FALSE)),VLOOKUP(LEFT(A2,12),'UB SLINs'!A:B,2,FALSE))
It's not working....here's the breakdown of what I'm ATTEMPTING to accomplish:
VLOOKUP(LEFT(A2,12),'SLIN rev'!A:B,2,FALSE) = Lookup against this cell through 12 characters
IF it doesn't exist
VLOOKUP(A2,'SLIN rev'!A:B,2,FALSE)) = Lookup against this cell through the entire character field
If it doesn't exist
VLOOKUP(LEFT(A2,12),'UB SLINs'!$A:B,2,FALSE) = Lookup against a different tab (UB SLINs) and bring that value back
Any help would be greatly appreciated
EDIT:
I've attached a spreadsheet example
Spreadsheet: 544867d1509070329-join-sheet-in-excel-2007-join-sheet-in-excel-2007-v2
Sheet: Compile

Sheet 1 |  |  |  |  |  |  |  | Sheet 2 |  |  |  |  |  |  |  | Sheet 3
No. | Username | [NAME] | [NAME] | Gender | [NAME] | [NAME] |  | No. | Username | [NAME] | [NAME] | Gender | [NAME] | [NAME] |  | No. | Username | [NAME] | [NAME] | Gender | [NAME] | [NAME]
Spreadsheet: 738014d1624745737-filter-table-based-on-dropdown-list-filter-table-on-dropdown
Sheet: Sheet1

 |  | Country Dropdown |  | Mexico |  |  | Unique Country List |  |  | Product | Country | Amount
 |  |  |  |  |  |  |  |  |  |  | Mexico | 345
 |  | Product | Country | Amount |  |  | Mexico |  |  | Widget 4 | Mexico | 123
 |  | Widget 1 | USA | 100 |  |  | Canada
 |  | Widget 2 | Mexico | 345
 |  | Widget 3 | USA | 753
 |  | Widget 4 | Mexico | 123
 |  | Widget 5 | Canada | 567
 |  | Widget 6 | USA | 876
Spreadsheet: 775629d1649235822-remove-space-before-the-start-of-text-and-not-within-texts-excelforum-6-april
Sheet: Sheet1

 |  | Given data | Preferred format
 |  | cvc fabric 115 cm off-white | cvc fabric 115 cm off-white
 |  | black felt fabric 150 cm- fetr | black felt fabric 150 cm- fetr
 |  | 100% polyester crepe fabric dark grey | 100% polyester crepe fabric dark grey
 |  | 100% polyester crepe fabric red | 100% polyester crepe fabric red
 |  | 100% polyester crepe fabric neon yellow | 100% polyester crepe fabric neon yellow
 |  | 100% polyester crepe fabric neon green | 100% polyester crepe fabric neon green
 |  | 100% polyester fabric neon orange | 100% polyester fabric neon orange
 |  | 100% polyester fabric canary yellow | 100% polyester fabric canary yellow
 |  | plastic buckle 5cm black | plastic buckle 5cm black
 |  | black rubber shoulder pad for webbing belt bag 4 cm | black rubber shoulder pad for webbing belt bag 4 cm
 |  | black metal tri-glide 5cm | black metal tri-glide 5cm
 |  | 100% polyester bird eye mesh fabric neon yellow | 100% polyester bird eye mesh fabric neon yellow
 |  | 100% polyester bird eye mesh fabric off-white | 100% polyester bird eye mesh fabric off-white
 |  | uniform fabric for customs officials and [NAME] | uniform fabric for customs officials and [NAME]
 |  | uniform fabric for gendarmerie- robinson | uniform fabric for gendarmerie- robinson
 |  | [NAME] plastic release buckle 5 cm- lb50wgd | [NAME] plastic release buckle 5 cm- lb50wgd
 |  | linen non-woven fabric 614 tella | linen non-woven fabric 614 tella
 |  | silver reflective round tape | silver reflective round tape
 |  | metal sling snap hook 2.5 cm | metal sling snap hook 2.5 cm
 |  | silver metal spring snap hook | silver metal spring snap hook
Spreadsheet: 766598d1643959480-search-within-an-array-table-book1
Sheet: Sheet1

Desired Results (Searchable databse)
Type the animal below | legs |  |  |  | animal database
dog | 4 |  |  |  | animal | legs
human | 2 |  |  |  | dog | 4
xyz |  |  |  |  | cat | 4
pluto |  |  |  |  | snake | 0
 |  |  |  |  | human | 2
snake | 0
dog | 4
cat | 4
Spreadsheet: 788035d1658232479-how-to-categorize-source-worksheets-to-destination-worksheets-based-on-product-type-help-7-19
Sheet: Sheet1

 | product A | product B | product B | product A | product C | product A | product B | product A | product D |  |  | product A | product A | product A | product A | product B | product B | product B | product C | product D
 | 100.005 | 200.56 | 300.89 | 400.01 | 500.6 | 600.48 | 700.26 | 800.24 | 900.09 |  |  | 100.005 | 400.01 | 600.48 | 800.24 | 200.56 | 300.89 | 700.26 | 500.6 | 900.09
 | 100.006 | 200.55 | 300.9 | 400.02 | 500.4 | 600.49 | 700.27 | 800.35 | 900.08 |  |  | 100.006 | 400.02 | 600.49 | 800.35 | 200.55 | 300.9 | 700.27 | 500.4 | 900.08
 | 100.007 | 200.54 | 300.91 | 400.03 | 500.2 | 600.5 | 700.28 | 800.46 | 900.07 |  |  | 100.007 | 400.03 | 600.5 | 800.46 | 200.54 | 300.91 | 700.28 | 500.2 | 900.07
 | 100.008 | 200.53 | 300.92 | 400.04 | 500 | 600.51 | 700.29 | 800.57 | 900.06 |  |  | 100.008 | 400.04 | 600.51 | 800.57 | 200.53 | 300.92 | 700.29 | 500 | 900.06
 | 100.009 | 200.52 | 300.93 | 400.05 | 499.8 | 600.52 | 700.3 | 800.68 | 900.05 |  |  | 100.009 | 400.05 | 600.52 | 800.68 | 200.52 | 300.93 | 700.3 | 499.8 | 900.05
 | 100.01 | 200.51 | 300.94 | 400.06 | 499.6 | 600.53 | 700.31 | 800.79 | 900.04 |  |  | 100.01 | 400.06 | 600.53 | 800.79 | 200.51 | 300.94 | 700.31 | 499.6 | 900.04
 | 100.011 | 200.5 | 300.95 | 400.07 | 499.4 | 600.54 | 700.32 | 800.9 | 900.03 |  |  | 100.011 | 400.07 | 600.54 | 800.9 | 200.5 | 300.95 | 700.32 | 499.4 | 900.03
 | 100.012 | 200.49 | 300.96 | 400.08 | 499.2 | 600.55 | 700.33 | 801.01 | 900.02 |  |  | 100.012 | 400.08 | 600.55 | 801.01 | 200.49 | 300.96 | 700.33 | 499.2 | 900.02
 | 100.013 | 200.48 | 300.97 | 400.09 | 499 | 600.56 | 700.34 | 801.12 | 900.01 |  |  | 100.013 | 400.09 | 600.56 | 801.12 | 200.48 | 300.97 | 700.34 | 499 | 900.01
 | 100.014 | 200.47 | 300.98 | 400.1 | 498.8 | 600.57 | 700.35 | 801.23 | 900 |  |  | 100.014 | 400.1 | 600.57 | 801.23 | 200.47 | 300.98 | 700.35 | 498.8 | 900
 | 100.015 | 200.46 | 300.99 | 400.11 | 498.6 | 600.58 | 700.36 | 801.34 | 899.99 |  |  | 100.015 | 400.11 | 600.58 | 801.34 | 200.46 | 300.99 | 700.36 | 498.6 | 899.99
 | 100.016 | 200.45 | 301 | 400.12 | 498.4 | 600.59 | 700.37 | 801.45 | 899.98 |  |  | 100.016 | 400.12 | 600.59 | 801.45 | 200.45 | 301 | 700.37 | 498.4 | 899.98
 | source worksheet |  |  |  |  |  |  |  |  |  |  | Destination worksheet
Spreadsheet: 65177d1265894699-multi-level-bill-of-material-717631_neorez
Sheet: formulas

Products | Ingredients | %
Yellow 13 ink | Yellow 13 Base | 0.55
Yellow 13 ink | Varnish 4347 | 0.32
Yellow 13 ink | IA 10 | 0.02
Yellow 13 ink | [NAME] | 0
Yellow 13 ink | Acetate | 0.09
Yellow 13 ink | Ethanol
Yellow 13 Base | Pigment Yellow 13 | 0.2
Yellow 13 Base | [NAME] | 0.3
Yellow 13 Base | DBP | 0.02
Yellow 13 Base | S 22000 | 0.002
Yellow 13 Base | S 54000 | 0.012
Yellow 13 Base | [NAME] | 0.048
Yellow 13 Base | Acetate | 0.06
Yellow 13 Base | Ethanol
Varnish 4347 | [NAME] | 0.6
Varnish 4347 | U-347 | 0.25
Varnish 4347 | Ethanol
Varnish 4347 | Acetate | 0.11667
Spreadsheet: 142763d1330005845-not-including-blank-data-in-charts-graph-requirement
Sheet: Sheet1

 | Date of Birth | 1983-11-16 00:00:00
 | Age
Age | Interest | Total Value
Spreadsheet: 167725d1342081885-count-unique-values-once-with-multiple-criteria-across-multiple-sheets-sample-file
Sheet: Sheet1

Invoice Date | Invoice No. | Customer ID | Customer Name | Customer Type | Sales
2012-06-10 00:00:00 | A123 | B123 | Adolf Pharmacy | Pharmacy | 100
2012-06-10 00:00:00 | A124 | B124 | Dido Mart | [NAME] | 124
2012-06-10 00:00:00 | A125 | B125 | [NAME] | Pharmacy | 124
2012-06-13 00:00:00 | A126 | B126 | Eight Twelve | [NAME] | 154
2012-06-13 00:00:00 | A127 | B127 | [NAME] | Wholesaler | 500
2012-06-14 00:00:00 | A128 | B123 | Adolf Pharmacy | Pharmacy | 123
2012-06-14 00:00:00 | A129 | B225 | Aluadin | Wholesaler | 500
2012-06-14 00:00:00 | A130 | B303 | Stiff Job Pharmacy | Pharmacy | 231
2012-06-14 00:00:00 | A131 | B898 | [NAME] | [NAME] | 231
2012-06-14 00:00:00 | A132 | B765 | Floor Mart | [NAME] | 230
2012-06-15 00:00:00 | A133 | B654 | Dido Mart | [NAME] | 231
2012-06-15 00:00:00 | A134 | B123 | Adolf Pharmacy | Pharmacy | 123
2012-06-16 00:00:00 | A135 | B671 | [NAME] | Wholesaler | 500
 |  |  | Number of Effective Outlet From 6/10/12 - 6/15/2012:
 |  |  |  | Result: | Expected Result:
 |  |  | Pharmacy |  | 3
 |  |  | [NAME] |  | 3
 |  |  | Wholesaler |  | 2
 |  |  | [NAME] |  | 1
Spreadsheet: 738144d1624872727-number-of-cells-between-2-cells-in-a-range-cell-spacing-new-range
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5
1
10
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Nov18-Nov24m

Main Arena
 | 2012-11-18 00:00:00 |  |  | Thru | 2012-11-24 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-11-18 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-24 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  | CLOSED |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  | CLOSED |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  | CLOSED |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  | CLOSED |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  | CLOSED |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  | CLOSED |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  | CLOSED |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  | CLOSED |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  | CLOSED |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  | CLOSED |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  | CLOSED |  |  | 12:00PM
 |  |  |  |  | CLOSED
1:00PM |  |  |  |  | CLOSED |  |  | 1:00PM
 |  |  |  |  | CLOSED
2:00PM |  |  |  |  | CLOSED |  |  | 2:00PM
 |  |  |  |  | CLOSED
3:00PM |  |  |  |  | CLOSED |  |  | 3:00PM
 |  |  |  |  | CLOSED
4:00PM |  |  |  |  | CLOSED |  |  | 4:00PM
 |  |  |  |  | CLOSED
5:00PM |  |  |  |  | CLOSED |  |  | 5:00PM
 |  |  |  |  | CLOSED
6:00PM |  |  |  |  | CLOSED |  |  | 6:00PM
 |  |  |  |  | CLOSED
7:00PM |  |  |  |  | CLOSED |  |  | 7:00PM
 |  |  |  |  | CLOSED
8:00PM |  |  |  |  | CLOSED |  |  | 8:00PM
 |  |  |  |  | CLOSED
9:00PM |  |  |  |  | CLOSED |  |  | 9:00PM
 |  |  |  |  | CLOSED
10:00PM |  |  |  |  | CLOSED |  |  | 10:00PM
 |  |  |  |  | CLOSED
11:00PM |  |  |  |  | CLOSED |  |  | 11:00PM
 |  |  |  |  | CLOSED
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments