tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 543186d1508261268-transpose-data-from-several-files-to-another-source-2
Sheet: example 1

Soc. | St | Ejerc./mes | Nº doc. | Fecha doc. | Fe.contab. | Cuenta | [NAME] |  | Cla | CT | Importe en ML | CeBe | Orden | II | Ce.coste | SocGLA | Texto | ML | Doc.comp.
 |  | 2017/06 | 1 | 01.06.2017 | 21.06.2017 | 6210001 | 321 |  | KR | 40 | 6.647,63 | GP99 |  | N0 | [NAME] |  | abcd | EUR
 |  | 2017/06 | 2 | 01.06.2017 | 21.06.2017 | 6210001 | 322 |  | KR | 40 | 1.830,18 | GP99 |  | P4 | [NAME] |  | abcd | EUR
 |  | 2017/07 | 3 | 01.07.2017 | 04.07.2017 | 6210001 | 323 |  | KR | 40 | 1.830,18 | GP99 |  | P4 | [NAME] |  | abcd | EUR
 |  | 2017/07 | 4 | 01.07.2017 | 04.07.2017 | 6210001 | 324 |  | KR | 40 | 6.647,63 | GP99 |  | N0 | [NAME] |  | abcd | EUR
 |  | 2017/07 | 5 | 03.07.2017 | 20.07.2017 | 6210001 | 325 |  | KR | 40 | 20 | GP99 |  | P4 | [NAME] |  | abcd | EUR |  | x
 |  | 2017/08 | 6 | 01.08.2017 | 24.08.2017 | 6210001 | 326 |  | KR | 40 | 6.647,63 | GP99 |  | N0 | [NAME] |  | abcd | EUR
 |  | 2017/08 | 7 | 31.08.2017 | 31.08.2017 | 6210001 | 327 |  | SA | 40 | 1.850,00 | GP99 |  | ZZ | [NAME] |  | abcd | EUR
 |  | 2017/08 | 8 | 31.08.2017 | 31.08.2017 | 6210001 | 328 |  | SA | 50 | -1.850,00 | GP99 |  | ZZ | [NAME] |  | abcd | EUR |  | x
 |  | 2017/09 | 9 | 01.09.2017 | 06.09.2017 | 6210001 | 329 |  | KR | 40 | 1.830,18 | GP99 |  | P4 | [NAME] |  | abcd | EUR |  | x
 |  | 2017/09 | 10 | 01.09.2017 | 06.09.2017 | 6210001 | 330 |  | KR | 40 | 6.647,63 | GP99 |  | N0 | [NAME] |  | abcd | EUR
Spreadsheet: 107539d1304682406-macro_transpose-macro2
Sheet: Report

Rainfall Data | Month
Year | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | Total
1997 | 25.5 | 5 | 18.2 | 12.8 | 59.2 | 33.4 | 19.2 | 29.7 | 55.9 | 28.6 | 54.9 | 5.7 | 348.1
1998 | 52.1 | 72.4 | 8.1 | 55.7 | 43.5 | 57.6 | 43.5 | 21 | 32.9 | 87.7 | 56.7 | 62.7 | 593.9000000000001
1999 | 29.8 | 35.6 | 47.3 | 25.2 | 55.6 | 47.1 | 15.3 | 76.2 | 28.2 | 59.3 | 32.9 | 101 | 553.5
2000 | 28.9 | 38.5 | 25.8 | 42.2 | 82.2 | 40.4 | 50 | 44.4 | 80.6 | 108.2 | 38 | 34.4 | 613.6
2001 | 12.1 | 8.9 | 85.9 | 114.6 | 17.4 | 59.8 | 13.4 | 51 | 39.9 | 76 | 70.5 | 59.5 | 609
2002 | 35.7 | 76 | 28.2 | 42.6 | 35.9 | 28.6 | 26.6 | 40.7 | 34 | 27 | 24.5 | 11 | 410.8
2003 | 11.8 | 19.2 | 18.3 | 67.3 | 24.4 | 34 | 71.6 | 53 | 35.7 | 67.5 | 19.2 | 62.6 | 484.6
2004 | 48 | 14.1 | 14.7 | 48.2 | 24.7 | 43.2 | 33.1 | 67.1 | 56.9 | 65.5 | 112.8 | 44.7 | 573
2005 | 19.5 | 157.3 | 10.5 | 28.2 | 10.7 | 40.4 | 26.4 | 60.2 | 44.7 | 42.1 | 55.3 | 61.6 | 556.9
2006 | 50.3 | 54.5 | 17.5 | 47 | 64.1 | 11.7 | 40.7 | 31.8 | 31.5 | 8.5 | 25 | 15.4 | 398
2007 | 31.9 | 17.6 | 41.9 | 22.4 | 39.4 | 40.4 | 64.7 | 15.9 | 19.4 | 20.5 | 56.9 | 75.7 | 446.6999999999999
Total | 345.6 | 499.1 | 316.4 | 506.2 | 457.0999999999999 | 436.6 | 404.4999999999999 | 491 | 459.6999999999999 | 590.9 | 546.7 | 534.3000000000001 | 5588.099999999999
Spreadsheet: 190174d1351546096-top-3-based-on-3-categories-fruit-example
Sheet: Summary

 | Top 3 Fruit |  |  | Top 3 Containers |  |  | Top 3 Locations
 | 1 | Apple
 | 2 | Orange |  | 1 | Bowl
 | 3 | [NAME] |  | 2 | Cup |  | 1 |  |  | [NAME] in each of the blank cells to calulate the top 3 locations for each variation of top three fruit and container.
 |  |  |  | 3 | Basket |  | 2
 | [NAME] in C3:C5 to calculate top three fruit |  |  |  |  |  | 3
 |  |  |  | 1 | Tub
 |  |  |  | 2 | Cup |  | 1
 |  |  |  | 3 | Bowl |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  | 1 | Bowl
 |  |  |  | 2 | Basket |  | 1
 |  |  |  | 3 | Cup |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  | [NAME] in F4:F6 | F8:F10 | F12:F14 to calculate top three containers for each of the top three fruit.
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
Spreadsheet: 867774d1714568288-really-really-need-help-with-this-contra-entries-with-customer-names-testingonline-updated
Sheet: Sheet1

Period | FY Year | FY Month Long Name | Invoice Date | Invoice Number | Invoice Separated | Customer Name | Sum of Revenue | ABS | Countif | Concat | Countif | customer same | Expected results
P1 | 2023 | October | 03/10/2022 | CSOL-1390946 | 1390946 | [NAME] | 995 |  |  |  |  |  | this should say 1 because even thought it has matched with row 9 it isnt john it is ollo
P1 | 2023 | October | 03/10/2022 | CSOL-1390946 | 1390946 | [NAME] | 96
P1 | 2023 | October | 03/10/2022 | CSOL-1390947 | 1390947 | Gabby | 56
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1390951 | [NAME] | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1390951 | ALi | 368.15
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1390951 | [NAME] | 378
P1 | 2023 | October | 03/10/2022 | CSOL-1390953 | 1390953 | Kit | 3040.2
P1 | 2023 | October | 03/10/2022 | CSOL-1390954 | 1390954 | Ollo | -995 |  |  |  |  |  | this should say 1 because even though it matched with row 1 it isnt john
P1 | 2023 | October | 03/10/2022 | CSOL-1390957 | 1390957 | mark | 2077.69
P1 | 2023 | October | 03/10/2022 | CSOL-1390960 | 1390960 | mark | -2077.69
P1 | 2023 | October | 03/10/2022 | CSOL-1390961 | 1390961 | Univar Speciality Consumables Limited | 1696.6
P1 | 2023 | October | 03/10/2022 | CSOL-1390962 | 1390962 | [NAME] | 565.64
P1 | 2023 | October | 03/10/2022 | CSOL-1390963 | 1390963 | Tele | 678.19
P1 | 2023 | October | 03/10/2022 | CSOL-1390963 | 1390963 | Tele | 3049.36
P1 | 2023 | October | 03/10/2022 | CSOL-1390964 | 1390964 | Remington | 884.34
Spreadsheet: 80945d1281188414-to-calculate-year-to-date-number-ytd
Sheet: Sheet1

2010-07-01 00:00:00
A/c code | A/c Name | [NAME] | 2009-01-01 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | [NAME] | 2010-01-01 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | [NAME] | 2011-01-01 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | [NAME] | 2012-01-01 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00 | [NAME] | YTD Act (Jan 2010 - July 2010) | LM YTD Act (Jan 2010 - June 2010) | LY YTD Act (Jan 2009 - July 2009)
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | 2009 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | 2010 | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | 2011 | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | 2012
611101 | Salary-Employees Local | PPC_SALARY | 0.9801063377922274 | 0.9906670645693687 | 0.7561210825908287 | 0.4474426906174422 | 0.8241332307305089 | 0.6883363854009794 | 0.5393484110654763 | 0.4861132942358397 | 0.6826145608657859 | 0.1413921819439898 | 0.23327416406174 | 0.2042336264504065 | 6.973783030324594 | 0.2940123007325899 | 0.585967522710467 | 0.1999442869571126 | 0.8257453848178393 | 0.3562962352638572 | 0.06195294007812979 | 0.6778147474711558 | 0.9130589098496307 | 0.7426126833263242 | 0.2427625350302804 | 0.6162917915974351 | 0.4956434825537439 | 6.012102820388566 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | what function to put here? | what function to put here? | what function to put here?
Spreadsheet: 31651d1227587966-conditional-linking-between-multiple-sheets-special_contest3
Sheet: Contacts

SPECIAL CONTEST - Contacts
Group | First Name | Last Name | website | City | Notes
judge | winner | Vader | www.youtube.com | California | will give $15K,
sponsor | winner | Jones | www.google.com | Chicago | will give $15K
media | winner | Rather | www.yahoo.com | New York | will do a news feature, will give $10K
judge, sponsor | winner
media, judge | winner
media, sponsor | winner
judge, media | [NAME] | doesn’t show on either sheet
sponsor, media | [NAME] | only shows on sponsor sheet
sponsor, judge | [NAME] | only shows on sponsr sheet
Spreadsheet: 62424d1263382030-look-up-and-place-certain-dates-within-months-with-an-extra-lookup-exampledata1
Sheet: Sheet2

 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00
Bloggs | 50000 |  |  |  |  |  |  |  |  |  |  |  | 58000 |  |  |  |  |  |  |  |  |  |  |  | 68000 |  |  |  |  |  |  |  |  |  |  |  | 75000 |  |  |  |  |  |  |  |  |  |  |  | 79000
Sinatra |  |  | 40000 |  |  |  |  |  |  |  |  |  |  |  | 45000 |  |  |  |  |  |  |  |  |  |  |  | 49000 |  |  |  |  |  |  |  |  |  |  |  | 52000 |  |  |  |  |  |  |  |  |  |  |  | 58000
Spreadsheet: 42237d1240844358-vlookup-problem-hlookup
Sheet: Sheet1

1101 | 14211 | 14541 | 14857 | 16957 |  |  |  |  |  | 14211,14541,14857,16957,,,,
1201 | 65124 | 78412 | 12458 | 19874 |  |  |  |  |  | 65124,78412,12458,19874,,,,
1301 | 12457 | 12458 |  |  |  |  |  |  |  | 12457,12458,,,,,,
1401 |  |  |  |  |  |  |  |  |  | ,,,,,,,
1501 |  |  |  |  |  |  |  |  |  | ,,,,,,,
1601 |  |  |  |  |  |  |  |  |  | ,,,,,,,
Spreadsheet: b8887d92-0ebe-4f8c-b31a-ef1ee9fdfe8b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43985608 | 2014-11-12 03:03:25 | ALLIES | 1 | 6 | 3 | 1472328 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43985786 | 2014-11-12 03:22:50 | AXIS | 1 | 6 | 5 | 1472328 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44011048 | 2014-11-14 00:02:50 | AXIS | 0 | 4 | 6 | 1345830 | player1345830 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44043128 | 2014-11-16 04:55:57 | AXIS | 0 | 3 | 6 | 1670292 | Unrealik280 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44101474 | 2014-11-20 04:49:27 | ALLIES | 0 | 4 | 6 | 946197 | Groka | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
44101612 | 2014-11-20 05:04:43 | AXIS | 1 | 6 | 1 | 946197 | Groka | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
44171403 | 2014-11-25 03:21:08 | ALLIES | 1 | 5 | 1 | 67493 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44171581 | 2014-11-25 03:38:15 | AXIS | 0 | 2 | 5 | 67493 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 544826d1509042934-conditional-formatting-based-on-date-and-time-queue-template
Sheet: Do not use - TEMPLATE

 |  | Total | Oldest | Age of Oldest (HRs)
 | [NAME] |  | 2017-10-24 00:00:00
 | Carrier Claims |  | 2017-10-24 00:00:00
 | Credits |  | 2017-10-23 00:00:00
 | Customer Service
 | Escalation
 | Escalation Emails
 | Fraud
 | [NAME]
 | PayPal Issues
 | Print Return Label
 | Rewards
 | Store Fulfill Issue
 | 6+ Days
 | 5 Days
 | 4 Days
 | 3 Days
 | 0-2 Days
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 515576 | 7533135 | 515593 | 745644 | 1031169 | 8278778
 | Loans |  | 21505 |  |  |  | 21505
 | Municipal |  | 3361 |  | <1,000 |  | 3361
 | Recovery
 | Sovereign | 33088 | 2631025 | 33088 | 239040 | 66177 | 2870065
Index Tranche | Asia |  |  |  | <100 |  | <100
 | Europe |  | 797657 |  | 77009 |  | 874666
 | North America |  | 892900 |  | 33228 |  | 926128
Index | Asia | 1321 | 294024 | 1623 | 45476 | 2944 | 339500
 | Europe | 275957 | 2512668 | 275957 | 384418 | 551915 | 2897085
 | North America | 458622 | 1465757 | 484249 | 322636 | 942871 | 1788393
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 1284565 | 16152032 | 1310510 | 1847449 | 2595075 | 17999481
Estimated gross notional amount outstanding, January 11 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 788220d1658331057-finding-sections-of-a-string-of-variable-length-plate-size-proxy-file
Sheet: Job Items

Section |  |  |  |  |  |  |  |  |  | [NAME] | Quantiy | Total Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plate size | Repetative Plates (Gus, Fin) | Plates (end Plates) | Plates Loose | Total Fin Plates | Total End Plates | Loose fin plates | loose end plates |  |  |  |  | Holes of different sizes/types |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total plate cost
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x100x10 | 4 | 4 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1 | 1
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x10 | 3 | 4 | 0 | 4 |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
Plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x100x10 | 4 | 4 | 0 |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
Plates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10x10000x11
Spreadsheet: 258792d1376854846-adult-baseball-league-schedule-2013spring-schedule-5-
Sheet: printable

# | Date | Visitors | Home | Field |  | # | Date | Visitors | Home | Field
1 | 2013-04-07 00:00:00 | REDWINGS | SENATORS | DP |  | 6 | 2013-05-19 00:00:00 | SENATORS | KEYS | CCC
 | 2013-04-07 00:00:00 | MUDCATS | BAYSOX | LBU |  |  | 2013-05-19 00:00:00 | ROCKCATS | SEADOGS | GHS
 | 2013-04-07 00:00:00 | SEADOGS | KEYS | CCC |  |  | 2013-05-19 00:00:00 | REDWINGS | MUDCATS | LBU
 | 2013-04-07 00:00:00 | ROCKCATS | BYE |  |  |  | 2013-05-19 00:00:00 | BAYSOX | BYE
2 | 2013-04-14 00:00:00 | KEYS | MUDCATS | CCC |  | 7 | 2013-05-26 00:00:00 | ROCKCATS | BAYSOX | RH
 | 2013-04-14 00:00:00 | BAYSOX | REDWINGS | LBU |  |  | 2013-05-26 00:00:00 | REDWINGS | KEYS | CCC
 | 2013-04-14 00:00:00 | SENATORS | ROCKCATS | GHS |  |  | 2013-05-26 00:00:00 | MUDCATS | SEADOGS | GHS
 | 2013-04-14 00:00:00 | SEADOGS | BYE |  |  |  | 2013-05-26 00:00:00 | SENATORS | BYE
3 | 2013-04-21 00:00:00 | MUDCATS | ROCKCATS | GHS |  | 8 | 2013-06-02 00:00:00 | SENATORS | REDWINGS | LBU
 | 2013-04-21 00:00:00 | SEADOGS | SENATORS | DP |  |  | 2013-06-02 00:00:00 | BAYSOX | MUDCATS | CCC
 | 2013-04-21 00:00:00 | KEYS | BAYSOX | RH |  |  | 2013-06-02 00:00:00 | KEYS | SEADOGS | GHS
 | 2013-04-21 00:00:00 | REDWINGS | BYE |  |  |  | 2013-06-02 00:00:00 | BYE | ROCKCATS
4 | 2013-04-28 00:00:00 | BAYSOX | SEADOGS | GHS |  | 9 | 2013-06-09 00:00:00 | MUDCATS | KEYS | CCC
 | 2013-04-28 00:00:00 | SENATORS | MUDCATS | CCC |  |  | 2013-06-09 00:00:00 | REDWINGS | BAYSOX | RH
 | 2013-04-28 00:00:00 | ROCKCATS | REDWINGS | LBU |  |  | 2013-06-09 00:00:00 | ROCKCATS | SENATORS | DP
 | 2013-04-28 00:00:00 | KEYS | BYE |  |  |  | 2013-06-09 00:00:00 | BYE | SEADOGS
5 | 2013-05-05 00:00:00 | SEADOGS | REDWINGS | CCC |  | 10 | 2013-06-16 00:00:00 | ROCKCATS | MUDCATS | CCC
 | 2013-05-05 00:00:00 | KEYS | ROCKCATS | GHS |  |  | 2013-06-16 00:00:00 | SENATORS | SEADOGS | GHS
 | 2013-05-05 00:00:00 | BAYSOX | SENATORS | DP |  |  | 2013-06-16 00:00:00 | BAYSOX | KEYS | RH
 | 2013-05-05 00:00:00 | MUDCATS | BYE |  |  |  | 2013-06-16 00:00:00 | BYE | REDWINGS
 |  |  |  |  |  | 11 | 2013-06-23 00:00:00 | REDWINGS | ROCKCATS | GHS
 |  |  |  |  |  |  | 2013-06-23 00:00:00 | SEADOGS | TBD | TBD
 |  |  |  |  |  | after week 11 all have 9 games
Spreadsheet: 675566d1588355133-show-total-spending-for-current-month-2020-05-01-oeldere-pt-675564d1588354443-show-total-spending-for-current-month-book1
Sheet: Sheet1

Invoice Sr .No | Date | Amount spend  (Inr) | year | month
1 | 01.04.2020 | 1000
2 | 22.04.2020 | 1000 |  |  |  |  | Som [NAME] spend  (Inr) | Kolomlabels
3 | 21.04.2020 | 1000 |  |  |  |  | Rijlabels | 2020 | 2019 | Eindtotaal
4 | 24.04.2020 | 2000 |  |  |  |  | 3 | 3500 |  | 3500
5 | 06.05.2020 | 2000 |  |  |  |  | 4 | 13000 |  | 13000
6 | 24.03.2020 | 2000 |  |  |  |  | 5 | 4000 |  | 4000
7 | 18.12.2019 | 1500 |  |  |  |  | 12 |  | 3500 | 3500
8 | 01.04.2020 | 3000 |  |  |  |  | Eindtotaal | 20500 | 3500 | 24000
9 | 22.04.2020 | 1000
10 | 21.04.2020 | 2000
11 | 24.04.2020 | 2000
12 | 06.05.2020 | 2000
13 | 24.03.2020 | 1500
14 | 18.12.2019 | 2000
I WANT TOTAL SPENDING OF CURRENT MONTH AUTOMATICALLY
MONTH ALSO SHOULD CHANGE AUTOMATICALLY EVERY MONTH
Spreadsheet: 213272d1360418067-help-merge-sheets-data-deep
Sheet: TRG

 |  | AD | SD | TD
 |  | 23 | 34 | 54
 |  | 24 | 56 | 76
Spreadsheet: 147931d1333039454-excel-2007-formula-to-retrieve-text-from-a-range-of-cells-example2
Sheet: Sheet1

Col A | Col b | Col c | Col d | Col E | Want to put a single column in F with the text of what is not blank in Col A-E
A1 |  |  |  |  | A1
 | b1 |  |  |  | B1
 |  | c1 |  |  | C1
 |  |  | d1 |  | D1
 |  |  | d2 |  | D2
 |  | c2 |  |  | C2
 |  |  | d3 |  | D3
 |  |  |  | e1 | E1
Spreadsheet: 715638d1611811041-understanding-the-lookup-formula-forum-excel-22-jan-2021
Sheet: Épargnes Inv.

 |  |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
 |  |  | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
 | Solde actuel des comptes: | AR
 |  | FT
 |  | PL
 |  | UR
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200
2020-01-21 00:00:00 | Deposit | AR | 200
2020-01-30 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-01 00:00:00 | Deposit | AR | 25
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-03-01 00:00:00 | Deposit | PL | 60
2020-03-01 00:00:00 | Deposit | UR | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 0 | 230 |  | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 0 | 320 |  | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 0 | 55 |  | 65
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 0 | 77 |  | 77
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-06-15 00:00:00 | Withdrawal | PL | -40
2020-06-15 00:00:00 | Withdrawal | UR | -70
2021-01-01 00:00:00 | Deposit | AR | 120
2021-01-01 00:00:00 | Deposit | FT | 100
2021-01-01 00:00:00 | Deposit | PL | 90
2021-01-01 00:00:00 | Deposit | UR | 80
Spreadsheet: 990f2b9a-1c94-4155-a042-da07dfa79ba5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44322061 | 2014-12-06 03:21:13 | ALLIES | 1 | 6 | 5 | 188507 | WiredNun | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44322362 | 2014-12-06 03:47:46 | AXIS | 0 | 3 | 6 | 188507 | WiredNun | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44328115 | 2014-12-06 15:24:51 | AXIS | 0 | 6 | 7 | 1546936 | KATANA PAPA | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44328415 | 2014-12-06 15:54:29 | ALLIES | 0 | 5 | 7 | 1546936 | KATANA PAPA | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44344631 | 2014-12-07 17:25:24 | ALLIES | 1 | 6 | 5 | 913651 | Simon1965 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44345012 | 2014-12-07 18:02:02 | ALLIES | 0 | 5 | 6 | 1616413 | célestin poux | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
44345486 | 2014-12-07 18:21:06 | AXIS | 0 | 5 | 6 | 1616413 | célestin poux | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
44373216 | 2014-12-09 18:18:01 | ALLIES | 1 | 6 | 3 | 1388575 | Shocking Blue | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44373633 | 2014-12-09 18:58:01 | AXIS | 0 | 4 | 6 | 1388575 | Shocking Blue | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44401281 | 2014-12-11 20:35:15 | ALLIES | 1 | 10 | 4 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44401609 | 2014-12-11 21:11:04 | AXIS | 1 | 10 | 6 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44414316 | 2014-12-12 20:41:04 | ALLIES | 1 | 6 | 2 | 583921 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
Spreadsheet: 868764d1715441530-shifting-cells-whilst-ignoring-certain-columns-excel-trial-
Sheet: After

 | Monday | Tuesday | Wednesday | Thursday | Friday | Weekend | Monday | Tuesday | Wednesday | Thursday | Friday | Weekend | Monday | Tuesday | Wednesday | Thursday | Friday | Weekend | Monday | Tuesday | Wednesday | Thursday | Friday | Weekend
 |  |  |  |  |  |  |  |  |  |  | Catch Up |  |  |  |  |  |  |  |  |  |  |  | Catch Up
Person 1 |  | 3 | 4 | 2 | 4 |  | 5 | 3 | 5 | 2 |  |  | 1 | 3 | 4 | 5 | 2
Spreadsheet: 66421d1267084445-vlookups-or-more-example1
Sheet: Sheet4

Area | (All)
Count of Dept. | Dept.
Person | CC | PR | Grand Total
[NAME] | 1 |  | 1
[NAME] |  | 1 | 1
[NAME] | 1 |  | 1
[NAME] |  | 1 | 1
Charlotte |  | 1 | 1
Emma |  | 1 | 1
[NAME] | 1 |  | 1
Gemma | 1 |  | 1
Geoff |  | 1 | 1
[NAME] | 1 |  | 1
Judi | 1 |  | 1
[NAME] | 1 |  | 1
Maria | 1 |  | 1
[NAME] | 1 |  | 1
Nick |  | 1 | 1
[NAME] |  | 1 | 1
Rachel |  | 1 | 1
Rich |  | 1 | 1
[NAME] |  | 1 | 1
[NAME] | 1 |  | 1
Grand Total | 10 | 10 | 20