tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 182497d1348504190-help-need-with-calculating-data-based-off-drop-down-list-test_scorecard_1
Sheet: Monday

Dell@ Daily Tracker/Dashboard
Store: | Sale |  |  |  |  |  |  |  |  |  |  |  |  | DPA |  |  | Quotes |  |  |  | Business Leads
 |  |  |  |  |  |  |  |  |  |  | Goal 2.0 |  |  | Goal 50% |  |  | Goal is 25 per day, with 60% emailed.
Associates Name | Customer | DPID | Dell.com | Inventory | Lost Sale | What Reason | Total | Revenue | System | Model | SnP | Warranty | [NAME] | Enroll     No | [NAME] | [NAME] Declined | [NAME] | [NAME] | Other Quote | Total Quote | Business Name | System total | Rep Assisting
Totals
Spreadsheet: sally_beck__33721__Enron Japan Contact List
Sheet: Sheet1

Enron - Japan Team
Member | Office Phone | [NAME] | Home Phone | email address | Assistant
[NAME], [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Anai, [NAME] | 813-5404-3816 |  |  | [EMAIL]
Aronowitz, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Beck, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
[NAME], Jan-Erland | 4-723-102-515 | 4-795-210-844 | 4-722-434-376 | [EMAIL]
Brelsford, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Dayao, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]4532
Eubanks, Archie | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Flores, Nony | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Gilchrist, Scott | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Grimes, [NAME] | 813-5404-3816 |  | 813-3794-7756. | [EMAIL]
Halliburton, [NAME] | [PHONE] | - | [PHONE] | [EMAIL] | [NAME] [PHONE]
Hirl, [NAME] | 813-5404-3818 | 614-1984-8629 | 813-5261-0652 | [EMAIL] | [NAME]
Mason, [NAME] | 612-9229-2335 | [PHONE] | 612-9420-9087 | [EMAIL]
Musch, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
O'Day, [NAME] | 813-5404-3820 | 813-9040-679-870 | 813-5261-0539 | nicholas.o'[EMAIL]
[NAME], [NAME] | [PHONE] | [PHONE]- Pgr. | [PHONE] | [EMAIL] | [NAME]5586
[NAME], [NAME] | [PHONE] | - | [PHONE] | [EMAIL]
[NAME], [NAME] | 813-5404-3814 | 81-090-4811-5855 | 813-5261-0286 | [EMAIL]
Robles, Eddie | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Schultz, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
[NAME], [NAME] | 612-9229-2308 | 0413-450-268 | 612-9665-4460 | [EMAIL] | Kristy Noyce 612-9229-2300
Viverito, [NAME] | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Whitehead, [NAME] | [PHONE] | 44-467-621-696 | [PHONE] | [EMAIL] | [NAME]
Wilson, Shona | [PHONE] | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Japan Office: Secretary - Ono-San -  813-5404-3816, Fax 813-5404-3401
Spreadsheet: 525714d1498845909-formulas-to-sum-distinct-values-with-condition-any-and-all-sample-c
Sheet: Formulas

Location | No. of Distinct Names | No. of Distinct Names with 1 or more cat. 'B' | No. Of Distinct Names with only cat. 'A' |  | Answer Key 1+ 'B': | Answer 'A' Only:
 |  | B | A
East |  |  |  |  | 2 | 1
North |  |  |  |  | 2 | 0
South |  |  |  |  | 1 | 1
West |  |  |  |  | 3 | 1
Spreadsheet: 203545d1357159602-dropdown-menu-help-data-example
Sheet: Product Comparison

 |  | Product 1 | Product 2 | Product 3 | Product 4
 | Company
 | Category
 | P/N #
 | Product Name
 | # of Ports
 | Target I/O Type (KVM Side)
 | Target I/O Type (Server Side)
 | Target Cables Included
 | Cat Distance ([NAME])
 | # of Local Users
 | Console I/O Type
 | # of Monitors Supported
 | [NAME]
 | Aspect [NAME]
 | Contrast Ratio
 | Brightness Value
 | [NAME]
 | Viewing Angle
 | Rail System
 | Optical Drive
 | nVidia 3D Support
 | IP Support
 | # of Remote Users
 | [NAME]
 | [NAME]. # of Targets via [NAME]
 | Rack Mountable
 | Includes [NAME]
 | Unit (U) Height
 | Built-In USB Hub
 | CAC Support
 | VM Support
 | [NAME]
 | Dedicated Processors
 | Memory Buffer
 | Secure EDID Channels
 | Restricted USB
 | High-Retention USB Ports
 | Audio Support
 | Audio Channel
 | Microphone Support
 | Push Button Support
 | OSD Support
 | Hotkey Switching
 | Password Protection
 | [NAME]
 | PC Support
 | [NAME]
 | [NAME]
 | Sun Support (USB)
 | Height
 | [NAME]
 | Length (Depth)
 | Weight
 | Operating Temp
 | Storage Temp
 | Operating Humidity
 | Operating Voltage
 | Input Power
 | Video Resolution ([NAME])
 | Compliance/Certification
 | [NAME]
 | Protection Profile
 | TAA Compliant
 | Warranty
Spreadsheet: 863842d1711225007-exchanging-no-s-for-names-examplebook1golf
Sheet: Sheet2

player 1 |  | player 1 |  | player 7
player 2 |  | player7
player 3
player 4 |  | player 2 |  | player 2 |  | player 2
player 5 |  | player5 |  |  |  |  |  |  |  | these players corespond to the list in sheet 1
player 6 |  |  |  |  |  |  |  | player 8
player 7 |  | player 3
player 8 |  | [NAME] |  | player 4 |  | player 8
 |  | player 6
 |  | player 8 |  | player 8
Spreadsheet: 140597d1328813010-find-friday-on-which-maximum-number-of-widgits-occurred-maxdatetest
Sheet: Sheet1

Friday | Widgits |  | Two named ranges:  Friday, and Widgits
2010-01-01 00:00:00 | 64 |  | I already have the formula for finding the largest number of widgets.
2010-01-08 00:00:00 | 49 |  | Need formula for getting the date when the largest number of widgets occurred.
2010-01-15 00:00:00 | 57
2010-01-22 00:00:00 | 88 |  | The largest number of widgits | 92 | {=MAX(IF(ISNA(Widgits),0,Widgits)))       (ARRAY FORMULA)
2010-01-29 00:00:00 | 79 |  | Occurred on | 2010-02-05 00:00:00
2010-02-05 00:00:00 | 92
2010-02-12 00:00:00 | 86
2010-02-19 00:00:00 | 57
2010-02-26 00:00:00 | 73
2010-03-05 00:00:00 | 82
2010-03-12 00:00:00 | #N/A
2010-03-19 00:00:00 | #N/A
2010-03-26 00:00:00 | #N/A
2010-04-02 00:00:00 | #N/A
2010-04-09 00:00:00 | #N/A
2010-04-16 00:00:00 | #N/A
2010-04-23 00:00:00 | #N/A
2010-04-30 00:00:00 | #N/A
2010-05-07 00:00:00 | #N/A
2010-05-14 00:00:00 | #N/A
2010-05-21 00:00:00 | #N/A
2010-05-28 00:00:00 | #N/A
2010-06-04 00:00:00 | #N/A
2010-06-11 00:00:00 | #N/A
2010-06-18 00:00:00 | #N/A
2010-06-25 00:00:00 | #N/A
Spreadsheet: 150809d1334685338-conditional-formatting-by-drawing-data-from-two-cells-practice
Sheet: Sheet1

Schedule
2012-04-09 00:00:00
PROJECT | JOB NUM | Design Team |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Date | End Date |  | 2012-04-09 00:00:00 |  | - | 2012-04-13 00:00:00 |  | 2012-04-16 00:00:00 |  | - | 2012-04-20 00:00:00 |  | 2012-04-23 00:00:00 |  | - | 2012-04-27 00:00:00 |  | 2012-04-30 00:00:00 |  | - | 2012-05-04 00:00:00 |  | 2012-05-07 00:00:00 |  | - | 2012-05-11 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00
Project 1 | 1 |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  | 04/10/2012 | 04/13/2012 |  | 1900-01-01 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-04 00:00:00 | 2012-05-04 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00
Project 2 | 2 |  |  |  |  |  |  |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-04 00:00:00 | 2012-05-04 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00
Project 3 | 3 |  |  |  |  |  | X |  | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-04 00:00:00 | 2012-05-04 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00
Spreadsheet: 837948d1690548751-get-values-from-connected-columns-in-excel-based-on-multiple-criteria-28072023-excel-forum
Sheet: Sheet1

Result columns
GOPENH | EWS | Fileds | Data field |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | helper1 | helper2
 |  | 1003 - Government College of Pharmacy 10031 - Pharm D ( Doctor of Pharmacy) |  | GOPENH |  | GSCH |  | GSTH |  | GVJH |  | GNT1H | GNT2H | GOBCH | LOPENH | LSCH | [NAME] | PWDOPENH | PWDRSCH
 |  | 1003 - Government College of Pharmacy 10031 - Pharm D ( Doctor of Pharmacy) |  | 2743 (96.1745367) |  | 4497 (94.1671647) |  | 9109 (89.3679174) |  | 2848 (96.0660092) |  | 3478 (95.3035568) | 4410 (94.2772446) | 4288 (94.3395273) | 1421 (97.8307797) | 4054 (94.6439628) | 3662 (95.0597286) | 16794 (81.2142273) | 17491 (80.4712960)
 |  | 1003 - Government College of Pharmacy 10031 - Pharm D ( Doctor of Pharmacy)
 |  | State Level |  | DEFOPENS |  | EWS
 |  | State Level |  | 4890 |  | 1249
 |  | State Level |  | -93.7076961 |  | -98.0573819
 |  | State Level
 |  | 1003 - Government College of Pharmacy 10031 - Pharm D ( Doctor of Pharmacy) |  | GOPENH |  | GSCH |  | GSTH |  | GVJH |  | GNT1H | GNT2H | GNT3H | GOBCH | LOPENH | LSCH | LSTH | [NAME] | PWDOPENH | PWDROBCH
 |  | 1003 - Government College of Pharmacy 10031 - Pharm D ( Doctor of Pharmacy) |  | 946 (98.4409244) |  | 2395 (96.6092771) |  | 12246 (85.7120925) |  | 1468 (97.7839057) |  | 2283 (96.7401872) | 1454 (97.7984245) | 1674 (97.4944320) | 1071 (98.2424768) | 623 (98.8942020) | 2197 (96.8146159) | 9199 (89.0749561) | 672 (98.8214555) | 10066 (88.0979149) | 13279 (84.6831342)
 |  | 1003 - Government College of Pharmacy 10031 - Pharm D ( Doctor of Pharmacy)
 |  | State Level |  | DEFOPENS |  | TFWS |  | DEFROBCS |  | EWS |  | ORPHAN
 |  | State Level |  | 3101 (95.7300057) |  | 316 (99.3722764) |  | 4880 (93.7076961) |  | 1021 (98.3387194) |  | 49705 (36.3808258)
 |  | State Level
 |  | 1115 - Mandela's Institute of Pharmacy |  | GOPENH |  | GSCH |  | GSTH |  | GVJH |  | GNT1H | GNT2H | GNT3H | GOBCH | LOPENH | LSCH | LSTH | [NAME]
 |  | 1115 - Mandela's Institute of Pharmacy |  | 10006 (88.1048795) |  | 15353 (82.5723830) |  | 16484 (81.6073162) |  | 10265 (87.9411764) |  | 11934 (86.1344749) | 15159 (82.9026150) | 42866 (49.8329621) | 12909 (85.1325805) | 3578 (95.2218601) | 13648 (84.4789798) | 31102 (66.0248119) | 5984 (92.4743268)
 |  | 1115 - Mandela's Institute of Pharmacy
 |  | State Level |  | DEFOPENS |  | TFWS |  | EWS
 |  | State Level |  | 11530 |  | 5516 |  | 6729
 |  | State Level |  | -86.5205507 |  | -93.0508899 |  | -91.7036962
 |  | State Level
Spreadsheet: 212352d1360099917-data-on-one-sheet-sorted-on-another-testfinal
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | s
a | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
b | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
c | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
d | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
e | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
f | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
g | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
h | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 708906d1608068409-if-vlookup-formula-if-vlookup-formula
Sheet: INW Table

[NAME] these table to the INW leadership team:  [NAME], [NAME], [NAME].  Confirm cost centers match from Upload tab and totals tie
Admissions |  |  |  | Observations |  |  |  | Newborns
Cost Center | Department Name | Admissions |  | Cost Center | Department Name | Observations |  | Cost Center | Department Name | Newborns
Deaconess |  |  |  | Deaconess |  |  |  | Deaconess
2160100 |  |  |  | 2160100 |  |  |  | 2170100 | DHS [NAME]
2160150 |  |  |  | 2160150
2160160 |  |  |  | 2160170
2160170 |  |  |  | 2160175
2160175 |  |  |  | 2160725
2160725 |  |  |  | 2160750
2160750 |  |  |  | 2160760
2160760 |  |  |  | 2161000
2161000 |  |  |  | 2170100
2170100 |  |  |  | 2170210
2170210 |  |  |  | 2170240
2171150
Sub-Total | Deaconess |  |  | Sub-Total | Deaconess |  |  | Sub-Total | Deaconess
Valley |  |  |  | Valley |  |  |  | Valley
2260100 |  |  |  | 2260100 |  |  |  | 2261000 | VHS BIRTH CENTER
2260710 |  |  |  | 2260710
2260760 |  |  |  | 2260760
2261000 |  |  |  | 2261000
2270200 |  |  |  | 2270200
2270210 |  |  |  | 2270210
2272300 |  |  |  | 2272300
Sub-Total | Valley |  |  | Sub-Total | Valley |  |  | Sub-Total | Valley
Total |  |  |  | Total |  |  |  | Total
Spreadsheet: 888998d1739643196-how-to-do-time-based-chart-drain
Sheet: Sheet1

Date | Time | Right | Left
2025-02-12 00:00:00 | 18:30:00 | 75 | 63
2025-02-12 00:00:00 | 20:48:00 | 23 | 50
2025-02-13 00:00:00 | 03:44:00 | 45 | 50
2025-02-13 00:00:00 | 14:10:00 | 35 | 45
2025-02-14 00:00:00 | 00:05:00 | 30 | 35
2025-02-14 00:00:00 | 21:30:00 | 25 | 25
2025-02-15 00:00:00 | 10:10:00 | 30 | 30
Spreadsheet: 79057d1279288636-delete-duplicate-add-values-in-cell-testing-draft
Sheet: Problem

Column 1 | Column 2 | Column 3 | Column 4 | Column 5
AA | test | 3 | music | 10
AB | test | 5 | game | 10
AA | test | 3 | music | 7
AC | xbox | 2 | melody | 4
SE | bad | 5 | music | 6
WW | good | 5 | game | 8
SE | bad | 5 | music | 5
AB | high | 11 | video | 5
SE | bad | 5 | music | 8
Spreadsheet: 781514d1653389896-array-formula-which-isnt-populating-further-down-the-sheet-sample-workbook
Sheet: Sheet1

Project Name | M-Pod Type | Materials Needed
[NAME]
[NAME]
Spreadsheet: 112001d1308207525-database-with-seperate-catagories-database-with-seperate-catagories
Sheet: Category 1

Type a category |  | Total Count
Category 1 |  | 20
Row # | Name | Address | Category
1 | Name 1 | Address 1 | Category 1
3 | Name 3 | Address 3 | Category 1
4 | Name 4 | Address 4 | Category 1
6 | Name 6 | Address 6 | Category 1 |  |  | If you want to create separate sheet,
7 | Name 7 | Address 7 | Category 1 |  |  | Copy sheet & just change the Category
8 | Name 8 | Address 8 | Category 1
10 | Name 10 | Address 10 | Category 1
11 | Name 11 | Address 11 | Category 1
13 | Name 13 | Address 13 | Category 1
14 | Name 14 | Address 14 | Category 1
18 | Name 18 | Address 18 | Category 1
21 | Name 21 | Address 21 | Category 1
24 | Name 24 | Address 24 | Category 1
27 | Name 27 | Address 27 | Category 1
29 | Name 29 | Address 29 | Category 1
32 | Name 32 | Address 32 | Category 1
34 | Name 34 | Address 34 | Category 1
42 | Name 42 | Address 42 | Category 1
46 | Name 46 | Address 46 | Category 1
54 | Name 54 | Address 54 | Category 1
Spreadsheet: 60bf70e0-6a0e-4e67-8f00-77fc272fe126
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
ADMFX | Test | ADMFX | ADAMTS13 Activity Assay | ADAMTS13 Activity Assay | Only orderable as part of a profile. For further information see ADM13/61212 ADAMTS13 Activity and Bethesda Inhibitor [NAME]. |  |  |  |  |  | Only orderable as part of a profile. For further information see ADM13/61212 ADAMTS13 Activity and Bethesda Inhibitor [NAME]. | 2 mL | Hemolysis 	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | ADAMTS13 ACTIVITY ASSAY > or =70% |  |  |  |  |  |  |  |  |  | Rochester
ADMFX | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
ADMFX | Result | 61211 | ADAMTS13 Activity Assay | ADAMTS13 Activity Assay | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 00adc676-063c-41b2-a9ec-010de8fa2766
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 12/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
Sep | 27.9925 | 29.035 | 30.2975 | 30.985 | 23.25999999999998 | 24.21999999999998 | 30.85 | 34.85 | 21.375 | 23.375
Oct | 26.7825 | 28.555 | 29.0875 | 30.385 | 22.62999999999998 | 23.04999999999998 | 30.85 | 34.85 | 21.375 | 23.3765
Nov | 26.8975 | 28.34 | 29.2025 | 30.17 | 20.04999999999998 | 22.23999999999998 | 30.85 | 35.35 | 21.375 | 23.375
Dec | 25.74 | 28.34 | 28.045 | 30.17 | 20.88999999999998 |  | 30.85 | 35.35 | 21.375 | 23.375
Jan | 24.855 |  | 26.555 |  | 19.89999999999998 |  | 34.85 |  | 23.375
Feb | 26.39833333333333 |  | 30.37 |  | 21.39999999999998 |  | 33.85 |  | 23.375
Mar | 26.1675 |  | 27.92 |  | 21.78999999999998 |  | 35.85 |  | 23.375
Apr | 25.5175 |  | 27.545 |  | 22.08999999999998 |  | 34.85 |  | 23.375
May | 24.485 |  | 26.7675 |  | 21.33999999999998 |  | 34.85 |  | 23.375
Jun | 24.295 |  | 25.995 |  | 21.24999999999998 |  | 34.85 |  | 23.375
Jul | 28.345 |  | 30.045 |  | 20.64999999999998 |  | 35.35 |  | 23.375
Aug | 30.4625 |  | 32.1625 |  | 24.09999999999998 |  | 34.85 |  | 23.375
Mkt year 2/ | 26.49486111111111 |  | 28.66604166666667 |  | 21.61249999999998 |  | 33.55833333333334 |  | 22.70833333333333
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 12/11/2012
Spreadsheet: 812154d1672997723-formula-to-duplicate-cell-content-from-multiple-columns-on-one-sheet-onto-separate-sheet-pick-list
Sheet: Pick List

Item | Category | Description
All item names different. | Category can be the same or vary | Product description here to be copied over to 'output' sheet
B | 1,2 | Product B Description
C | 1 | Product C Description
D | 1,2,3 | Product D Description
E | 1 | Product E Description
F | 1 | Product F Description
G | 1,2,3 | Product G Description
List will be extensive
Spreadsheet: 287352d1388764017-using-drop-downs-to-act-as-switches-switches
Sheet: Switch Model

OP | FE_P | OP | £
FE_P |  | £
NW |  | MP
 |  | S | R | Y1 | Y2 | Y3 | Y4 | Y5
Spreadsheet: 856445d1705678634-counting-cells-that-meet-multiple-criteria-book1
Sheet: Sheet1

DWANEY MILLS |  |  |  |  |  |  |  |  |  | DM
[NAME] |  |  |  |  |  |  |  |  |  | RM |  |  |  |  | V |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | SW |  |  |  |  | V |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | JM |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO
[NAME] |  |  |  |  |  |  |  |  |  | DL |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO
HAYDEN JACKSON |  |  |  |  |  |  |  |  |  | HJ
JAQUAN MASON |  |  |  |  |  |  |  |  |  | JM
[NAME] |  |  |  |  |  |  |  |  |  | HC
BRUCE MELTON |  |  |  |  |  |  |  |  |  | BM |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
[NAME] |  |  |  |  |  |  |  |  |  | CC |  | 55 |  |  | V |  |  | V |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
DONNIE NALLEY |  |  |  |  |  |  |  |  |  | DN |  |  |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | TB |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
MARTY BROOME |  |  |  |  |  |  |  |  |  | MB
CRANE OPERATOR |  |  |  |  |  |  |  |  |  | C
UNASSIGNED |  |  |  |  |  |  |  |  |  | X
Spreadsheet: 812795d1673375555-calculating-annual-sales-increase-excel-problem
Sheet: Sheet1

2020-2021 |  |  |  |  |  |  |  |  | 2020-2021
Region | Client | Client Contact | Contract Sales (Net New) | Perm Sales | Total Sales |  | No Repeat Business |  | Region | Client | Client Contact | Contract Sales (Net New) | Perm Sales | Total Sales |  | Reduced Sales |  | Increased Sales | Total Sales Increase
 | 7 |  | 3226 |  |  |  | Increased Sales |  |  | 6B |  | 1440 |  |  |  | Increased Sales |  | A2
 | A2 |  | 54154 |  |  |  | Reduced Sales |  |  | A2 |  | 207171 |  |  |  | New Clients |  | Ac
 | Ac |  |  | 15057 |  |  |  |  |  | AA |  |  | 5000 |  |  |  |  | Bi
 | Act |  |  | 5000 |  |  |  |  |  | Ab |  |  | 71487
 | Ad |  |  | 13250 |  |  |  |  |  | A1 |  | 22711 |  |  |  |  |  | Totals
 | AD1 |  | 7800 | 5250 |  |  |  |  |  | Ac |  |  | 21028
 | All |  | 15120 |  |  |  |  |  |  | Ad |  |  | 11851
 | All |  | 36150 |  |  |  |  |  |  | Ag |  | 8400
 | An |  |  | 15600 |  |  |  |  |  | Ai |  |  | 5000
 | ap |  |  | 13910 |  |  |  |  |  | Al |  |  | 9626
 | Au |  |  | 7373 |  |  |  |  |  | All |  | 25175
 | Aus |  | 23607 | 16000 |  |  |  |  |  | Ap |  |  | 6154
 | AV |  |  | 8481 |  |  |  |  |  | ASE |  |  | 7500
 | Ava |  |  | 9601 |  |  |  |  |  | Atl |  |  | 5550
 | Avan |  |  | 52903 |  |  |  |  |  | Au |  |  | 17250
 | AX |  |  | 6450 |  |  |  |  |  | Avan |  |  | 31354
 | AZ |  |  | 135795 |  |  |  |  |  | Az |  |  | 68240
 | Bi |  |  | 7650 |  |  |  |  |  | Bi |  |  | 30000
 | Total |  |  |  |  |  |  |  |  | Total
Spreadsheet: 53307d1253199647-points-system-table-standing
Sheet: Sheet6

 | Chelsea | Vs | Stoke
Particpants | Chelsea |  | Stoke | Actual Team A | Actual Team B | Correct goals (1) | No Goals (1) | Correct Result (3) | Win Score (3) | Draw Score (3) | Correct Match (5) | Points
[NAME] | 3 |  | 1 | 0 | 0 |  | 1
Angiiie | 3 |  | 0 | 0 | 0 | 1 | 1
Bakchang |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
Blue Rascal | 3 |  | 0 | 0 | 0 | 1 | 1
[NAME] (1) | 2 |  | 0 | 0 | 0 | 1 | 1
[NAME] |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
Chelseapaul | 4 |  | 1 | 0 | 0 |  | 1
[NAME] |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
[NAME] | 2 |  | 0 | 0 | 0 | 1 | 1
Double D |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
[NAME] | 3 |  | 0 | 0 | 0 | 1 | 1
Fookwing |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
Harmony2828 | 3 |  | 0 | 0 | 0 | 1 | 1
[NAME] |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
[NAME] |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
JWNY | 5 |  | 0 | 0 | 0 | 1 | 1
Karthigesh | 2 |  | 0 | 0 | 0 | 1 | 1
[NAME] (1) |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
[NAME] (: | 3 |  | 0 | 0 | 0 | 1 | 1
[NAME] |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
Lighthouse | 2 |  | 0 | 0 | 0 | 1 | 1
[NAME] | 5 |  | 0 | 0 | 0 | 1 | 1
Monir | 4 |  | 0 | 0 | 0 | 1 | 1
North Stand |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
[NAME] (2) |  |  |  | 0 | 0 |  | 1 | 3 |  |  | 5
[NAME] | 2 |  | 1
[NAME] | 5 |  | 0
PetrJack | 2 |  | 0
Polobear
Ray
[NAME] | 4 |  | 0
Shevchenko
Shiesse | 3 |  | 0
Silent
Singablue | 2 |  | 0
Stellazio
Stephen
tab
[NAME] (6) | 2 |  | 0
The Ridz
Uncle gg | 4 |  | 0
Zenden | 4 |  | 0
Sharlene95
[NAME]
JoeyCole
[NAME] | 2 |  | 0
SoccerMusic
Voodoo
[NAME]
Wannshag
Dessimondo | 2 |  | 0