tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 672645d1586946342-formula-troubles-too-big-and-confusing-text-help_150420
Sheet: text help!

Previous |  |  |  |  | Current
 |  | Target | Universe | Units |  |  | Target | Universe | Units
 |  | A4+ | A4+ | A4+ |  |  | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+ | A4+
 |  | Nat[Consolidated] | Nat[Consolidated] | Nat[Consolidated] |  |  | Nat[Consolidated] | Nat[Consolidated] | Nat[Consolidated] | Nat[Consolidated] | Nat[Consolidated] | Nat[Online Pre-Broadcast] | Nat[Online Pre-Broadcast] | Nat[Online Pre-Broadcast] | Nat[Online Pre-Broadcast] | Nat[Online Pre-Broadcast] | Nat[Online 1-7 Day] | Nat[Online 1-7 Day] | Nat[Online 1-7 Day] | Nat[Online 1-7 Day] | Nat[Online 1-7 Day] | FORMULA | FORMULA
CREATURE | sea | Count | '000 (avg) | Prog Share | CREATURE | sea | '000 (avg) | Prog Share | Count | Benchmark 000 (18) | [NAME] (18) | '000 (avg) | Prog Share | Count | Benchmark 000 (18) | [NAME] (18) | '000 (avg) | Prog Share | Count | Benchmark 000 (18) | [NAME] (18) | Difference vs Slot | Difference vs Slot
fish body | crab | 6 | 923.289 | 11.368 | fish body | crab | 4018.15 | 19.101 | 2 | 1474.91 | 8.722 | 0 | 0 | 2 | 0 | 0 | 307.535 | 0 | 3 | 0 | 0
fish [NAME] | crab | 6 | 5923.289 | 11.368 | fish [NAME] | crab | 4018.15 | 19.101 | 2 | 5474.91 | 8.722 | 0 | 0 | 2 | 0 | 0 | 307.535
 |  |  |  | CORRECT
 |  |  |  | NOT CORRECT
 |  |  |  | SHOULD BE |  | [NAME] have consolidated to 4.0m (19.1%), below the slot average by -1.5m and +10.4 share pts (5.5m, 8.7%). It's also performed -1.9m and +7.7 share pts below the previous CREATURE.
Spreadsheet: 871474d1717901167-filtering-on-any-text-in-column-test-wildkid-
Sheet: Sheet2

Region: | ECA
 |  | FY19 | FY20 | FY21 | FY22 | FY23 | FY24
Global Practice: | EDU
 | EDU + any
*What row 4 should show |  | 0 | 0 | 0 | 1 | 1 | 3
*If you filter on ECA for these years here is what shows up in the list form. I want the additional formula to filter on column C where it's any contributing GP is included in row 4 but I can't get it working
A | B | C | D | E
ECA | EDU |  | FY22 | FY26
ECA | EDU |  | FY22 | FY24
ECA | EDU | HNP POV SPJ | FY22 | FY29
ECA | EDU |  | FY23 | FY30
ECA | HNP |  | FY23 | FY24
ECA | EDU | HNP | FY24 | FY29
ECA | SPJ | EDU HNP | FY24 | FY29
Spreadsheet: 376586d1423655288-calculating-file-intervals-from-300-to-300-volumes
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of files | Interval | Folder's number
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 269
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: 859953d1708176382-multi-return-lookup-from-2d-array-2d-multi-return-lookup-1-
Sheet: Sheet1

Fruit |  | Part of which combos?
Apple
[NAME]
Jujubees
Blueberries
Peach
[NAME]
Tomato
Lemon
Orange
Combos |  | Combo ingredients
Red bounty |  | Apple | Tomato | Jujubees | [NAME]
Yellow bonanza |  | [NAME] | Jujubees | Lemon
Orange treats |  | Apple | Peach | Orange | Jujubees
Spreadsheet: chris_germany__2930__CES-AGL-Mar00
Sheet: Summary

 |  | CES Atlanta Retail Requirements
 |  | Current |  | Intra-day |  | Tomorrow
AGL Pool
Atlanta IT |  |  |  |  | 800
Atlanta FT |  |  |  |  | 20005
Atlanta
Ex-Atl SNG |  |  |  |  |  | 800
Brunswick |  |  |  |  |  | 756
Rome |  |  |  |  |  | 1266
Augusta |  |  |  |  |  | 717
Savannah |  |  |  |  |  | 649
Macon |  |  |  |  |  | 1102
Valdosta |  |  |  |  |  | 84
Ex-Atl Transco |  |  |  |  |  | 979
Total:
Comments: | Revised volumes for 29th and 3/1
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk24

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 273468d1382721738-need-to-reference-3-columns-to-1-column-and-return-a-value-book1
Sheet: form responses

A | B | C | D | E | F
time stamp | username | category | Campus | Campus | Campus
1300 | [EMAIL] | elementary |  |  | BAG-109
1310 | [EMAIL] | elementary |  |  | BHC-103
1315 | [EMAIL] | middle school |  | LMS-042
1320 | [EMAIL] | elementary |  |  | BAG-109
1325 | [EMAIL] | high school | RHS-004
Spreadsheet: 644865d1570788844-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis
Sheet: carrying cost

 | Weight in pounds
[NAME] | 0 to 55 | 56 to 102 | 103 to 205 | 206 to 600 | 601 ad beyond
0 to 100 miles | 1.97 | 1.56 | 1.37 | 1.22 | Call for rate
101 to 450 miles | 2.15 | 1.72 | 1.49 | 1.32 | Call for rate
451 to 950 miles | 2.75 | 2.38 | 2.18 | 2.09 | Call for rate
951 to 1500 miles | 3.29 | 2.87 | 2.58 | 2.49 | Call for rate
1500 to 2000 miles | 3.8 | 3.31 | 3.01 | 2.85 | Call for rate
2001 to 2550 miles | 3.95 | 3.35 | 3.05 | 3.01 | Call for rate
2551 and over miles | 4.36 | 3.8 | 3.45 | 3.35 | Call for rate
Spreadsheet: 215813d1361492027-how-many-of-each-part-number-was-sold-ef361_sum_uniques
Sheet: Sheet1

Model# | Qty |  | Unique Model # | Total
19A4GLTEFU | 13
19A4GLTEFU | 3
19A4GLTEFU | 1
19A4GLTEFU | 2
19A4GLTEFU | 1
19GOBI2FU2 | 10
19GOBI2FU2 | 20
19GOBI2000FU | 6
19GOBI2000FU | 1
19GOBI2FU2 | 1
19GOBI2FU2 | 5
19GOBI2FU2 | 1
19GOBI2FU2 | 5
19GOBI2FU2 | 1
19GOBI2FU2 | 1
19GOBI2000FU | 1
19GOBI2FU2 | 6
19GOBI2000FU | 2
19GOBI2FU2 | 3
19GOBI2FU2 | 1
19GOBI2FU2 | 43
19GOBI2FU2 | 2
19GOBI2000FU | 2
19GOBI2000FU | 3
19GOBI2000FU | 3
19GOBI2000FU | 1
Spreadsheet: c153e5f4-b464-40d0-93d9-eaea0649f423
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8584 | 53518 | [NAME] | Bixenstine | USA | 183 | 01:11:30 | 00:01:29 | 01:27:38 | 00:02:44 | 00:38:34 | 1 | 03:21:53
8584 | 12233 | [NAME] | Leovic | AUS | 184 | 01:24:08 | 00:01:34 | 02:19:02 | 00:02:59 | [NAME] | 2 | 04:32:59
Spreadsheet: 715614d1611787325-if-cell-text-value-is-canada-then-x-if-canada
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exchange | Revenue
 | Orders
 | Company | Address | City | State/Prov | Zip/Postal | Country | First | Last | Position | Qty |  |  |  | MSRP Quote | Price/ per | Price with FX | Total Rev
 |  |  |  |  |  | USA |  |  |  | 18 |  |  |  | 34.99 | 16.5
 |  |  |  |  |  | Canada |  |  |  | 12 |  |  |  | 34.99 | 15.95
 |  |  |  |  |  | USA |  |  |  | 12 |  |  |  | 34.99 | 17.5
 |  |  |  |  |  | Mexico |  |  |  | 200 |  |  |  | 34.99 | 16
Spreadsheet: 78d7d376-7821-4d14-a3cf-b911d30ebe1b
Sheet: Sheet1

Prislista - 2012 - Meselefors Vandrarhem & Camping     0940-250 89 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Opened the whole year round |  | Wir haben ganzjährig geöffnet |  |  |  | Öppet året runt |  |  | Gehele jaar geopend
Lågsäsong 13/8 - 17/6    kl. 09 - 21 |  |  |  |  |  | [NAME]. 08 - 21
[NAME] |  |  | Bäddpriser |  |  | Campingavgifter |  |  | [NAME]
Storstugan, rumspris, 1 pers. |  | 300:- |  |  |  | [NAME]
Storstugan, hela huset |  | 700:- | Storstugan, 1 person |  | 200:- | Husbil, husvagn .. |  | 155:- | Hyra linne/person |  | 50:-
 | 8 - bäddar |  |  |  |  | Lågsäsong 130:- sek/dygn
Gårdshuset, rumspris, 1 pers. |  | 200:- |  |  |  | [NAME]
Gårdshuset, hela huset |  | 650:- | Gårdshuset, 1 person |  | 200:- | Husbil, husvagn, el |  | 180:- | Hyra dusch/person |  | 25:-
 | 6 bäddar |  |  |  |  | Lågsäsong 155:- sek/dygn
 |  |  |  |  |  | Ensam tältare |  | 90:-
Stuga 1, hela huset |  | 480:- | Stuga 1 | 1 person | 300:- | Tält -Två personer |  | 130:- | Hyra bastu, 2 timmar |  | 100:-
 | 4 - bäddstuga |  | Priset gäller hela stugan |  |  | Fler än två person. |  | 145:-
 |  |  |  |  |  | Hyra av Tältkåta
Stuga 2, hela huset |  | 550:- | Stuga 2 | 1 person | 300:- | Tältkåta, | [NAME] | 300:- | Hyra cykel/dygn |  | 50:-
 | 7 - bäddstuga |  | Priset gäller hela stugan |  |  | Bädd, tältkåta |  | 100:- | Ved till grillplats/korg |  | 20:-
Lågsäsong, 320:- sek/natt. |  |  |  |  |  |  |  |  | Hyra båt, [NAME] |  | 60:-
Stugorna 6 - 9, hela huset |  | 370:- | Stuga 6-9 | 1 person | 220:- | Eluttag, stolpe |  | 25:- | Hyra båt, [NAME] |  | 100:-
 | 4 - bäddstugor |  | Priset gäller hela stugan |  |  |  |  |  | Båtmotor/dag exkl. [NAME] |  | 100:-
Lågsäsong, 320:- sek/natt.
[NAME] 10 , hela huset |  | 370:- | Lillstugan | 1 person | 220:- | Tvättmaskin/tvätt |  | 20:- | Depositionsavgift, nycklar |  | 100:-
 | 2 - bäddsstuga |  | Priset gäller hela stugan |  |  |  |  |  | Depositionsavgift, övrigt |  | 50:-
Spreadsheet: 798387d1664459442-sort-of-a-countif-but-not-sample-data-for-forum
Sheet: Sheet1

Sheet 1 |  |  |  |  |  |  | Sheet 2
Property Reference | Date Property Was Built | 30 Days After Property Was Built | 60 Days After Property Was Built | Number of Repairs 30 Days After Property Was Built | Number of Repairs 60 Days After Property Was Built |  | Property Reference | Date Repair was Carried Out
1 | 2010-01-01 00:00:00 |  |  |  |  |  | 1 | 2010-01-01 00:00:00
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
Spreadsheet: 159562d1338749668-return-all-values-based-on-a-date-range-book1
Sheet: Weekly

Week Commening | 2012-06-04 00:00:00
Client name | Date | Priority | Description
a | 2012-06-04 00:00:00 | 1 | Some Description here 1
b | 2012-06-04 00:00:00 | 2 | Some Description here 2
c | 2012-06-04 00:00:00 | 3 | Some Description here 3
d | 2012-06-03 00:00:00 | 4 | Some Description here 4
e | 2012-06-06 00:00:00 | 5 | Some Description here 5
f | 2012-06-06 00:00:00 | 6 | Some Description here 6
g | 2012-06-06 00:00:00 | 7 | Some Description here 7
h | 2012-06-07 00:00:00 | 8 | Some Description here 8
i | 2012-06-07 00:00:00 | 9 | Some Description here 9
j | 2012-06-07 00:00:00 | 10 | Some Description here 10
k | 2012-06-07 00:00:00 | 11 | Some Description here 11
l | 2012-06-07 00:00:00 | 12 | Some Description here 12
m | 2012-06-07 00:00:00 | 13 | Some Description here 13
n | 2012-06-07 00:00:00 | 14 | Some Description here 14
o | 2012-06-07 00:00:00 | 15 | Some Description here 15
p | 2012-06-07 00:00:00 | 16 | Some Description here 16
q | 2012-06-07 00:00:00 | 17 | Some Description here 17
Spreadsheet: 877006d1723707872-cel-d2-data-validation-or-vlookup-based-on-value-c2-yeti2201-stocktake-simplified-version-for-help-2021-aligw
Sheet: purchase history

 | Cask number | Supplier | Product | caliber
 | 1 | VH | CHN | 20/22
 | 2 | VH | HOG | 32/34
 | 3 | VH | CHN | 19/21
 | 4 | VH | HOG | 43/46
 | 5 | VH | ANZ | 24/26
 | 6 | VH | ANZ | 24/26
 | 7 | VH | ANZ | 24/26
 | 8 | OCC | ANZ | 22/24
 | 9 | OCC | ANZ | 19/21
 | 10 | OCC | ANZ | 19/21
 | 11 | OCC | ANZ | 19/21
 | 12 | OCC | ANZ | 20/22
 | 13 | OCC | ANZ | 21/23
 | 14 | OCC | ANZ | 22/24
 | 15 | VH | CHN | 19/21
 | 16 | OCC | ANZ | 18/20
 | 17 | OCC | ANZ | 22/24
 | 18 | OCC | ANZ | 22/24
 | 19 | OCC | ANZ | 22/24
 | 20 | OCC | CHN | 20/22
 | 21 | VH | HOG | 33/36
 | 22 | VH | HOG | 33/36
 | 23 | VH | HOG | 33/36
 | 24 | VH | HOG | 33/36
 | 25 | VH | HOG | 33/36
 | 26 | VH | HOG | 33/36
 | 27 | VH | HOG | 33/36
 | 28 | OCC | ANZ | 18/20
 | 29 | OCC | ANZ | 20/22
 | 30 | OCC | ANZ | 21/23
 | 31 | OCC | ANZ | 21/23
 | 32 | OCC | ANZ | 22/24
 | 33 | OCC | ANZ | 22/24
 | 34 | OCC | CHN | 20/22
 | 35 | OCC | CHN | 20/22
 | 36 | OCC | CHN | 20/22
 | 37 | OCC | CHN | 20/22
 | 38 | VH | ANZ | 18/20
 | 39 | VH | ANZ | 19/21
 | 40 | VH | ANZ | 19/21
 | 41 | VH | ANZ | 19/21
 | 42 | VH | ANZ | 20/22
 | 43 | VH | ANZ | 20/22
 | 44 | VH | ANZ | 20/22
 | 45 | OCC | ANZ | 18/20
 | 46 | OCC | ANZ | 19/21
 | 47 | OCC | ANZ | 20/22
 | 48 | OCC | ANZ | 20/22
 | 49 | OCC | ANZ | 20/22
 | 50 | OCC | ANZ | 21/23
 | 51 | OCC | ANZ | 21/23
 | 52 | VH | HOG | 33/36
 | 53 | VH | HOG | 33/36
 | 54 | VH | HOG | 33/36
 | 55 | VH | HOG | 33/36
 | 56 | VH | HOG | 33/36
 | 57 | VH | HOG | 33/36
 | 58 | VH | HOG | 33/36
 | 59 | VH | HOG | 33/36
 | 60 | VH | HOG | 33/36
 | 61 | VH | HOG | 33/36
 | 62 | VH | HOG | 33/36
 | 63 | VH | CHN | 20/22
 | 64 | VH | CHN | 20/22
 | 65 | VH | CHN | 20/22
 | 66 | VH | CHN | 20/22
 | 67 | VH | CHN | 20/22
Spreadsheet: 733655d1621687714-change-a-number-into-text-with-the-use-of-currency-number-format-currency-aligw
Sheet: Sheet1

I am asking for a formula to change a number into text with the use of currency number format.
Reporting Currency: |  |  |  |  | USD |  |  | Reporting Currency: |  |  |  |  | ZWL |  |  | Reporting Currency: |  |  |  |  | ZAR
Date | Description | Reference | Revenue | Expense | Balance |  |  | Date | Description | Reference | Revenue | Expense | Balance |  |  | Date | Description | Reference | Revenue | Expense | Balance
Balance Brought Forward |  |  |  |  | 2345 |  |  | Balance Brought Forward |  |  |  |  | 3000 |  |  | Balance Brought Forward |  |  |  |  | 1000
2021-01-06 00:00:00 | [NAME] | 1 | 3000 |  |  |  |  | 2021-01-06 00:00:00 | [NAME] | 1 | 3000 |  |  |  |  | 2021-01-06 00:00:00 | [NAME] | 1 | 3000
2021-01-23 00:00:00 | OK MART | 2 | 2000 | 1450 |  |  |  | 2021-01-23 00:00:00 | OK MART | 2 | 2000 | 1450 |  |  |  | 2021-01-23 00:00:00 | OK MART | 2 | 2000 | 1450
2021-01-23 00:00:00 | Jonnes | 3 | 40000 |  |  |  |  | 2021-01-23 00:00:00 | Jonnes | 3 | 40000 |  |  |  |  | 2021-01-23 00:00:00 | Jonnes | 3 | 40000
2021-01-23 00:00:00 | [NAME] | 4 | 3800 |  |  |  |  | 2021-01-23 00:00:00 | [NAME] | 4 | 3800 |  |  |  |  | 2021-01-23 00:00:00 | [NAME] | 4 | 3800
Desired Solution
CASH ON HAND
Cash held in ZWL Account (as at23/01/21
Cash held in USD Account (as at23/01/21
Cash held in ZAR Account (as at23/01/21
Spreadsheet: 68185d1268742668-report-table-vlookup-match-index-formula-book2
Sheet: Sheet1

SETTING | Scheme |  |  | REPORT
Acorn | A |  |  |  | Scheme Count
Bankwood | B |  |  | SETTING | A | B | C
Bankwood | C |  |  | Acorn | 1 | 1
Acorns C | A |  |  | Acorns C | 2
Ashdell | C |  |  | Appletree |  |  | 1
Acorn | B |  |  | Ashdell
Acorns C | A |  |  | Bankwood |  | 1 | 1
Spreadsheet: darrell_schoolcraft__7843__Griffith901
Sheet: PPL-OBA

Citizens Arizona Gas |  |  |  |  |  |  |  | Customer: | PP&L
Balance Tracking Report |  |  |  | Month:
 | Transwestern Lateral |  |  |  |  |  |  | El Paso Lateral |  |  |  |  |  |  | Total
 |  |  |  |  | Imbalance |  |  |  |  |  |  | Imbalance |  |  |  |  | Imbalance
 | Alloc. Del. | Oper. Alloc. | Total Alloc. | Scheduled | Daily | Cummulative |  | Alloc. Del. | Oper. Alloc. | Total Alloc. | Scheduled | Daily | Cummulative |  | Alloc. Del. | Scheduled | Daily | Cummulative
Day | Dth | Dth | Dth | Dth | Dth | Dth |  | Dth | Dth | Dth | Dth | Dth | Dth |  | Dth | Dth | Dth | Dth
Beginning Bal. |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
1
Total
(+due Pipeline/-due PPL)
Spreadsheet: 799700d1665218979-case-sensitive-with-match-while-using-arrays-excel_help
Sheet: control-1array

UNMATCH: |  | (case-unsensitive) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1)
 |  | (case-sensitive) |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0))))
grade |  |  |  | grade
A |  |  |  | A
A |  |  |  | B
B |  |  |  | b
C |  |  |  | C
D
a
F
A
A
B
B
D
A
B
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: BRAZIL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 51525d1251191038-graphing-help-696911
Sheet: Sheet4

Sum of VALUE | Column Labels
Row Labels | NAME1 | NAME2 | NAME3 | Grand Total
6/26/09 | 5 | 10 |  | 15
6/27/09 |  |  | 6 | 6
6/28/09 | 7 |  |  | 7
6/29/09 | 3 |  |  | 3
6/30/09 |  | 2 | 4 | 6
Grand Total | 15 | 12 | 10 | 37
Spreadsheet: 51574d1251221366-data-validation-from-table-non-vb-dynamic-data-validation
Sheet: Sales

Department: | SALES
Project 1
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Project 2
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Spreadsheet: 669100d1585208945-solver-delivery-planning-solver_delivery_planning
Sheet: Solver_setup

 |  |  | Shipping quantity (t)
customer | Shipping quantity (t) | Deadline delivery (week) | week 3 | week 4 | week 5 | week 6
[NAME] | 30 | 3
Michelle | 100 | 5
[NAME] | 75 | 6
[NAME] | 50 | 5
Valery | 159 | 3
[NAME] | 64 | 4
Total
 |  | binary grd
[NAME] |  |  | 1 | 0 | 0 | 0 |  | =
Michelle |  |  | 1 | 1 | 1 | 0 |  | =
[NAME] |  |  | 1 | 1 | 1 | 1 |  | =
[NAME] |  |  | 1 | 1 | 1 | 0 |  | =
Valery |  |  | 1 | 0 | 0 | 0 |  | =
[NAME] |  |  | 1 | 1 | 0 | 0 |  | =
 |  | Weekly sum
 |  |  | <= | <= | <= | <=
 |  |  | 189 | 70 | 150 | 500
Spreadsheet: 385274d1427252048-data-base-linked-to-placement-key-ln2-log
Sheet: entry

 |  |  |  |  |  |  |  | VIAL IN | VIALS | VIALS
 | Box name | row,col | CELL TYPE | EXPERIMENT | ID# | SAMPLE DETAILS | DATE | STOCK | REMOVED | REMAINING
1 | T1C1B1 | 1,1 | SPLEEN | Exp1/13 | 4 | CONTROL | 2008-05-16 00:00:00 | 3
2 | T1C1B1 | 1,2 | SPLEEN | Exp1/13 | 3 | PRCV+PRRSV | 2008-05-16 00:00:00 | 3
3 | T1C1B1 | 1,3 | SPLEEN | Exp1/13 | 2 | PRCV | 2008-05-16 00:00:00 | 3
4 | T1C1B1 | 2,1 | PBMC | LJS | 2 | PRCV+PRRSV | 2008-05-22 00:00:00 | 2 | 1
5 | T1C1B1 | 2,2 | PBMC | LJS |  | PRCV+PRRSV | 2008-05-22 00:00:00 | 2 | 1
6 | T1C1B1 | 2,3 | PBMC | LJS |  | PRRSV | 2008-05-22 00:00:00 | 1 | 1
7 | T1C1B1 | 3,1 | PBMC | LJS |  | CONTROL | 2008-05-22 00:00:00 | 1 | 1
8 | T1C1B1 | 3,2 | SPLEEN | EXP2/13 | 6 | PRRSV+PRCV | 2008-05-22 00:00:00 | 1 | 1
9 | T1C1B1 | 3,3 | SPLEEN | EXP2/14 | 5 | PRCV | 2008-05-22 00:00:00 | 1 | 1
Spreadsheet: 695731d1600364634-find-and-keep-running-total-of-max-value-in-very-large-spreadsheet-sample-data-1-
Sheet: Max w Formulas

Data Type | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date | [NAME] | Date
B
C
D
E
F
G
H
I
J
K
L