tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43773d1242386570-cell-formatting-research
Sheet: surplus,deficit

 | Requirement |  | Jan | Feb | Mar | Apr | May | June | July | August | September
 |  | X | 9 | 8 | 5 | 2 | 6 | 5 | 36 | 0 | 0
 |  | Y | 4 | 6 | 17 | 1 | 5 | 4 | 30 | 0 | 0
 |  | Z | 3 | 10 | 7 | 5 | 3 | 7 | 37 | 0 | 0
 | Availability |  | Jan | Feb | Mar | Apr | May | June | July | August | September
 |  | X | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4
 |  | Y | 5 | 7 | 5 | 5 | 5 | 6 | 6 | 6 | 6
 |  | Z | 5 | 5 | 5 | 5 | 5 | 3 | 3 | 3 | 3
 | Surplus/Deficit |  | Jan | Feb | Mar | Apr | May | June | July | August | September
 |  | X | -4 | -3 | 0 | 3 | -1 | -1 | -32 | 4 | 4
 |  | Y | 1 | 1 | -12 | 4 | 0 | 2 | -24 | 6 | 6
 |  | Z | 2 | -5 | -2 | 0 | 2 | -4 | -34 | 3 | 3
Spreadsheet: 806235d1669185241-sumif-if-multiple-criteria-including-dates-is-met-not-working-outco-copy
Sheet: BEAUDESERT

Site |  |  |  | Start Date | COR | Broker | Plc Comments | [NAME] | Forecast | OutcoType | F / P / NP | Due Date | Amount | Date Submitted | Date Taken
BEAUDESERT |  |  |  | 2022-08-04 00:00:00 | Yes | No | Yes | Yes | No | 4 | NP | 2022-09-01 00:00:00 | 400
BEAUDESERT |  |  |  | 23/08/2022 | Yes |  | Yes | Yes | Yes | 4 | PART | 2022-09-20 00:00:00 | 240
BEAUDESERT |  |  |  | 30/08/2022 | Yes | Yes | No | Yes | No | 4 | NP | 2022-09-27 00:00:00 | 1000
BEAUDESERT |  |  |  | 2022-03-09 00:00:00 |  |  |  |  | No | 4 | NP | 2022-10-01 00:00:00 | 500
BEAUDESERT |  |  |  | 2022-08-05 00:00:00 | Yes | No | Yes | Yes | No | 12 | NP | 2022-10-02 00:00:00 | 400
BEAUDESERT |  |  |  | 21/09/2022 | Yes | No | Yes | Yes | Yes | 4 | PART | 2022-10-19 00:00:00 | 250 | 2022-11-23 00:00:00 | 2022-11-23 00:00:00
BEAUDESERT |  |  |  | 24/09/2022 | Yes | Yes | Yes | Yes | Yes | 4 | FULL | 2022-10-22 00:00:00 | 1000 | 2022-11-10 00:00:00 | 2022-11-15 00:00:00
BEAUDESERT |  |  |  | 28/09/2022 | No |  |  |  | Yes | 4 | FULL | 2022-10-26 00:00:00 | 1000 | 2022-11-15 00:00:00
BEAUDESERT |  |  |  | 28/09/2022 | Yes | No | Yes | Yes | Yes | 4 | FULL | 2022-10-26 00:00:00 | 500 | 2022-11-11 00:00:00 | 2022-11-11 00:00:00
BEAUDESERT |  |  |  | 2022-10-04 00:00:00 | Yes | No | Yes | Yes | Yes | 4 | FULL | 2022-11-01 00:00:00 | 1000 | 2022-11-03 00:00:00 | 2022-11-03 00:00:00
BEAUDESERT |  |  |  | 2022-12-08 00:00:00 |  |  |  |  | No | 12 | NP | 2022-11-04 00:00:00 | 3000
BEAUDESERT |  |  |  | 2022-09-10 00:00:00 | Yes | No | Yes | Yes | Yes | 4 | FULL | 2022-11-05 00:00:00 | 1000 | 2022-11-08 00:00:00 | 2022-11-08 00:00:00
BEAUDESERT |  |  |  | 13/09/2022 |  |  |  |  | No | 4 | NP | 2022-11-10 00:00:00 | 1000
BEAUDESERT |  |  |  | 30/08/2022 | Yes | Yes | Yes | Yes | Yes | 12 | FULL | 2022-11-22 00:00:00 | 1000
BEAUDESERT |  |  |  | 2022-12-10 00:00:00 | No | No | No |  | At Risk | 4 | NP | 2022-11-23 00:00:00 | 500
BEAUDESERT |  |  |  | 26/10/2022 | No | No | Yes | Yes | At Risk | 4 | NP | 2022-11-23 00:00:00 | 1000
BEAUDESERT |  |  |  | 2022-10-18 00:00:00 | Yes | No | Yes | Yes | Yes | 4 | FULL | 2022-11-29 00:00:00 | 1000
BEAUDESERT |  |  |  | 21/09/2022 | Yes | No | Yes | Yes | Yes | 12 | PART | 2022-12-14 00:00:00 | 500
BEAUDESERT |  |  |  | 16/11/2022 |  |  |  |  |  | 4 |  | 2022-12-14 00:00:00 | 1000
BEAUDESERT |  |  |  | 19/11/2022 |  |  |  |  |  | 4 |  | 2022-12-17 00:00:00 | 500
BEAUDESERT |  |  |  | 24/09/2022 | Yes | Yes | Yes | Yes | Yes | 12 | FULL | 2022-12-17 00:00:00 | 3000
BEAUDESERT |  |  |  | 28/09/2022 | Yes | No | Yes | Yes | Yes | 12 | PART | 2022-12-21 00:00:00 | 500
BEAUDESERT |  |  |  | 2022-10-04 00:00:00 | Yes | No | Yes | Yes | Yes | 12 | FULL | 2022-12-27 00:00:00 | 3000
BEAUDESERT |  |  |  | 2022-09-10 00:00:00 | Yes | No | Yes | Yes | At Risk | 12 | FULL | 2022-12-31 00:00:00 | 1000
Spreadsheet: 847474d1698391462-value-error-on-using-sort-filter-test
Sheet: Result

 | Depo-1 | APPLE INC | 197.35
 | Depo-2 | World Bank | 898
 | Depo-3 | [NAME] | 959.62
 | Depo-4 | Lustiana | 61977.08
 | Depo-5 | WOE | 452
 | Depo-5.1 | Dish | 6536
 | Depo-5.2 | [NAME] | 1245
 | Depo-6 | Custo Rica | 81196
 | Depo-7 | THE WOLD IS GONE | 1547428.48
Spreadsheet: 42460d1241024250-look-up-multiple-columns-return-multiple-values-testing
Sheet: Sheet1

9 | A | B | C |  | A | B | C
8 | D | J | O |  |  |  |  |  | 6 | 9
7 | B | G | U |  |  |  |  |  |  | 7
6 | C | H | Q |  |  |  |  |  |  | 6
5 | B | B | D |  |  |  |  |  |  | 5
4 | G | H | M |  |  |  |  |  |  | 3
3 | F | C | Y |  |  |  |  |  |  | 2
2 | E | B | A
Spreadsheet: 683717d1592912374-return-a-value-on-a-row-which-satisfies-a-condition-formulas
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6
Length ↓ / Diameter  → | 6 | 8 | 10 | 12 | 14 | 16
1000 | 10.02508738556673 | 5.871946100528567 | 4.211400677229841 | 2.000161962262141 | 1.505408209951998 | 1.130909303086452
900 | 12.32517790907409 | 7.25711649563905 | 5.209029234375978 | 2.473744106904616 | 1.856309216401486 | 1.397118535814626
600 | 13.37062102473855 | 7.892480471858927 | 5.648932609285289 | 2.668301492861927 | 2.011203399076348 | 1.513550458204409
400 | 14.23243567856045 | 8.41495158093445 | 2.7 | 2.862726066394936 | 2.145896223213431 | 1.616868531930135
250 | 15.09951449305406 | 8.956271788678006 | 6.410528271330596 | 3.060181355303883 | 2.301334100512764 | 1.741071017558297
175 | 20.06070309247687 | 11.94606793966054 | 8.521902870698204 | 4.070365298968864 | 3.045246130909925 | 2.302917635255948
150 | 20.11695228602526 | 11.99302378818789 | 8.559402333063796 | 4.098057209638839 | 3.071083081056553 | 2.326917291169926
Enter Length | 175
No. of holes
Diameter
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: NGPL

 | 52862 |  | 6828 |  | 6838
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 38753 | 38839 |  | -1752 | 27848 | 23815
2 | 40637 | 40684 |  |  | 27871 | 25215
3 | 40652 | 40676 |  |  | 28102 | 25164
4 | 40650 | 40684 |  |  | 27824 | 25215 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 37651 | 37644 |  |  | 24510 | 24952
6 | 37652 | 37684 |  |  | 26762 | 25198 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 37653 | 37684 |  |  | 26569 | 25217
8 | 39631 | 39684 |  |  | 21066 | 25215 |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 45455 | 45458 |  |  | 24054 | 23449 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 45361 | 45458 |  |  | 23079 | 23449 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 45428 | 45458 |  |  | 27403 | 19517 |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 | 45768 | 37497 |  |  | 14699 | 23449 |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13 | 33659 | 33643 |  |  | 29075 | 28943
14 | 33891 | 33684 |  |  | 28918 | 28943 |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15 | 33682 | 33684 | -3456 | -10000 | 28439 | 28452
16 | 33687 | 33684 |  | -4795 | 28439 | 28452 |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17 | 33681 | 33684 |  | -5000 | 28436 | 28452
18 | 33667 | 33684 |  | -4813 | 28416 | 28452
19 | 33680 | 33684 |  | -5000 | 28419 | 28452
20 | 50293 | 50450 |  | -5000 | 28415 | 28452
21 | 52677 | 52684 | -284 |  | 28432 | 28452
22 | 48733 | 48684 | -66783 | -78600 | 28393 | 28452
23 | 45700 | 45653 | -35089 | -43800 | 28192 | 28452
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2002-01-31 00:00:00
2002-02-23 00:00:00
CBS Dollars
 |  |  |  |  | 338741
Spreadsheet: 83521d1283476545-copying-data-from-one-sheet-to-another-2010itemizedsample
Sheet: Expense report

 | Type Entity Name in yellow portion |  | Sample report
 | Year: | 2010 | Month: | 4
 | Sample report  Expense Report
 | April-2010
 | Date |  | Item |  | Amount
 | 2010-04-01 00:00:00
 | 2010-04-02 00:00:00 |  | cut grass |  | 90
 | 2010-04-03 00:00:00
 | 2010-04-04 00:00:00
 | 2010-04-05 00:00:00 |  | Vacuum bags |  | 11.84
 | 2010-04-06 00:00:00
 | 2010-04-07 00:00:00
 | 2010-04-08 00:00:00
 | 2010-04-09 00:00:00
 | 2010-04-10 00:00:00
 | 2010-04-11 00:00:00
 | 2010-04-12 00:00:00
 | 2010-04-13 00:00:00 |  | Cleaning supplies |  | 11.18
 | 2010-04-14 00:00:00 |  | Lowes Home Center, board for table top |  | 13.18
 | 2010-04-15 00:00:00 |  | So. States – mulch |  | 12.9
 | 2010-04-16 00:00:00 |  | cut grass |  | 125
 | 2010-04-17 00:00:00
 | 2010-04-18 00:00:00
 | 2010-04-19 00:00:00
 | 2010-04-20 00:00:00
 | 2010-04-21 00:00:00
 | 2010-04-22 00:00:00 |  | Plant hooks, [NAME] |  | 13.14
 | 2010-04-23 00:00:00
 | 2010-04-24 00:00:00
 | 2010-04-25 00:00:00
 | 2010-04-26 00:00:00
 | 2010-04-27 00:00:00
 | 2010-04-28 00:00:00
 | 2010-04-29 00:00:00 |  | cut grass |  | 90
 | 2010-04-30 00:00:00
 | 2010-05-01 00:00:00
 |  | TOTAL: |  |  | 367.24
Spreadsheet: 786680d1657365260-payslip-presentation-with-itemized-results-excelforum-payslip
Sheet: Joseph

PAYSLIP ADVICE
Employer Name |  | Pay Month | [NAME] | Tax Period | Employer's  Address
Employee Number |  | Employee Surname | First Names | Job Title | Pay date
 |  | [NAME] | [NAME] | Producer
Graded Tax Number |  | Identity number | Date of birth | Age | Mobile Number
2160 01-003874332 |  | [PHONE] |  |  | 76353617
Pay Rate |  | Start Tax Period | End Tax Period | No. of [NAME] | Sex
 |  |  |  |  | Male
Description | Unit Price | Quantity | Value | Deductions | Value
LINE 64 FROM SOURCE DATA UNDER JOSEPH COLUMN |  | 0 | 0 | PAYE | 0
LINE 40 FROM SOURCE DATA UNDER JOSEPH COLUMN |  | 0 | 0 | Graded Tax | 0
 |  | 0 | 0 | ENPF | 0
 |  | 0 | 0
Total Earnings |  |  |  | Total Deductions
 |  |  |  | Net Pay
Spreadsheet: 55743d1255949180-multiple-interrogation-of-data-corres_test
Sheet: FINANCE

FINANCE
COUNTRY | BOOKING REF | DATE OF DEPARTURE | Value of Holiday
Andorra | 123456 | 2009-12-01 00:00:00 | 200
Andorra | 654321 | 2009-12-13 00:00:00 | 1000
Canada | 987654 | 2010-01-01 00:00:00 | 2000
Italy | 345634 | 2010-01-03 00:00:00 | 100
USA | 123987 | 2010-01-23 00:00:00 | 2000
USA | 345234 | 2010-01-31 00:00:00 | 3000
USA | 987234 | 2010-01-13 00:00:00 | 100
Canada | 987987 | 2009-12-01 00:00:00 | 1000
Austria | 123567 | 2009-12-13 00:00:00 | 1000
Austria | 983456 | 2009-12-13 00:00:00 | 1000
Switzerland | 567987 | 2009-12-25 00:00:00 | 20000
Austria | 234876 | 2009-12-25 00:00:00 | 1200
Andorra | 234123 | 2010-01-01 00:00:00 | 1000
Spreadsheet: 139196d1328123141-complicated-countif-function-book2
Sheet: Sheet1

Date | Text
2012-12-01 00:00:00 | A
2012-10-26 15:13:16 | B
2012-08-26 11:28:54 | B
2012-06-24 02:50:55 | C
2012-03-22 12:32:12 | D
2012-03-22 11:45:34 | C
2012-01-17 22:12:50 | B
2012-01-17 14:10:53 | C
 | 2012
 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
A
B
C
D
Spreadsheet: 869367d1715938463-sumproduct-pricing-table-threshold-calculation-issue-threshold_test-jt
Sheet: Bag price Luggage Logistics

From | 1 | per 1000 units |  | Threshold | diff
1 | 83000 | 26.58 |  |  |  |  |  | 83000
 | 166000 | 20.63 |  |  |  |  |  | 83000
 | 250000 | 16.83
 | 500000 | 12.15
 | 1000000 | 8.4
 | 2000000 | 5.16 |  |  |  |  | Total |  |  |  | wrong SUM!
 | 999999999 | 3.8
Input units |  | 200000
Output price | my formula |  | "=SUMPRODUCT(--(C11>$E$2:$E$8),(C11-($E$2:$E$8)), $[NAME] |  |  |  |  |  |  |  |  |  |  | Correct
 | BrianSheen formula |  | "=SUM(SUMPRODUCT(($C$11>=$B$2:$B$8)*C2:C8*(B2:B8-B1:B7)),SUMPRODUCT(($C$11>=B1:B7)*($C$11<B2:B8)*($C$11-(B1:B7))*C2:C8))/1000 |  |  |  |  |  |  |  |  |  |  | Wrong
Whatif units | manual output | BrianSheen formula output
100000 | 2556.82342 | 2556.82342 | ok !
200000 | 3918.43 | 4490.62342 | nok ! | Wrong!
300000
600000
900000
1100000
Spreadsheet: 709483d1608325221-help-me-to-use-another-cell-value-as-the-range-value-of-correl-or-similar-function-book2-excelforum
Sheet: Sheet2

2 | 200
2.5 | 245
2.8 | 146
3.5 | 185
3.8 | 158
4.3 | 131
4.76 | 104
5.22 | 77
5.68 | 50
6.14 | 366
6.6 | 290
7.06 | 80
7.52 | 50
7.98 | 165
7.6 | 125
7.2 | 85
6.8 | 45 |  | 16
6.4 | 5 |  | 15
6 | 25 |  | 8
5.6 | 166 |  | 4
5.2 | 185 |  | 5
Spreadsheet: 672110d1586748512-sumproduct-for-tiered-pricing-structure-sumproduct-for-tiered-pricing-structure-tim
Sheet: Sheet1

600000 | (amount)
 |  |  |  | Full category payments:
Up to | pricing: |  |  | Additional partial category payment:
0 | 0 |  |  | total:
300000 | 0.003
500000 | 0.002
1000000 | 0.001 |  | combined formula: =SUM(SUMPRODUCT(($B$9>=$B$14:$B$18)*C14:C18*(B14:B18-B13:B17)),SUMPRODUCT(($B$9>=B13:B17)*($B$9<B14:B18)*($B$9-(B13:B17))*C14:C18))
1250000 | 0.0005
1250001 | 0
Spreadsheet: 768488d1644998891-running-values-based-on-criteria-errors-in-a-table-learnexcel2
Sheet: Daily

Date | Details | Category | Paids | Sub Details | Income | Expenses | Balance
2022-01-01 00:00:00 | Brought Forward | Opening | Cash |  | 323.5
2022-01-01 00:00:00 | Brought Forward | Opening | ENBD |  | 669.3
2022-01-01 00:00:00 | Brought Forward | Opening | Pay IT |  | 1000
2022-01-01 00:00:00 | Brought Forward | Opening | NoL |  | 113
2022-01-01 00:00:00 | Brought Forward | Opening | SIB |  | 795.55
2022-01-06 00:00:00 | December | Salary | ENBD |  | 1000
2022-01-09 00:00:00 | Dinner | Food | Cash |  |  | 10
2022-01-09 00:00:00 | Water | Beverages | Cash |  |  | 2
2022-01-09 00:00:00 | Breakfast | Food | Cash |  |  | 4.5
2022-01-09 00:00:00 | RTA | Transport | NoL |  |  | 7.5
2022-01-09 00:00:00 | Transport | Transport | Cash | Car lift January |  | 250
2022-01-09 00:00:00 | Dinner | Food | Cash |  |  | 7
2022-01-10 00:00:00 | Office | OfficeRent | Cash | Rent | 500
2022-01-10 00:00:00 | Office | LoanReturn | Cash | Amazon | 969
2022-01-10 00:00:00 | Lunch | Food | ENBD | Office Lunch |  | 18.75
2022-01-10 00:00:00 | Dinner | Food | Cash |  |  | 17
2022-01-11 00:00:00 | Rent | Room | Cash | January Rent |  | 700
2022-01-11 00:00:00 | Dinner | Food | Cash |  |  | 10
2022-01-12 00:00:00 | Dinner | Food | Cash |  |  | 20
2022-01-12 00:00:00 | Bilal | OutLoan | Cash |  |  | 800
2022-01-13 00:00:00 | Breakfast | Food | Cash |  |  | 7
2022-01-13 00:00:00 | Dinner | Food | Cash |  |  | 10
2022-01-14 00:00:00 | Breakfast | Food | Cash |  |  | 5
2022-01-14 00:00:00 | Lunch | Food | Cash |  |  | 13
2022-01-14 00:00:00 | Dinner | Food | Cash |  |  | 5
2022-01-15 00:00:00 | Breakfast | Food | Cash |  |  | 4
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -3406 |  |  | -25
2 | -1974 |  |  | -25
3 | -1939 | -1900 |  | -25
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102856.14
2001-12-03 00:00:00
CBS Volume
 |  |  | 43009
Spreadsheet: 723540d1615761932-how-to-calculate-the-change-in-rank-of-lists-of-variables-rank-change-problem
Sheet: Sheet1

Rank on 14/03/2021 | Coin | Rank on 15/03/2021 | Coin | Daily Rank change | Rank on 16/03/2021 | Coin | Daily Rank change
1 | Bitcoin BTC | 1 | Bitcoin BTC | 0 | 1 | Bitcoin BTC | 0
2 | Ethereum ETH | 2 | Ethereum ETH | 0 | 2 | Ethereum ETH | 0
3 | Binance Coin BNB | 3 | Binance Coin BNB | 0 | 3 | Binance Coin BNB | 0
4 | Tether [NAME] | 4 | Tether [NAME] | 0 | 4 | Tether [NAME] | 0
5 | [NAME] | 5 | Polkadot DOT | 1 | 5 | Polkadot DOT | 0
6 | Polkadot DOT | 6 | [NAME] | -1 | 6 | [NAME] | 0
7 | XRP XRP | 7 | XRP XRP | 0 | 7 | XRP XRP | 0
8 | Uniswap UNI | 8 | Uniswap UNI | 0 | 8 | Litecoin LTC | 1
9 | Litecoin LTC | 9 | Litecoin LTC | 0 | 9 | Uniswap UNI | -1
10 | Chainlink LINK | 10 | Stellar XLM | 3 | 10 | Stellar XLM | 0
11 | [NAME] | 11 | Chainlink LINK | -1 | 11 | Chainlink LINK | 0
12 | USD Coin USDC | 12 | [NAME] | -1 | 12 | [NAME] | 0
13 | Stellar XLM | 13 | USD Coin USDC | -1 | 13 | USD Coin USDC | 0
14 | [NAME] WBTC | 14 | [NAME] WBTC | 0 | 14 | [NAME] WBTC | 0
15 | Dogecoin DOGE | 15 | Terra LUNA | 2 | 15 | Terra LUNA | 0
16 | THETA THETA | 16 | Aave AAVE | 2 | 16 | Aave AAVE | 0
17 | Terra LUNA | 17 | Crypto.com Coin CRO | 2 | 17 | Crypto.com Coin CRO | 0
18 | Aave AAVE | 18 | VeChain VET | 2 | 18 | VeChain VET | 0
19 | Crypto.com Coin CRO | 19 | Dogecoin DOGE | -4 | 19 | Dogecoin DOGE | 0
20 | VeChain VET | 20 | THETA THETA | -4 | 20 | THETA THETA | 0
 |  |  |  |  | Values to be calculated
 | Notes:
 | The aim of this is to see which cryptocurrencies are rising up the ranks
 | I want to be able to paste in a list of the names of cryptocurrencies from a list like coinmarket cap and then assess the change in rank on any particular day
 | Any help would be fantastic… thanks!
Spreadsheet: 120009d1314910464-how-to-remotely-access-an-array-in-an-unopened-excel-spreadsheet-fooddata
Sheet: Sheet1

Type: | Apples | Grapes | Chips | Units
Energy: | 97 | 85 | 127 | Calories
Serving: | 389 | 407 | 125 | [NAME]
Cost: | 0.46 | 0.57 | 0.86 | Dollars
Density: |  |  |  | Cal/g
Eff: |  |  |  | Cal/$
Spreadsheet: 31609d1227553565-dynamic-validation-without-using-named-ranges-validation-help
Sheet: Sheet1

 |  | Their code | Our code |  |  | Unique list of there codes |  | Unique list of our codes that match their codes
 |  | 1234 |  |  |  | 1234 | 1234 | A
 |  |  |  |  |  | 12345 | 1234 | B
 |  |  |  |  |  | 123456 | 1234 | C
 |  |  |  |  |  | 1234567 | 12345 | AB
 |  |  |  |  |  |  | 123456 | ABA
 |  |  |  |  |  |  | 123456 | ABB
 |  |  |  |  |  |  | 123456 | ABC
 |  |  |  |  |  |  | 123456 | ABD
 |  |  |  |  |  |  | 1234567 | ABCA
 |  | I would like a validation list in row "D6" that only shows our codes that pretain to their code.
 |  | for example:
 |  | if they use code 1234 the validation list would only show "A", "B", and "C"
 |  | if they use code 12345 the validation list would only show "AB"
Spreadsheet: 836585d1689508320-roulette-counting-how-many-colored-cells-are-between-123
Sheet: List1

random 0-36
 | 8
Spreadsheet: 215485d1361390157-auto-filling-formulas-across-multiple-sheets-excel-percent-diff-example
Sheet: AFTER

Subsidiary | Distributor | 2012 | % DIFF VS. [NAME] |  | 2011 | % DIFF VS. [NAME] |  | 2010 | % DIFF VS. [NAME] |  | 2009
COMPANY NAME | 1A | 164516 |  |  | 10188 |  |  | 3754 |  |  | 0
COMPANY NAME | 2A | 7072 |  |  | 44134 |  |  | 0 |  |  | 13358
COMPANY NAME | 3A | 37420 |  |  | 21182 |  |  | 48936 |  |  | 94594
COMPANY NAME | 4A | 0 |  |  | 1006 |  |  | 74166 |  |  | 92941
COMPANY NAME | 5A | 12666 |  |  | 0 |  |  | 1083 |  |  | 12477
COMPANY NAME | 6A | 308966 |  |  | 10652 |  |  | 0 |  |  | 0
COMPANY NAME | 7A | 15178 |  |  | 0 |  |  | 34094 |  |  | 25456
COMPANY NAME | 8A | 4132 |  |  | 21144 |  |  | 10936 |  |  | 209652
COMPANY NAME | 9A | 3632 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 10A | 213376 |  |  | 43898 |  |  | 121108 |  |  | 0
COMPANY NAME | 11A | 40370 |  |  | 81366 |  |  | 139506 |  |  | 0
COMPANY NAME | 12A | 133046 |  |  | 0 |  |  | 0 |  |  | 25848
COMPANY NAME | 13A | 14308 |  |  | 0 |  |  | 1700 |  |  | 5458
COMPANY NAME | 14A | 0 |  |  | 0 |  |  | 15764 |  |  | 63154
COMPANY NAME | 15A | 86386 |  |  | 620664 |  |  | 457904 |  |  | 843460
COMPANY NAME | 16A | 375926 |  |  | 319406 |  |  | 72218 |  |  | 0
COMPANY NAME | 17A | 3720 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 18A | 8970 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 19A | 13326 |  |  | 1064 |  |  | 0 |  |  | 0
COMPANY NAME | 20A | 83264 |  |  | 0 |  |  | 236834 |  |  | 138062
COMPANY NAME | 21A | 3332 |  |  | 962 |  |  | 3288 |  |  | 284
COMPANY NAME | 22A | 170446 |  |  | 344586 |  |  | 197296 |  |  | 0
COMPANY NAME | 23A | 19092 |  |  | 0 |  |  | 0 |  |  | 8814
COMPANY NAME | 24A | 9474 |  |  | 2128 |  |  | 0 |  |  | 33302
COMPANY NAME | 25A | 0 |  |  | 0 |  |  | 0 |  |  | 109082
COMPANY NAME | 26A | 27392 |  |  | 14584 |  |  | 0 |  |  | 28962
COMPANY NAME | 27A | 0 |  |  | 0 |  |  | 0 |  |  | 7500
COMPANY NAME | 28A | 13186 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 29A | 0 |  |  | 27207 |  |  | 40846 |  |  | 34188
COMPANY NAME | 30A | 59816 |  |  | 94326 |  |  | 0 |  |  | 0
COMPANY NAME | 31A | 104988 |  |  | 3008 |  |  | 0 |  |  | 162740
COMPANY NAME | 32A | 860393 |  |  | 474810 |  |  | 600634 |  |  | 1986064
COMPANY NAME | 33A | 292 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 34A | 19692 |  |  | 0 |  |  | 0 |  |  | 0
COMPANY NAME | 35A | 2644 |  |  | 0 |  |  | 0 |  |  | 5231
COMPANY NAME | 36A | 0 |  |  | 0 |  |  | 14460 |  |  | 0
COMPANY NAME | 37A | 1816 |  |  | 1238 |  |  | 62098 |  |  | 0
COMPANY NAME | 38A | 4380 |  |  | 1364 |  |  | 18374 |  |  | 0
COMPANY NAME | 39A | 11856 |  |  | 9568 |  |  | 7288 |  |  | 0
COMPANY NAME | 40A | 390 |  |  | 0 |  |  | 0 |  |  | 2303
COMPANY NAME | 41A | 87172 |  |  | 103377 |  |  | 294270 |  |  | 128284
COMPANY NAME | 42A | 539870 |  |  | 404900 |  |  | 328254 |  |  | 581508
COMPANY NAME | 43A | 328012 |  |  | 108526 |  |  | 26046 |  |  | 29732
COMPANY NAME | 44A | 0 |  |  | 0 |  |  | 0 |  |  | 45604
COMPANY NAME | 45A | 600916 |  |  | 14050 |  |  | 35922 |  |  | 239220
Spreadsheet: 41788d1240316659-award-points-from-scale-to-test-results-test2
Sheet: Week by Week

Week 1 | Test |  |  |  |  |  |  | Scoring System
Name | Rank | Score | Points |  |  |  |  | Test Marks
[NAME] | 1 | 8.26 | 175 |  |  |  |  | Between |  | Points
[NAME] | 3 | 8.02 | 150 |  |  |  |  | 9 | 10 | 250
Julie | 4 | 7.95 | 125 |  |  |  |  | 8.75 | 8.99 | 225
[NAME] | 4 | 7.95 | 125 |  |  |  |  | 8.5 | 8.74 | 200
Doug | 8 | 7.41 | 100 |  |  |  |  | 8.25 | 8.49 | 175
[NAME] | 2 | 8.21 | 150 |  |  |  |  | 8 | 8.24 | 150
[NAME] | 7 | 7.65 | 100 |  |  |  |  | 7.75 | 7.99 | 125
[NAME] | 9 | 6.49 | 0 |  |  |  |  | 7.4 | 7.74 | 100
[NAME] | 10 | 6.26 | 0 |  |  |  |  | 7 | 7.39 | 25
Stuart | 6 | 7.91 | 125 |  |  |  |  | 0 | 6.99 | 0
Team | = | 7.611 | 1050
Week 2 | Test
Name | Rank | Score | Points
[NAME] | 1 | 9.21 | 250
[NAME] | 6 | 8.02 | 150
Julie | 2 | 8.45 | 175
[NAME] | 5 | 8.1 | 150
Doug | 9 | 6.79 | 0
[NAME] | 4 | 8.31 | 175
[NAME] | 7 | 7.32 | 25
[NAME] | 8 | 6.9 | 0
[NAME] | 10 | 6.78 | 0
Stuart | 3 | 8.35 | 175
Team | = | 7.822999999999999 | 1100
Week 3 | Test
Name | Rank | Score | Points
[NAME] | 6 | 8.1 | 150
[NAME] | 2 | 8.45 | 175
Julie | 7 | 7.51 | 100
[NAME] | 10 | 5.23 | 0
Doug | 1 | 8.51 | 200
[NAME] | 3 | 8.35 | 175
[NAME] | 4 | 8.12 | 150
[NAME] | 9 | 7.01 | 25
[NAME] | 8 | 7.23 | 25
Stuart | 4 | 8.12 | 150
Team | = | 7.662999999999999 | 1150
Week 4 | Test
Name | Rank | Score | Points
[NAME] | 3 | 8.68 | 200
[NAME] | 4 | 8.46 | 175
Julie | 8 | 7.49 | 100
[NAME] | 6 | 7.67 | 100
Doug | 1 | 9.23 | 250
[NAME] | 2 | 8.79 | 225
[NAME] | 9 | 7.48 | 100
[NAME] | 7 | 7.51 | 100
[NAME] | 10 | 7.41 | 100
Stuart | 5 | 8.01 | 150
Team | = | 8.073 | 1500