tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92050d1291728088-need-to-divide-hours-evenly-between-multiple-fields-to-maintain-averages-solver_production_test2
Sheet: Sample

Sample
PRODUCT | Custom Built | Hours | CBPH |  | AVERAGE | keep as close as possible
Sedans & Coupes | 3.2 | 1 | 3.2 |  | 3.3
Sedans & Coupes & Assistance | 3.2 | 1 | 3.2 |  | 2.6
Sedans | 3.2 | 1 | 3.2 |  | 3.2
Cycle | 0 | 0 | 0 |  | 10
Coupes | 0 | 0 | 0 |  | 3.5
Assistance | N/A | 0 | 0 |  | 0.18
 | TOTAL HOURS | 1
 | Target total hrs | 4.75
Had to change your formulas to show zero instead of "blank" as Solver preferes numbers.
Solver can be tricky to start with only zero values, so I'v given it a starting point by setting C5 value to 1.
Target cell must be set to the value of "Total Hours"
Use propper decimal separator i.e. the one shown in picture is for Sweden.
Solver is an add-in for Excel and it's not installed by default. So check that
Solver is installed.
For Excel 2007 you will find Solver under "tab" Data if installed.
Solver is often used in conction with proffit or costs. You wan a solution
maximizing profit or minimizing costs. Is there any costs involved in
these time splitting decisions. If so do tell because the model could then be
rebuild to take this in account.
Spreadsheet: 40654d1239046021-multiply-text-cell-to-multiple-outputs-example
Sheet: Sheet1

KEYWORD COLUMN | FREQUENCY OF KEYWORD | DESIRED OUTPUT:
KEYWORD A | 5 | KEYWORD A
KEYWORD B | 3 | KEYWORD A
[NAME] | 9 | KEYWORD A
KEYWORD D | 7 | KEYWORD A
 |  | KEYWORD A
 |  | KEYWORD B
 |  | KEYWORD B
 |  | KEYWORD B
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | KEYWORD D
 |  | KEYWORD D
 |  | KEYWORD D
 |  | KEYWORD D
 |  | KEYWORD D
 |  | KEYWORD D
 |  | KEYWORD D
Spreadsheet: 723650d1615821081-formula-for-new-worksheet-index-aggregate-with-and-and-or-operations-kim0204-
Sheet: FS CLIENT DISTRIBUTION TABLE

COMPANY NAME | COMPANY CONTACT PERSON | ORIGINAL FOOD SOURCE INVOICE | CLIENT CREDIT NOTE | SUPPLIER CREDIT RECEIVED | VOLUME BY STATE
COMPANY NAME | [NAME] | 1000 | 2000 | 3000
x  Raw Ingredient |  |  |  |  | 10
x  Manufactured but not Distributed |  |  |  |  | 10
x  Manufactured and in Transit to [NAME] |  |  |  |  | 10
x  Manufactured and in Retailer DC |  |  |  |  | 10
x  Manufactured and On [NAME] ([NAME]) |  |  |  |  | 10
TOTAL CLIENT X
COMPANY NAME | 0 | 0 | 0 | 0
y  Raw Ingredient |  |  |  |  | 0
y  Manufactured but not Distributed |  |  |  |  | 0
y  Manufactured and in Transit to [NAME] |  |  |  |  | 0
y  Manufactured and in Retailer DC |  |  |  |  | 0
y  Manufactured and On [NAME] ([NAME]) |  |  |  |  | 0
TOTAL CLIENT Y
COMPANY NAME | 0 | 0 | 0 | 0
z  Raw Ingredient |  |  |  |  | 0
z  Manufactured but not Distributed |  |  |  |  | 0
z  Manufactured and in Transit to [NAME] |  |  |  |  | 0
z  Manufactured and in Retailer DC |  |  |  |  | 0
z  Manufactured and On [NAME] ([NAME]) |  |  |  |  | 0
TOTAL CLIENT Z
Spreadsheet: 217645d1362141289-hlookup-and-average-formula-book5
Sheet: Cdata

sys_RespNum | Importance_Brand | Importance_HeadsetDesign | Importance_ConnectiontoGamingConsole | Importance_Compatibility | Importance_Sound | Importance_Microphone | Importance_EqualizerApp | Importance_BeatEnhancingTechnology | Importance_VoiceMorphing | Importance_SideTone | Importance_GameandChatSoundMixer | Importance_USBChargingCable | Importance_StorageDevice | Importance_Price
4 | 4.30821 | 2.86889 | 0 | 7.00788 | 13.13755 | 0 | 1.67609 | 0.99327 | 1.11584 | 0.22838 | 1.73117 | 2.453 | 5.57336 | 58.90635
6 | 4.56197 | 7.9652 | 13.29123 | 25.77373 | 19.71363 | 8.11687 | 3.08855 | 1.86788 | 0 | 0.33391 | 0 | 0 | 5.89806 | 9.38898
7 | 6.16854 | 9.51489 | 0 | 1.01916 | 7.3981 | 4.33602 | 2.00931 | 6.82484 | 0.19241 | 0 | 0 | 9.89449 | 5.09157 | 47.55067
11 | 10.35212 | 12.83469 | 5.56201 | 7.58652 | 10.77313 | 5.37327 | 1.35925 | 6.92421 | 2.02841 | 0 | 3.13633 | 0 | 7.39269 | 26.67736
16 | 16.23263 | 7.2875 | 0.24642 | 6.66942 | 20.84484 | 6.43332 | 1.64225 | 7.18801 | 0 | 0 | 0 | 7.01283 | 5.52329 | 20.91948
25 | 2.03858 | 17.97273 | 15.24325 | 1.06662 | 12.91268 | 8.15127 | 4.80601 | 6.02178 | 0 | 0 | 4.68777 | 0 | 3.72388 | 23.37545
27 | 5.65708 | 0 | 16.5816 | 18.39275 | 26.89936 | 0 | 2.41746 | 5.24109 | 0 | 0 | 0 | 4.66815 | 9.50819 | 10.63432
29 | 8.45438 | 4.21667 | 0 | 4.41867 | 2.78342 | 7.85708 | 1.19663 | 1.88786 | 0 | 0 | 0 | 3.82545 | 7.21194 | 58.1479
30 | 11.49345 | 10.1977 | 0.26856 | 10.63716 | 8.80577 | 6.04653 | 6.79371 | 7.87839 | 0 | 0 | 7.53826 | 3.37712 | 6.37684 | 20.58652
35 | 2.29867 | 6.05398 | 16.55399 | 13.4659 | 15.98552 | 7.99232 | 1.56519 | 1.92516 | 0 | 0 | 0 | 0 | 4.65 | 29.50928
36 | 4.74991 | 8.26055 | 5.94376 | 0 | 9.43865 | 7.36489 | 7.27098 | 4.98999 | 0 | 6.95875 | 5.10902 | 0 | 4.65713 | 35.25638
40 | 0.59134 | 12.40032 | 9.8024 | 10.59528 | 18.04847 | 5.85504 | 4.43309 | 5.80936 | 8.86675 | 0 | 0 | 2.92959 | 7.80432 | 12.86404
41 | 8.04199 | 14.9792 | 4.91338 | 4.04556 | 15.2656 | 0 | 6.3348 | 9.09712 | 0 | 0 | 0 | 5.02116 | 4.19041 | 28.11078
Spreadsheet: 871488d1717914199-trying-to-count-values-with-a-formula-question
Sheet: SUNDAYS 2024

 |  | 2024
 |  | SHOP1 |  |  | SHOP2
 |  | 2024-05-05 00:00:00 | PERSON 1 |  | 2024-05-05 00:00:00 | PERSON 1
 |  | 2024-05-12 00:00:00 | PERSON 2 |  | 2024-05-12 00:00:00 | PERSON 2
 |  | 2024-05-19 00:00:00 | PERSON 1 |  | 2024-05-19 00:00:00 | PERSON 5
 |  | 2024-05-26 00:00:00 | PERSON 3 |  | 2024-05-26 00:00:00 | PERSON 3
 |  | 2024-06-02 00:00:00 | PERSON 2 |  | 2024-06-02 00:00:00 | PERSON 2
 |  | 2024-06-02 00:00:00 | PERSON 4 |  | 2024-06-02 00:00:00 | PERSON 4
 |  | 2024-06-09 00:00:00 | PERSON 1 |  | 2024-06-09 00:00:00 | PERSON 1
 |  | NUMBERS OF SUNDAYS |  |  | NUMBERS OF SUNDAYS
 |  | PERSON 1 | 3 |  | PERSON 1 | 2
 |  | PERSON 2 | 2 |  | PERSON 2 | 2
 |  | PERSON 3 | 1 |  | PERSON 3 | 1
 |  | PERSON 4 | 1 |  | PERSON 4 | 1
 |  |  |  |  | PERSON 5 | 1
 |  | PREFERRED RESULT
Spreadsheet: 713715d1610893483-extracting-data-from-multiple-worksheets-sample-new-ufc
Sheet: Sheet1

Rank | Fighter
 | Conor [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Khabib Nurmagomedov
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Merrick
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Shane Burgos
 | [NAME]
 | [NAME]
 | [NAME]
 | Raulian Paiva
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Catello Laine
 | [NAME]
 | [NAME]
 | Urbano Beck
 | [NAME]
 | [NAME]
 | Rodolphe Everhart
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Marlon Vera
 | [NAME]
 | [NAME] dos [NAME]
 | [NAME]
 | [NAME]
 | Tyson Nam
 | Yair Rodríguez
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Ciarán Süß
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Anraí Cinege
 | [NAME]
 | [NAME]
 | Aljamain Sterling
Spreadsheet: 231378d1367023773-how-to-protect-a-group-of-worksheets-how-to-protect-a-group-of-sheets
Sheet: test-1 (3)

 | NAME COMBINED | FIRST NAME | LAST NAME
1 | ALBERT
2 | EINSTEIN
3 | MARRY
4 | CURIE
5 | [NAME]
6 | TAYLOR
7 | HARRISON
8 | FORD
9 | [NAME]
10 | [NAME]
Spreadsheet: 647702d1572572601-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-tennispq17
Sheet: Tennis Data

Carpet |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 22 | 255 | 372 | 117 | 0.7143 | Hard | 0.7446 | 572989
[NAME] |  | [NAME] | 26 | 278 | 446 | 168 | 0.6543 | Clay | 0.6561 | 446804
Spreadsheet: 822608d1679440610-index-match-with-multiple-row-results-s666-pq-indexmatch-multi-row
Sheet: Sheet1

NAME | AET | GROUP | AS1 | AS2 | AS3 | AS4 | [NAME] | [NAME] | AS7 | AS8 | AS9 | AS10 | AS11 | AS12 | AS13 | AS14 | AS15 | AS16 | AS17 | AS18 | AS19 | AS20 | AS21 | AS22 | AS23 | AS24 | AS25 | AS26 | AS27 | AS28 | AS29 | AS30 | AS31 | AS32 | AS33
Person1 | ONE | CSG | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 44 | 46 | 56 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 80 | 86 | 90 | 92 | 94
Person2 | TWO | CSG | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 44 | 46 | 56 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 80 | 86 | 90 | 92 | 94
Person3 | THREE | CSG | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 44 | 46 | 56 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 80 | 86 | 90 | 92 | 94
Person4 | FOUR | CSG | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 44 | 46 | 56 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 80 | 86 | 90 | 92 | 94
Person5 | FIVE | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person6 | SIX | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person7 | SEVEN | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person8 | EIGHT | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person9 | NINE | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person10 | TEN | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person11 | ELEVEN | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person12 | TWELVE | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
[NAME] | THIRTEEN | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person14 | FOURTEEN | MAP | 39 | 40 | 55 | 56 | 61 | 62 | 67 | 68 | 71 | 72 | 79 | 80 | 93 | 94
Person15 | FIFTEEN | CAP | 37 | 38 | 41 | 42 | 49 | 50 | 51 | 52 | 57 | 58 | 73 | 74 | 75 | 76 | 81 | 82
Person16 | SIXTEEN | CAP | 37 | 38 | 47 | 48 | 49 | 50 | 51 | 52 | 57 | 58 | 73 | 74 | 75 | 76 | 81 | 82
Person17 | SEVENTEEN | CAP | 37 | 38 | 49 | 50 | 51 | 52 | 57 | 58 | 73 | 74 | 75 | 76 | 81 | 82
Person18 | EIGHTEEN | CAP | 37 | 38 | 49 | 50 | 51 | 52 | 57 | 58 | 73 | 74 | 75 | 76 | 81 | 82
Person19 | NINETEEN | UAP | 77 | 78 | 87 | 88
[NAME] | TWENTY | UAP | 77 | 78 | 87 | 88
Person21 | TWENTYONE | UAP | 77 | 78 | 87 | 88
Person22 | TWENTYTWO | UAP | 77 | 78 | 87 | 88
Person23 | TWENTYTHREE | UAP | 77 | 78 | 87 | 88
Person24 | TWENTYFOUR | UAP | 77 | 78 | 87 | 88
Person25 | TWENTYFIVE | UAP | 77 | 78 | 87 | 88
Person26 | TWENTYSIX | UAP | 77 | 78 | 87 | 88
Person27 | TWENTYSEVEN | UAP | 77 | 78 | 87 | 88
Which Server # ?
37
AET list matching
FIFTEEN
SIXTEEN
SEVENTEEN
EIGHTEEN
Server |  | AET |  |  |  | after change server number right click on green table and select [NAME]
37 |  | FIFTEEN
 |  | SIXTEEN
 |  | SEVENTEEN
 |  | EIGHTEEN
Spreadsheet: 871716d1718132130-dynamic-calculation-row-and-column-operations-randjo
Sheet: Sheet1

0.83430155 | 0.580553842 | 0.348584099 | 0.420539842 | 0.583892886 | 0.46086388 | 0.810126559 | 0.830109017 | 0.843489139 |  |  |  |  | SUM(A1:A10) | Sum(B1:B10)| SUM(C1:[NAME])
0.049380668 | 0.566570026 | 0.300095114 | 0.016045539 | 0.568907809 | 0.73156691 | 0.201381596 | 0.025214578 | 0.96600303 |  |  |  |  | SUM(D1:D10)| Sum(E1:E10) | Sum(F1:[NAME])
0.650378556 | 0.896557871 | 0.399269313 | 0.99097527 | 0.716639937 | 0.309991158 | 0.084696007 | 0.434419509 | 0.392676138 |  |  |  |  | SUM(G1:G10)| Sum(H1:H10) | Sum(I1:I10)
0.923133369 | 0.507890355 | 0.779445044 | 0.075274557 | 0.920150345 | 0.252689235 | 0.206218027 | 0.271049924 | 0.052910757
0.404394479 | 0.751618217 | 0.771374923 | 0.349304944 | 0.843896301 | 0.891552716 | 0.166329907 | 0.84464468 | 0.23543607
0.219808845 | 0.133496878 | 0.02874144 | 0.178003019 | 0.929661147 | 0.682071652 | 0.984850578 | 0.959935047 | 0.973773127
0.247205959 | 0.544407774 | 0.373298892 | 0.010865352 | 0.010043074 | 0.459332076 | 0.12697625 | 0.938000947 | 0.208823788
0.283506258 | 0.043122548 | 0.037509503 | 0.712992584 | 0.92864103 | 0.157464012 | 0.571699336 | 0.207903276 | 0.364425613
0.260035824 | 0.160353106 | 0.126029825 | 0.593165782 | 0.513064422 | 0.315484001 | 0.474075262 | 0.273442445 | 0.971758478
0.751313457 | 0.058197364 | 0.762151656 | 0.736473387 | 0.901213079 | 0.997865927 | 0.327578452 | 0.645238879 | 0.003238067
Spreadsheet: 887290d1737526812-schedule-calendar-cover-school-copy-of-absence-timetable-v1
Sheet: Su

Period | Time | Monday | Tuesday | Wednesday | Thursday | Friday
 | 7:30-8:00 | 3.2 Fuhan (B1) | 3.2 Fuhan (B1) | 3.2 Fuhan (B1) | 3.2 Fuhan (B1) | Department Meeting
Period 1 | 8:00-8:30 |  | 5.1 Geo (B2)                                  5.2 Timmy (B2) | 5.2 Aura (B2)                                                 5.3 [NAME] (B1)                                             5.3 Harry (B1)
 | 8:30-9:00 |  |  |  |  | 3.1 Pippa (B2)
Period 2 | 9:00-9:30 | 3.1 Pippa (B2) | 3.1 Noah (B4)                                            2.2 Oliver (B5) | 3.1 Noah (B4)                                            2.2 Oliver (B5) | 3.1 Noah (B4)                                            2.2 Oliver (B5) | 5.1 Geo (B2)                                  5.2 Timmy (B2)
 | 9:30-10:00 | 3.1 Noah (B4)                                          2.2 Oliver (B5)
Period 3 | 10:00-10:30 | Break
 | 10:30-11:00 | Y5 Planning |  | 3.1 Pippa (B2)
Period 4 | 11:00-11:30
 | 11:30-12:00 | 3.2 Cameron (B1)                                   3.3 Otis (B3) | 3.2 Cameron (B1)                                   3.3 Otis (B3) | 3.2 Cameron (B1)                                   3.3 Otis (B3) | 3.2 Cameron (B1)                               3.3 Otis (B3) | 3.2 Cameron (B1)                       3.3 Otis
Period 5 | 12:00-12:30 | Lunch | Cafeteria 1 | Lunch | Lunch | Lunch
 | 12:30-13:00 | Cafeteria 1 | Lunch
Period 6 | 13:00-13:30
 | 13:30-14:00 |  | 5.1 Kenzo (B2) | 3T Department Meeting | 5.2 Aura (B2)                      5.1 Geo (B2) | 5.2 Aura (B2)                                 5.1 Geo (B2)
Period 7 | 14:00-14:30 |  | 5.2 Aura (B2)                                                 5.3 [NAME] (B1)                                             5.3 Harry (B1)
 | 14:30-15:00 | 5.1 Kenzo (B2) |  | 5.1 Kenzo (B2)
 | 15:00-15:15 | Bus Loading/Dismissal
 | 15:30-16:30 | Staff Meeting |  | CCA
Spreadsheet: 717502d1612704399-extract-values-using-left-right-or-mid-function-left_right_function_extract_sample_3
Sheet: Okay

Name
[NAME], [NAME]
[NAME], [NAME]
Abdelnour, [NAME]
Abdelrahman, [NAME]
[NAME], Hable
Macchi, [NAME]
Sablan, [NAME]
[NAME], Chiocemax
Deer, Chiocemax Jr
Deer, Chiocemax-Ben
[NAME], Chiocemax
[NAME], Yan
[NAME], [NAME]
Head, [NAME]
Head, Chroster
Luther-Ara, English
Luther, English
Macchio Jon, [NAME]
Macchio, Hach
Macchio, [NAME]
[NAME], Backen
Otoma, Look
Stormy, English
Bock, [NAME]
Abdelnour, [NAME]
[NAME], Good
Kinda, [NAME] Claire
Abdelnour, [NAME]
Spreadsheet: daren_farmer__5509__hpl1004
Sheet: Sheet1

HPLN1004.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 4, 2000
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-10-04 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
ENA (S) |  | LS Mivida |  |  | 7.92 | 7.92
ENA (S) |  | LS Range/Lomax I.C. |  |  | 1.78 | 1.78
ENA (S) |  | Oasis Turbine |  |  | 5 | 5
ENA (S) |  | Oasis Sealy |  |  | 20 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 809359d1671043283-advanced-function-to-count-orders-with-some-exceptions-count
Sheet: Sheet1

DATE | COMPANY | MARKET | ORDER | VARIAN | PRICE | PRODUCTION
2022-03-10 00:00:00 | RYKTOS | CZECH | 54232 | V1 | 5000
2022-04-10 00:00:00 |  |  | 55555 | V1 | 10000
2022-05-24 00:00:00 | RYKTOS | CZECH | 65445 | V1 | 10000
2022-09-12 00:00:00 | RYKTOS | CZECH | 65445 | V2 | 11000
2022-09-12 00:00:00 | RYKTOS | CZECH | 65445 | V3 | 12000
2022-10-04 00:00:00 | RYKTOS | CZECH | 65445 | V4 | 13000
2022-10-04 00:00:00 | RYKTOS | CZECH | 65445 | V5 | 14000
2022-10-25 00:00:00 | RYKTOS | CZECH | 65445 | V6 | 15000
2022-10-25 00:00:00 | RYKTOS | CZECH | 65445 | V7 | 16000
2022-11-03 00:00:00 | RYKTOS | CZECH | 65445 | V8 | 20000 | x
2022-11-10 00:00:00 |  |  | 55555 | V3 | 1000 | x
2022-11-14 00:00:00 | AMN SLO | VAKIA | 54231 | V2 | 2000 | x
Spreadsheet: 150144d1334310831-take-data-from-tables-on-other-sheets-irtest2
Sheet: Express Plus

 | Express Plus |  |  |  |  |  | 41 | 51 | 6 | 7 | 8 | 9
 | Documents & Packages | Weight ([NAME]) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 0.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5
 |  | 1 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5
 |  | 1.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5
 |  | 2 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
 |  | 2.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | 9.5
 |  | 3 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | 9.5 | 10 | 10.5
 |  | 3.5 | 7 | 7.5 | 8 | 8.5 | 9 | 9.5 | 10 | 10.5 | 11 | 11.5
 |  | 4 | 8 | 8.5 | 9 | 9.5 | 10 | 10.5 | 11 | 11.5 | 12 | 12.5
 |  | 4.5 | 9 | 9.5 | 10 | 10.5 | 11 | 11.5 | 12 | 12.5 | 13 | 13.5
 |  | 5 | 10 | 10.5 | 11 | 11.5 | 12 | 12.5 | 13 | 13.5 | 14 | 14.5
 |  | 5.5 | 11 | 11.5 | 12 | 12.5 | 13 | 13.5 | 14 | 14.5 | 15 | 15.5
 |  | 6 | 12 | 12.5 | 13 | 13.5 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5
 |  | 6.5 | 13 | 13.5 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5
 |  | 7 | 14 | 14.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5
 |  | 7.5 | 15 | 15.5 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5
 |  | 8 | 16 | 16.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5 | 20 | 20.5
 |  | 8.5 | 17 | 17.5 | 18 | 18.5 | 19 | 19.5 | 20 | 20.5 | 21 | 21.5
 |  | 9 | 18 | 18.5 | 19 | 19.5 | 20 | 20.5 | 21 | 21.5 | 22 | 22.5
 |  | 9.5 | 19 | 19.5 | 20 | 20.5 | 21 | 21.5 | 22 | 22.5 | 23 | 23.5
 |  | 10 | 20 | 20.5 | 21 | 21.5 | 22 | 22.5 | 23 | 23.5 | 24 | 24.5
 |  | 11 | 21 | 21.5 | 22 | 22.5 | 23 | 23.5 | 24 | 24.5 | 25 | 25.5
 |  | 12 | 22 | 22.5 | 23 | 23.5 | 24 | 24.5 | 25 | 25.5 | 26 | 26.5
 |  | 13 | 23 | 23.5 | 24 | 24.5 | 25 | 25.5 | 26 | 26.5 | 27 | 27.5
 |  | 14 | 24 | 24.5 | 25 | 25.5 | 26 | 26.5 | 27 | 27.5 | 28 | 28.5
 |  | 15 | 25 | 25.5 | 26 | 26.5 | 27 | 27.5 | 28 | 28.5 | 29 | 29.5
 |  | 16 | 26 | 26.5 | 27 | 27.5 | 28 | 28.5 | 29 | 29.5 | 30 | 30.5
 |  | 17 | 27 | 27.5 | 28 | 28.5 | 29 | 29.5 | 30 | 30.5 | 31 | 31.5
 |  | 18 | 28 | 28.5 | 29 | 29.5 | 30 | 30.5 | 31 | 31.5 | 32 | 32.5
 |  | 19 | 29 | 29.5 | 30 | 30.5 | 31 | 31.5 | 32 | 32.5 | 33 | 33.5
 |  | 20 | 30 | 30.5 | 31 | 31.5 | 32 | 32.5 | 33 | 33.5 | 34 | 34.5
 |  | 22 | 31 | 31.5 | 32 | 32.5 | 33 | 33.5 | 34 | 34.5 | 35 | 35.5
 |  | 24 | 32 | 32.5 | 33 | 33.5 | 34 | 34.5 | 35 | 35.5 | 36 | 36.5
 |  | 26 | 33 | 33.5 | 34 | 34.5 | 35 | 35.5 | 36 | 36.5 | 37 | 37.5
 |  | 28 | 34 | 34.5 | 35 | 35.5 | 36 | 36.5 | 37 | 37.5 | 38 | 38.5
 |  | 30 | 35 | 35.5 | 36 | 36.5 | 37 | 37.5 | 38 | 38.5 | 39 | 39.5
 |  | 35 | 36 | 36.5 | 37 | 37.5 | 38 | 38.5 | 39 | 39.5 | 40 | 40.5
 |  | 40 | 37 | 37.5 | 38 | 38.5 | 39 | 39.5 | 40 | 40.5 | 41 | 41.5
 |  | 45 | 38 | 38.5 | 39 | 39.5 | 40 | 40.5 | 41 | 41.5 | 42 | 42.5
 |  | 50 | 39 | 39.5 | 40 | 40.5 | 41 | 41.5 | 42 | 42.5 | 43 | 43.5
 |  | 55 | 40 | 40.5 | 41 | 41.5 | 42 | 42.5 | 43 | 43.5 | 44 | 44.5
 |  | 60 | 41 | 41.5 | 42 | 42.5 | 43 | 43.5 | 44 | 44.5 | 45 | 45.5
 |  | 65 | 42 | 42.5 | 43 | 43.5 | 44 | 44.5 | 45 | 45.5 | 46 | 46.5
 |  | 70 | 43 | 43.5 | 44 | 44.5 | 45 | 45.5 | 46 | 46.5 | 47 | 47.5
Spreadsheet: 145159d1331326582-find-out-how-many-cells-in-one-column-have-values-less-than-another-column-numbaz
Sheet: Sheet1

 |  |  | How many cells in column A have a value less than the cell in the same row in column B array formula
5574 | 5636 |  | The answer should be 21
5689 | 5690
5685 | 5648
5646 | 5645
5635 | 5662
5634 | 5658
5687 | 5683
5683 | 5665
5689 | 5691
5630 | 5648
5657 | 5708
5668 | 5673
5717 | 5711
5744 | 5724
5751 | 5744
5781 | 5744
5748 | 5758
5753 | 5746
5770 | 5770
5733 | 5686
5678 | 5707
5702 | 5743
5776 | 5773
5794 | 5792
5914 | 5866
5891 | 5880
5883 | 5905
5900 | 5895
5907 | 5875
5857 | 5912
5911 | 5885
5905 | 5911
5858 | 5847
5908 | 5901
5922 | 5936
5943 | 5931
5914 | 5915
5912 | 5944
5945 | 5943
5922 | 5892
5911 | 5927
5932 | 5922
5874 | 5882
5939 | 5921
5908 | 5878
5883 | 5843
5747 | 5772
5791 | 5826
5861 | 5853
Spreadsheet: 288922d1389345965-convert-one-column-of-addresses-into-three-columns-when-text-to-be-grouped-is-not-even-example-address-column-separated-to-3-columns
Sheet: Sheet1

CURRENT FORM |  |  |  | DESIRED RESULT
COMBINED ADDRESS |  |  |  | SUBURB | STATE | POSTCODE
ALTONA NORTH VIC 3025
BONDI NSW 2026
WOOLLOONGABBA QLD 4102
TOOWONG QLD 4066
NOVAR GARDENS SA 5040
Spreadsheet: 866478d1713385698-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-eba
Sheet: Weekly OJR View

 |  |  | K | USE CELL B5 TO EDIT DATE!!!  DO NOT EDIT ANY OTHER PART OF THIS SHEET!!!
 | 2024-04-15 00:00:00 | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime
 | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital
 | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric
 | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship
 | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces
 | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs
 | CKGC 61110- ICE BOX TALL REPRINT | To Inv./ 186 |  |  | CKRE  2476- NB CKMW Welcome Sign & Coffee Panels | 3 /17 | CKRE  2477- NB RE CKMW ACM Panels 4702281 & 4702226 | 1/13 | CKCC 45484- NM MURALS 2723844 | To Inv./ 9
 | HHGJ   289 - E03108409 Macy's Son Grand Opening 2028 | 1 / 3 |  |  | GGPM 23497- New Low Priced Cigarettes April Rollout | 284/ 1872 | GIAB   281  - April Hang Tags - TO INV | To Inv./ 5300 | CKCC 45736- NM FFF MURAL 2720823 | To Inv./ 6
 |  |  |  |  | GIAB   289  - April New Dealer Kits - FROM INV | 14/ 126 LOW$ | GIAB   282  - Service WBBT, Weblink & 60 Day Shelf - TO INV | To Inv./ 343 | CKGC 61889- INSTALLATION NEEDS FOR- 9955 | 1/1
 |  |  |  |  | HHGJ   271 - E03082789 [NAME] | 216/ 6749 | GIAB   284  - Floor Mats - TO INV | To Inv./ 107 | CKGC 62256- RE ICE BOX FOR 1570 | 1/6
 |  |  |  |  | HHGJ   272 - E03081809 [NAME] | 216/ 12401 | GIAB   285  - 8in and 12in Circles - TO INV | To Inv./ 124 | CKWE 21113 (ships w/ CKWE 21105-) SWM - MAY/JUNE 2024 SMART VALUE TAGS | To Inv./ 1560
 |  |  |  |  | HHGJ   282 - E03094459 [NAME] April | 146/ 424 | GIAB   296  - NB - Weblink Banners | 1/1 | HHGJ   178 - E03059762 JD BOC Puma Fenty Launch | 17/ 37
 |  |  |  |  | HHGJ   306 (ships w/ HHGJ   271)    - E03082789 [NAME] x adidas Badge of Sports | 163/ 489 |  |  | HHGJ   275 - HR E03079504 JD-CHI New Balance 1906 AZ | 1/9
 |  |  |  |  | HHGJ   308 (ships w/ HHGJ   272)    - E03081809 [NAME] | 164/ 4908 |  |  | HHGJ   305 - E03086138 JD BOC Asics As | 157/ 303
 |  |  |  |  | KNST     3    - 4.25 Mother's Day | 137/ 698 |  |  | TOFA     2    - May June Cold Vault POP - | 374/ 30780
 |  |  |  |  |  |  |  |  | TOFA     3    - NB - May June Cold Vault POP - Store 300 | 283/ 23227
 |  |  |  |  |  |  |  |  | TOFA     4 (ships w/ TOFA     3)        - NB - May June Cold Vault POP - Store 200 | 29/ 2407
 |  |  |  |  |  |  |  |  | TOFA     5 (ships w/ TOFA     3)        - NB - May June Cold Vault POP - Store 100 | 91/ 2671