tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 801126d1666095744-prime-numbers-book1
Sheet: Sheet1

 | 3
 | 5
 | 7
 | 11
 | 13
 | 17
 | 19
 | 23
 | 29
 | 31
 | 37
 | 41
 | 43
 | 47
 | 53
 | 59
 | 61
 | 67
 | 71
 | 73
 | 79
 | 83
 | 89
 | 97
 | 101
 | 103
 | 107
 | 109
 | 113
 | 127
 | 131
 | 137
 | 139
 | 149
 | 151
 | 157
 | 163
 | 167
 | 173
 | 179
 | 181
 | 191
 | 193
 | 197
 | 199
 | 211
 | 223
 | 227
 | 229
 | 233
 | 239
 | 241
 | 251
 | 257
 | 263
 | 269
 | 271
 | 277
 | 281
 | 283
 | 293
 | 307
 | 311
 | 313
 | 317
 | 331
 | 337
 | 347
 | 349
 | 353
 | 359
 | 367
 | 373
 | 379
 | 383
 | 389
 | 397
 | 401
 | 409
 | 419
 | 421
 | 431
 | 433
 | 439
 | 443
 | 449
 | 457
 | 461
 | 463
 | 467
 | 479
 | 487
 | 491
 | 499
 | 503
 | 509
 | 521
 | 523
 | 541
 | 547
 | 557
 | 563
 | 569
 | 571
 | 577
 | 587
 | 593
 | 599
 | 601
 | 607
 | 613
 | 617
 | 619
 | 631
 | 641
 | 643
 | 647
 | 653
 | 659
 | 661
 | 673
 | 677
 | 683
 | 691
 | 701
 | 709
 | 719
 | 727
 | 733
 | 739
 | 743
 | 751
 | 757
 | 761
 | 769
 | 773
 | 787
 | 797
 | 809
 | 811
 | 821
 | 823
 | 827
 | 829
 | 839
 | 853
 | 857
 | 859
 | 863
 | 877
 | 881
 | 883
 | 887
 | 907
 | 911
 | 919
 | 929
 | 937
 | 941
 | 947
 | 953
 | 967
 | 971
 | 977
 | 983
 | 991
 | 997
Spreadsheet: 600170d1543506385-vlookup-specific-text-specific-text-example
Sheet: Sheet1

TABLE A |  |  |  |  |  |  |  | TABLE B
Store | Account | Center # |  |  |  |  |  | Store | Account | Center #
123 Handy |  |  |  |  |  |  |  | Handy | 55A | 123456
123 Dandy |  |  |  |  |  |  |  | Dandy | 66A | 456789
987 Handy |  |  |  |  |  |  |  | Candy | 79Q | 789012
759 Candy
 |  | I would like to use the specifc store name (Handy, Dandy, or [NAME]) to look up in TABLE B to fill in the Account and Center # cells.
TABLE A (OUTPUT GOAL)
Store | Account | Center #
123 Handy | 55A | 123456
123 Dandy | 66A | 456789
987 Handy | 55A | 123456
759 Candy | 79Q | 789012
Spreadsheet: 168354d1342421644-sorting-numbers-according-to-their-appearance-in-rows-and-colums-test-1-9
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  | 1
2 | 3 | 4 | 5 | 6 | 1 | 8 | 9 | 1 |  |  | 2
3 | 9 | 8 | 7 | 6 | 5 | 8 | 3 | 2 |  |  | 3
4 | 5 | 1 | 5 | 8 | 9 | 1 | 2 | 3 |  |  | 4
5 | 4 | 3 | 2 | 1 | 9 | 8 | 7 | 6 |  |  | 5
6 | 1 | 2 | 3 | 4 | 5 | 7 | 8 | 9 |  |  | 6
7 | 8 | 9 | 6 | 5 | 2 | 3 | 2 | 1 |  |  | 7
8 | 1 | 2 | 1 | 4 | 5 | 6 | 7 | 9 |  |  | 8
9 | 8 | 7 | 6 | 5 | 4 | 3 | 1 | 1 |  |  | 9
Spreadsheet: 96176d1295593575-show-data-in-sequence-row-groupautolist
Sheet: Sheet2

SELECT GROUP | GROUP1 |  | Select Group | GroupNum | << Does making it a list and auto filter work?
A |  |  | A | GROUP1
 |  |  | B | [NAME]
 |  |  | C | GROUP3
 |  |  | D | GROUP3
 |  |  | F | GROUP3
 |  |  | G | GROUP3
 |  |  | H | [NAME]
 |  |  | I | [NAME]
 |  |  | J | [NAME]
 |  |  | K | [NAME]
 |  |  | L | [NAME]
M |  |  | M | GROUP1
N |  |  | N | GROUP1
Spreadsheet: 811212d1672348880-help-if-formula-with-conditions-payment-forumla-problem-bsb-
Sheet: Sheet1

Total payment | 12254
Base Payment | 2800
Payment 1 |  | formula to run - display 2800 | 1
Payment 2 |  | formula to run - display 2800 | 1
Payment 3 |  | formula to run - display 2800 | 1
Payment 4 |  | formula not to run - display 0, then when I enter 1 in d10 - to display 2800 again
Payment 5
Payment 6
Payment 7
Payment 8
Payment 9
Payment 10
Spreadsheet: 30236755-1152-4c4e-ad84-d76bf0965369
Sheet: 2002

WEST BRANCH MARINA HISTORICAL DATA - 2002
Category |  |  |  |  |  |  |  |  |  |  |  |  | Total | Commission | %
of Revenue | Jan. | Feb. | March | Apr. | May | Jun. | Jul. | Aug. | Sept. | Oct. | Nov. | Dec. | Receipts | Paid | Paid
Rental - Boats & Motors | 0 | 0 | 0 | 0 | 4696.25 | 24668 | 44496 | 33358 | 12575 | 405 | 0 | 0 | 120198.25 | 9615.859999999999 | 0.08
Marine Equipment Sales | 0 | 0 | 0 | 0 | 843.11 | 4861.54 | 6522.52 | 3355.86 | 1476.7 | 0 | 0 | 0 | 17059.73 | 767.6800000000001 | 0.045
Bait and Tackle | 0 | 0 | 0 | 0 | 681.46 | 1381.12 | 1533.78 | 906.68 | 445.15 | 0 | 0 | 0 | 4948.19 | 321.62 | 0.065
Gas and Oil | 0 | 0 | 0 | 0 | 1723.47 | 10705.87 | 18036.96 | 12350.84 | 7686.73 | 77.85 | 0 | 0 | 50581.71999999999 | 0 | 0
Food and Beverage | 0 | 0 | 0 | 0 | 1857.98 | 7366.22 | 8254.09 | 5823.1 | 2220.66 | 357.8 | 0 | 0 | 25879.85 | 1682.19 | 0.065
Vending Machines | 0 | 0 | 0 | 0 | 147 | 1038 | 842 | 316 | 71 | 30 | 0 | 0 | 2444 | 158.87 | 0.065
Transient Dockage | 0 | 0 | 0 | 0 | 40 | 340 | 670 | 260 | 90 | 0 | 0 | 0 | 1400 | 672 | 0.48
Souvenirs and Sundries | 0 | 0 | 0 | 0 | 0 | 48.48 | 0 | 0 | 0 | 0 | 0 | 0 | 48.48 | 3.88 | 0.08
All Other Receipts | 0 | 0 | 0 | 0 | 67.98 | 363.15 | 514.73 | 170.37 | 85.12 | 0 | 0 | 0 | 1201.35 | 78.08000000000001 | 0.065
Totals | 0 | 0 | 0 | 0 | 10057.25 | 50772.38 | 80870.08 | 56540.85000000001 | 24650.36 | 870.6500000000001 | 0 | 0 | 223761.57 | 13300.18
Spreadsheet: 884662d1733905442-sum-data-with-condition-kimudao-sumif-2-pt-365-aligw
Sheet: Sheet1

Cust | Accounting Month | Net Sales (EUR) | Values | Active L12M |  |  | Active L12M | (Multiple Items)
A | 2023 - 01 | 100
B | 2023 - 02 | 0 |  |  |  |  | Sum of Values2 | Column Labels
B | 2023 - 03 | 0 |  |  |  |  | Row Labels | 2024 - 01 | 2024 - 02 | 2024 - 05 | Grand Total
C | 2023 - 05 | 200 |  |  |  |  | A | 20 |  |  | 20
C | 2023 - 12 | 200 |  |  |  |  | B |  | 19 |  | 19
C | 2023 - 12 | 300 |  |  |  |  | C |  |  | 11 | 11
A | 2024 - 01 | 20 |  |  |  |  | Grand Total | 20 | 19 | 11 | 50
B | 2024 - 02 | 19
B | 2024 - 03 |  |  |  |  |  | I 'd like to filter only data in 12 '23 - 11 '24 and sum this month range > 0 when filter with active L12M . My formula is correct? I found result is ok but when I use real data to test still show sum 12 m rolling = 0 but I can't use real data to post , real data some have blank as well but i tried to delete as blank in this file but it work in this file but not work in real job.Please kindly suggest.
C | 2024 - 04 | 0
C | 2024 - 05 | 11
C | 2023 - 12 | 30
A | 2024 - 07 | 0
B | 2024 - 08
B | 2024 - 09 | 0
C | 2024 - 10 | 0
C | 2024 - 11 | 0
Spreadsheet: 740182d1626213536-countif-not-working-with-true-criterion-functional-detailed-cs-schedule-sample
Sheet: Friday

 | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00 |  |  |  |  | Attendance
 | 7:00a | 7:15a | 7:30a | 7:45a | 8:00a | 8:15a | 8:30a | 8:45a | 9:00a | 9:15a | 9:30a | 9:45a | 10:00a | 10:15a | 10:30a | 10:45a | 11:00a | 11:15a | 11:30a | 11:45a | 12:00p | 12:15p | 12:30p | 12:45p | 1:00p | 1:15p | 1:30p | 1:45p | 2:00p | 2:15p | 2:30p | 2:45p | 3:00p | 3:15p | 3:30p | 3:45p | 4:00p | 4:15p | 4:30p | 4:45p | 5:00p | 5:15p | 5:30p | 5:45p | 6:00p | 6:15p | 6:30p | 6:45p | NA | A | UA | T
Talk Agents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
Total staffed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Staff needed
Number of Calls
Spreadsheet: 53646d1253583407-help-with-autoshapes-and-gantt-charts-example
Sheet: Gantt

 |  | 2009/10 Construction Program
 | Weeks remaining  51 | Weeks remaining  50 | Weeks remaining  50 | Weeks remaining  49 | Weeks remaining  48 | Weeks remaining  47 | Weeks remaining  46 | Weeks remaining  45 | Weeks remaining  44 | Weeks remaining  43 | Weeks remaining  42 | Weeks remaining  41 | Weeks remaining  40 | Weeks remaining  39 | Weeks remaining  38 | Weeks remaining  37 | Weeks remaining  36 | Weeks remaining  35
Day/Mth | 2009-06-22 00:00:00 | 2009-06-29 00:00:00 | 2009-07-06 00:00:00 | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 2009-07-27 00:00:00 | 2009-08-03 00:00:00 | 2009-08-10 00:00:00 | 2009-08-17 00:00:00 | 2009-08-24 00:00:00 | 2009-08-31 00:00:00 | 2009-09-07 00:00:00 | 2009-09-14 00:00:00 | 2009-09-21 00:00:00 | 2009-09-28 00:00:00 | 2009-10-05 00:00:00 | 2009-10-12 00:00:00 | 2009-10-19 00:00:00
P.A
P.B
P.C
Spreadsheet: 455267d1460212233-summary-ageing-formula-ageing-example-2-
Sheet: Output

FLAT | Date | DUE AMT | TODAY | NO OF DAYS | >120 | 91-120 | 61-90 | 30-60 | 0-30 | FUTURE DUES
A1004 | 2016-01-15 00:00:00 | 20000 | 2016-04-09 00:00:00
A1004 | 2016-03-31 00:00:00 | 30000 | 2016-04-09 00:00:00
A1104 | 2015-12-15 00:00:00 | 40000 | 2016-04-09 00:00:00
A1104 | 2016-01-12 00:00:00 | 50000 | 2016-04-09 00:00:00
A1004
A1104
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Pipeline Vols

Volume Assumptions
Volume Assumptions
([NAME] in TBtu's) |  |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  | Included? |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Existing Pipeline
 | Affiliated Volumes |  | 1 |  | 117600 | 116600
 | Non-affiliated [NAME] |  | 1 |  | 135900 | 158600
New Projects (Total Capacity)
 | Mainline 104 |  | 1
 | Southern Trails |  | 0 |  |  |  | 0
 | Central Utah |  | 1
[NAME] (MMBtu)
Storage |  |  | 1 |  |  | 117500
Spreadsheet: 250477d1373950685-delete-all-rows-in-workbook-with-same-title-ffcs-sample
Sheet: QBs

Pos# | P-Rnk | Player | ADP | Team | Bye | PassYds | PassTDs | Fumbles | Tot Pts
QB 1 | 1
QB 2 | 2
QB 3 | 3
QB 4 | 4
QB 5 | 5
Spreadsheet: 802857d1667083978-xirr-calculation-error-xirr-multicol
Sheet: descend

original data |  |  |  |  |  |  | reordered data (helper cells)
 | deposit (+) withdraw (-) | invest | cuml net cash flows | end bal | IRR to date |  |  | deposit (+) withdraw (-) | invest | end bal | IRR to date
2016-08-01 00:00:00 |  | 150 |  | 1819.73
2016-07-01 00:00:00 |  | 200 |  | 1686.59
2016-06-01 00:00:00 |  |  |  | 1491.84
2016-05-01 00:00:00 |  | 150 |  | 1420.8
2016-04-01 00:00:00 |  | 150 |  | 1310.1
2016-03-01 00:00:00 | -200 |  |  | 1137.35
2016-02-01 00:00:00 | -1 | 150 |  | 1298.4
2016-01-01 00:00:00 | 1 | 150 |  | 1160
2015-12-01 00:00:00 | 1 | 1000
Spreadsheet: 221731d1363650076-combo-box-to-filter-data-in-excel-book1test
Sheet: Main table

 |  | WARD
 |  | MONTH
 |  | YEAR
Year | MONTH | COMMENTS | STATUS | WARD
2011 | September | example data 1 | positive | Ward 1
2011 | September | example data 2 | positive | Ward 1
2011 | September | example data 3 | positive | Ward 1
2011 | October | example data 2 | Need to Improve | Burns
2011 | November | example data 3 | positive | PAU
2012 | September | example data 4 | Need to Improve | Ward 1
2011 | September | example data 5 | Need to Improve | Ward 1
Spreadsheet: 867234d1714079269-formula-to-return-last-non-blank-value-in-column-when-data-filtered-filter-test
Sheet: Sheet1

account | q | w | e | r | t | y | u | i | o | p | a | s | d | f | g | h | j |  | Helper
1222
1222
1222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BW
1222
1222
1222
1222
1222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BW
1222
1222
1222
1222
1222
1222
1222
1222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTSC
1222
2222
2222
2222
2222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTSC
2222
2222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER
2222
2222
2222
2222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BW
3333
3333
3333
3333
3333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTSC
3333
3333
3333
3333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER
3333
Spreadsheet: 12ff8c58-268d-4c69-ba97-02e55fa031ca
Sheet: Sheet1

Your Name Here database instructions
For the 5200 Your Name Here Appointment Calendar:
For the 5210 Your Name Here Desk Calendar:
1.) Save this database with your own naming convention to a location that is convenient for you.
2.) Choose the tab labeled [NAME] if you want your order packed bulk.
Choose the tab labeled Individual Mail if you want your order individually mailed (extra charges apply)
3.) You will need to supply the following information for all names:
* First Name (Must be 15 characters or less)
* Last name (Must be 15 characters or less)
* The Full Name field is automatically populated
4.) If you are requesting your calendars to be individually mailed, you will also need to supply:
* Company Name (if applicable)
* Address
* City
* State
* Zip
* Country (if other than USA)
5.) Your ad copy and any artwork that is to be printed in the imprint area must be supplied.
6.) Send us your database, order and ad copy/artwork.
Additional Information
Double-check all submitted names. [NAME] is not responsible for errors in names or addresses supplied and will not make changes to the submitted database. We do not recommend copying from an existing spreadsheet as the character limit notice will not alert you if there is an issue.
Type First & Last Names in upper/lower case so the software works correctly
Do not include any special characters (example: &, #, @) in the First and Last Names
- comma, apostrophe, quotes, period or hyphen are OK
Type the Company Name exactly as you want it to appear - either upper/lower or all CAPS.
- We suggest no more that 20 characters to ensure the company name is readable.
Spreadsheet: 94565d1294340496-finding-matching-date-matching-date
Sheet: matchingdate

1 | 2011-01-06 00:00:00 | [NAME] | Newport | RI | USA |  |  | In B1:B20 I have dates
2 | 2011-01-05 00:00:00 | [NAME] | Newport | RI | USA |  |  | In G1:G20 there are some numbers
3 | 2011-01-04 00:00:00 | [NAME] | Newport | RI | USA
4 | 2011-01-03 00:00:00 | [NAME] | Newport | RI | USA | 2 |  | I want to look in G1:G20 and find the first row that contains a number and
5 | 2011-01-02 00:00:00 | [NAME] | Newport | RI | USA |  |  | then find the corresponding matching date in B1:[NAME]
6 | 2011-01-01 00:00:00 | [NAME] | Newport | RI | USA
7 | 2010-12-31 00:00:00 | [NAME] | Newport | RI | USA | 3 |  | in this example, the first number in G1:G20 is a 2 (in G4), therefore I would like
8 | 2010-12-30 00:00:00 | [NAME] | Newport | RI | USA |  |  | to return the value of 1/3/2011 (B4)
9 | 2010-12-29 00:00:00 | [NAME] | Newport | RI | USA | 2 |  | I need help writing a formula for this.
10 | 2010-12-28 00:00:00 | [NAME] | Newport | RI | USA
11 | 2010-12-27 00:00:00 | [NAME] | Newport | RI | USA
12 | 2010-12-26 00:00:00 | [NAME] | Newport | RI | USA
13 | 2010-12-25 00:00:00 | [NAME] | Newport | RI | USA
14 | 2010-12-24 00:00:00 | [NAME] | Newport | RI | USA | 1
15 | 2010-12-23 00:00:00 | [NAME] | Newport | RI | USA
16 | 2010-12-22 00:00:00 | [NAME] | Newport | RI | USA
17 | 2010-12-21 00:00:00 | [NAME] | Newport | RI | USA
18 | 2010-12-20 00:00:00 | [NAME] | Newport | RI | USA
19 | 2010-12-19 00:00:00 | [NAME] | Newport | RI | USA | 4
20 | 2010-12-18 00:00:00 | [NAME] | Newport | RI | USA
Spreadsheet: 547581d1510635404-how-to-merge-tabs-and-make-the-columns-inside-each-tab-alternate-with-each-other-how-to-merge-tabs-and-make-the-columns-inside-each-tab-alternate-with-each-other
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  | Original
 |  |  |  |  |  |  |  |  |  |  | Tab1 Col1 | Tab2 Col1 | Tab3 Col1 | Tab1 Col2 | Tab2 Col2 | [NAME] | Tab1 Col3 | Tab2 Col3 | Tab3 Col3
 |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 6 | 2 | 12 | 56 | 4 | 3 | 14
 |  |  |  |  |  |  |  |  |  |  | 2 | 6 | 7 | 3 | 13 | 57 | 5 | 4 | 15
 |  |  |  |  |  |  |  |  |  |  | 3 | 7 | 8 | 4 | 14 | 58 | 6 | 5 | 16
 |  |  |  |  |  |  |  |  |  |  | 4 | 8 | 9 | 5 | 15 | 59 | 7 | 6 | 17
 |  |  |  |  |  |  |  |  |  |  | 5 | 9 | 10 | 6 | 16 | 60 | 8 | 7 | 18
 |  |  |  |  |  |  |  |  |  |  | 6 | 10 | 11 | 7 | 17 | 61 | 9 | 8 | 19
 |  |  |  |  |  |  |  |  |  |  | 7 | 11 | 12 | 8 | 18 | 62 | 10 | 9 | 20
 |  |  |  |  |  |  |  |  |  |  | 8 | 12 | 13 | 9 | 19 | 63 | 11 | 10 | 21
Spreadsheet: 688021d1595528747-counting-columns-based-on-criteria-dates-match-column-data-example
Sheet: Sheet2

2020-07-20 00:00:00 | 2020-08-03 00:00:00 | 2020-08-17 00:00:00 | 2020-08-31 00:00:00 |  | Yes | No | Yes | No
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | Yes | No | Yes | No
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | Yes | No | Yes | No
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | Yes | No | Yes | No
 |  |  |  |  | No | Yes | No | Yes
 |  |  |  |  | No | Yes | No | Yes
Spreadsheet: a02f3c66-4f84-487d-b05d-9ea9baedc4ac
Sheet: Tble 12

Table 12
U.S. Export Balances and Cumulative Exports (1,000 metric tons)
 | Wheat |  |  |  |  |  | Corn | Soybeans | Total
Week ending | HRW | SRW | HRS | SWW | DUR | All wheat
Export Balances1
This week year ago
Cumulative exports-marketing year 2
2012/13 YTD
2011/12 YTD
YTD 2012/13 as % of 2011/12
Last 4 wks as % of  same period 2011/12
2011/12 Total | 9904 | 4319 | 6312 | 5601 | 491 |  | 37900 | 36727
2010/11 Total | 15837 | 2828 | 8623 | 4717 | 979 |  | 44569 | 39753
1 Current unshipped export sales to date
2 Shipped export sales to date; new marketing year begins for corn and soybeans
Note:  YTD = year-to-date.  Marketing Year: wheat = 6/01-5/31, corn & soybeans = 9/01-8/31
Source:  Foreign Agricultural Service/USDA (www.fas.usda.gov)
Spreadsheet: 714508d1611248970-help-computing-a-running-total-between-2-sheets-book6
Sheet: Sheet1

 |  | Date |  | Incoming Weight
PO | Line | Mon 01/25 | 10:00:00 | 45000 | Status
PO | Line | Mon 01/25 | 15:00:00 | 45000 | Status
PO | Line | Tue 01/26 | 10:00:00 | 45000 | Status
PO | Line | Tue 01/26 | 15:00:00 | 45000 | Status
PO | Line | Tue 01/26 | 15:00:00 | 0 | Status
PO | Line | Wed 01/27 | 10:00:00 | 45000 | Status
PO | Line | Wed 01/27 | 15:00:00 | 45000 | Status
PO | Line | Thu 01/28 | 10:00:00 | 45000 | Status
PO | Line | Thu 01/28 | 15:00:00 | 45000 | Status
PO | Line | Fri 01/29 | 10:00:00 | 45000 | Status
PO | Line | Fri 01/29 | 15:00:00 | 45000 | Status
PO | Line | Sat 01/30 | 10:00:00 | 45000 | Status
PO | Line | Sat 01/30 | 15:00:00 | 45000 | Status
PO | Line | Sun 01/31 | 10:00:00 | 45000 | Status
This is the schedule, I assume some sort of VLOOKUP formula needs to be done utilizing Columns C and E
I want to take the incoming weight, and have it added to the running total on the previous sheet
Example: The previous sheet shows a starting of 200,000. Then on Monday we are using a total of 82,204 between both production lines; but on Monday we also have an incoming qty of 90,000
(See Rows 4 and 5)
How can I set up the VLOOKUP to add the weight on the 1st page based on the dates and qtys on the 2nd?
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Acrylic

233-A Jefferson Street • Newnan, GA 30263 |  |  |  | Phone: [PHONE]
 | Quantity
Size | 18 | 24 | 36 | 48 | 60 | 72 | 96
12 | 30 | 30 | 80 | 80 | 140 | 140 | 130
18 | 30 | 30 | 80 | 80 | 140 | 140 | 130
24 | 30 | 50 | 80 | 80 | 140 | 140 | 130
36 | 30 | 60 | 80 | 80 | 140 | 140 | 130
48 | 30 | 60 | 80 | 70 | 130 | 130 | 120
Spreadsheet: 91319d1291076426-excel-2007-copy-from-one-sheet-to-another-if-a-condition-is-met-copy-of-admin-budget-revised2
Sheet: Raw Data

Item | Transaction Type | Account | Job Center | Purchaser | Purchase Date | Month | Period | Quantity | Cost/unit | Subtotal | Fee | GST | PST | HST | Total
Monitor | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 129.99 |  | 9 | 0 | 0
Training Cable | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 45 |  | 8 | 0 | 0
Headset | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 86 |  |  | 0 | 0
Headset Connect Cord | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 2 | 96 |  |  | 0 | 0
Headset tools | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 15.1 |  | 8 | 0 | 0
5-Port Switch | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 39.15 |  |  | 0 | 0
[NAME] | Expense | Office Equipment & Furniture | Not Applicable | [NAME] | 2010-06-01 00:00:00 |  |  | 1 | 19.99 |  |  | 0 | 0
Groceries | Expense | [NAME] | Not Applicable | [NAME] | 2010-06-01 00:00:00 |  |  | 1 | 45.01 |  |  | 0 | 0
Groceries | Expense | [NAME] | Not Applicable | [NAME] | 2010-07-01 00:00:00 |  |  | 1 | 19.93 |  |  | 0 | 0
Groceries | Expense | [NAME] | Not Applicable | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 13.93 |  |  | 0 | 0
[NAME] | Expense | [NAME] | Not Applicable | [NAME] | 2010-06-01 00:00:00 |  |  | 1 | 26.98 |  |  | 0 | 0
Groceries | Expense | [NAME] | Not Applicable | [NAME] | 2010-06-01 00:00:00 |  |  | 1 | 2.38 |  |  | 0.12 | 0
Postage Stamps | Expense | Shipping | Not Applicable | [NAME] | 2010-06-01 00:00:00 |  |  | 1 | 17.1 |  |  | 0 | 0
Postage Stamps | Expense | Shipping | Not Applicable | [NAME] | 2010-06-01 00:00:00 |  |  | 1 | 13.23 |  |  | 0 | 0.66
Postage Stamps | Expense | Shipping | Pakit | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 9.48 |  |  | 0 | 0
Postage Stamps | Expense | Shipping | Pakit | [NAME] | 2010-08-01 00:00:00 |  |  | 1 | 7.98 |  |  | 0 | 0
Cash Float | Cash Input | Cash Input | Not Applicable | Cash | 2010-11-26 00:00:00 |  |  | 1 | 100 |  | 0 | 0 | 0
Test1 | Expense | Office Equipment & Furniture | Not Applicable | Nick | 2010-11-22 00:00:00 |  |  | 1 | 10 |  | 0 | 0 | 0
Test2 | Expense | [NAME] | Not Applicable | Nick | 2010-10-10 00:00:00 |  |  | 1 | 15
Test 3 | Different TRXN | Different Account | MNP | Nick | 2010-11-25 00:00:00 |  |  | 3 | 24 |  | 2 | 3 | 3 | 4
Spreadsheet: 704518d1605610566-how-to-combine-data-from-multiple-rows-into-a-single-row-multiple-columns-create-mail-merge
Sheet: Sheet1 (2)

CUSTOMER NUMBER | CUSTOMER NAME | ITEM | NUMBER | COST | TOTAL VALUE | TOTAL INVOICE TOTAL
CUSTOMER ONE | CUSTOMER NAME ONE | ITEM 1 | 1 | 5000 | 5000
CUSTOMER ONE | CUSTOMER NAME ONE | ITEM 2 | 5 | 2000 | 10000
CUSTOMER ONE | CUSTOMER NAME ONE | ITEM 3 | 2 | 3000 | 6000
CUSTOMER ONE | CUSTOMER NAME ONE | ITEM 4 | 6 | 500
CUSTOMER ONE | CUSTOMER NAME ONE | ITEM 5 | 1 | 1500 | 1500
MAIL MERGE FILE FORMAT
CUSTOMER NUMBER | CUSTOMER NAME | ITEM | NUMBER | COST | TOTAL VALUE | ITEM | NUMBER | COST | TOTAL VALUE | ITEM | NUMBER | COST | TOTAL VALUE | ITEM | NUMBER | COST | TOTAL VALUE | ITEM | NUMBER | COST | TOTAL VALUE | TOTAL INVOICE TOTAL
CUSTOMER ONE | CUSTOMER NAME ONE
CUSTOMER TWO | CUSTOMER NAME TWO
CUSTOMER THREE | CUSTOMER NAME THREE
CUSTOMER FOUR | CUSTOMER NAME FOUR