tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771112d1646416387-expected-output-based-on-2-criteria-and-header-sample-workbook-with-expected-outcome
Sheet: Data

Category | Activity | Performer Name | Dec.21 Status (Yes/No) | [NAME] (Yes/No) | Feb.22 Status (Yes/No) |  | All |  | All
GL | 123 | A | Yes | Yes | Yes |  | GL |  | Yes
GL | 456 | A | Yes | Yes | Yes |  | Recon |  | No
Recon | 789 | B | No | Yes | Yes |  | Reporting |  | Not Due
Recon | 101 | C | Yes | Not Due | Not Due
Recon | 112 | B | Not Due | Yes | Yes
Reporting | 132 | D | No | Yes | No
Reporting | 659 | E | Yes | Yes | No
Recon | 489 | C | No | No | Yes
GL | 542 | F | No | No | Yes
Spreadsheet: 144588d1331051555-excel-2007-vlookup-for-cells-and-then-in-one-of-them-i-need-a-drop-down-menu-to-pick-between-2-states-copy-of-book1-3
Sheet: Sheet1

Grower number | [NAME] | State | variety | boxes
1384 | [NAME] | MI | Peach | 50
1384 | [NAME] | NY
1519 | [NAME] | NJ | Peach | 50
1519 | [NAME] | FL
Worksheet
Grower Number | [NAME] | State | Variety | boxes
1384 | [NAME] |  | peach | 50
I put in Grower Number and then using vlookup bob comes in automatically but with state there is 2 different states,
I want to have it give me a drop down menu so I can pick what state bob is bringing these peaches from otherwise with
vlookup it will only pick the top one because it can't figure it out that there are 2 with different states. I would like
it to have do vlookup but then give me the option of putting the state in from a drop down menu.
Spreadsheet: 270738d1381614062-1st-occurance-of-value-identification-book2
Sheet: Sheet1

120 | 120
250 | 250
-100 | 375
-250 | 500
-650 | 600
500
120 | 120
-100 | 250
-250 | 375
-650 | 0
-650 | 300
Spreadsheet: 164357d1340732644-is-there-a-way-of-comparing-text-values-in-rows-email-address
Sheet: Sheet1

[EMAIL]
[EMAIL] <<<<<< Highlight these 2 |  |  | if the count is greater than the same email or if email is duplicated, it will be highlighted in red color
[EMAIL] <<<<<< Highlight these 2
[EMAIL]
[EMAIL]
[EMAIL] <<<<<< Highlight these 2
[EMAIL] <<<<<< Highlight these 2
Spreadsheet: 177132d1346196379-list-name-once-from-list-contains-multiple-entries-of-same-name-sample_index_issue-helper
Sheet: Detail RPS breakdown

 |  |  |  |  |  | HELPER
 |  | SE Name | Branch | District | Period
 | 1 | Mark | x | x | P9 | 14
 | 1 | [NAME] | x | x | P9 | 15
 | 1 | [NAME] | x | x | P10 | 16
 | 1 | [NAME] | x | x | P11 | 17
 | 1 | Mark | x | x | P9
 | 1 | [NAME] | x | x | P9 | 19
 |  | PETE |  |  |  | 20
 |  | [NAME]
Spreadsheet: 784675d1655900126-lookup-previous-price-in-price-list-previous-price
Sheet: Price List

Date | Site | Supplier | P/N | MOQ | Price | Previous price
2022-06-21 00:00:00 | Paris | S1 | 123 | 10 | 12 |  |  |  |  |  | Task:
2022-06-21 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  |  |  |  | Lookup previous price matching with Site, [NAME], P/N and MOQ. If MOQ does not match, look for the closest value instead.
2022-06-21 00:00:00 | Paris | S1 | 258 | 60 | 12.6 |  |  |  |  |  | If the previous price does not exist for the criteria above, show "-".
2022-06-21 00:00:00 | Prague | S1 | 456 | 100 | 6.8 |  |  |  |  |  | Data may not be sorted
2022-06-21 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-06-21 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-06-18 00:00:00 | London | S2 | 147 | 100 | 15
2022-06-18 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2022-06-18 00:00:00 | Paris | S2 | 159 | 1000 | 14
2022-06-18 00:00:00 | Prague | S2 | 369 | 4500 | 13
2022-06-18 00:00:00 | Prague | S2 | 369 | 13500 | 10.1
2022-06-18 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2022-05-15 00:00:00 | Prague | S3 | 369 | 4500 | 12
2022-05-15 00:00:00 | Prague | S3 | 369 | 26000 | 7.4
2022-04-18 00:00:00 | Paris | S1 | 123 | 10 | 14
2022-04-18 00:00:00 | Paris | S1 | 258 | 30 | 17
2022-04-18 00:00:00 | Paris | S1 | 258 | 60 | 13
2022-04-18 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-04-18 00:00:00 | Prague | S1 | 456 | 1000 | 4.2
2022-04-18 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-03-30 00:00:00 | Prague | S3 | 369 | 4500 | 13
2022-03-30 00:00:00 | Prague | S3 | 369 | 26000 | 6.5
2022-03-05 00:00:00 | London | S2 | 147 | 100 | 14
2022-03-05 00:00:00 | Paris | S2 | 123 | 20 | 14.3
2022-03-05 00:00:00 | Paris | S2 | 159 | 500 | 13
2022-03-05 00:00:00 | Prague | S2 | 369 | 6000 | 12
2022-03-05 00:00:00 | Prague | S2 | 369 | 13500 | 9.9
2022-03-05 00:00:00 | Prague | S2 | 369 | 26000 | 7.2
2022-03-05 00:00:00 | Paris | S2 | 159 | 100 | 20
2022-01-14 00:00:00 | Paris | S1 | 123 | 10 | 13
2022-01-14 00:00:00 | Paris | S1 | 258 | 30 | 16.5
2022-01-14 00:00:00 | Paris | S1 | 258 | 60 | 11.2
2022-01-14 00:00:00 | Prague | S1 | 159 | 200 | 17
2022-01-14 00:00:00 | Prague | S1 | 456 | 100 | 7
2022-01-14 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-01-14 00:00:00 | Prague | S1 | 456 | 10000 | 2.1
2021-12-22 00:00:00 | Prague | S3 | 369 | 4500 | 11
2021-12-22 00:00:00 | Prague | S3 | 369 | 26000 | 6.3
2021-12-19 00:00:00 | London | S2 | 147 | 100 | 16
2021-12-19 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2021-12-19 00:00:00 | Paris | S2 | 159 | 1000 | 12
2021-12-19 00:00:00 | Prague | S2 | 369 | 4500 | 11
2021-12-19 00:00:00 | Prague | S2 | 369 | 10000 | 9.1
2021-12-19 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2021-12-19 00:00:00 | Paris | S2 | 159 | 100 | 16.5
Spreadsheet: 806229d1669179315-need-help-auto-populating-i-think-cells-test-spreadsheet
Sheet: Sheet1

PART NUMBER | [NAME] | COST | QUANTITY | TOTAL
123456 | Cast Iron Defibrillating Cheese Grater | 6.99 | 137
234567 | Velvet Tire Chains | 96.38 | 59
345678 | Wooden Cast Iron Skillet | 0.38 | 2
 |  |  | ORDER TOTAL
Spreadsheet: 74469d1274963402-countif-problem-example
Sheet: Sheet1

Date | Data | Month
2009-01-01 00:00:00 | 1 | Jan,09
2009-01-02 00:00:00 | 2 | Jan,09 |  |  |  |  | Jan,09
2009-01-03 00:00:00 | 3 | Jan,09
2009-01-04 00:00:00 | 4 | Jan,09
2009-01-05 00:00:00 | 5 | Jan,09 |  | Total Days in Jan |  |  | 31
2009-01-06 00:00:00 | 6 | Jan,09
2009-01-07 00:00:00 | 7 | Jan,09 |  | Total Bussiness days left in Jan |  |  | ?
2009-01-08 00:00:00 | 8 | Jan,09
2009-01-09 00:00:00 | 9 | Jan,09
2009-01-10 00:00:00 | 10 | Jan,09
2009-01-11 00:00:00 |  | Jan,09
2009-01-12 00:00:00 |  | Jan,09
2009-01-13 00:00:00 |  | Jan,09
2009-01-14 00:00:00 |  | Jan,09
2009-01-15 00:00:00 |  | Jan,09
2009-01-16 00:00:00 |  | Jan,09
2009-01-17 00:00:00 |  | Jan,09
2009-01-18 00:00:00 |  | Jan,09
2009-01-19 00:00:00 |  | Jan,09
2009-01-20 00:00:00 |  | Jan,09
2009-01-21 00:00:00 |  | Jan,09
2009-01-22 00:00:00 |  | Jan,09
2009-01-23 00:00:00 |  | Jan,09
2009-01-24 00:00:00 |  | Jan,09
2009-01-25 00:00:00 |  | Jan,09
2009-01-26 00:00:00 |  | Jan,09
2009-01-27 00:00:00 |  | Jan,09
2009-01-28 00:00:00 |  | Jan,09
2009-01-29 00:00:00 |  | Jan,09
2009-01-30 00:00:00 |  | Jan,09
2009-01-31 00:00:00 |  | Jan,09
2009-02-01 00:00:00 |  | Feb,09
2009-02-02 00:00:00 |  | Feb,09
2009-02-03 00:00:00 |  | Feb,09
2009-02-04 00:00:00 |  | Feb,09
Spreadsheet: joe_parks__14588__Storage Declines
Sheet: Parameters

 |  |  |  | Bear Creek Storage |  |  |  |  |  | Entex Portland Storage
 |  |  |  |  | Inventory asof |  |  | Total dths |  |  | Inventory asof |  | Total dths
 |  |  |  |  | 2001-12-31 00:00:00 |  |  | 411529 |  |  | 2001-12-31 00:00:00 |  | 471078
 | Prior Year |  |  |  | Beginning | Amount | Amount | Ending |  |  | Beginning | Amount | Ending
 | Delivery |  |  |  | Balance | Withdrawn | Withdrawn | Balance |  |  | Balance | Withdrawn | Balance
 | (dth/day) |  |  |  |  | (dth/day) | (dth/mo)
2002-01-01 00:00:00 | 14085.16129032258 |  |  | 2002-01-01 00:00:00 |  |  |  |  |  | 2002-01-01 00:00:00
2002-02-01 00:00:00 | 10187.71428571429 |  |  | 2002-02-01 00:00:00 |  |  |  |  |  | 2002-02-01 00:00:00
2002-03-01 00:00:00 | 9177.322580645161 |  |  | 2002-03-01 00:00:00 |  |  |  |  |  | 2002-03-01 00:00:00
2002-04-01 00:00:00 | 5401.866666666667 |  |  | 2002-04-01 00:00:00 |  |  |  |  |  | 2002-04-01 00:00:00
2002-05-01 00:00:00 | 4676.193548387097 |  |  | 2002-05-01 00:00:00 |  |  |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 3607.433333333333 |  |  | 2002-06-01 00:00:00 |  |  |  |  |  | 2002-06-01 00:00:00
2002-07-01 00:00:00 | 4294.225806451613 |  |  | 2002-07-01 00:00:00 |  |  |  |  |  | 2002-07-01 00:00:00
2002-08-01 00:00:00 | 4582.419354838709 |  |  | 2002-08-01 00:00:00 |  |  |  |  |  | 2002-08-01 00:00:00
2002-09-01 00:00:00 | 4743.366666666667 |  |  | 2002-09-01 00:00:00 |  |  |  |  |  | 2002-09-01 00:00:00
2002-10-01 00:00:00 | 6118.967741935484 |  |  | 2002-10-01 00:00:00 |  |  |  |  |  | 2002-10-01 00:00:00
Spreadsheet: 160997d1339361116-formula-for-averaging-averaging-example
Sheet: Sheet1

 |  |  | Column of numbers | Rolling average of last 10 values
 |  |  | 2 | -
 |  |  | 45 | -
 |  |  | 23 | -
 |  |  | 27 | -
 |  |  | 56 | -
 |  |  | 13 | -
 |  |  | 46 | -
 |  |  | 6 | -
 |  |  | 7 | -
 |  |  | 43 | 26.8
 |  |  | 35 | 30.1
 |  |  | 68 | 32.4
 |  |  | 57 | 35.8
 |  |  | 83 | 41.4
 |  |  | 19 | 37.7
 |  |  | 34 | 39.8
 |  |  | 9 | 36.1
Spreadsheet: 858000d1706808414-formula-to-place-worksheet-name-in-cell-on-another-worksheet-sample-sheet
Sheet: Sup 5

 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 |  |  |  | Team Score
 |  |  |  | Updated 12/27/23
Spreadsheet: daren_farmer__5910__leak
Sheet: VOLUME

The following volumes were caluclated using the Enron Gas Loss Program Version 1.10 - June 21,1998 program.
The area was caluclated from the physical Mic readings taken from each hole at the leak sight.
The pressure used to calculate these volumes was taken form meter # 986501-10, which is the closest meter to the leak sight.
 | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00
DAY | MCF | DTH | MCF | DTH | MCF | DTH | MCF | DTH
1 | 3504.5 |  | 3383.7 |  | 3390 |  | 3169.3
2 | 3653.6 |  | 3126.3 |  | 3072.5 |  | 3212.4
3 | 3605.2 |  | 3363.1 |  | 3298.5 |  | 3142.4
4 | 3773.8 |  | 3153.2 |  | 3535.2 |  | 3282.3
5 | 3363.1 |  | 3147.8 |  | 3556.8 |  | 3346.9
6 | 3352.3 |  | 3551.4 |  | 3411.5 |  | 3427.6
7 | 3180.1 |  | 3605.2 |  | 3470.7 |  | 3309.2
8 | 3400.7 |  | 3282.3 |  | 3535.2 |  | 3309.2
9 | 3626.7 |  | 3524.5 |  | 3599.8 |  | 3459.9
10 | 3438.4 |  | 3599.8 |  | 3546 |  | 3336.1
11 | 3250.1 |  | 3454.5 |  | 3589 |  | 2997.2
12 | 3029.4 |  | 3492.2 |  | 3433 |  | 3314.6
13 | 3034.8 |  | 3589 |  | 3395.3 |  | 3357.7
14 | 3137.1 |  | 3578.3 |  | 3346.9 |  | 3449.1
15 | 3503 |  | 3406.1 |  | 3390 |  | 3535.2
16 | 3551.4 |  | 3406.1 |  | 3443.8 |  | 3513.7
17 | 3524.5 |  | 3406.1 |  | 3433 |  | 3034.8
18 | 3233.9 |  | 3233.9 |  | 3379.2 |  | 3067.1
19 | 3260.8 |  | 3056.3 |  | 3314.6 |  | 3067.1
20 | 3190.9 |  | 3201.6 |  | 3443.8 |  | 3540.6
21 | 3018.7 |  | 3131.7 |  | 3476.1 |  | 3519.1
22 | 3223.1 |  | 3137.1 |  | 3519.1 |  | 3373.8
23 | 3282.3 |  | 3481.4 |  | 3363.1 |  | 3110.2
24 | 3180.1 |  | 3653.6 |  | 3352.3 |  | 3099.4
25 | 3104.8 |  | 3260.8 |  | 3244.7 |  | 3169.3
26 | 3120.9 |  | 3137.1 |  | 3422.2 |  | 3083.2
27 | 3250.1 |  | 3378.2 |  | 3510 |  | 3131.7
28 | 3185.5 |  | 3293.1 |  | 3400.7 |  | 3400.7
29 | 3228.5 |  | 3185.5 |  | 3422.2 |  | 3454.5
30 | 3454.5 |  |  |  | 3427.6
31 | 3395.3 |  |  |  | 3293.1
TOTALS
We do not have the charts for meter # 986501 for May to calculate May's gas loss, however the estimated gas loss for the previous four months
is 409,333 DTH.  It is safe to say the leak started back in '99 due to the UAF we were experiencing on system 550.  Since June 99 we were
losing 100,000 DTH  to 150,000 DTH each month.  A physical measurement audit has been underway looking for possible problems on system 550
and thus far has not turned up any errors due to measurement.
Spreadsheet: 748109d1631891686-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: NEEDED INFO

Invoice Number | [NAME] | Item Number | Invoice Date | Total Qty | Unit Price | Extended Price
78080 | [NAME] | UR52005 | 2021-09-10 00:00:00 | 2 | 630
78089 | P413752 | UR52006 | 2021-09-13 00:00:00 | 2 | 630
78088 | PN32324 | 300763 | 2021-09-10 00:00:00 | 1 | 395
78070 | PN30128 | 260086 | 2021-09-09 00:00:00 | 8 | 64
78071 | PN30784 | 451729 | 2021-09-09 00:00:00 | 1 | 303
78072 | PN31022 | 451729 | 2021-09-09 00:00:00 | 1 | 303
78056 | PN31698 | 450858 | 2021-09-03 00:00:00 | 1 | 82
78057 | PN31699 | Delivery Charges | 2021-09-03 00:00:00 | 1 | 22.5
Spreadsheet: 700025d1602906951-help-with-combining-the-if-iserror-find-functions-together-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | abc student
 |  |  |  |  |  |  |  |  |  | xyz student
 |  |  |  |  |  |  |  |  |  | professor
 |  |  |  |  |  |  |  |  |  | worker
 |  |  |  |  |  |  |  |  |  | fresh student
 |  |  |  |  |  |  |  |  |  | Student A
 |  |  |  |  |  |  |  |  | Count
 |  |  |  |  |  |  |  |  |  |  | Help with combining the IF/ISERROR/FIND functions together.
 |  |  |  |  |  |  |  |  |  |  | Hello,
 |  |  |  |  |  |  |  |  |  |  | I need to combine the Excel IF and ISERROR functions with the Excel FIND function to place a 1 in the blank column if the string “student” is found,
 |  |  |  |  |  |  |  |  |  |  | or 0 if it is not.
 |  |  |  |  |  |  |  |  |  |  | I am referencing k2.
 |  |  |  |  |  |  |  |  |  |  | I tried:
 |  |  |  |  |  |  |  |  |  |  | =IF("student",1,0)FIND("student",K2,1)
 |  |  |  |  |  |  |  |  |  |  | I am not sure where to insert the ISERROR function. I want to determine how many students are in column k. The list is long with entries like "freshman student," "elementary student", teacher, professor, etc. I want to extract only "student," and place 1 if true, or 0 if false in the next column, L, so I can determine the percentage of students there are in the list using the SUM and COUNT functions.
 |  |  |  |  |  |  |  |  |  |  | I hope this makes sense.
Spreadsheet: darrell_schoolcraft__7782__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 10th = 65,000
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 152 | 154 | 150 |  | 6.5
he 7 | 08:00:00 |  | 152 | 154 | 150 |  | 6.5
he8 | 09:00:00 |  | 152 | 154 | 150 |  | 6.5
he9 | 10:00:00 |  | 152 | 154 | 150 |  | 6.5
he10 | 11:00:00 |  | 152 | 154 | 150 |  | 6.5
he11 | 12:00:00 |  | 152 | 154 | 150 |  | 6.5
he12 | 13:00:00 |  | 152 | 154 | 150 |  | 6.5
[NAME] | 14:00:00 |  | 152 | 154 | 150 |  | 6.5
he14 | 15:00:00 |  | 152 | 154 | 150 |  | 6.5
he15 | 16:00:00 |  | 152 | 154 | 150 |  | 6.5
he16 | 17:00:00 |  | 152 | 154 | 150 |  | 6.5
he17 | 18:00:00 |  | 152 | 154 | 150 |  | 6.5
he18 | 19:00:00 |  | 152 | 154 | 150 |  | 6.5
he19 | 20:00:00 |  | 152 | 154 | 150 |  | 6.5
he20 | 21:00:00 |  | 152 | 154 | 150 |  | 6.5
he21 | 22:00:00 |  | 152 | 154 | 150 |  | 6.5
he21 | 23:00:00 |  | 152 | 154 | 150 |  | 6.5
he22 | 00:00:00 |  | 152 | 154 | 150 |  | 6.5
he23 | 01:00:00 |  | 152 | 154 | 150 |  | 6.5
he24 | 02:00:00 |  | 152 | 154 | 150 |  | 6.5
he1 | 03:00:00 |  | 152 | 154 | 150 |  | 6.5
he2 | 04:00:00 |  | 152 | 154 | 150 |  | 6.5
he3 | 05:00:00 |  | 152 | 154 | 150 |  | 6.5
he4 | 06:00:00 |  | 152 | 154 | 150 |  | 6.5
[NAME] | 07:00:00 |  | 152 | 154 | 150 |  | 6.5
Spreadsheet: 51e6ae0d-741d-419d-936e-1c7421c1d059
Sheet: Ark1

[NAME] | Grand Prix | Gull | Shortlist
TRY/APT | 1 | 6 | 6
[NAME] | 1 | 2 | 3
[NAME] |  | 2 | 2
Berghs School of Communication |  | 1 | 3
McCann/Mediafront/SDG |  | 1 | 2
WTW |  | 1 | 2
[NAME] |  | 1 | 2
iProspect |  | 1 | 2
Unfold |  | 1 | 2
F&B Factory |  | 1 | 2
Giant Leap Technologies |  | 1 | 1
SMFB |  | 1 | 1
Metronet |  | 1 | 1
[NAME] |  | 1 | 1
Plan 8 |  | 1 | 1
Rebenga |  | 1 | 1
Mediafront |  |  | 4
Laboremus |  |  | 3
Keyteq |  |  | 2
[NAME] |  |  | 2
Seefood TV |  |  | 2
B-Reel |  |  | 2
IXD |  |  | 1
Epinova |  |  | 1
Anti |  |  | 1
Increo Interactive Creations |  |  | 1
Mobiento |  |  | 1
Intelecom |  |  | 1
Apphuset |  |  | 1
Modulez |  |  | 1
[NAME] |  |  | 1
Fotograf Isidor |  |  | 1
Molamil |  |  | 1
Gobsmack |  |  | 1
Tilnærmet Lik |  |  | 1
[NAME] fortalt |  |  | 1
Paradox [NAME] |  |  | 1
Westerdals School of Communication |  |  | 1
[NAME] |  |  | 1
Saatchi & Saatchi |  |  | 1
Filmfaktisk |  |  | 1
Klinger |  |  | 1
Spreadsheet: 683597d1592842137-trying-to-apply-multiple-formula-to-a-cell-works-great-but-how-on-earth-do-i-fill-down-reverse-engineering-logic
Sheet: Sheet2

 | [NAME] |  | Category
 | [PHONE]
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Line checks to see if there are 2 numbers next to each other the same, so therefore checking for a double or more
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting up in sequence but ignoring the first 4 digits to avoid "0845"
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting down in sequence but ignoring the first 4 digits to avoid "0845"
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting up in 2's
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks for counting down in 2's
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checking for alternate zero's ie 101010 or 707070
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (N15) Checks for alternate match at the end of the number, ie 5050 or 1010 or 8585, The 5's, the 1's and the 8's all match in these examples (O15) does the same but for the next number along, ie 0,0 and 5
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (M16 totals S13,14 and 15), as its lookingfor a 3, its therefore looking for 3 doubles)                                                                                                        (N16 is looking for patterns like 2010,3020,9080 etc, where the 3rd number is 1 more than the 1st numbers)                                                     (O16 is doing the same other than for the next set of digits, ie 0102, 0809,0506, so the 1+1 is 2, the 8+1=8, the 5+1 is 6.
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N17 and O17 are looking for the same logic other than instead of +1, its -1, so 1020,2030,8090 for N and 0201,0908,0605 for O
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 | [PHONE]
 | [PHONE]
 | [PHONE]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This col seems to be searching for doubles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If R18 is less than 10 Standard
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-13 Bronze
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14-15 Silver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-20 Gold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 and over Platinum
Spreadsheet: 797464d1663908221-identify-a-text-based-on-number-bigger-than-zero-identify-a-text-based-on-number-bigger-than-0
Sheet: 21 09 2022 Sampling bulanan Rin

Unit | ECO 2 AD | ECO 3 AD | ECO 5 AD | ECO 7 AD | MICRO 100 | THIS IS TE FORMULA I USED TO IDENTIFY | THIS IS THE EXACT POINT I WANT
GA01 | 0 | 12030 | 0 | 0 | 0 | ECO 3 AD, , | ECO 3 AD
GA02 | 373.3 | 11743.6 | 57672.9 | 104993.9 | 0 | ECO 2 AD, ECO 3 AD, ECO 5 AD, ECO 7 AD, | ECO 2 AD, ECO 3 AD, ECO 5 AD, ECO 7 AD
GA03 | 0 | 17010 | 58620 | 101580 | 0 | ECO 3 AD, ECO 5 AD, ECO 7 AD, | ECO 3 AD, ECO 5 AD, ECO 7 AD
GA04 | 0 | 15932.5 | 43108.7 | 96283.8 | 454.5 | ECO 3 AD, ECO 5 AD, ECO 7 AD, MICRO 100 | ECO 3 AD, ECO 5 AD, ECO 7 AD, MICRO 100
GA05 | 0 | 15270 | 57540 | 106440 | 0 | ECO 3 AD, ECO 5 AD, ECO 7 AD, | ECO 3 AD, ECO 5 AD, ECO 7 AD
GA06 | 0 | 19910 | 7920 | 0 | 0 | ECO 3 AD, ECO 5 AD, , | ECO 3 AD, ECO 5 AD
GA07 | 363 | 19053.2 | 50850.6 | 101782.8 | 0 | ECO 2 AD, ECO 3 AD, ECO 5 AD, ECO 7 AD, | ECO 2 AD, ECO 3 AD, ECO 5 AD, ECO 7 AD
GA08 | 0 | 20220 | 55440 | 89820 | 0 | ECO 3 AD, ECO 5 AD, ECO 7 AD, | ECO 3 AD, ECO 5 AD, ECO 7 AD,
 |  |  |  |  |  | STILL GOT THE "," MARK IF THE NUMBER WAS ZERO | THE TEXT SHOULD'NT HAVE "," IF THE NUMBER WAS ZERO
Spreadsheet: 715970d1611939092-index-match-and-sumifs-sample-data-1-
Sheet: Analysis

Deck
Officer
 | Department A | Department B
Salary
Leave
Expenses
Deck
Rating
 | Department A | Department B
Salary
Leave
Expenses
Engine
Officer
 | Department A | Department B
Salary
Leave
Expenses
Engine
Rating
 | Department A | Department B
Salary
Leave
Expenses
Spreadsheet: 120788d1315514640-help-auto-filing-missing-address-in-file-test
Sheet: Sheet2

Account | Address | City | State | ZIP
23234 | 456 Oak Drive Lovely |  | Alabama | 35214
23234 | 456 Oak Drive Lovely |  | Alabama | 35214
23234 | 456 Oak Drive Lovely |  | Alabama | 35214
12345 | 123 Main Street | Hohum | Alabama | 35242
12345 | 123 Main Street | Hohum | Alabama | 35242
Spreadsheet: 415945e6-707b-46f7-8d04-75a5807102af
Sheet: Sheet1

U.S DIRECT LOANS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
UCL Cost of Attendance Calculator 2012/13 - Graduates
Please complete Section A: 1-5
SECTION A: Please complete 1 - 4
 | Costs |  | Total
 | 1. Maintenance
 | Maintenance for 12 months* |  | 14670 |  | *Maximum £14,670 inc rent on/off campus
 | Course Materials* |  | 830 |  | *Maximum £830
 | Flights* |  | 1500 |  | *Maximum £1,500
 | 2. Tuition Fees
 | Tuition Fees |  | 15000 |  | *see tuiton fee rates http://www.ucl.ac.uk/current-students/money
 | Additional Bench Fees |  | 0
 | (if applicable)
 | 3 Exceptional Extras (if any)
 | Supplement for SLADE/BARTLETT |  | 0 |  | *Please give details on a separate sheet. Essential costs are not intended to be an extension of general living costs for which the minimum and maximum levels are outlined in Section 1 - an amount  between these parameters is adequate for food, accommodation, books, clothes, laundry, entertainment etc. We will only certify extra costs for items such as a computer, dependent care or compulsory field work expenses.  You must list exact details for such costs.
 | Other essential costs* |  | 0
 | 3. Additional Funding (e.g. Scholarship)
 | Effective Financial Aid |  | 0 |  | Please list any scholarships, grants or other sources of funding for 2012/13 in USD
 | CoA GBP |  | 32000
Estimate exchange rate 2012/13* |  |  | 1.6
CoA USD |  |  | 51200
 | 4. Expected Family Contribution (EFC)
 |  | [NAME] from SAR* | 0 |  | *Expected Family Contribution: please see page 1 of Student Aid Report (SAR)
Educational 'Need' |  |  | 51200
 | CoA - (EFC + Additional Funding)
SECTION B: Estimate Loan Entitlement for Graduate Students
 | Subsidized Direct |  |  |  | 51200
 | Unsubsidized Direct |  | 20500 |  | 51200
 | Direct Total |  | 20500
 | Direct Plus or Private |  | 30700
 |  | TOTAL | 51200
IMPORTANT:  Please note that a Direct Loan must be disbursed in three termly instalments, and cannot be disbursed in one lump sum. Please note this is an estimate of your CoA and that UCL can not certify any student loan application until you have completed a MPN for each loan, completed entrance counselling and submitted a Direct Loan  UCL Cover Sheet to the UCL Student Funding Office.
Spreadsheet: 212434d1360135097-collecting-and-grouping-of-data-into-columns-solution
Sheet: Sheet2

 |  | A |  |  |  |  |  |  |  |  | B
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  |  |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
10am | a | b | c | d | e |  |  |  | a
11am | e | a | b | c | d |  |  |  | b
12pm | d | e | a | b | c |  |  |  | c
1pm | c | d | e | a | b |  |  |  | d
2pm | b | c | d | e | a |  |  |  | e
Spreadsheet: 688585d1595859727-how-to-rank-filtered-cells-w-o-duplicates-w-o-breaking-sequence-sample
Sheet: Sample

 | Data source |  |  |  |  | Actual formula |  |  |  |  | Expected result (if we deselect e.g.: 8005606 & 8022660)
 | MATERIAL # | MISSING STOCK (QTY) | DESIGNATION | PROGRESS |  | RANK | MATERIAL # | DESIGNATION | PROGRESS |  | RANK | MATERIAL # | DESIGNATION | PROGRESS
 | 8001947 | 2258 | A50T14 | 0.45 |  |  |  |  |  |  | 1 | 8010244
 | 8005604 | 0 | A100T11 | 0 |  |  |  |  |  |  | 2 | 8104601
 | 8005606 | 490 | A50T12 | 0.09 |  |  |  |  |  |  | 3 | 8001947
 | 8007802 | 3311 | A50T11 | 0.45 |  |  |  |  |  |  | 4 | 8007802
 | 8010244 | 640 | A50T14 | 0.1
 | 8013080 | 0 | A50T11 | 0
 | 8022660 | 999 | A50T12 | 0.1
 | 8104601 | 1376 | A50T14 | 0.3025210084033613