tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103799d1301497539-if-function-book1_quiggdavid
Sheet: Sheet1

 | Test 1 |  | 2011-03-16 00:00:00 |  | Test 15
 | Test 2 |  | 2011-03-17 00:00:00
 | Test 3 |  | 2011-03-18 00:00:00
 | Test 4 |  | 2011-03-19 00:00:00
 | Test 5 |  | 2011-03-20 00:00:00
 | Test 6 |  | 2011-03-21 00:00:00
 | Test 7 |  | 2011-03-22 00:00:00
 | Test 8 |  | 2011-03-23 00:00:00
 | Test 9 |  | 2011-03-24 00:00:00
 | Test 10 |  | 2011-03-25 00:00:00
 | Test 11 |  | 2011-03-26 00:00:00
 | Test 12 |  | 2011-03-27 00:00:00
 | Test 13 |  | 2011-03-28 00:00:00
 | Test 14 |  | 2011-03-29 00:00:00
 | Test 15 |  | 2011-03-30 00:00:00
 | Test 16 |  | 2011-03-31 00:00:00
 | Test 17 |  | 2011-04-01 00:00:00
 | Test 18 |  | 2011-04-02 00:00:00
 | Test 19 |  | 2011-04-03 00:00:00
 | Test 20 |  | 2011-04-04 00:00:00
Spreadsheet: 328929d1404140573-vlookup-between-two-sheets-including-entire-row-samv1
Sheet: Table

ID | List1 | List2 | List3 | List4
Test1 | Value 70069 | Value 39239 | Value 85087 | Value 10269
Test2 | Value 98592 | Value 91876 | Value 29875 | Value 75958
Test3 | Value 58047 | Value 47835 | Value 55976 | Value 72197
Test4 | Value 73114 | Value 64022 | Value 54811 | Value 97189
Test5 | Value 28656 | Value 79035 | Value 94125 | Value 32407
Test6 | Value 48170 | Value 65808 | Value 68545 | Value 41513
[NAME] | Value 53529 | Value 32570 | Value 11653 | Value 66859
Test8 | Value 94027 | Value 7807 | Value 80065 | Value 86875
Test9 | Value 48183 | Value 83178 | Value 66482 | Value 428
Test10 | Value 24021 | Value 22321 | Value 94553 | Value 5224
Test11 | Value 86286 | Value 90172 | Value 76791 | Value 81676
Test12 | Value 15141 | Value 71348 | Value 32500 | Value 50811
Test13 | Value 94339 | Value 40118 | Value 2730 | Value 98157
Test14 | Value 34932 | Value 8630 | Value 28085 | Value 90172
Test15 | Value 12489 | Value 79 | Value 72421 | Value 86066
Test16 | Value 17281 | Value 83124 | Value 50840 | Value 61056
Test17 | Value 24845 | Value 9080 | Value 9737 | Value 81575
Test18 | Value 35600 | Value 26057 | Value 21920 | Value 42414
Test19 | Value 58245 | Value 22148 | Value 21813 | Value 36878
Test20 | Value 24416 | Value 60350 | Value 54775 | Value 12810
Test21 | Value 59220 | Value 89567 | Value 49105 | Value 49725
Spreadsheet: 794641d1662184405-8x8-matrix-detailed-explanation-solving-linair-equations-with-matrices-hd
Sheet: Example solving equation

Detailed Example solving the following equation system with 4 linear equations with 4 unknown parameters
These equations are filled into the matrix in the following way.
 | X1 | X2 | X3 | X4 | C
EQ1 | 2 | 1 | 3 | -2 | 1
EQ2 | 4 | 3 | 2 | -1 | -6
EQ3 | 1 | 3 | 1 | 1 | 2
EQ4 | -2 | -2 | -2 | 2 | 8
Calculate the inverse matrix of the yellow part
 | X1 | X2 | X3 | X4
 |  | 0.5 | -0.25 | 0.375
 | -0.3333333333333333 | -0.1666666666666667 | 0.25 | -0.5416666666666667
 | 0.6666666666666666 | -0.1666666666666667 | 0.25 | 0.4583333333333334
 | 0.3333333333333333 | 0.1666666666666667 | 0.25 | 0.7916666666666667
Multipy the inverse by the origin equation matrix (inclusive Column with the constante C)
 | X1 | X2 | X3 | X4 | C
EQ1 |  | 0 | 0 | 0 | -0.5
EQ2 | 2.220446049250313e-16 | 1 | 2.220446049250313e-16 | -2.220446049250313e-16 | -3.166666666666667
EQ3 | -2.220446049250313e-16 | -2.220446049250313e-16 | 0.9999999999999999 | 3.33066907387547e-16 | 5.833333333333334
EQ4 | -2.220446049250313e-16 | -2.220446049250313e-16 | -2.220446049250313e-16 | 1 | 6.166666666666667
And now we see 4 in column F the final result (in the form of equations):
 | EQ1: X1=
 | EQ2: X2= | -3.166666666666667
 | EQ3: X3= | 5.833333333333334
 | EQ4: X4= | 6.166666666666667
Everything is checked below
 | X1 | X2 | X3 | X4 |  |  | CHECK FORMULA
 |  | -3.166666666666667 | 5.833333333333334 | 6.166666666666667
 |  | 1 | 3 | -2 | 1 | =
 | 4 | 3 | 2 | -1 | -6 | =
 | 1 | 3 | 1 | 1 | 2 | =
 | -2 | -2 | -2 | 2 | 8 | =
If desired, change the array of equations in range B11:F14 and see what happens.
Spreadsheet: b0e2c4aa-044d-42f4-8981-77c8a6fb33ee
Sheet: Sheet1

Cat | Lifter | BD WT | Snatch1 | Snatch2 | Snatch3 | Best | C&J1 | C&J2 | C&J3 | Best.1 | Total | Place
48 | [NAME] | 47.64 | 50 | 52 | 52 | 52 | 63 | 66 | 69 | 66 | 118 | 1
48 | Chani Matsui | 46.54 | 48 | 50 | 50 | 50 | 63 | 63 | 65 | 65 | 115 | 3
48 | [NAME] | 46.78 | 47 | 50 | 51 | 51 | 61 | 65 | 65 | 65 | 116 | 2
53 | [NAME] | 52.04 | 66 | 69 | 71 | 71 | 85 | 88 | 88 | 85 | 156 | 1
53 | [NAME] | 52.59 | 62 | 64 | 65 | 64 | 72 | 75 | 77 | 77 | 141 | 2
53 | [NAME] | 52.43 | 60 | 63 | 64 | 64 | 72 | 76 | 76 | 76 | 140 | 3
53 | [NAME] | 52.72 | 52 | 52 | 55 | 55 | 70 | 74 | 74 | 74 | 129 | 4
53 | [NAME] | 52.01 | 44 | 46 | 48 | 46 | 63 | 63 | 67 | 67 | 113 | 5
53 | [NAME] | 50.74 | 44 | 47 | 49 | 49 | 58 | 61 | 63 | 63 | 112 | 6
Spreadsheet: 349515d1412352796-auto-populate-sheets-based-on-master-sheet-doc-review-schedule-with-pivot-tables
Sheet: Master_List

Doc # | [NAME] | Last Review Date | Next Review Date | QuarterNum
1 | Test 1
2 | Test 2
3 | Test 3
4 | Test 4
5 | Test 5
6 | Test 6
7 | Test 7
8 | Test 8
9 | Test 9
10 | Test 10
11 | Test 11
Spreadsheet: 702556d1604412267-check-and-replace-value-by-group-conflict-v2
Sheet: Sheet1

Source Data with duplicates removed (Duplicates based on Project and Rank Status) |  |  |  |  |  |  |  |  | Target Data
Project | Users | Status Rank | Project Status | [NAME] | StatusConflictCheck | Sort Master | Helper Formula |  | Project | Status | [NAME]
[NAME] | [NAME] |  |  | 9. Unknown | False | [NAME]. Unknown |  |  | [NAME] | Unknown
[NAME] | Saffron | 1 | Decommission | 1. Decommission | False | [NAME]. Decommission |  |  | [NAME] | Conflict
[NAME] | Saffron | 1 | Confirmed | 1. Confirmed | False | [NAME]. Confirmed |  |  | [NAME] | Confirmed
[NAME] | Saffron |  |  | 9. Unknown | False | [NAME]. Unknown |  |  | NON RESTRICTED//FOLDER-FOUR//PHOTON | Unknown
[NAME] | [NAME] | 1 | Confirmed | 1. Confirmed | False | [NAME]. Confirmed |  |  | [NAME] | Decommission
[NAME] | [NAME] | 4 | Referred | 4. Referred | False | [NAME]. Referred
NON RESTRICTED//FOLDER-FOUR//PHOTON | Tara | 9 | Unknown | 9. Unknown | False | [NAME]. Unknown
[NAME] | Tara | 1 | Decommission | 1. Decommission | False | [NAME]. Decommission
[NAME] | Tara |  |  | 9. Unknown | False | [NAME]. Unknown
Spreadsheet: 784622d1655879389-extract-values-with-the-help-of-two-criteria-sample
Sheet: Expected Result

Sr. No. | Name of the Subject | Name of the Employee | Batch No. | Total Batches No | Total | Allocation of Blocks | Balance No. of Blocks
1 | Finance | Mr. [NAME] | 1. 2. 15. 16 | 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16 | 16
 |  | Mr. [NAME] | 3. 4
 |  | Mrs. B | 5
 |  | Mrs. C | 6. 7
 |  | Mr. [NAME] | 8. 9. 10
 |  | Ms. [NAME] | 11. 12. 13. 14
Spreadsheet: 92696d1292261486-update-project-list-by-department-pulling-the-list-from-another-tab-capital-projects-report
Sheet: Dept. Summary

 | Capital Improvement Plan
 | City of xxxxx
 | Projects and Funding Sources by Department
 | Administration
 | Project Name | Project # | Priority | 2011 | 2012 | 2013 | 2014 | 2015 | Total
 | Leisure Services
 | Project Name | Project # | Priority | 2011 | 2012 | 2013 | 2014 | 2015 | Total
 | Public Works
 | Project Name | Project # | Priority | 2011 | 2012 | 2013 | 2014 | 2015 | Total
Spreadsheet: 54435d1254413059-search-for-text-within-a-string-lookup-and-then-return-item-701479_raoul_duke
Sheet: Sheet2

Channel | Tag | Keyword(s)
Tech | Microsoft | Windows | Vista | XP | Word | Excel
Tech | Computers | Internet | PC
Tech | MP3 Players | iPod | Zune
Beauty | Weddings | Flowers | Gowns | Rings | Vicars | Bridal | Mascara
Food | [NAME] | Cake
Food | Meat | Beef
Spreadsheet: 28777d1223316998-summarizing-data-table
Sheet: BODY

BODY- NPT ENDS
MATERIAL | STANDARD | W/BOTTOM PLUG (-26 OPTION) | PHANTOM
BRASS | X |  | V2367
CAST IRON | X |  | V2368
STEEL | X |  | V2369
SST | X |  | V2370
BRASS |  | X | V2371
CAST IRON |  | X | V2372
STEEL |  | X | V2373
SST |  | X | V2374
Total
Spreadsheet: 78518d1278928283-classify-data-values-range_belonging
Sheet: Foglio1

Year | Range belonging |  | range | range ID
1420 | 1 |  | 1400/1500 | 1
1460 | 1 |  | 1500/1600 | 2
1500 | 1 |  | 1600/1700 | 3
1500 | 1
1500 | 1
1580 | 2
1600 | 2
1600 | 2
1670 | 3
Spreadsheet: 738686d1625172604-calculation-to-work-out-service-fee-example-fee-calculator
Sheet: Sheet1

Spend | Fee
0 | 0.125 | 0.125 |  | Spend | 10000
5000 | 0.1
10000 | 0.075 |  |  | Fee
20000 | 0.05
 |  |  |  | Percentage
Spreadsheet: 871905d1718291652-highlight-next-odd-number-months-in-range-dates-4-cf-aligw
Sheet: Sheet1

 | DATES
 | 2024-07-02 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-18 00:00:00
 | 2024-07-24 00:00:00
 | 2024-08-02 00:00:00
 | 2024-08-09 00:00:00
 | 2024-08-15 00:00:00
 | 2024-08-25 00:00:00
 | 2024-09-01 00:00:00
 | 2024-09-09 00:00:00
 | 2024-09-17 00:00:00
 | 2024-09-25 00:00:00
 | 2024-09-30 00:00:00
 | 2024-10-09 00:00:00
 | 2024-10-15 00:00:00
 | 2024-10-23 00:00:00
 | 2024-11-01 00:00:00
 | 2024-11-09 00:00:00
 | 2024-11-15 00:00:00
 | 2024-11-23 00:00:00
 | 2024-11-30 00:00:00
 | 2024-12-07 00:00:00
 | 2024-12-17 00:00:00
 | 2024-12-25 00:00:00
 | 2025-01-03 00:00:00
 | 2025-01-13 00:00:00
 | 2025-01-22 00:00:00
 | 2025-01-30 00:00:00
 | 2025-02-06 00:00:00
 | 2025-02-12 00:00:00
 | 2025-02-18 00:00:00
 | 2025-02-25 00:00:00
Spreadsheet: 53624d1253562663-sum-array-value-errors-multi-array-20sample-20workbook-1-
Sheet: Summary

SUMMARY
 |  | Date | 2009-09-01 00:00:00
Project | Phase | Dept
Pr1 | Build | Tech
Pr2 | Build | Tech
Pr3 | Build | Tech
Pr1 | Maintenance | Tech
Pr2 | Maintenance | Tech
Pr3 | Maintenance | Tech
 | NBVC formula
Spreadsheet: 70808d1271501465-printing-cell-contents-as-a-header-on-all-pages-stmaster_apr10
Sheet: Logos 6

Logo Options 5
Embroidery
Logo Position |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Stitch No | Hoop |  |  |  |  | Notes
[NAME] | [NAME] |  |  | 5000 |  |  |  |  |  | Test
Right Breast | Logo |  |  | 0 |  |  |  |  |  | Test
Back | Logo |  |  | 0 |  |  |  |  |  | Test
Left Sleeve | Logo |  |  | 0 |  |  |  |  |  | Test
Right Sleeve | Logo |  |  | 0 |  |  |  |  |  | Test
[NAME] | Logo |  |  | 0 |  |  |  |  |  | Test
 |  |  | Total | 5000
Printing
Logo Position
 |  |  |  |  | Cost £ | Notes
Front | Test |  |  |  | 6 | Test
Right Breast | Test |  |  |  | 0 | Test
Back | Crown thing |  |  |  | 0 | Test
Lower back | SA2010 |  |  |  | 0 | Test
Right Sleeve | [PHONE] |  |  |  | 0 | Test
[NAME] | TE |  |  |  | 0 | Test
 |  |  |  | Total | 6
Spreadsheet: 164309d1340724458-search-display-multiple-instances-of-unique-clients-and-related-cells-help-please-test-copy-timesheet
Sheet: Consulting Timesheet June

 |  |  |  | Time Sheet
 |  |  |  | Period: | 2012-06-01 00:00:00 | - | 2012-06-30 00:00:00
 | Client | Date | Matter | Activity | Description | Participants | Hours
 | Great American Insurance Group | 2012-06-25 00:00:00 | APU | Discussion Re: | Marketform Claims Review | [NAME] | 2
 | Chubb Insurance Group | 2012-06-16 00:00:00 | A&E Reserves | [NAME] re: | Port of Seattle | [NAME] | 0.75
 | Travellers Insurance Group | 2012-06-20 00:00:00 | Claims | Meeting Re: | Marketform Claims Review | S. Cole | 0.75
 | Great American Insurance Group | 2012-06-20 00:00:00 | AFG | Meeting Re: | Port of Seattle | [NAME] | 7.75
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 1.25
 |  |  |  |  |  |  | 1.25
 |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  | 1.25
 |  |  |  |  |  |  | 1.75
 |  |  |  |  |  |  | 4.75
 |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  | 1.5
Spreadsheet: 862879d1710447272-how-to-organize-table-that-has-different-data-rate-but-want-newest-data-lined-up-organize
Sheet: Sheet1

 | Item 1 | Item 2 | Item 3
Day 1 | 1.5 | 10.25 | 22.55
Day 2 | 1.65
Day 3 | 1.75
Day 4 | 1.7
Day 5 | 1.85
Day 6 | 1.99
Day 7 | 2 | 11
Day 8 | 2.25
Day 9 | 1.99
Day 10 | 1.5
Day 11 | 1.65
Day 12 | 1.75
Day 13 | 1.7
Day 14 | 1.85 | 12.25
Day 15 | 1.99
Day 16 | 2
Day 17 | 2.25
Day 18 | 1.99
Day 19 | 1.5
Day 20 | 1.65
Day 21 | 1.75
Day 22 | 1.7
Day 23 | 1.85
Day 24 | 1.99
Day 25 | 2
Day 26 | 2.25
Day 27 | 1.99
Spreadsheet: 136951d1326896590-help-with-vlookup-and-if-in-the-same-statment-help-if-and-vlookup
Sheet: P

 | Test P
 | ID | Number |  | Nome
 | 1 | 1131 | 0170283_11V2 | ANA
 | 2 | 1132 | 0169519_11V2 | ANA
 | 3 | 1133 | 01779959_11v2 | ANA
 | 4 | 1134 | 01779959_11v3 | ANA
 | 5 | 1135 | 01779959_11v4 | ANA
 | 6 | 1136 | 01779959_11v5 | ANA
 | 7 | 1137 | 01779959_11v6 | ANA
 | 8 | 1138 | 01779959_11v7 | ANA
 | 9 | 1139 | 01779959_11v8 | ANA
 | 10 | 1140 | 01779959_11v9 | ANA
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Cicada

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | paying £7.70 monthly [NAME]
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
Spreadsheet: 144819d1331150350-transfering-a-list-of-data-based-on-a-list-selection-smiproducttest_updated
Sheet: Sheet1

 |  |  | PRODUCT |  |  | PERFORMANCE
 |  |  | FUJITSU12K |  |  | 12000
 |  |  |  |  |  | 11000 | Followed by Ctrl+Shft+Enter, so that you see flower brackets { }
 |  |  |  |  |  | 10000 | Drag down 3 more rows
 |  |  |  |  |  | 9000
 |  |  |  |  |  | 42000
 | PRODUCT |  | [NAME] | FUJITSU12K | FUJITSU18K | [NAME] | LG12K | LG18K
 | [NAME] |  | 9000 | 12000 | 18000 | 8000 | 11000 | 17000
 | FUJITSU12K |  | 8000 | 11000 | 17000 | 7000 | 10000 | 16000
 | FUJITSU18K |  | 7000 | 10000 | 16000 | 6000 | 9000 | 15000
 | [NAME] |  | 6000 | 9000 | 15000 | 5000 | 8000 | 14000
 | LG12K |  | 30000 | 42000 | 66000 | 26000 | 38000 | 62000 | <- Check
 | LG18K
Spreadsheet: 206570d1358227979-drop-down-box-assitance-projected-data-testing-2-
Sheet: Febuary

Loc A |  |  |  |  |  | [NAME]
2012-12-31 00:00:00 | 15203 |  | -2363.81 |  |  | 2012-12-31 00:00:00 | -1007.41 |  | -186213
2012-12-31 00:00:00 | 0.01 |  | -2350.59 |  |  | 2012-12-31 00:00:00 | -1513 |  | -187356.63
2012-12-27 00:00:00 | 669.66 |  | -2350.6 |  |  | 2012-12-28 00:00:00 | 1156.44 |  | -186961.63
2012-12-27 00:00:00 | -295 |  | -3020.26 |  |  | 2012-12-24 00:00:00 | 1477.28 |  | -188118.07
2012-12-19 00:00:00 | 690.31 |  | -2725.26 |  |  | 2012-12-12 00:00:00 | 2173.74 |  | -189595.35
2012-12-19 00:00:00 | -295 |  | -3415.57 |  |  | 2012-12-11 00:00:00 | 0 |  | -191769.09
2012-12-18 00:00:00 | -1089.7 |  | -3120.57 |  |  | 2012-12-10 00:00:00 | -45123 |  | -191769.09
2012-12-12 00:00:00 | 669.66 |  | -2030.87 |  |  | 2012-12-03 00:00:00 | 0 |  | -191585.76
2012-12-12 00:00:00 | -295 |  | -2700.53
2012-12-11 00:00:00 | 0 |  | -2405.53 |  |  | Opening Balance | 191585.76
2012-12-05 00:00:00 | 669.66 |  | -2405.53 |  |  | Closing Balance | 186213
2012-12-05 00:00:00 | -295 |  | -3075.19
2012-12-03 00:00:00 | 0 |  | -2780.19
Income | 17902.3
Expenses | 2269.7
Opening Balance | 27801.9
Spreadsheet: 825180d1681157268-exclude-data-in-hidden-columns-max-weekly-history-jv
Sheet: Max Weekly History

 | Hide | Hide |  |  |  | Hide |  |  |  | Subtoal is not working
 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Average | [NAME] | Average2
January |  | 13233 | 18452 | 19680 | 17116 | 20057 | 14686 | 22123 | 21873
February |  | 14313 | 18349 | 23201 | 18748 | 25222 | 16415 | 25552 | 21405
March |  |  | 2985 | 18239 | 21288 | 23740 | 19442 | 25408 | 19795
April |  | 9654 | 20663 | 21242 | 21606 |  | 17455 | 29419 | 18390
May |  |  | 9352 | 19960 | 22784 |  | 19807 | 21765
June |  | 13424 | 23641 | 19838 | 18177 |  | 20825 | 26414
July |  | 2842 | 24023 | 18444 | 19010 |  | 22693 | 23504
August |  | 16090 | 21851 | 18371 | 21742 | 15875 | 23989 | 26046
September |  |  | 23335 | 22760 | 22080 | 16808 | 24765 | 22784
October | 4628 | 16987 | 20848 | 18539 | 21922 | 14112 | 6828 | 26938
November | 11504 | 16059 | 22338 | 16328 | 25503 | 15988 | 7044 | 24686
December |  |  | 19893 | 17895 | 25880 | 14490 | 7595 | 29300
 |  | I would like to hide Rows 2015, 2016 and 2020 to see the new Average and [NAME] values in colums K and L respectively.
Spreadsheet: 39772d1238063177-how-to-structure-a-modell-data-input-test
Sheet: Ark2

Id | Name | Type of System
101 | Gas | Water Heating
102 | Electricity | Electric
103 | Electricity with Heatpump | Water Heating
104 | Heating Oil | Water Heating
Currency
Unit | FF | EUR
FF
Energy
MWh
Spreadsheet: 664151d1582478638-how-to-loop-through-values-using-power-query-stockdownload
Sheet: Stock Symbols

C
BAC
GM
[NAME]
AEP
AGR
FTS
ATO
DTE
PXD
CNP
SR
MDU
AWK
CRC
AEE
OGS
EXC
CLB
DHI
NOV
GIL
DRE
WWD
TIF
D
HAL
TRMB
TPR
TSCO
LNT
ULTA
PBA
IVZ
KTB
HOG
ZBH
MKC
HRL
CLX
CAG
K
ROK
NTR
GIB
SWK
APH
BAX
EQR
STI
WMB
HSY
CVE
MCO
WELL
ENB
KMB
ROST
[NAME]
SHW
CTSH
GE
CME
EOG
ADP
EMR
GIS
SPGI
DD
CL
VLO
LLY
ITW
LOW
RF
DOW
BCE
AMAT
EBAY
CSX
BBT
CTL
DEO
MPC
PSX
PYPL
ADBE
BKNG
ALL
QCOM
HON
MCD
COP
CI
ACN
TXN
MO
GILD
BP
BMY
PM
KO
GSK
F
AVGO
SBUX
HD
IBM
CSCO
COF
CVX
FB
JNJ
AMZN
GOOGL
MS
HSBC
AAPL
CTVA
Spreadsheet: 207088d1358359191-1-cell-looking-a-range-then-returning-data-from-adjacent-cell-and-combining-if-then-schedule-demo
Sheet: Template-Demo (2)

DATES |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  | Time | Trainer | Time | Trainer | Time | Trainer | Time | Trainer | Time | Trainer | Time | Trainer
Trainees | Tinker |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Tailor |  | [NAME] |  |  |  |  |  |  |  |  |  | OFF
 |  |  | 815/115
 | Soldier |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Spy |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Thing 1 |  |  |  |  |  |  |  | OFF |  |  |  | [NAME] R
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | Thing 2 |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Red Fish |  |  |  |  |  |  |  | OFF |  |  |  | [NAME] R
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | Blue Fish |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Old Fish |  |  |  |  |  |  |  | OFF |  |  |  | [NAME] R
 |  |  |  |  |  |  |  |  |  |  |  |  | 830/12
 | New Fish |  | [NAME] |  |  |  |  |  |  |  |  |  | OFF
 |  |  | 815/115
Instructors | [NAME] |  | Tailor & New Fish |  | Tinker & Soldier |  | Thing 2 & Red Fish |  | Tinker & New Fish |  | Thing 1 & New Fish |  | OFF
 |  |  | 815/115
 | [NAME] |  | Blue Fish & Old Fish |  | Tailor, Thing 1, & New Fish |  | Thing 1 & Tailor |  | Tailor & Blue Fish |  | Tinker, Soldier & Old Fish |  | OFF
 |  |  | 815/145
 | [NAME] |  | Spy & Red Fish |  | Thing 2 & Red Fish |  | Soldier, Blue Fish & Old Fish |  | Soldier & Spy |  | Thing 2 & Red Fish |  | OFF
 |  |  | 815/145
 | [NAME] T |  | Thing 1 & Thing 2 |  | Blue Fish |  | Spy & New Fish |  | Thing 2 |  | Blue Fish |  | OFF
 |  |  | 9/215
 | [NAME] R |  | Tinker & Soldier |  | Spy & Old Fish |  | Tinker |  | OFF |  | Tailor & Spy |  | Thing 1, Red Fish, & Old Fish
 |  |  | 10/3 |  |  |  |  |  |  |  |  |  | 830/12
Spreadsheet: 151883d1335175463-collecting-data-from-a-row-collecting-data-from-row-example-2
Sheet: Sheet1

 |  | NOKIA | 100 |  | 2 | 200 | 60 |  | ABB | 55 |  | 5 | 500 | 100 |  | VESTAS | 0.8 | 50 | 50 |  | UPONOR | 50
 |  | [NAME]) shows the largest value in that data range (alter range to suit) change the 1 to 2 or 3 for next values
 |  | match(above [NAME]) returns the value for the column that the highest value is in
 |  | -1 to get the name next to it
 |  | index($A$6:$W$6,,(above value)) returns the value of the cell x amount along in specified range.
 |  | hope that helps out
Spreadsheet: 696201d1600698373-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 1

Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product A | 2000 | 1 | -3 |  | 30000
2021-02-01 00:00:00 | Product A |  | 2 | -3 |  | 40000
2021-03-01 00:00:00 | Product A |  | 3 | -3 |  | 50000
2021-04-01 00:00:00 | Product A |  | 4 | -3 |  | 10000
Spreadsheet: 153949d1336128349-retrieving-numbers-from-another-file-stored-under-a-different-directory-copy-compare-ytd-jan_feb-2011-2012
Sheet: Sheet1

positive development Jan/Feb 2011/2012
negative development Jan/Feb 2011/2012
new in 2012
Client Group | Branche | Service | Sector | New 2012 ? | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Delta % | (re-)activation activities necessary
a | Banking & Finance | Translation | Finance |  | 32527.56 | 38468.05 |  |  |  |  |  |  |  |  |  |  |  | yes
b |  | Translation | Telco & Media |  | 0 | 61237.00999999999
Client Group | Press & Journalism | Translation | Telco & Media |  | 61025.71 | 0 |  |  |  |  |  |  |  |  |  |  |  | yes
Spreadsheet: 866330d1713280665-dynamic-drop-down-lists-dynamic-dropdowns-textsplit
Sheet: Sheet1

 | 1. Reference Table |  |  | 2. Main Table in Use |  | Dynamic DV Lists |  |  |  |  |  |  | 3. Data Validation Lists
 |  |  |  |  |  | req'd in this col.
 | Class No. | Code |  | ID | Class Code | Class Name |  |  |  |  | Used Classes |  |  | 2 | 3
 | 1 | A, B, C, D |  | 1 | 1
 | 1 | A |  | 2 | 3 |  |  |  |  |  | 2 |  | B | H | D
 | 1 | A, B |  | 3 | 2 |  |  |  |  |  | 3 |  | C | I | I
 | 1 | A, E, F |  | 4 |  |  |  |  |  |  |  |  | D |  | J
 | 1 | B, F |  | 5 |  |  |  |  |  |  |  |  | E |  | K
 | 2 | G |  | 6 |  |  |  |  |  |  |  |  | F |  | L
 | 2 | G, H, I |  |  |  |  |  |  |  |  |  |  |  |  | M
 | 2 | H |  |  |  |  |  |  |  |  |  |  |  |  | N
 | 3 | C, D, I, J, K |  |  |  |  |  |  |  |  |  |  |  |  | O
 | 3 | C
 | 3 | J, K, L, M
 | 3 | K, L
 | 3 | M
 | 3 | M
 | 3 | J, M
 | 3 | J, K, M, N, O
Spreadsheet: 756796d1637783332-remove-any-letters-except-the-capital-letters-remove-small-letters-excep-captial-letters
Sheet: Sheet3

Orders | Remove any letters except the capital letters
#111a | #111
#111b | #111
#2222 | #2222
#2223 | #2223
#22244 | #22244
#22222a | #22222
#22223b | #22223
#2225c | #2225
#3332 | #3332
#3333 | #3333
#3334a | #3334
#3334b | #3334
#3334c | #3334
#3334d | #3334
#3334e | #3334
#3334f | #3334
#3334g | #3334
#3334h | #3334
#3334i | #3334
#3334k | #3334
#3334l | #3334
#3334m | #3334
#[NAME] | #3334
#3334o | #3334
#3334p | #3334
#777777Aa | #777777A
#777777Ab | #777777A
#777777Ac | #777777A
5555Ba | 5555B
5555Bb | 5555B
5555Bc | 5555B
5555Bd | 5555B
Spreadsheet: 686218d1594423282-if-cell-contains-text-string-return-the-text-in-another-cell-book1
Sheet: Sheet1

2 | This is an apple | apple
4 | Hello is my name | twelve
5 | 21 is purple | 20
6 | Dogs are nice | are
7.5 | This is an apple
8.8 | Hello is my name
10.1 | 21 is purple
11.4 | Dogs are nice
12.7 | This is an apple
14 | Hello is my name
15.3 | 21 is purple
16.6 | Dogs are nice
Spreadsheet: 723883d1615928288-how-to-determine-the-position-of-the-greatest-value-on-an-arbitrary-range-question
Sheet: Sheet1

408 | [NAME] value 1st
432
432 | [NAME] value 5th
426
403
396
390
364
364
364 | [NAME] value 3rd
357
340
275
275 | [NAME] value 7th
253
230
230
221
221
221
Spreadsheet: 860229d1708416741-result-based-on-multiple-parameters-case-excel
Sheet: Data

Code | KdService | KdVType | Commodity | KdCost | Cost | IdPrice
KLTN-KLTN-PSR | FTL | TGWB | GC | A | 1650000 | 1
KLTN-KLTN-PSR | FTL | TGWB | GC | B | 175000 | 1
KLTN-KLTN-PSR | FTL | TGWB | GC | C | 20000 | 1
KLTN-KLTN-SUB | FTL | TGWB | Paper | A | 1650000 | 2
KLTN-KLTN-SUB | FTL | TGWB | Paper | B | 250000 | 2
Spreadsheet: 873108d1719521968-if-cell-value-is-with-a-date-range-copy-another-cell-to-that-date-range-row-demo-data
Sheet: Sheet1

Opportunity Name | Amount | Close Date
Customer 1 | 20 | 7/31/2024
Customer 2 | 204 | 7/19/2024
Customer 2 | 476 | 2024-06-22 00:00:00
Customer 4 | 577.5 | [NAME]
Customer 5 | 711.43 | 8/2/2024
Customer 6 | 806.4 | 7/24/2024