tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 700074d1602936425-rank-top-10-by-summed-group-values-fragan
Sheet: Feuil2

GROUP | Value | Number of sales
A | 50 | 69 |  |  | TOP K | 7
A | 33 | 28 |  |  |  |  | k=4 so i should print only 4 top groups by value
B | 51 | 24
A | 68 | 25
B | 91 | 2 |  |  |  |  | Desired Result :
A | 39 | 97 |  |  |  |  |  | GROUP | Value | Number of Sales
F | 474 | 101114
C | 70 | 146
E | 89 | 71
A | 64 | 68
B | 45 | 5
D | 72 | 73
Z | 21 | 57
E | 22 | 56
A | 93 | 89
B | 79 | 77
D | 46 | 87
C | 43 | 86
A | 7 | 27
B | 51 | 18
C | 97 | 2
A | 83 | 69
Z | 7 | 12
B | 8 | 67
C | 3 | 92
S | 56 | 13
A | 37 | 85
T | 32 | 45
Spreadsheet: 106544d1303821761-vlooup-and-sums-test_garethjohn
Sheet: Sheet2

 | Stage | cost 1 | cost 2 | cost 3 | cost 4 | cost 5
project A | Post | 10 | 20 | 30 | 40 | 50
project B | Current | 20 | 40 | 60 | 80 | 100
project A | pre | 40 | 80 | 120 | 160 | 200
project A | Current | 80 | 160 | 240 | 320 | 400
Spreadsheet: 789874d1659423198-autocount-function-count-down-and-not-up-2022-08-01-oeldere-zachwalkerpinto-sample-7-ans
Sheet: Sheet1

Group
Account A | 5
Account A | 10
Account A | 15
Account A | 20
Account A | 15
Account A | 20
Account A | 25
Account A | 5
Account A | 10
Account A | 20
Account B Total
Account B | 15
Account B | 20
Account B | 25
Account B | 10
Account B | 10
Account B | 15
Account B | 25
Account B | 25
Account B | 30
Account B | 10
Account B | 6.66666666666666
Account B | -0.833333333333336
Account B | -8.33333333333334
Spreadsheet: 244ad00c-e068-4a86-afd8-9eec1cd65361
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7994 | 55784 | Gabriella | Guidotti | ITA | 107 | 00:30:44 | 00:00:00 | 00:40:46 | 00:00:00 | 00:42:33 | 1 | 01:54:04
Spreadsheet: d6372810-46a2-4e4a-a1fd-8ac212ba5ec3
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FMAXN | Test | FMAXN | Amoxicillin Level, BA | Amoxicillin Level, BA | Bioassay |  |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL of serum frozen. | 0.5 mL | Hemolysis	NA Thawing	Yes Lipemia	NA Icterus	NA Other	[NAME] other than serum | AMOXICILLIN LEVEL        mcg/mL   Average peak levels (1-2 hrs post oral dosing)    250 mg:  3.5-5.5 mcg/mL    400 mg:  5.9 mcg/mL    500 mg:  5.5-7.5 mcg/mL   This assay tests Amoxicillin alone since concentrations are equivalent for Amoxicillin plus clavulanate.  This assay does not detect clavulanate levels.  Any undisclosed antimicrobials might affect the results.   Test Performed By:  Focus Diagnostic, Inc.                                5785 Corporate Ave.                                Cypress, CA  90630-4750 | Monday through Friday | 3-4 days | 5-6 days | 1 | 80299 |  |  |  |  | Focus Diagnositics, Inc.
FMAXN | [NAME] | SRED | Serum Red |  |  |  | Frozen | 30 days
FMAXN | Result | Z2517 | Amoxicillin Level, BA | Amoxicillin Level, BA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_m_love__31092__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 10/19/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
[NAME], LP | YC2760.1 | F | C3GC | Credit Previously Provided
Kennedy Oil | [NAME] | P | NG | [NAME]
McElvain Oil & Gas Properties | YC2968.1/2 | F | NG | Credit Previously Provided
Piper Energy Inc. | YC2951.1 YC3014.1/2 | P | NGGJ | [NAME]
Prima Energy Inc. | YC2848.1 | F | NG | Credit Previously Provided
Tri-State Generation and Transmission | YB5833.2 | F | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Barclays Capital Commodities | YC1835.1 | F | NG | Barclays Bank PLC
General Mills Inc. | YC2484.1 | F | WTI | General Mills Operations, Inc.
New Counterparty | YC2759.1 | F | WTI | KCS Energy Marketing Inc.
Spreadsheet: 704170d1605391416-function-to-count-days-since-an-incident-exampleexcelforum
Sheet: Sheet1

 | Meal_Type | Values |  |  |  |  |  |  |  |  |  |  |  |  |  | DaysSinceLast>2300
 | Breakfast |  | [NAME] |  | Dinner |  | Drink |  | Lunch |  | Snack |  | Grand Total |  |  | 2
Date | SUM of Sodium (mg) | SUM of Calories | SUM of Sodium (mg) | SUM of Calories | SUM of Sodium (mg) | SUM of Calories | SUM of Sodium (mg) | SUM of Calories | SUM of Sodium (mg) | SUM of Calories | SUM of Sodium (mg) | SUM of Calories | SUM of Sodium (mg) | SUM of Calories
2020-10-17 00:00:00 |  |  |  |  | 2000 | 1000 | 23.5 | 382 | 1421 | 427 |  |  | 3444.5 | 1809
2020-10-18 00:00:00 |  |  |  |  | 1230 | 670 | 2.5 | 70 | 532 | 233 |  |  | 1764.5 | 973
2020-10-19 00:00:00 |  |  |  |  | 50 | 195 | 30 | 105 | 1230 | 670 |  |  | 1310 | 970
2020-10-20 00:00:00 |  |  | 50 | 100 | 1550 | 680 | 5 | 75 | 50 | 237.5 |  |  | 1655 | 1092.5
2020-10-21 00:00:00 |  |  |  |  | 200 | 236 | 0 | 390 | 1550 | 680 |  |  | 1750 | 1306
2020-10-22 00:00:00 |  |  |  |  | 735 | 230 | 5 | 105 | 200 | 236 | 45 | 449 | 985 | 1020
2020-10-23 00:00:00 |  |  |  |  | 390 | 310 | 31 | 604 | 1547.5 | 724.25 | 110 | 50 | 2078.5 | 1688.25
2020-10-24 00:00:00 |  |  |  |  | 607.5 | 486 | 0 | 60 | 947.5 | 404.25 | 220 | 424 | 1775 | 1374.25
2020-10-25 00:00:00 |  |  | 50 | 100 | 1150 | 422 | 24 | 415 | 839 | 356 | 165 | 192 | 2228 | 1485
2020-10-26 00:00:00 |  |  |  |  | 930 | 920 |  |  | 1055.5 | 379.5 | 5 | 234 | 1990.5 | 1533.5
2020-10-27 00:00:00 |  |  |  |  | 1390 | 780 | 12.5 | 60 | 560.5 | 504.5 | 5 | 60 | 1968 | 1404.5
2020-10-28 00:00:00 |  |  |  |  | 1660 | 750 | 30 | 90 | 80 | 336 | 257.5 | 87 | 2027.5 | 1263
2020-10-29 00:00:00 |  |  |  |  | 845 | 434 |  |  | 911 | 480 | 458 | 444 | 2214 | 1358
2020-10-30 00:00:00 |  |  |  |  | 704 | 259 | 20 | 125 | 911 | 480 | 912 | 606 | 2547 | 1470
2020-10-31 00:00:00 |  |  | 120 | 340 | 3226 | 1712 | 16 | 1003 | 339.9 | 114.84 |  |  | 3701.9 | 3169.84
2020-11-01 00:00:00 | 978 | 633.75 |  |  | 438 | 199 |  |  |  |  | 0 | 129 | 1416 | 961.75
2020-11-02 00:00:00 |  |  | 420 | 8 | 930 | 690 | 37.5 | 160 | 708 | 199 | 0 | 129 | 2095.5 | 1186
Spreadsheet: 110539d1307149333-pivot-tables-pivot-table2
Sheet: pivot data

Division | Category # | Cost/Issue | Company A | Company B | Company C
Division 3 | 300 | Initial Amount | 20 | 8 | 30
Division 4 | 400 | Initial Amount | 10 | 35 | 60
Division 3 | 300 | Additional Amount | 50 | 10 | 15
Division 3 | 300 | Issue | books | lighting | other
Division 4 | 400 | Additional Amount | 5 | 18 | 75
Spreadsheet: 852592d1702572846-how-to-sumif-with-dynamic-variable-number-of-criteria-ranges-excel-example-1-
Sheet: Sheet1

 |  |  |  |  |  | Master [NAME] |  |  | Value Array |  |  | Unique Master Array |  |  | [NAME]
 |  |  |  |  |  |  | Red | True |  |  |  |  | Red | True
 |  |  |  |  |  | A | Blue | True | 40 |  |  | A | Blue | True | 740 | 740
 |  |  |  |  |  | B | Blue | False | 450 |  |  | B | Blue | False | 450 | 450
 |  |  |  |  |  | A | Blue | True | 100 |  |  | C | Blue | False | 25 | 25
 |  |  |  |  |  | A | Blue | True | 600 |  |  | A | Yellow | True | 400 | 400
 |  |  |  |  |  | C | Blue | False | 25
 |  |  |  |  |  | A | Red | True | 400
 |  |  |  |  |  | A | Red | True | 150
 |  |  |  |  |  | A | Yellow | True | 400
 |  |  |  |  |  | [NAME] | Working, but as the size of array is dynamic the number of criteria ranges and criteria will change.
 |  |  |  |  |  | Sometimes the data will be like this |  |  |  |  | Or like this etc.
 |  |  |  |  |  | Master [NAME] |  | Value Array |  |  | Master [NAME] |  |  |  | Value Array
 |  |  |  |  |  |  | Red |  |  |  |  | Red | True | Int
 |  |  |  |  |  | A | Blue | 40 |  |  | A | Blue | True | Int | 40
 |  |  |  |  |  | B | Blue | 450 |  |  | B | Blue | False | Int | 450
 |  |  |  |  |  | A | Blue | 100 |  |  | A | Blue | True | Ext | 100
 |  |  |  |  |  | A | Blue | 600 |  |  | A | Blue | True | Ext | 600
 |  |  |  |  |  | C | Blue | 25 |  |  | C | Blue | False | Ext | 25
 |  |  |  |  |  | A | Red | 400 |  |  | A | Red | True | Ext | 400
 |  |  |  |  |  | A | Red | 150 |  |  | A | Red | True | Int | 150
 |  |  |  |  |  | A | Yellow | 400 |  |  | A | Yellow | True | Ext | 400
Spreadsheet: 141664d1329391867-linking-cells-master-a
Sheet: MASTER

PRODUCTS | PACK | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
Group-A
Brethmol Plus | 100ml. | 32.26
[NAME] | 100ml. | 49.03
[NAME] | 10's | 23.09
Livergen  Liquid | 100ml. | 34.46
Livergen  Liquid | 200ml. | 59.07
[NAME] | 100ml. | 34.36
[NAME] | 200ml. | 58.91
Livergen Container | 60's | 69.43
Livergen Tablet | 10'S | 13.33
Stanmycin-A 250 | 1 x 6 | 54.7
Stanmycin-A 500 | 1 x 3 | 54.7
Stanmycin-A 100mg Syp | 60 ml | 18.23
Stanmycin-A 200mg Syp | 60 ml | 28.05
Stanpen-CV Dry Syp. | 30ml. | 33.92
Stanpen-CV Tablet | 6's | 93.46
Stanrab-20 Tablet | 10's | 33.23
Stanrab-DSR | 10's | 45
[NAME] | 15ml. | 21.57
Vinkola Liquid | 200ml. | 44.41
Vinkola Tablet | 10's | 19.67
GROUP - A TOTAL
Group-B
Allout Suspension | 10 ml. | 13.33
Allout Tablet | 1's | 10.17
B-Ascorvit Capsule | 10's | 7.56
Brethmol Plus M | 100 ml. | 13.12
[NAME] | 60 ml | 15.43
Dolonip-500 Tablet | 20's | 14.03
[NAME] | 21 gms. | 9.69
[NAME] | 100 gms. | 31.56
Quadran-500 Capsules | 10's | 10.42
Quino-C 500 Tablet | 10's | 47.6
Quino-CT Tablet | 10's | 54.43000000000001
[NAME] | 60 gms. | 31.56
[NAME] | 10's | 8.78
[NAME] | 100 ml. | 35.07
Stanpen - 200 | 6's | 2.46
Stanpen - 500 | 6's | 4.67
Stanpen - 800 | 4's | 4.67
Stantac 150 Tablet | 10's | 4.07
Xoma 500 Capsule | 10's | 63.11900000000001
BE |  | ASHISH MAZUMDAR | ASHISH MAZUMDAR | ASHISH MAZUMDAR | ASHISH MAZUMDAR
HEADQUARTER |  | NAGAON | NAGAON | NAGAON | NAGAON
STOCKIST 1 |  | MONORAMA ENTERPRISES | MONORAMA ENTERPRISES
STOCKIST 2 |  | MEDICARE | MEDICARE
STOCKIST 3 |  | SAIKIA DRUG DISTRIBUTORS | SAIKIA DRUG DISTRIBUTORS
STOCKIST 4 |  | CHOUDHURY DRUG DISTRIBUTORS | CHOUDHURY DRUG DISTRIBUTORS
STOCKIST 5 |  | APORNA DRUG DISTRIBUTORS | APORNA DRUG DISTRIBUTORS
STOCKIST 6 |  | M.K.DRUG DISTRIBUTORS | M.K.DRUG DISTRIBUTORS
Spreadsheet: 127218d1320237117-find-or-lookup-looking-for-stores-excelforum-
Sheet: Sheet2

Store1 | a
[NAME] | b
Store3 | c
Store4 | d
Store5 | e
Store6 | f
Store7 | g
Store8 | I
Store9 | h
Store10 | kl
Store11 | p
Spreadsheet: 146340a3-69ef-4b0e-a069-26ba878520b0
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Aug. | Sep. | Oct. |  | Oct.
Item | 2013 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 257912.011 | 245258.846 | 251107.488 |  | 240961.437
Cotton | 136354.667 | 132958.553 | 131619.988 |  | 124140.304
Linen | 7097.136 | 6745.79 | 7363.005 |  | 7047.501
Wool | 2819.399 | 3524.546 | 3789.806 |  | 2974.896
Silk | 1215.61 | 1041.199 | 1177.178 |  | 1111.204
Manmade | 110425.199 | 100988.758 | 107157.511 |  | 105687.532
Apparel: | 28907.356 | 25901.264 | 29367.221 |  | 25798.933
Cotton | 12747.893 | 11545.446 | 13265.604 |  | 11321.205
Linen | 513.531 | 413.424 | 546.24 |  | 383.075
Wool | 1702.633 | 1713.591 | 1898.655 |  | 1563.844
Silk | 1178.24 | 1055.106 | 1218.954 |  | 1454.762
Manmade | 12765.059 | 11173.697 | 12437.768 |  | 11076.047
Home furnishings: | 5564.768 | 5439.307000000001 | 6072.571 |  | 5449.011
Cotton | 2675.081 | 2691.656 | 2727.418 |  | 2592.85
Linen | 230.566 | 227.166 | 398.832 |  | 274.383
Wool | 168.152 | 140.108 | 223.278 |  | 196.609
Silk | 147.145 | 140.497 | 249.753 |  | 177.498
Manmade | 2343.824 | 2239.88 | 2473.29 |  | 2207.671
Floor coverings: | 35542.053 | 36263.266 | 36482.021 |  | 31674.918
Cotton | 2323.4 | 2720.986 | 2577.217 |  | 2212.555
Linen | 1156.876 | 1443.072 | 1254.331 |  | 1092.078
Wool | 3748.501 | 4808.481 | 3645.946 |  | 2429.421
Silk | 39.272 | 34.702 | 22.492 |  | 39.904
Manmade | 28274.004 | 27256.025 | 28982.035 |  | 25900.96
Total exports: 2/ | 328005.754 | 312956.802 | 323124.318 | 0 | 303983.75
Cotton | 154148.925 | 149979.329 | 150261.255 |  | 140332.432
Linen | 8998.108 | 8829.452 | 9562.407 |  | 8797.037
Wool | 8441.206 | 10192.127 | 9560.944 |  | 7171.954
Silk | 2580.267 | 2271.504 | 2668.378 |  | 2783.368
Manmade | 153837.248 | 141684.39 | 151071.334 |  | 144898.959
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 12/12/13.
Spreadsheet: randall_gay__31435__Deets Electric
Sheet: Sheet1

 |  | REVISED ELECTRIC EXTRAS ON GAY RESIDENCE 1-26-01
ITEM | QTY |  | [NAME] |  |  |  | UNIT | EXTENDED |  | [NAME]
1 | 2 | RECESS CANS EXTERIOR OF GARAGE |  |  |  |  | 50 |  |  | ok
2 | 0 | OPENING FOR ABOVE |  |  |  |  | 25 |  | * | X
3 | 1 | SWITCH AT GARAGE |  |  |  |  | 25 |  |  | ?
4 | 1 | WATERPROOF AT FRONT PORCH |  |  |  |  | 65 |  |  | X
5 | 2 | WATERPROOF AT REAR PORCH |  |  |  |  | 65 |  |  | one
6 | 1 | WATERPROOF AT FRONT GARAGE |  |  |  |  | 65 |  |  | far right
7 | 1 | SWITCH | FOR ARCH LIGHTS |  |  |  | 25 |  |  | ?
8 | 1 | SWITCH ENTRY |  |  |  |  | 25 |  |  | ?
9 | 1 | RECESS CANS ENTRY |  |  |  |  | 50 |  | * | X
10 | 2 | RECESS CANC LIVING ROOM |  |  |  |  | 50 |  |  | ok
11 | 2 | SWITCHES IN LIVING ROOM |  |  |  |  | 25 |  |  | only 1 extra
12 | 0 | DIMMER LIVING ROOM |  |  |  |  | 50 |  | * | X
13 | 1 | FAN IN LIVING ROOM ($30 BLOCK & $25 FOR OPENING) |  |  |  |  | 55 |  | * | included
14 | 1 | RECESS IN DINING RM |  |  |  |  | 50 |  |  | ok
15 | 1 | SWITCH IN DINING ROOM |  |  |  |  | 25 |  |  | ok
16 | 1 | DIMMER IN DINING RM |  |  |  |  | 50 |  |  | X
17 | 1 | RECESS CAN IN GARGAE AT SHELVES |  |  |  |  | 50 |  |  | X
18 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | X
19 | 0 | ADDITIONAL FLOURESCENT & OPENING GARAGE |  |  |  |  | 70 |  | * | X
20 | 1 | EXHAUST FAN IN STORAGE AREA OFF ENTRY |  |  |  |  |  |  |  | ok
 |  | BY GARAGE |  |  |  |  | 45 |  |  | ok
21 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | ok
22 | 1 | DEDICATED OUTLET FOR TRASH COMPACTOR |  |  |  |  | 55 |  |  | ok
23 | 1 | GFI KITCHEN |  |  |  |  | 50 |  | ? | Code?
24 | 3 | PENDENT LIGHTS IN KITCHEN |  |  |  |  | 80 |  |  | ok
25 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | ok
26 | 1 | SET DBL FLOODS |  |  |  |  | 60 |  |  | X
27 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | X
28 | 6 | RECESS IN FAMILY RM |  |  |  |  | 50 |  |  | 7 included
29 | 4 | RECESS IN MEDIA |  |  |  |  | 50 |  |  | ok
30 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | ok
31 | 1 | FAN & LIGHT IN MEDIA |  |  | BLOCKING |  | 30 |  | * | ok
32 | 1 | FAN & LIGHT IN BDRM #3 |  |  | BLOCKING |  | 0 |  | * | ok
33 | 2 | RECESS IN BDRM #3 |  |  |  |  | 50 |  | * | ok (@ window seat?)
34 | 1 | FAN & LIGHT BDRM #2 |  |  | BLOCKING |  | 0 |  | * | ok
35 | 1 | FAN & LIGHT LOFT |  |  |  |  | 55 |  | * | fan block only
36 | 2 | SWITCHES FOR ABOVE |  |  |  |  | 25 |  |  | 1 switch
37 | 4 | RECESS UP HALL |  | BOOKCASE |  |  | 50 |  |  | ok
38 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | ok
39 | 1 | TV OUTLET MASTER |  |  |  |  | 25 |  |  | X
40 | 3 | RECESS IN MASTER |  |  |  |  | 50 |  |  | ?
41 | 1 | SWITCH FOR ABOVE |  |  |  |  | 25 |  |  | ?
41 | 1 | PHONE IN MASTER |  |  |  |  | 25 |  |  | included
42 | 0 | FAN & LIGHT IN MASTER BATH |  |  |  |  | 175 |  | * | ok
43 | 0 | SWITCH FOR ABOVE |  |  |  |  | 25 |  | * | ok
44 | 2 | RECESS THIRD FLOOR |  |  |  |  | 50 |  |  | included
 |  |  |  |  |  | TOTAL
Spreadsheet: vkaminski__40935__s100068
Sheet: ATTdetails

 | AT&T Calling Card Details
 | ATT Billing Dates From:  2001-02   To:   2001-02,   Accounting YearMonth: 2001-02
 | Company:  0011   Enron Corp.
 | RC | Card Number | To Number | To Location | St Co | From Number | Call Date | Charge | State Tax | Local Tax | Federal Tax | Other Charge | Total Charge | Connect Time | Name | Cancel
Not in Group | 100068 | [PHONE] | [PHONE] | HOUSTON | TX | [PHONE] | 01/01/19 | 10.52 | 0 | 0 | 0.24 | 0 | 10.76 | 000:29:082 | PIPER, GREG
Not in Group | 100068 | [PHONE] | [PHONE] | HOUSTON | TX | [PHONE] | 01/01/19 | 0.65 | 0 | 0 | 0.01 | 0 | 0.66 | 000:00:308 | PIPER, GREG
Not in Group | 100068 | [PHONE] | [PHONE] | KATONAH | NY | [PHONE] | 01/01/20 | 0.89 | 0 | 0 | 0.02 | 0 | 0.91 | 000:01:130 | PIPER, GREG
Not in Group | 100068 | [PHONE] | [PHONE] | GLENWD SPG | CO | [PHONE] | 01/01/20 | 0.58 | 0.02 | 0.03 | 0.01 | 0 | 0.64 | 000:00:573 | PIPER, GREG
Not in Group | 100068 | [PHONE] | [PHONE] | HOUSTON | TX | [PHONE] | 01/01/30 | 16.9 | 0 | 0 | 0.38 | 0 | 17.28 | 000:47:393 | PIPER, GREG
 |  | [PHONE] Total
 |  | Grand Total
Spreadsheet: 883512d1732121529-1-row-and-3-column-wise-lookup-using-index-match-function-excel-comp-eba
Sheet: Comp

 |  |  | Make | Product | Model |  | Column |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accord | Mag | 6420
 |  |  | Accord | RO_Panel | AP LED Lite |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adept | pH | 6440
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aster | RO_Panel | 6410/6415
 | Make |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR Instrumentation |  | A3 Series
 | Product |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Infinity |  | A7 Series
 | Application |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proton |  | A9 Series GSM
 | Model |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AP 1:1/1:3/3:3
 | Display |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AP GSM 1:1/1:3/3:3
 | Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AP LED Lite
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Bore
 | Flow Range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRO 11M/13M
 | Mounting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRO 33M
 | Relay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LITE NXT
 | Raw Water Pump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAG 650
 | High Pressure Pump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NXT11/13/33
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PO650 pH
 | Input |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA11/13/33
 | Output |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smart EFM
 | Installation
 | Power supply
 | Pressure rating (kg/cm2)
 | Process temperature
 | Electrode material
 | [NAME]
 | Lining material
 | Cable
 | Body material
 | protection
 | Price
 | Feature
Spreadsheet: 870294d1716829334-inserting-rows-and-keeping-formula-anonymised-history-group-spreadsheet
Sheet: A - DAY BOOK

Date | Description | CASH |  | BANK |  | BALANCE |  | CREDITORS | [NAME] | Check col | INCOME |  |  |  |  |  | EXPENDITURE
 |  | Debit | Credit | Debit | Credit | CASH | BANK |  |  |  | Subs | Donations | Meetings | Bank interest | [NAME] | [NAME]. | Supplies | Equipment | Meetings | Bank charges | [NAME].
 | Balance brought forward |  | 0 |  | 3636.87 | 0 |  | 0 | 0
Janauary 2023
2 | Subs (Smith) |  |  |  |  |  |  |  |  |  | 10
9 | Sub (Jones) |  |  |  | 5 |  |  |  |  |  | 5
15 | Monthly fee |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
22 | Online payment - Village Hall Mickleham |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 | Sub ( Bloggs) |  |  |  | 5 |  |  |  |  |  | 5
30 | Online payment - |  |  |  | 10 |  |  |  |  |  |  |  | 10
 | Sub (Fred) |  |  |  | 10 |  |  |  |  |  | 5 | 5
TOTALS
Spreadsheet: 739503d1625747214-xlookup-more-than-3-results-from-data-set-multiple-lookup-populating-a-calendar
Sheet: CALENDAR

Month | July |  |  |  | August |  |  |  | September |  |  |  |  | October |  |  |  | November |  |  |  | December
Week No | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | 202127 | 202128 | 202129 | 202130 | 202131 | 202132 | 202133 | 202134 | 202135 | 202136 | 202137 | 202138 | 202139 | 202140 | 202141 | 202142 | 202143 | 202144 | 202145 | 202146 | 202147 | 202148 | 202149 | 202150 | 202151 | 202152
Trial
Rollout
Spreadsheet: 158594d1338315533-index_match-or-vlookup-with-multiple-criteria-multiple-criteria-index_match-or-vlookup-file
Sheet: Sheet1

 | I would like to have several worksheets pulling from one Data Source Sheet that is updated every day with that day's figures. The Data Source Sheet comes to me by email
 | and I would like to copy and paste the whole sheet each day on top of itself in a workbook that has a sheet for each company. I need to have these company sheets
 | look at the date and company number of the Data Source Sheet and put the corresponding dollar amounts in for that company and date. I've tried INDEX_MATCH and
 | VLOOKUP but have not been able to get either of them to work.
 |  |  |  |  |  |  |  | This comes daily and each day's date is just added to the bottom.
 |  |  |  |  |  |  |  | Data Source Sheet
 | Must meet 2 criteria to bring corresponding $ amount to cell:
 | (1)  Date on Wksht must match corresponding date on Data Source Sheet |  |  |  |  |  |  | As-of Date | GL ACCOUNT | Amount
 | (2)  Last 4 digits of GL ACCOUNT number must match Co. number
 |  |  |  |  |  |  |  | 2012-04-02 00:00:00 | 112-000-000-11024-0001 | 31826.75
 | Each of the sheets has its own company number: |  |  |  |  |  |  | 2012-04-02 00:00:00 | 112-000-000-11024-0002 | 20719.85
 |  |  |  |  |  |  |  | 2012-04-02 00:00:00 | 112-000-000-11024-0003 | 8010.25
 |  | Wksht 1 | Wksht 2 | Wksht 3 | etc |  |  | 2012-04-02 00:00:00 | 112-000-000-11024-0004 | 42022.43
 |  | Co. | Co. | Co. |  |  |  | 2012-04-02 00:00:00 | 112-000-000-11024-0005 | 12394.25
 | Date | 0001 | 0003 | 0004
 |  |  |  |  |  |  |  | 2012-04-03 00:00:00 | 112-000-000-11024-0001 | 24630
 | 2012-04-02 00:00:00 | 31826.75 | 8010.25 | 42022.43 |  |  |  | 2012-04-03 00:00:00 | 112-000-000-11024-0002 | 29099.5
 | 2012-04-03 00:00:00 | 24630 | 3282.5 | 30149.75 |  |  |  | 2012-04-03 00:00:00 | 112-000-000-11024-0003 | 3282.5
 | 2012-04-04 00:00:00 | 15230.1 | 11690.25 | 16475.75 |  |  |  | 2012-04-03 00:00:00 | 112-000-000-11024-0004 | 30149.75
 |  | (The anwers I need.) |  |  |  |  |  | 2012-04-03 00:00:00 | 112-000-000-11024-0005 | 14470
 |  |  |  |  |  |  |  | 2012-04-04 00:00:00 | 112-000-000-11024-0001 | 15230.1
 |  |  |  |  |  |  |  | 2012-04-04 00:00:00 | 112-000-000-11024-0002 | 19281.5
 |  |  |  |  |  |  |  | 2012-04-04 00:00:00 | 112-000-000-11024-0003 | 11690.25
 |  |  |  |  |  |  |  | 2012-04-04 00:00:00 | 112-000-000-11024-0004 | 16475.75
 |  |  |  |  |  |  |  | 2012-04-04 00:00:00 | 112-000-000-11024-0005 | 23774.14
 |  |  |  |  |  |  |  | etc | etc | etc