tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59975d1260489828-sum-formula-in-vba-sample
Sheet: Sheet1

 | Row Data |  |  |  |  |  |  |  |  | SUM Table
Ref No | [NAME] | Country | Status | Scan Date |  | Due |  |  | PO Invoice |  | Non PO Invoice |  | Expense report
1215 | PO Invoice | ITALY | New | 2009-12-10 00:00:00 |  |  |  | Country | Due | Not Due | Due | Not Due | Due | Not Due
5465 | PO Invoice | ITALY | New | 2009-12-10 00:00:00 |  |  |  | Italy
9715 | PO Invoice | ITALY | New | 2009-12-10 00:00:00 |  |  |  | Ivory Coast
13965 | NON PO invoice | ITALY | New | 2009-12-10 00:00:00 |  |  |  | Turkey
18215 | PO Invoice | IVORY COAST | Data entry | 2009-12-10 00:00:00
22465 | PO Invoice | IVORY COAST | Data entry | 2009-12-10 00:00:00
26715 | NON PO invoice | IVORY COAST | Data entry | 2009-12-10 00:00:00
30965 | NON PO invoice | IVORY COAST | Data entry | 2009-12-10 00:00:00
35215 | NON PO invoice | IVORY COAST | Data entry | 2009-12-07 00:00:00
39465 | Expense Report | Turkey | Data entry | 2009-12-07 00:00:00
43715 | Expense Report | Turkey | Data entry | 2009-12-07 00:00:00
47965 | Expense Report | Turkey | Data entry | 2009-12-07 00:00:00
52215 | Expense Report | Turkey | Data entry | 2009-12-07 00:00:00
56465 | Expense Report | Turkey | Data entry | 2009-12-10 00:00:00
Spreadsheet: 831546d1685707899-finding-duplicate-but-with-1-column-has-to-be-different-help-4-
Sheet: Sheet2

my forumla is calculating all YES
SWAP NAME | Claimant ID (if UC Customer) | Referring Office | PET Start (Date) | DUPLICATE differnt SHEET
WarehouseOnline13-Jun-23.xlsm | bbf2-bb6e-45c3-b2da-d83ae8f93 | Fulham | 2023-05-15 00:00:00
WarehouseOnline13-Jun-23.xlsm | bbf2-bb6e-45c3-b2da-d83ae8f93 | Fulham | 2023-05-15 00:00:00
sBrent13-Jun-23.xlsm | f0c0-4d06-8cab-7c60a78bbb33 | Harlesden | 2023-05-30 00:00:00
Something different | f0c0-4d06-8cab-7c60a78bbb33 | Harlesden | 2023-05-30 00:00:00
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 10b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 2358526 | 10230907 | 645572 | 954677 | 586400 | 146112 | 413137 | 15335331
Cross-Currency Fixed-Fixed | 53999 | 180577 | 50496 | 31111 | 6947 | 25648 | 30933 | 379711
Cross-Currency Fixed-Float | 128178 | 298584 | 40905 | 58002 | 44972 | 13496 | 600938 | 1185075
TOTAL
Spreadsheet: 86647d1286572790-pivot-calculated-fields-pvtcalcfieldexample
Sheet: Sheet1

Dept | Budget | Actual
Dept1 | 456 | 400
Dept2 | 456 | 420
Dept3 | 456 | 430 |  |  |  | Data
Dept4 | 458 | 350 |  |  | Dept | Sum of Budget | Sum of Actual | Sum of Diff
Dept5 | 488 | 400 |  |  | Dept1 | 1076 | 915 | 161
Dept1 | 500 | 400 |  |  | Dept2 | 1116 | 935 | 181
Dept2 | 520 | 400 |  |  | Dept3 | 1216 | 945 | 271
Dept3 | 580 | 400 |  |  | Dept4 | 1248 | 865 | 383
Dept4 | 590 | 400 |  |  | Dept5 | 1273 | 915 | 358
Dept5 | 600 | 400 |  |  | Grand Total | 5929 | 4575 | 1354
Dept1 | 120 | 115
Dept2 | 140 | 115
Dept3 | 180 | 115
Dept4 | 200 | 115
Dept5 | 185 | 115
Spreadsheet: 221683d1363639479-convert-column-to-text-textjoin
Sheet: Sheet1

1
2
3
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 90751d1290508672-another-vlookup-problem-copy-of-stocktake-19-11-10
Sheet: Ltd Accessories

Item No. | Cumulative Qty
019-1030C | 0
019-1030N | 0
1200/02 | 0
151228 | 0
2009 | 140
38023 Rev.01 | 20
38024 Rev.01 | 26
38031 Rev.01 | 0
38032 Rev.01 | 20
4073 | 1
4080 | 0
41690 Rev.01 | 10
41691 Rev.01 | 0
41692 Rev.01 | 0
41693 Rev.01 | 0
4244/03 | 0
430402009-006 | 25
430402009-461 | 5
430402209-461 | 1
430402409-461 | 0
430402A09-461 | 0
4444/66 | 0
4503 | 126
500.015.000 | 0
6801 Rev.01 | 0
6802 Rev.01 | 33
6803 Rev.01 | 10
6805 Rev.01 | 0
6806 Rev.01 | 0
6807 Rev.01 | 10
8444/01 | 0
900MR030 | 19
900MR033 | 2
900MR042 | 0
900MR047 | 0
900MR050 | 0
900MR065 | 0
900MR066 | 10
900MR070 | 10
900MR071 | 0
900MR125 | 0
900MR126 | 0
900MR128 | 0
900MR130 | 0
900MR145 | 0
900MR146 | 0
900MR148 | 0
900MR170 | 0
900MR178 | 0
900MR510 | 0
900MR521 | 0
900MR522 | 0
900MR528 | 0
900MR532 | 3
900MR533 | 0
900MR534 | 0
900MR556 | 0
900MR558 | 0
900MR559 | 0
900MR561 | 0
900MR569 | 7
900MR747 | 0
900MR750 | 0
900MR751 | 18
900MR754 | 11
900MR755 | 0
900MR761 | 0
900MR780 | 0
900MR781 | 0
900MR801 | 0
900MR858 | 6
900MR860 | 0
900MR861 | 0
900MR869 | 0
9040/01 | 0
9066/01 | 0
9080/100 | 0
AG-AP0200 | 0
AG-AP1000 | 0
AG-AP1015 | 0
AG-AP1085 | 0
AG-AP6000-CH | 0
AG-AP6000-IN | 0
AG-AP6000-IT | 0
F710102 [NAME] | 1
F710213 Rev.04 | 20
F710213PKG Rev.04 | 0
F710214 Rev.04 | 4
F710513 [NAME] | 1
F710519 Rev.01 | 0
F710523 Rev.01 | 43
[NAME] | 10
F710542 Rev.00 | 0
F710561 [NAME] | 0
F710562 | 0
F710562 [NAME] | 3
F710563 [NAME] | 0
[NAME] | 0
[NAME] Rev.01 | 3
F730729 | 0
F730740 Rev.00 | 11
F730744 [NAME] | 2
F910034 [NAME] | 0
F910035 Rev.00 | 0
F910039-GB Rev.10 | 10
F910039-US Rev.07 | 0
F910202 [NAME] | 0
F910203 [NAME] | 0
F910203PKG [NAME] | 36
[NAME] | 2
F910204PKG Rev.00 | 14
F910255 Rev.05 | 68
F910260 [NAME] | 4
F910272 [NAME] | 0
[NAME] | 0
F910275 Rev.00 | 0
F910281 [NAME] | 0
F910321 [NAME] | 70
F910322 [NAME] | 0
F910355 [NAME] | 1
F940005 Rev.02 | 0
F-TUB/A/RE-01 Rev.00 | 1
F-TUB/A/RE-02 Rev.00 | 0
F-TUB/A/RE-03 1.8M | 0
F-TUB/A/RE-03 Rev.00 | 27
F-TUB/N/RE-01 Rev.00 | 11
F-TUB/N/RE-02 Rev.00 | 15
F-TUB/N/RE-03 Rev.00 | 11
F-TUB/P/RE-03 Rev.00 | 2
MR210 | 0
MR250 | 0
MR340E | 0
MR370 | 0
MR410AEU | 0
MR410JHU | 28
MR410JSU | 0
MR730AEU | 0
MR810AEU | 0
MR850AEK | 0
MR850AEU | 0
R100P02 | 0
R213P05 | 0
R300P06 | 0
RAM9102 | 2
RAM9103 | 2
RAM9104 | 10
RAM9125 | 0
RT020 | 0
RT126 | 0
Spreadsheet: 269201d1381029283-convert-time-to-numeric-value-schedule
Sheet: Sheet1

 | Schedule
 | NAME | Time In | Time Out | Shift length | Break
 | Associate A | 10:00:00 | 17:00:00 | 07:00:00 | 15
 | Associate B | 10:00:00 | 15:00:00 | 05:00:00 | 15
 | Associate C | 14:00:00 | 18:00:00 | 3 | 15
 | Associate D | 12:00:00 | 18:00:00 | 6 | 30
 | If the associate works a shift length of 5 or more hours they receive a 30 minute break, if they work less than 5 hours they receive a 15 minute break.
 | The formula =IF(D4>4.99,"30","15") will get me where I want if the number of hours is written in a numeric value vs a time value.
 | I am looking for a formula to determine the length of breaks that associates A & B receive OR help in how to convert the shift lengths from hours to a numeric value.
Spreadsheet: 52586d1252441834-parsing-a-city-name-when-its-concatenated-to-a-street-name-698679-parsing-a-city-name-when-its-concatenated-to-a-street-name-3-
Sheet: Sheet1

Original Text | Extract 1 | Final | Final(2)without helpercolumn E, F, G | Letter | Code | Position
4 Example WayOakland, CA 94601 | WayOakland | Oakland | Oakland | O | 79 | 4
5 Other WaySacramento, CA 99909 | WaySacramento | Sacramento | Sacramento | S | 83 | 4
6 Another WayNew York, NY98765 | WayNew York | New York | New York | N | 78 | 4
Spreadsheet: 668609d1584925197-show-column-data-to-corresponded-columns-q1
Sheet: Sheet1

 | Indent | Type | Part |  | Indent | Part | Part |  | 0 | 1 | 2 | 3 | 4 | 5 |  | In G, I have Column D, SortBy : B ascending and C descending
 | 0 | Y | 1234 |  |  |  |  |  | 1234 | 1254 | 2233 |  |  |  |  | I want please : "0" not to appear in G and put G in corresponded column F to columns I2:N2
 | 1 |  | 2222 |  |  | 1119 |  |  | 1119 | 4499 | 9922
 | 1 | Y | 1254 |  |  | 1254 |  |  |  | 1254 | 1765
 | 2 |  | 9999 |  |  | 4499 |  |  |  | 4466 | 9999
 | 2 |  | 1765 |  |  | 2222 |  |  |  |  | 9991
 | 2 | Y | 2233 |  |  | 4466
 | 2 | Y | 9922 |  |  | 2233
 | 1 |  | 4466 |  |  | 9922
 | 1 | Y | 4499 |  |  | 9999
 | 0 | Y | 1119 |  |  | 1765
 | 2 |  | 9991 |  |  | 9991
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Spreadsheet: 1f554711-4ef6-4d01-8558-cf4264bceafc
Sheet: Sheet1

Scholarship | Criteria | Contact | Deadline | Amount
Baptist Hospital East | Student must be accepted in the nursing program. Acceptance letter must be attached to application. Maintain 3.0 GPA. Six months commitment of employment for every $2,500 of assistance. Promissory notes will be completed each time money is paid. | [NAME]; 896-7581; [EMAIL] |  | $5,000 per year
CARITAS Nursing Award | Offers up to $6,000 per year to nursing students at am accreditated institution for tuition and other college-related expenses. The amount awarded is dependent upon the cost of tuition for one year at the school you are attending. Once accepted, recipients sign an agreement to work for CARITAS for one year for each academic year you receive scholarship support. This scholarship is given based on academic achievement, a demonstrated desire to become a nurse and the quality of the application/references. | [NAME]; CARITAS Foundation; 1850 Bluegrass Avenue; Louisville, KY 40215; [PHONE]; FAX: [PHONE]
CARITAS Bellarmine Nursing Award | For nursing students accepted into the Accelerated BSN Program at Bellarmine University. It provides $9,000 to defray the cost of tuition. In exchange for this generous financial aid, the recipient agrees to a two-year work commitment at CARITAS upon graduation. This scholarship is given based on academic achievement, a demonstrated desire to become a nurse, and the quality of the application/references. | [NAME]; CARITAS Foundation; 1850 Bluegrass Avenue; Louisville, KY 40215; [PHONE]; FAX: [PHONE]
[NAME] | Award covers tuition, fees, and books. Students must maintain an overall GPA of 3.0. Student must commit to a year of employment w/ [NAME] for every year of scholarship | Submit applications to [NAME]; Director of Education and Research; [NAME]; 1220 Missouri Avenue; Jeffersonville, IN 47130; Questions may be directed to [PHONE] or [NAME]; [NAME], [NAME]; 1220 Missouri Avenue; Jeffersonville, IN 27130; [PHONE]; fax ([PHONE]; [EMAIL] | No deadline to apply; scholarships are awarded at the beginning of Fall, Spring, and Summer semester. | Up to $6,000 per year
Hardin Memorial Hospital |  | [NAME]; [PHONE]; [EMAIL]
Jewish Hospital | Instructions for the educational loan process is included in the application. | [NAME]; (502) 540-3817; application can be submitted online at the website: [NAME] | There is no dealline; committee meets monthly; students hear within a week of meeting. | $6,000 to 24,000
Norton Healthcare | Must meet for interview | [NAME]; 662-0003; [EMAIL]
University of Louisville |  | [NAME]; [PHONE]; [EMAIL]
Spreadsheet: louise_kitchen__23836__lkitchen
Sheet: Sheet1

West Middle Market:  Mid-Year Summary
Origination Metrics | [NAME]
 | Coverage Origination | Services Origination | Total Origination
Choi | 8663463.44921987 | 0 | 8663463.44921987
Krebs | 9742218.837593162 | 0 | 9742218.837593162
Rosman | 7094465.072792638 | 0 | 7094465.072792638
Malowney | 2105422.146124979 | 0 | 2105422.146124979
[NAME] | 975377.1664260544 | 1394467 | 2369844.166426054
Wolfe | 5430413.890471738 | 0 | 5430413.890471738
[NAME] | 1914253.748608625 | 0 | 1914253.748608625
Rawson | 5933.489198577118 | 3559574 | 3565507.489198577
Scholtes | 1681165.811987375 | 0 | 1681165.811987375
Cocke | 27557.87804513807 | 723036 | 750593.8780451381
Ward | 1756.509531846394 | 0 | 1756.509531846394
Total | 37642028.00000001 | 5677077 | 43319105.00000001
Spreadsheet: 69960d1270620114-pulling-data-from-another-sheet-with-drop-down-menu-testsports-2-
Sheet: Sheet1

Name:
Date:
Address:
Pick a sport: | NBA
Who will win the next title? | Celtics
5 | rows
2010-03-01 00:00:00 | @ | Celtics | CELTICS
2010-03-02 00:00:00 | vs | Cavaliers | CELTICS
2010-03-03 00:00:00 | vs | Magic | CELTICS
2010-03-04 00:00:00 | @ | Spurs | CELTICS
2010-03-05 00:00:00 | @ | Nets | CELTICS
Spreadsheet: 807426d1669899386-conditional-formatting-multiple-text-values-sample-1-
Sheet: Sheet1

[NAME]
2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00
 |  | EM | EM | N | N | N |  | Im trying to format 1 cell to be green(red if not) if the range of cells under contains: 2 or more with text "MF" & 2 or more with the text "S" & 4 or more with the text "B" & 1 or more with the text "K".
MF | MF | MF | MF | MF | MF | MF
S | MF | B | B | B | B | B
S | S | MF | MF | MF | MF | MF
S | S | B | B | B | B | B
S | B | B | B | B | B | B
B | B | S | S | S | S | S
B | B | S | S | S | S | S
K | K | MF | MF | MF | MF | MF
K | K | K | K | K | K | K
K | K | B | B | B | B | B
Spreadsheet: f045883b-f911-4466-92e4-a0af26deee25
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
FOOD3 | Test | FOOD3 | Food-Vegetable Panel | Food-Vegetable Panel | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
FOOD3 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FOOD3 | Result | FOOD3 | Food-Vegetable Panel | Food-Vegetable Panel | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 46711-8
Spreadsheet: 845495d1696998688-copy-formulas-and-format-from-existing-row-to-a-new-row-my-gites
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Date d'arriver | Date de départ | Gite No. | Duration | Prix par jour | Prix de Séjour | No. Adultes | No. D'enfants | Ménage | Serviettes | Taux de Taxe | Totale Tax | Total Prix | Acompte 1 | Méthod | Acompte 2 | Méthod | [NAME] | A Payé | Payé? |  |  | SPILL Zone for available rooms
1 [NAME] |  | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 10 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 9 | 11
2 Bruce Springsteen |  | Direct | 2024-01-02 00:00:00 | 2024-01-07 00:00:00 | 2 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 9 | 11
4 [NAME] |  | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 12 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 9 | 11
4 [NAME] |  | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 8 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 9 | 11
4 [NAME] |  | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 3 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 9 | 11
6 [NAME] |  | Booking | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 4 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 9 | 11
Spreadsheet: 684695d1593505066-function-to-move-value-from-cell-to-cell-based-on-matches-test-ark
Sheet: Page1

[NAME] |  |  |  |  |  |  | ITEM
11111 | Ref1 |  | 2020-06-30 00:00:00 | 2020-06-15 00:00:00 | Option1 |  | ITEM1
22222 | Ref2 |  |  |  | Option2 |  | ITEM2
33333 | Ref3 |  | 2020-06-22 00:00:00 | 2020-06-25 00:00:00 | Option1 |  | ITEM2 | ITEM3
 | Wish: Need a code in "Page2" B2, B4, [NAME] etc to fill down. If [NAME] matches a value in Page1-H-I-J-K-L etc it should copy the value from column A of the same row to the same item in page 2.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Option1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Option2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Example I have made where you see 11111 and 33333 is on [NAME] because [NAME] is Option1. When Option1 is changed to Option2 it should clear the cell on Page 2.
Spreadsheet: chris_germany__1779__200004strg
Sheet: Strg Rules

FSS Cheat Sheet
INJECTIONS: STORAGE GAS LOSS RETAINAGE APPLIES
MMIQ (Maximum Monthly Injections Quantity) |  |  |  |  | SCQ = | 6050607
 |  | % of SCQ | MMIQ | 1.05
April |  | 0.15
May - Aug |  | 0.2
Sept |  | 0.13
Oct |  | 0.07
Nov |  | 0.05
Dec - Mar |  | 0.1
If 105% MMIQ is exceded a penatly of $5.00/dkt for all quantitiels injected in excess of 105% of its
MMIQ will be assessed.
MDIQ (MAXIMUM DAILY INJECTION QUANTITY)
MMIQ/30 | For November & December
MMIQ/25 | For Rest of the Months
 | April | May-Aug | Sept | Oct | Nov | Dec | Jan-Mar
MDIQ
110%MDIQ
If 110% of MDIQ is exceeded a penalty of $5.00 per dth for all quantities injected in excess of 110%
of its MDIQ will be assessed.
WITHDRAWALS: MDWQ BASED UPON AND LIMITED BY SCQ INVENTORY
REMAINING IN STORAGE.
% of SCQ in Inventory |  |  |  | MDWQ as % of MDSQ |  |  | MDSQ = | 108648
100% to 30% |  |  |  | 1
less than 30% to 20% |  |  |  | 0.8
less than 20% to 10% |  |  |  | 0.65
less than 10% to 0% |  |  |  | 0.5
If 103% of MDWQ is exceeded a penalty of $10.00 per dkt for all quantitites withdrawn in excess
of 103% of its MDWQ will be assessed.
Minimum and [NAME] net withdrawal for November thru March
 |  | Min % |  |  | [NAME]
Month |  | of SCQ |  |  | of SCQ
November |  | none |  |  | 0.4
December |  | none |  |  | 0.4
January |  | none |  |  | 0.4
February |  | 0.1 |  |  | 0.3
March |  | 0.1 |  |  | 0.2
If monthly net withdrawal exceeds applicable limits a penalty of $5.00 per dkt for all quantities
withdrawn in excess of such limits will be assessed.
INVENTORY: |  | no more than x% in SCQ in storage
April 1st |  | 0.25
February 1st |  | 0.65
June 30th |  | 0.6
August 31st |  | 0.85
Spreadsheet: 762216d1641459252-if-cell-contains-product-name-then-count-all-the-cells-that-contain-the-letter-a-sample
Sheet: Sales (2)

 |  |  |  | ACTIVE ( a ) | DEAD ( d ) | LOST ( l ) | CONVERTED ( c ) | TOTAL
 |  |  | TEFLON - PTFE
 |  |  | NYLON - PA
 |  |  | ACETAL - POM
 |  |  | POLYESTER - PET
 |  |  | [NAME]'S
 |  |  | POWER TRANS
 |  |  | CONPRO
 |  |  | Totals
STATE | DATE | CUSTOMER | PRODUCT | [NAME] | QUANTITY | EST VALUE $ | PROJECT NAME | COMPETITORS | 2020
 |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
QLD | 2021-08-24 00:00:00 |  | CONPRO | STEEL ROLLERS | 8 | 8000 | ROLLER REPLACE | Other
 |  |  | CONPRO |  |  |  |  |  |  |  | a | d | c | l
 |  |  | ACETAL - POM |  |  |  |  |  |  |  | d |  |  |  |  |  | l
 |  |  | POWER TRANS | RELAG WHEELS |  |  |  |  |  | a | d |  |  |  |  |  |  | d
 |  |  | POLYESTER - PET | BUMP STOPS
 |  |  | TEFLON - PTFE | GUIDES |  |  |  |  |  | a | a |  | d | l | c | c |  |  | l
Spreadsheet: 48696d1247951406-compare-columns-solved-columnsexample-2-
Sheet: First way

 | Column1 | helper | Column2 | Column3
 | 2 | 0 | 1 | 659
 | 5 | 2 | 2 | 759 |  | 2967.886904761906
 | 6 | 3 | 3 | 859
 | 9 | 0 | 4 | 236
 | 10 | 5 | 5 | 234
 | 3 | 6 | 6 | 523
 | 15 | 0 | 7 | 6236
 | 18 | 0 | 8 | 2342
 |  | 9 | 9 | 3525.07142857143
 |  | 10 | 10 | 3979.30952380953
 |  | 0 | 11 | 4433.54761904762
 |  | 0 | 12 | 4887.78571428572 |  |  |  |  |  |  |  | I want to average only the values in column 3 that correspond to values in column 1
 |  | 0 | 13 | 5342.02380952381
 |  | 0 | 14 | 5796.26190476191
 |  | 15 | 15 | 6250.5
 |  | 0 | 16 | 6704.7380952381 |  |  |  |  |  |  |  | Thanks a lot =)
 |  | 0 | 17 | 7158.97619047619
 |  | 18 | 18 | 7613.21428571429
 |  | 0 | 19 | 8067.45238095238
 |  | 0 | 20 | 8521.69047619048
 |  | 0 | 21 | 8975.92857142857
 |  | 0 | 22 | 9430.16666666667
 |  | 0 | 23 | 9884.40476190477
 |  | 0 | 24 | 10338.6428571429
 |  | 0 | 25 | 10792.880952381
 |  | 0 | 26 | 11247.1190476191
 |  | 0 | 27 | 11701.3571428572
 |  | 0 | 28 | 12155.5952380953
 |  | 0 | 29 | 12609.8333333334
 |  | 0 | 30 | 13064.0714285715
 |  | 0 | 31 | 13518.3095238096
 |  | 0 | 32 | 13972.5476190477
 |  | 0 | 33 | 14426.7857142857
 |  | 0 | 34 | 14881.0238095238
 |  | 0 | 35 | 15335.2619047619
 |  | 0 | 36 | 15789.5
 |  | 0 | 37 | 16243.7380952381
 |  | 0 | 38 | 16697.9761904762
 |  | 0 | 39 | 17152.2142857143
Spreadsheet: 3c4f4044-cd1b-43e9-ab46-e3e06546206a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table 10--Acreage, yield, and production estimates, 2011
State/region | Planted |  | Harvested |  | Yield |  | Production
 |  |  |  |  | Pounds/
 | -- 1,000 acres -- |  |  |  | [NAME] |  | 1,000 bales
Upland:
Alabama | 460 |  | 440 |  | 731 |  | 670
Florida | 122 |  | 120 |  | 712 |  | 178
Georgia | 1600 |  | 1520 |  | 853 |  | 2700
North Carolina | 810 |  | 800 |  | 702 |  | 1170
South Carolina | 305 |  | 303 |  | 776 |  | 490
Virginia | 116 |  | 115 |  | 835 |  | 200
Southeast | 3413 |  | 3298 |  | 787 |  | 5408
Arkansas | 680 |  | 660 |  | 996 |  | 1370
Louisiana | 295 |  | 285 |  | 893 |  | 530
Mississippi | 630 |  | 605 |  | 960 |  | 1210
Missouri | 375 |  | 365 |  | 1131 |  | 860
Tennessee | 495 |  | 490 |  | 823 |  | 840
Delta | 2475 |  | 2405 |  | 960 |  | 4810
Kansas | 78 |  | 67 |  | 595 |  | 83
Oklahoma | 415 |  | 100 |  | 504 |  | 105
Texas | 7550 |  | 3200 |  | 600 |  | 4000
Southwest | 8043 |  | 3367 |  | 597 |  | 4188
Arizona | 250 |  | 248 |  | 1510 |  | 780
California | 182 |  | 181 |  | 1485 |  | 560
New Mexico | 68 |  | 63 |  | 952 |  | 125
West | 500 |  | 492 |  | 1429 |  | 1465
Total Upland | 14431 |  | 9562 |  | 797 |  | 15871
Pima:
Arizona | 11 |  | 11 |  | 873 |  | 20
California | 260 |  | 259 |  | 1269 |  | 685
New Mexico | 3 |  | 3 |  | 832 |  | 5
Texas | 15 |  | 15 |  | 894 |  | 27
Total Pima | 289 |  | 288 |  | 1231 |  | 737
Total all | 14720 |  | 9850 |  | 809 |  | 16608
Last update: 10/13/11.
Source:  USDA, October 2011 Crop Production report.
Spreadsheet: 95249d1294875935-populate-a-table-from-another-two-columns-sheet-joshua123-ef759674-sdg12
Sheet: Instructions

Yesterday, 10:20 PM
ReorgData - Populate a Table from another two columns sheet - joshua123 - EF759674 - SDG12.xls | joshua123 - EF759674 - SDG12.xls
Registered User   Join Date: 11 Jan 2011
Location: INA
MS Office Version:Excel 2003
Posts: 2
Populate a Table from another two columns sheet
http://www.excelforum.com/excel-general/759674-populate-a-table-from-another-two-columns-sheet.html
Hi guys, could you help me to solve this problem.
You see I want to populate my table in the first sheet:
 | Sheet1 | A | B |  | Results | A | B | C | D | E | F | G
 | 4 | ANNEX |  |  | 1 |  | X001 | X002 | X003 | X004 | X005 | X006
 | 5 |  |  |  | 2 | ANNEX |  | 4 |  |  | 3
 | 6 | X002 | 4 |  | 3 | AXIS
 | 7 | X005 | 3 |  | 4 | BRAVO | 7 | 2 |  |  | 1 | 10
 | 8 | BRAVO |  |  | 5 | ROMEO
 | 9 |  |  |  | 6 | THE JEG |  |  | 8
 | 10 | X001 | 7
 | 11 | X002 | 2
 | 12 | X005 | 1
 | 13 | X006 | 10
 | 14 | THE JEG
 | 15
 | 16 | X003 | 8