tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14062__PEP_OAT_KO financials and ratios
Sheet: Pepsi Ratios

 |  |  | PEPSI RATIO ANALYSIS
ROE
Leverage
ROA
Asset Turn
Net Margin
Total Debt/Equity
Growth
Sales
EBIT
Net income
Spreadsheet: 807891d1670140059-counting-the-number-of-people-on-leave-per-month-book1
Sheet: LEAVE PER MONTH

 | LEAVE START | LEAVE END |  | MONTH | NUMBER OF LEAVE PER MONTH
 | 2022-05-17 00:00:00 | 2022-06-15 00:00:00 |  | JANUARY
 | 2022-10-18 00:00:00 | 2022-10-23 00:00:00 |  | FEBRUARY
 | 2022-07-27 00:00:00 | 2022-08-20 00:00:00 |  | [NAME]
 | 2022-05-16 00:00:00 | 2022-06-19 00:00:00 |  | APRIL
 | 2022-11-01 00:00:00 | 2022-12-05 00:00:00 |  | MAY
 | 2022-02-16 00:00:00 | 2022-03-17 00:00:00 |  | [NAME]
 | 2022-07-21 00:00:00 | 2022-08-23 00:00:00 |  | JULY
 | NA | NA |  | AUGUST
 | 2022-03-10 00:00:00 | 2022-04-13 00:00:00 |  | SEPTEMBER
 | 2022-09-01 00:00:00 | 2022-09-14 00:00:00 |  | OCTOBER
 | NA | NA |  | NOVEMBER
 | NA | NA |  | DECEMBER
 | NA | NA
 | NA | NA
 | NA | NA
 | 2022-10-01 00:00:00 | 2022-11-29 00:00:00
 | NA | NA
 | 2022-05-24 00:00:00 | 2022-07-07 00:00:00
 | NA | NA
 | NA | NA
 | NA | NA
 | NA | NA
 | NA | NA
Spreadsheet: 820608d1678196347-i-need-help-for-formula-count-if-distinct-s666-pq-ronyn-v3
Sheet: sheet

product_code | type |  |  |  | product_code | type | Count
[PHONE] | 009 |  | Power Query |  | [PHONE] | 009 | 3
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 3
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 009 |  |  |  | [PHONE] | 009 | 3
[PHONE] | 009 |  |  |  | [PHONE] | 009 | 2
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 010 |  |  |  | [PHONE] | 010 | 3
[PHONE] | 009 |  |  |  | [PHONE] | 009 | 2
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 2
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 3
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 2
[PHONE] | 010 |  |  |  | [PHONE] | 010 | 3
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 2
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 2
[PHONE] | 000 |  |  |  | [PHONE] | 000 | 3
Spreadsheet: 831131d1685442983-how-to-use-the-minimum-or-equal-to-50-recursive-subtraction-5-30
Sheet: Sheet1

 |  |  | RESULT
A | 89 |  | A | 50 |  |  |  | 50 |  |  | 50
B | 72 |  | A | 39 |  |  | A | 39 |  | A | 39
C | 15 |  | B | 50 |  |  | B | 50 |  | B | 50
D | 21 |  | B | 22 |  |  | B | 22 |  | B | 22
E | 46 |  | C | 15 |  |  | C | 15 |  | C | 15
F | 199 |  | D | 21 |  |  | D | 21 |  | D | 21
 |  |  | E | 46 |  |  | E | 46 |  | E | 46
 |  |  | F | 50 |  |  | F | 50 |  | F | 50
 |  |  | F | 50 |  |  | F | 50 |  | F | 50
 |  |  | F | 50 |  |  | F | 50 |  | F | 50
 |  |  | F | 15 |  |  | F | 49 |  | F | 49
Spreadsheet: 768185d1644871663-summing-data-based-on-overlapping-multiple-criteria-sum-by-overlapping-multiple-criteria-snook-adj-
Sheet: Pivot

 | System Name | Date | Sum of Students
 | CLNC-CCS (CCS-006) | 23-Oct | 28
 | CLNC-CCS (CCS-006) | 26-Oct | 18
 | CLNC-CCS (CCS-006) | 27-Oct | 36
 | CLNC-CCS (CCS-006) | 28-Oct | 36
 | CLNC-CCS (CCS-006) | 29-Oct | 18
 | CLNC-CCS (CCS-007) | 23-Oct | 27
 | CLNC-CCS (CCS-007) | 26-Oct | 17
 | CLNC-CCS (CCS-007) | 27-Oct | 62
 | CLNC-CCS (CCS-007) | 28-Oct | 34
 | KBAY-CCS-(CCS-004) | 06-Oct | 48
 | KBAY-CCS-(CCS-004) | 16-Oct | 57
 | KBAY-CCS-(CCS-004) | 06-Nov | 17
 | KBAY-CCS-(CCS-004) | 13-Nov | 19
 | KBAY-CCS-(CCS-004) | 23-Nov | 18
 | Grand Total |  | 435
Spreadsheet: 52755d1252589114-pivot-tables-error-message-test_pivot
Sheet: Sheet1

DATE | ORDER NO | SUPPLIER | PURPOSE | INITIALS | VALUE | NET | VAT | CHARGE1 | CHARGE2 | COMMENTS | [NAME] needed? | Filed in Folder A | Filed in folder B
2009-08-18 00:00:00 | 2770768 | Expenses for AR | Hotel | AB | 74.95 | 66.47 | 8.48 | 99999 | DG1000A | none | N | 2009-09-10 00:00:00 | 2009-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 11111 | DG1000J
2009-08-21 00:00:00 | 2770769 | Expenses for AR | Visiting Company D | AB | 144 | 144 | 0 | 99999 | DG1000A | none | N | 2009-09-10 00:00:00 | 2009-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | DG1000X
2009-09-04 00:00:00 | 2770767 | Expenses for MA | Visiting Company E | AB | 187.67 | 177.86 | 9.81 | 11604 | RA4350A | none | N | 2009-09-10 00:00:00 | 2009-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | RA5751C
Spreadsheet: 3dadbb84-7eac-4437-83e3-e0bb166b5fcb
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0022785 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Lattisville Grove Baptist Church | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Orange | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 1.04 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  | Fescue / Rye |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 23.75 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 775641d1649239202-i-need-a-countifs-formula-to-count-based-on-multiple-values-countifs-example-1-
Sheet: Countifs Example

[NAME] | Name |  | Name | Email address appears 3+ times
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | [NAME] |  | [NAME] | 3
[EMAIL] | Tia Davies |  | Tia Davies | 3
[EMAIL] | Tia Davies |  | [NAME] | 2
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME] |  | I would like to count how many times a name has an email address that appears 3 or more times in the 1st 2 columns. The result would look like the column above.
[EMAIL] | Tia Davies
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | [NAME]
[EMAIL] | Tia Davies
[EMAIL] | [NAME]
[EMAIL] | [NAME] |  | Again thank you for your time, hopefully I can explain this better. For each name in column D, I want column E to return how many times the corresponding names have an email address that appears 3 or more time in column A. Example: Tia Davies appears in Column B 4 times, but in Column A there are only 3 email address that 3 or more times for Tia Davies as the [EMAIL] address only appears once. Many thanks [NAME]
[EMAIL] | [NAME]
Spreadsheet: 772900d1647521317-transposing-single-column-grouped-data-into-2-columns-transpose-examples
Sheet: Sheet1

Ref-Group-B04-Item-VP |  |  | Ref-Group-B04-Item-VP | Ref-Group-B04-Item-001
Ref-Group-B04-Item-001 |  |  | Ref-Group-B10-Item-VP | Ref-Group-B10-Item-001
Ref-Group-B10-Item-VP |  |  | Ref-Group-B11-Item-VP | Ref-Group-B11-Item-001
Ref-Group-B10-Item-001 |  |  | Ref-Group-B12-Item-VP | Ref-Group-B12-Item-001
Ref-Group-B11-Item-VP |  |  | Ref-Group-B13-Item-VP | Ref-Group-B13-Item-001
Ref-Group-B11-Item-001 |  |  | Ref-Group-B13-Item-VP | Ref-Group-B13-Item-002
Ref-Group-B12-Item-VP |  |  | Ref-Group-B13-Item-VP | Ref-Group-B13-Item-003
Ref-Group-B12-Item-001 |  |  | Ref-Group-B13-Item1-VP | Ref-Group-B13-Item1-001
Ref-Group-B13-Item-VP |  |  | Ref-Group-B13-Item1-VP | Ref-Group-B13-Item1-002
Ref-Group-B13-Item-001 |  |  | Ref-Group-B18-Item-VP | Ref-Group-B18-Item-001
Ref-Group-B13-Item-002 |  |  | Ref-Group-B18-Item2-VP | Ref-Group-B18-Item2-001
Ref-Group-B13-Item-003
Ref-Group-B13-Item1-VP
Ref-Group-B13-Item1-001
Ref-Group-B13-Item1-002
Ref-Group-B18-Item-VP
Ref-Group-B18-Item-001
Ref-Group-B18-Item2-VP
Ref-Group-B18-Item2-001
Spreadsheet: 599335d1542975506-lookup-based-on-left-value-multiple-column-choices-lookup-issue
Sheet: Sheet1

 | [NAME] | Value
 | 300 | value 1
 | 350 | Value 2
 | 400 | Val 3
 |  |  |  | Other 1 | Other 2 | Ref 1 | Val 1 | Ref 2 | Val 2 | Ref 3 | Val 3
 |  |  |  | 300 |  | 300 | value 1
 |  |  |  | 450 |  |  |  | 350 | Value 2
 |  |  |  | 400 |  |  |  |  |  | 400 | Val 3
 | `
Spreadsheet: 41392d1239867692-cant-use-match-to-compare-two-columns-book1
Sheet: Sheet1

 | 3882 | 3929 | 3828 | 5195 | 5757 | 3829 | 7777 | 9392
283882818182838 | Yes
8382929383848380 |  |  |  |  |  | Yes
83929029383822 |  | Yes
8383829383482 |  |  |  |  |  | Yes
89309293843
93929383842 |  | Yes |  |  |  |  |  | Yes
838293938482 |  |  |  |  |  | Yes
83828283848383 |  |  | Yes
8292938484737
9828738472243
83827492938429
Spreadsheet: 703545d1605037275-exclude-range-from-randbetween-exclude-range-random-sample
Sheet: Sheet1

Fruit | Veg | Drink
Apple | Peppers | Water |  |  | Table 1
Orange | Carrots | Apple Juice |  | Fruit 1 |  | {=INDEX($A$2:$A$10, RANDBETWEEN(1, ROWS($A$2:$A$10)))}
[NAME] | Brocoli | Orange Juice |  | Fruit 2
Pear | Cauliflower | Coffee |  | Veg 1 |  | {=INDEX($B$2:$B$8, RANDBETWEEN(1, ROWS($B$2:$B$8)))}
Grapefruit | Celery | Tea |  | Veg 2
Orange | Cabbage | Vodka |  | Drink 1 |  | {=INDEX($C$2:$C$7, RANDBETWEEN(1, ROWS($C$2:$C$7)))}
Lemon | Peas |  |  | Drink 2
Kiwi
[NAME]
 |  |  |  |  | Table 2
 |  |  |  | Fruit 1 | Apple
 |  |  |  | Fruit 2 | [NAME]
 |  |  |  | Veg 1 | Peppers
 |  |  |  | Veg 2 | Brocoli
 |  |  |  | Drink 1 | Tea | ERROR, Tea appears in table above
 |  |  |  | Drink 2 | Vodka
 |  |  |  |  | Table 3
 |  |  |  | Fruit 1 | Pear
 |  |  |  | Fruit 2 | Kiwi
 |  |  |  | Veg 1 | Celery
 |  |  |  | Veg 2 | Peas
 |  |  |  | Drink 1 | Coffee
 |  |  |  | Drink 2 | Water
Spreadsheet: 121124d1315856296-searching-for-exact-phrases-dummy-workbook
Sheet: Sheet1

Team | Team | Down | ToGo
A | B | 2 | 6 | 69 | (12:59) K.Branagan pass short left to R.Martz for 10 yards
A | B | 2 | 7 | 77 | (:45) (Shotgun) K.Branagan pass short left to A.Roberts for 4 yards
A | B | 2 | 8 | 36 | (12:07) (Shotgun) N.Blonski pass short right to S.Biser for 12 yards
A | B | 2 | 8 | 89 | (4:50) K.Branagan pass short right to P.Byrne to for 14 yards
A | B | 2 | 8 | 91 | (6:44) (Shotgun) K.Branagan pass short right to S.Biser for 3 yards
A | B | 2 | 9 | 54 | (8:17) (Shotgun) N.Blonski pass short right to H.Towers for 6 yards
A | B | 2 | 9 | 81 | (9:43) (Shotgun) K.Branagan pass short left to S.Howling for 12 yards
A | B | 2 | 9 | 51 | (14:19) N.Blonski pass short left to S.Howling for 13 yards
A | C | 2 | 10 | 53 | (1:19) (Shotgun) N.Blonski pass short right to S.Williams for 10 yards
A | C | 2 | 10 | 63 | (10:33) (Shotgun) N.Blonski pass short left to P.Byrne for 6 yards
A | C | 2 | 10 | 79 | (8:02) (Shotgun) N.Blonski pass short right to A.Roberts pushed ob for 13 yards
A | C | 2 | 10 | 51 | (4:50) K.Branagan pass short right to P.Byrne for 15 yards
A | C | 2 | 11 | 33 | (14:19) (Shotgun) N.Blonski pass short right to S.Biser for 10 yards
A | C | 2 | 16 | 54 | (9:03) K.Branagan pass short left to E.Doucet for 3 yards
A | C | 2 | 18 | 82 | (7:34) (No Huddle Shotgun) K.Branagan pass short left to P.Byrne for 4 yards
A | B | 3 | 1 | 74 | (3:30) (No Huddle Shotgun) N.Blonski pass short right to B.Patrick for 11 yards
A | B | 3 | 2 | 40 | (3:03) (Shotgun) N.Blonski pass short left to S.Biser for 14 yards
A | B | 3 | 3 | 78 | (9:40) (Shotgun) K.Branagan pass short right to S.Howling for 3 yards
A | B | 3 | 4 | 43 | (:28) (Shotgun) N.Blonski pass short left to S.Williams for 1 yard
A | B | 3 | 5 | 73 | (13:43) (Shotgun) N.Blonski pass short right to P.Byrne pushed ob for 8 yards
A | C | 3 | 5 | 35 | (12:59) (Shotgun) N.Blonski pass short right to S.Biser for 5 yards
A | C | 3 | 6 | 67 | (7:36) (Shotgun) N.Blonski pass short right to S.Biser for 16 yards
A | C | 3 | 6 | 57 | (10:10) (Shotgun) K.Branagan pass short right to C.Wells for 14 yards
A | C | 3 | 6 | 31 | (2:28) (Shotgun) N.Blonski pass short right to P.Byrne for 3 yards
A | C | 3 | 7 | 74 | (14:54) (Shotgun) K.Branagan pass short left to P.Byrne pushed ob for 10 yards
Spreadsheet: 207564d1358495013-matching-columns-predicament-predicament-attachment
Sheet: Sheet1

User Name | name1 |  | Personnel No. | [NAME]
ZE55395 | Rosemary Adolfo |  | 5834 | [NAME]
ZE7462194 | Mushosho Adonia |  | 2624 | [NAME]
ZE7462194 | Ushendibaba Adonis T |  | 1606 | Gabrial Antipas
[NAME] | [NAME] |  | 5835 | [NAME]
ZE55115 | Gabrial Antipas |  | 6770 | [NAME]
ZE55042 | [NAME] |  | 2522 | Mushosho Adonia
ZE222496 | [NAME] |  | 2733 | Ushendibaba Adonis T
ZE243647 | [NAME] |  | 6683 | Rosemary Adolfo
 | The result should look like this
ZE55395 | Rosemary Adolfo |  | 6683 | Rosemary Adolfo
ZE7462194 | Mushosho Adonia |  | 2522 | Mushosho Adonia
ZE7462194 | Ushendibaba Adonis T |  | 2733 | Ushendibaba Adonis T
[NAME] | [NAME] |  | 2624 | [NAME]
ZE55115 | Gabrial Antipas |  | 1606 | Gabrial Antipas
ZE55042 | [NAME] |  | 6770 | [NAME]
ZE222496 | [NAME] |  | 5834 | [NAME]
ZE243647 | [NAME] |  | 5835 | [NAME]
Spreadsheet: 28049d1221849865-using-if-to-colour-shape-test
Sheet: Sheet1

 | Select: | Fine
 |  |  |  | Error in column...
 |  |  | Alpha | Beta | [NAME] | Delta | Echo
 |  |  | aa | bb | cc | dd | ee
 |  |  | aa | bb | cc | dd | ee
 |  |  | aa | bb | cc | dd | ee
Spreadsheet: 464014d1464847122-drop-down-list-sum-function-fuel
Sheet: Sheet4

Row Labels | Sum of Fuel | Sum of Miles | Sum of Hours
c4 | 30 | 115 | 10
D3 | 215 | 280 | 450
E1 | 75 | 640 | 35
Grand Total | 320 | 1035 | 495
Spreadsheet: 581851d1531530153-update-countif-formula-when-using-tables-countif-example
Sheet: Sheet1

# | Days
 | 1
 | 2-4
 | 5+
Date Rec'd | Doc # | Date Shipped | Type | Status | Dock Days
2018-01-01 00:00:00 | A1234 | 2018-01-03 00:00:00 | Handles | POSTED
2018-01-01 00:00:00 | B1234 | 2018-01-06 00:00:00 | Knobs | POSTED
2018-01-02 00:00:00 | C1234 | 2018-01-02 00:00:00 | Knobs | POSTED
2018-02-02 00:00:00 | D1234 | 2018-03-01 00:00:00 | Handles | POSTED
2018-03-01 00:00:00 | E1234 | 2018-03-02 00:00:00 | Handles | POSTED
2018-04-02 00:00:00 | F1234 | 2018-04-05 00:00:00 | Handles | POSTED
Spreadsheet: 66772d1267464596-lookup-to-find-and-output-multiple-values-in-different-worksheet-example
Sheet: Requirements

Component | Requirement | Description | Tracelability | What I want the Traceability to look like:-
forecast | 1.1.0 | fdsgfdg |  | 1,2
forecast | 1.1.1 | sdfdsf |  | 3
Forecast | 1.1.2 | [NAME] |  | 4,5,6
Forecast | 1.1.3 | [NAME] |  | 7
Arrivals | 1.2.0 | sadfdsf |  | 8,9,10,11
Arrivals | 1.2.1 | dsfdsaf |  | 12,13,14
Arrivals | 1.2.2 | sdaf |  | etc….
Order | 1.3.0 | [NAME]
Order | 1.3.1 | gds
Order | 1.3.2 | hhgj
Order | 1.3.3 | dfh
Inv Flow | 1.4.0 | fdsgfdg
Inv Flow | 1.4.1 | gjk
Inv Flow | 1.4.2 | trd
Inv Flow | 1.4.3 | sddsfds
Inv Flow | 1.4.4 | sdfd
Shipment | 1.5.0 | ghhgdffsd
Shipment | 1.5.1 | sadfdsf
Shipment | 1.5.2 | sdfsdf |  | If there is not occurrence, then put some value like '0' OR 'None'
Spreadsheet: 970d2b95-832d-4fd3-be79-d399ca8ed74b
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
[NAME] | Test | [NAME] | Selenium, Random, [NAME] | Selenium, [NAME], U | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 1 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 1 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of barium, gadolinium, and iodine are known to interfere with most metals tests. If barium, gadolinium, or iodine containing contrast media has been administered, a specimen cannot be collected for 96 hours. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 15-50 mcg/L | Monday, 8 a.m. - 6 p.m. | 1 day | 7 days | 1 | 84255 |  |  |  |  | Rochester
[NAME] | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
[NAME] | Result | 60077 | Selenium, [NAME], U | Selenium, [NAME], U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5726-5 | Selenium:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 133751d1324576785-lookup-values-from-three-different-columns-in-a-table-matrix-lookup-problem-for-target
Sheet: Target

AM | Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Emp1 | 2009 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000
Emp1 | 2010 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000
Emp1 | 2011 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000 | 95000
Emp2 | 2009 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000 | 90000
Emp2 | 2010 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
Emp2 | 2011 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000 | 110000
Emp3 | 2009 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000
Emp3 | 2010 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000
Emp3 | 2011 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000
Emp4 | 2009 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000 | 65000
Emp4 | 2010 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000
Emp4 | 2011 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 | 85000
Spreadsheet: ce245009-5ce3-4460-9db9-a73f42fcc8eb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  |  |  |  | COMMERCIAL INVOICE/PACKING LIST
Sender: |  |  |  | Consignee |  |  |  |  |  |  |  | License:
 |  |  |  |  |  |  |  |  |  |  |  | Carnet:
 |  |  |  |  |  |  |  |  |  |  |  | IRS NO:
 |  |  |  |  |  |  |  |  |  |  |  | Pieces
 |  |  |  |  |  |  |  |  |  |  |  | Weight
Total Pieces | Item No | Quantity | Description of Contents | HS CODE | Country of Origin | Weight  (LBS) | L x | Dims (Inches)   W  x | H | CBM | Temp Import | Give Away | SOLD | Value Per Item ($) | Total Value ($)
 |  |  |  |  |  |  |  |  |  | 0 | X
 |  |  |  |  |  |  |  |  |  | 0 | X
 |  |  |  |  |  |  |  |  |  | 0 | X
 |  |  |  |  |  |  |  |  |  | 0 | X
 |  |  |  |  |  |  |  |  |  | 0 | X
 |  |  |  |  |  |  |  |  |  |  |  |  | CIF TOTAL VALUE |  | 0
The shipper hereby accepts LAS Worldwide and their agent, In his name and behalf, to prepare any export documentation, |  |  |  |  |  |  |  |  |  |  |  |  | Authorized Signature
to sign and accept and documents relating to said shipment and forward this shipment in accordance with the conditions of carriage. |  |  |  |  |  |  |  |  |  |  |  |  | Date:
The values listed on this document represent the fair market value.
These commodities or software were exported from the United States in accordance with Export Administration regulations.  Diversion contrary to US. law prohibited.
Spreadsheet: 201692d1356081265-countif-that-returns-a-count-based-on-specific-words-within-a-cell-countif-specific-text-within-a-cell
Sheet: Sheet1

 | Process | Countif should return |  |  | Filenames | Code
 | Authorise Customer Bill Invoice Adjustment | 2 |  |  | BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.03 - Authorise Customer [NAME] Adjustment\SI_ Authorise Customer Bill Invoice Adjustment | UC_R2.1_343
 | Track And Manage Customer Bill Inquiry Resolution | 4 |  |  | BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.03 - Authorise Customer [NAME] Adjustment\SI_ Authorise Customer Bill Invoice Adjustment | UC_R2_342
 |  |  |  |  | BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_1156
 |  |  |  |  | Operations\CRM - Customer Relationship Management\BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_1157
 |  |  |  |  | Operations\CRM - Customer Relationship Management\BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_036
 |  |  |  |  | Operations\CRM - Customer Relationship Management\BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_036.a
 | Requirement
 | I need a countif that takes the value in B3 and looks for it embedded within larger strings in F3:FX
 | So in this example the Countif would return the following values in C3 & C4
Spreadsheet: 709907d1608622095-conditional-drop-down-list-attendance
Sheet: Sheet2

Name | Days | Attendance |  |  |  |  |  |  |  | Present | [NAME]
A | [NAME] | Present |  |  |  |  |  |  |  | Absent | mon
A | mon | Absent |  |  |  |  |  |  |  | Haliday | tue
A | tue |  |  |  |  |  |  |  |  |  | wed
A | wed | Haliday |  |  |  |  |  |  |  |  | thu
A | thu |  |  |  |  |  |  |  |  | Data | =Sheet2!$B$2:$B$16
B | [NAME] |  |  |  |  |  |  |  |  | Days | =Sheet2!$L$1:$L$5
B | mon |  |  |  |  |  |  |  |  | list | =Sheet2!$K$1:$K$3
B | tue
B | wed |  |  | I want the corresponding cells to be repeated automatically for the holidays I select
B | thu |  |  | Please, without VBA
C | [NAME]
C | mon
C | tue
C | wed
C | thu
Spreadsheet: 725290d1616605067-help-cant-for-the-life-of-me-figure-out-how-to-deal-with-as-an-input-excel-test
Sheet: Sheet1

Ticker | Company | Consecutive Div. Growth Years | Beta 3-Year | [NAME] | Div. 5Y Avg (%) | Dividend Yield | Price / Earnings | [NAME] 10-Year | [NAME] 10-Year Peak | [NAME] Trough | RULE
AAPL | Apple | 8 | 1.2 | 0.216 | 0.095 | 0.007 | 32.4 | -0.438 | 2012-09-19 00:00:00 | 2013-04-19 00:00:00
ABB | ABB | 1 | 0.93 | 0.34 | - | 0.028 | 100+ | -0.481 | 2018-01-26 00:00:00 | 2020-03-23 00:00:00
ABBV | AbbVie | 7 | 0.78 | 1.639 | 0.179 | 0.05 | 38 | -
ABC | AmerisourceBergen | 10+ | 0.89 | - | 0.053 | 0.015 | - | -0.39 | 2015-04-24 00:00:00 | 2016-11-08 00:00:00
ABM | [NAME] | 0 | 1.12 | 1.08 | 0.029 | 0.015 | 72.5 | -0.543 | 2017-07-27 00:00:00 | 2020-03-23 00:00:00