tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33f1c4f3-4045-4992-b830-d537051fe724
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
CMG | Test | CMG | Cytomegalovirus (CMV) Antibodies, IgG, Serum | [NAME], IgG, S | Enzyme-Linked Fluorescence Assay (ELFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <4 AU/mL (negative) 4-5 AU/mL (equivocal) > or =6 AU/mL (positive) A convalescent IgG antibody level of >6 AU/mL combined with a ratio of > or =2 in a paired sera (seroconversion) IgG titer indicates recent infection. The presence of only IgG antibodies generally indicates past infection with CMV. | Monday through Saturday; Varies | Same day/1 day | 3 days | 1 | 86644 |  |  |  |  | Rochester
CMG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CMG | Result | CMG | [NAME], IgG, S | [NAME], IgG, S | Numeric |  |  |  |  | AU/mL |  |  |  |  |  |  |  |  |  | 5124-3
Spreadsheet: 105533d1302854473-updating-the-changing-price-of-product-by-date-murphree-5-5h8-volume-accounting-sheet-in-edit-2
Sheet: MUD TRANSFER SHEET

MUD TRANSFER SHEET
Report # | Date | In | Out | Wt. | $ / bbl | Comments: [NAME] and #, Well Name, AFE#, Reason & Date (If transferred between jobs)
1 | 2011-03-29 00:00:00
2 | 2011-03-30 00:00:00
3 | 2011-03-31 00:00:00
4 | 2011-04-01 00:00:00
5 | 2011-04-02 00:00:00
6 | 2011-04-03 00:00:00
7 | 2011-04-04 00:00:00
8 | 2011-04-05 00:00:00
9 | 2011-04-06 00:00:00
10 | 2011-04-07 00:00:00
11 | 2011-04-08 00:00:00
12 | 2011-04-09 00:00:00
13 | 2011-04-10 00:00:00
14 | 2011-04-11 00:00:00
15 | 2011-04-12 00:00:00
16 | 2011-04-13 00:00:00
17 | 2011-04-14 00:00:00
18 | 2011-04-15 00:00:00
19 | 2011-04-16 00:00:00
20 | 2011-04-17 00:00:00
21 | 2010-06-19 00:00:00
22 | 2010-06-20 00:00:00
23 | 2010-06-21 00:00:00
24 | 2010-06-22 00:00:00
25 | 2010-06-23 00:00:00
26 | 2010-06-24 00:00:00
27 | 2010-06-25 00:00:00
28 | 2010-06-26 00:00:00
29 | 2010-06-27 00:00:00
30 | 2010-06-28 00:00:00
TOTALS |  | 0 | 0
Spreadsheet: 713327d1610647148-string-comparison-exceltestbench-gk
Sheet: testLink

POINT | WIRE1 | WIRE2 | WIRE3 | WIRE4 | WIRE5 | WIRE6 | WIRE7 | WIRE8 | [NAME] | WIRE10 | WIRE11 | WIRE12 | WIRE13 | WIRE14 | WIRE15 | t |  |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 14GA RED | 3 14GA GRN | 4 14GA PNK | 5 14GA BLU | 6 14GA PUR | 2 14GA WHT | 4 14GA WHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 14GA RED | 3 14GA WHT | 1 14GA WHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 14GA GRN | 2 14GA WHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 14GA PNK | 5 14GA WHT | 6 14GA WHT | 1 14GA WHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 14GA BLU | 4 14GA WHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1 14GA PUR | 4 14GA WHT
Full code | Partial Code |  | Uniques
Spreadsheet: 856092d1705479832-sumproduct-formula-giving-error-my-workbook-copy
Sheet: Testing 123

Date | STD | DLX | BVL | WVL
2023-01-01 00:00:00 | 695 | 776 | 996 | 1163
2023-01-02 00:00:00 | 695 | 776 | 996 | 1163
2023-01-03 00:00:00 | 695 | 776 | 996 | 1163
2023-01-04 00:00:00 | 513 | 590 | 800 | 959 |  | Room category | BVL
2023-01-05 00:00:00 | 513 | 590 | 800 | 959 |  | checking Date | 2023-01-06 00:00:00
2023-01-06 00:00:00 | 1317 | 1543 | 1611 | 1677 |  | Check out Date | 2023-01-08 00:00:00
2023-01-07 00:00:00 | 1317 | 1543 | 1611 | 1677
2023-01-08 00:00:00 | 1317 | 1543 | 1611 | 1677 |  | Total Rate
2023-01-09 00:00:00 | 1105 | 1322 | 1385 | 1449
2023-01-10 00:00:00 | 1105 | 1322 | 1385 | 1449
Spreadsheet: 214627d1361014137-highlighting-lowest-score-w-o-duplicates-highlighting-and-counting-player-skins-golf_skins
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Out | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | In | Total |  | Skins
GOLFERS | NAMES | 5 | 4 | 3 | 4 | 4 | 4 | 5 | 4 | 3 | 36 | 4 | 5 | 3 | 4 | 5 | 4 | 4 | 3 | 4 | 36 | 72
[NAME] | Adams | 5 | 4 | 2 | 3 | 5 | 4 | 5 | 3 | 6 | 37 | 3 | 4 | 5 | 4 | 6 | 6 | 5 | 2 | 7 | 42 | 79 | 2 | $ | 33.33333333333334
[NAME] | Callaghan | 5 | 4 | 4 | 3 | 4 | 7 | 5 | 5 | 4 | 41 | 5 | 6 | 4 | 5 | 5 | 3 | 4 | 3 | 3 | 38 | 79 | 1 | $ | 16.66666666666667
[NAME] | [NAME] | 4 | 4 | 4 | 5 | 4 | 5 | 7 | 4 | 3 | 40 | 5 | 4 | 5 | 4 | 6 | 3 | 3 | 5 | 5 | 40 | 80 | 0 | $
[NAME] | Cornell | 4 | 5 | 3 | 4 | 4 | 4 | 5 | 5 | 4 | 38 | 5 | 5 | 4 | 3 | 4 | 6 | 6 | 4 | 5 | 42 | 80 | 1 | $ | 16.66666666666667
Wayne | [NAME] | 5 | 5 | 4 | 5 | 4 | 4 | 7 | 3 | 2 | 39 | 5 | 6 | 2 | 4 | 5 | 6 | 4 | 4 | 5 | 41 | 80 | 1 | $ | 16.66666666666667
[NAME] | Little | 4 | 3 | 2 | 5 | 4 | 5 | 5 | 5 | 4 | 37 | 5 | 5 | 5 | 4 | 6 | 4 | 5 | 4 | 6 | 44 | 81 | 0 | $
[NAME] | [NAME] | 4 | 4 | 2 | 4 | 6 | 5 | 5 | 5 | 4 | 39 | 5 | 5 | 3 | 5 | 4 | 6 | 5 | 4 | 5 | 42 | 81 | 0 | $
Greg | Nicholson | 7 | 3 | 4 | 5 | 6 | 5 | 6 | 3 | 3 | 42 | 5 | 6 | 3 | 5 | 6 | 4 | 4 | 4 | 4 | 41 | 83 | 0 | $
Doug | Brunet | 5 | 5 | 5 | 4 | 6 | 5 | 4 | 5 | 3 | 42 | 8 | 4 | 4 | 5 | 4 | 5 | 3 | 3 | 5 | 41 | 83 | 1 | $ | 16.66666666666667
[NAME] | Stoliker | 7 | 5 | 4 | 3 | 4 | 4 | 6 | 5 | 3 | 41 | 4 | 6 | 2 | 5 | 5 | 5 | 4 | 6 | 5 | 42 | 83 | 0 | $
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | -
10 | [NAME] | - | - | - | - | - | - | 4 | - | 2 |  | 3 | - | - | 3 | - | - | - | 2 | 3 |  |  | 6 | 10
 | Skins Payout |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.66666666666667
 |  | 4 | 3 | 2 | 3 | 4 | 4 | 4 | 3 | 2 |  | 3 | 4 | 2 | 3 | 4 | 3 | 3 | 2 | 3
 |  | 4 | 2 | 3 | 3 | 6 | 4 | 1 | 3 | 1 |  | 1 | 3 | 2 | 1 | 3 | 2 | 2 | 1 | 1
 |  | - | - | - | - | - | - | 4 | - | 2 |  | 3 | - | - | 3 | - | - | - | 2 | 3
Spreadsheet: 822885d1679579729-how-to-return-value-from-a-table-based-on-3-or-more-variables-excelforum_tip
Sheet: ExcelTip

Country | Element | Grade | Funct.2 | FUNC. | Value1 | Value2 | Value3 | Value4 | Value5
Country1 | Base | 17 | Sal | KAS | 50555 | 56460 | 66301 | 76123 | 88341 |  |  | Elements | Value1 | Value2 | Value3 | Value4 | Value5
Country1 | Base 2 | 17 | Sal | KAS | 37 | 41 | 47 | 54 | 59 |  |  | Base
Country1 | Sen | 17 | Sal | KAS | 0 | 1 | 5 | 13 | 21 |  |  | Base 2
Country1 | Sen2 | 17 | Sal | KAS | 2 | 3 | 10 | 19 | 30 |  |  | Sen
Country1 | HP | 17 | Sal | KAS | 478 | 478 | 478 | 479 | 483 |  |  | Sen2
Country1 | Base | 18 | Sal | KAS | 54049 | 64830 | 74674 | 87031 | 100489 |  |  | HP
Country1 | Base 2 | 18 | Sal | KAS | 38 | 42 | 48 | 55 | 60
Country1 | Sen | 18 | Sal | KAS | 0 | 1 | 4 | 12 | 22
Country1 | Sen2 | 18 | Sal | KAS | 2 | 6 | 13 | 18 | 26 |  |  | Variable (dropdown)
Country1 | HP | 18 | Sal | KAS | 566 | 566 | 566 | 566 | 570 |  |  | Country1
Country2 | Base | 18 | Sal | KAS | 186540 | 211549 | 249233 | 293289 | 324817 |  |  | Sal
Country2 | Base 2 | 18 | Sal | KAS | 37 | 40 | 45 | 50 | 53 |  |  | KAS
Country2 | Sen | 18 | Sal | KAS | 2 | 6 | 12 | 17 | 24 |  |  | 14
Country2 | HP | 18 | Sal | KAS | 566 | 566 | 566 | 566 | 566
Country2 | Base | 14 | Sal | KAS | 68436 | 78000 | 90000 | 103521 | 125190 |  |  | Based on 3 variables (dropdown) Country, KAS & 14  return value from table on the left to table on the right.
Country2 | Base 2 | 14 | Sal | KAS | 30 | 34 | 39 | 44 | 49
Country2 | Sen | 14 | Sal | KAS | 1 | 2 | 5 | 12 | 17
Country2 | HP | 14 | Sal | KAS | 291 | 291 | 291 | 291 | 291
Country2 | Base | 16 | Sal | IMPORT | 105099 | 123000 | 146024 | 174927 | 206185
Country2 | Base 2 | 16 | Sal | IMPORT | 34 | 38 | 43 | 48 | 52
Country2 | Sen | 16 | Sal | IMPORT | 2 | 4 | 8 | 15 | 20
Country2 | HP | 16 | Sal | IMPORT | 404 | 404 | 404 | 404 | 404
 | Country | FUNC. | Grade
 | Country1 | KAS | 14
 | Country2 | IMPORT | 16
 |  |  | 17
 |  |  | 18
Spreadsheet: kate_symes__18449__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 |  |  |  |  |  | ..
Spreadsheet: rick_buy__32932__TAB6_EPMI_ISDA
Sheet: Liquidation Value

Deal ID | Deal Ticket ID | Contract ID | Deal Date | Forward Date | LoadDefinition NM | MW | Nominal Volume | Discounted Volume | Contract Price | Bid/Offer | NominalLQValue | DiscountLQValue | CounterParty NM | Commodity NM | Region_NM | DealType_NM | UtilityName | RateScheduleName | Buy/Sell | Physical
28319 | 534 | 9996832 | 2001-09-25 00:00:00 | 2001-12-01 00:00:00 | East OffPeak | 50 | 21200 | 21134.45 | 21.2 | 17.5 |  |  | Enron Power Marketing | Electricity | WH | Swap | (Generation Only) | WH | Buy | No
28399 | 543 | 9996885 | 2001-10-08 00:00:00 | 2001-12-01 00:00:00 | East OffPeak | 50 | 21200 | 21134.45 | 20.15 | 17.5 |  |  | Enron Power Marketing | Electricity | WH | Swap | (Generation Only) | WH | Buy | No
24298 | 207 | 9993270 | 2001-04-19 00:00:00 | 2001-12-01 00:00:00 | East Peak | 50 | 16000 | 15950.53 | 55 | 34.7 |  |  | Enron Power Marketing | Electricity | NE | Swap | (Generation Only) | NE | Buy | No
Spreadsheet: 879222d1726668801-excel-time-sheet-needs-to-work-out-hours-but-take-off-30-mins-if-a-break-was-taken-new-gss-labour-sheet
Sheet: Weekly

Attention: - SUTTI / MARTIN / DANNY |  |  |  | Date-: Mon 17th Sept 2024
[NAME] To :-  AHLMARK SHIPPING (UK) Ltd
Vessel / Job = |  | Swe-Freighter
*- Crane Driver Always No.1 - If No Crane Driver Ordered Leave CD Empty
Men | Name | Start | Finish | Break | Normal Hrs | O/T Hrs | [NAME]
CD | S NICHOLLS | 06:00:00
1 | M [NAME] | 06:00:00
2 | J TOMKINS | 06:00:00
3 | N SHIPLEY | 06:00:00
4 | J SAINSBURY | 06:00:00
5 | M CAWKILL | 06:00:00
6 | N PARKER | 06:00:00
7 | L ZEIMSKI | 06:00:00
8 | L BRAITHWAITE | 06:00:00
9 | J SYLVESTER | 06:00:00
10 | K LAMBERT | 06:00:00
11 | L BLACK | 06:00:00
12 | I VASILJEVAS | 06:00:00
13
14
15
16
17
18
19
20
21
 | Goole Men Travel
 |  |  |  | Total Hrs
 | Costs For Invoicing | Normal Hrs | Over Time
 | [NAME]
 | Stevedores
 | Travel |  | 0
Please Sign and E-Mail Back To:                                                                     [EMAIL]; [EMAIL]; [NAME] |  |  |  | Total
Signed:
Spreadsheet: 889887d1740893474-identifying-the-patients-having-specific-combination-of-conditions-multiple-rows-mwal13-sample_mw-tms
Sheet: Sheet1

PID | DISEASE CODE | DESCRIPITON |  | Combined
1 | 51356 | Eczema | Example 1
1 | 51355 | Psoriasis |  |  | Eczema|Psoriasis|Fracture
1 | 51358 | Fracture |  |  | Eczema|Psoriasis|Fracture
2 | 51358 | Fracture |  |  | Fracture|Eczema|Psoriasis
2 | 51356 | Eczema |  |  | Fracture|Eczema|Psoriasis
2 | 51355 | Psoriasis |  |  | Fracture|Eczema|Psoriasis
3 | 51355 | Psoriasis |  |  | Psoriasis|Fracture
3 | 51358 | Fracture |  |  | Psoriasis|Fracture
4 | 51356 | Eczema |  |  | Eczema|Psoriasis
4 | TMS test | Psoriasis |  | <<< | Eczema|Psoriasis |  | <<< automatically extends entries
 | Added for testing
 |  |  | Example 2 |  | Eczema|Psoriasis|Fracture
 |  |  | Fixed range | 2 | Fracture|Eczema|Psoriasis
 |  |  | A2:C10 |  |  |  | <<< does not automatically extend the extracted list
 |  |  | Example 3 |  | Eczema|Psoriasis|Fracture
 |  |  | Unlimited | 2 | Fracture|Eczema|Psoriasis
 |  |  |  | 4 | Eczema|Psoriasis |  | <<< automatically extends the extracted list
 |  |  | All these formulae SPILL down
 |  |  | You do not need to copy them down
 |  |  | The first concatenates the disease descriptions on a row by row basis
 |  |  | (It is for reference only)
 |  |  | The last one will work for any number of rows and extracts the patient list
 |  |  | Do not put anything under column A or column C
Spreadsheet: 8de901df-42f1-4730-9cfd-6c7091fd18f7
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
ANAH2 | Test | ANAH2 | Antinuclear Antibodies (ANA), [NAME], Serum | Antinuclear Ab, HEp-2 Substrate, S | Immunofluorescence Assay (IFA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.350 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative (titer of <1:40) If positive, pattern will be reported and serum will be titered. | Monday through Friday. Sunday; 3rd shift | 1 day/2 days if positive | 4 days | 1 | 86038 |  |  |  |  | New England
ANAH2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ANAH2 | Result | 86038 | Antinuclear Ab, HEp-2 Substrate, S | Antinuclear Ab, HEp-2 Substrate, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8061-4
ANAH2 | [NAME] | ANAB | Antinuclear Antibody (Multiple), Serum | Antinuclear Antibody (Multiple), S | Immunofluorescence Assay (IFA) | Plain, Red-Top Tube: Red |  |  | 0.4 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.4 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative (Titer of <1:40)  If positive, pattern will be reported and serum will be titered. | Monday through Friday; 1st shift | 1 day/2 days if positive | 4 days | 1 | 86039 |  |  | No | No
ANAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ANAB | Result | 11215 | ANA Titer: | ANA Titer: | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5048-4
ANAB | Result | 11214 | ANA Pattern: | ANA Pattern: | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49311-4
ANAB | Result | 11054 | ANA Titer(2) | ANA Titer(2) | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
ANAB | Result | 11213 | ANA Pattern(2) | ANA Pattern(2) | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 288569d1389232778-find-a-specific-accounts-value-from-a-range-of-text-strings-upload-a-spreadsheet-to-excelforum-010614
Sheet: Sheet1

 |  |  |  | Find a specific account's value from a range of text strings.
 | The Data below was copied and then special pasted intact as a form.
 | The actual info or values were changed or x'd out, but the values shown retain their original character including some nonbreaking space characters.
 | Each account in row B is manipulated by 3 formulas to net the value of an account in the table at Column I.
 | What I would like to do is find a numeric value for each account in the table using a single formula for each.
 |  |  |  |  | Acct No. |  |  | Results
 |  |  |  |  | & Value |  |  | Column
 | Accounts |  |  |  | formulas |  | (entry) | (formula)
 | xxxxxxx |  |  |  |  |  | Acct | Value
 |  |  |  |  |  |  | 123456789 XZ |  | value not found because formula in Col. F removed the XZ terms.
 |  |  |  |  |  |  | 101112134
 |  |  |  |  |  |  | 202224268
 |  |  |  |  |  |  | 404448536
 | Account Balance
 | Account number:[PHONE] XZ
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$12,345.56
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Summary
 | Account number:101112134
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$24,691.12
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Summary
 | Account number:202224268
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$16,543.05
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Summary
 | Account number:404448536
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$33,086.10
 | xxxxxxx
Spreadsheet: 879629d1727200294-group-rows-keep-text-statetrialformula
Sheet: Sheet1

State | Order   # | Date |  | State | Order   # | Date
CT | 805359 | 2024-09-05 00:00:00 |  | NH | 822063 | 2024-09-23 00:00:00
NM | 822049 | 2024-09-23 00:00:00 |  | RST | 822063 | 2024-09-23 00:00:00
NH | 822063 | 2024-09-23 00:00:00 |  | WY | 822468 | 2024-09-26 00:00:00
RST | 822063 | 2024-09-23 00:00:00 |  | RST | 822468 | 2024-09-26 00:00:00
CA | 822258 | 2024-09-27 00:00:00 |  | RST CHG | 822468 | 2024-09-26 00:00:00
WY | 822468 | 2024-09-26 00:00:00 |  | NC | 824377 | 2039-10-10 00:00:00
RST | 822468 | 2024-09-26 00:00:00 |  | RST 1ST | 824377 | 2039-10-10 00:00:00
RST CHG | 822468 | 2024-09-26 00:00:00 |  | clevland | 825059 | 2024-09-30 00:00:00
KY | 822513 | 2024-08-21 00:00:00 |  | RST | 825059 | 2024-09-30 00:00:00
NC | 824377 | 2039-10-10 00:00:00 |  | FL | 828049 | 2024-10-10 00:00:00
RST 1ST | 824377 | 2039-10-10 00:00:00 |  | RSTfl | 828049 | 2024-10-10 00:00:00
clevland | 825059 | 2024-09-30 00:00:00 |  | RST 1ST | 828049 | 2024-10-10 00:00:00
RST | 825059 | 2024-09-30 00:00:00 |  | Mass | 828098 | 2024-09-09 00:00:00
[NAME] | 827661 | 2024-10-10 00:00:00 |  | RST | 828098 | 2024-09-09 00:00:00
FL | 828049 | 2024-10-10 00:00:00 |  | RST  CHG | 828098 | 2024-09-09 00:00:00
RSTfl | 828049 | 2024-10-10 00:00:00 |  | RST 1ST | 828098 | 2024-09-09 00:00:00
RST 1ST | 828049 | 2024-10-10 00:00:00
Mass | 828098 | 2024-09-09 00:00:00
RST | 828098 | 2024-09-09 00:00:00
RST  CHG | 828098 | 2024-09-09 00:00:00
RST 1ST | 828098 | 2024-09-09 00:00:00
NY | 828143 | 2024-09-26 00:00:00
LA | 828207 | 2024-09-24 00:00:00
MO | 828361 | 2024-09-27 00:00:00
__________________ | _______ | ___________
Spreadsheet: 861527d1709401662-to-show-months-without-data-as-well-all-months-to-show-aligw
Sheet: Sheet1

Period | Amount |  | What I get
2023-10-31 00:00:00 | 90 |  |  | 2023-11-30 00:00:00 | 2024-01-31 00:00:00 | 2024-03-31 00:00:00 |  |  |  |  | Nov'23 | Dec'23 | Jan'24 | Feb'24 | Mar'24 | Apr'24 | May'24 | Jun'24 | Jul'24 | Aug'24 | Sep'24
2023-11-30 00:00:00 | 100 |  | 90 | 100 | 1039 | 12 |  |  |  | 90 | 100 | 0 | 1039 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0
2024-01-31 00:00:00 | 120
2024-01-31 00:00:00 | 919
2024-03-31 00:00:00 | 12
 |  |  | What I want
 |  |  | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00
 |  |  | 90 | 100 | 0 | 1039 | 0 | 12
Spreadsheet: 770250d1645949850-offset-with-count-not-working-horizontally-book1-1-
Sheet: scores-averages

PLAYERS | SUITE SPOT GOLF LEAGUE AVERAGES
16 WEEK SCHEDULE | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Average
[NAME], [NAME], [NAME] | 33 | 54 | 43 | 17 | 16 | 15 | 100
Berry, [NAME], [NAME] | 11 | 21 | 17
Coble, [NAME], [NAME] | 12 | 14 | 16 | 32 | 33 | 44 | 55
Protsman, [NAME], [NAME]
[NAME], [NAME], Todd
Dabe, [NAME], Brett
Dahl, [NAME], [NAME]
Hernandez, [NAME], [NAME]
Osbourn, Tyler + Salm, [NAME]
Busick, [NAME], [NAME]
Sellers, [NAME], [NAME]
[NAME], [NAME], [NAME]
Beery, [NAME], [NAME]
Dice, [NAME], [NAME]
[NAME], [NAME], [NAME]
[NAME], [NAME], Adam
Dewitt, [NAME], [NAME]
Cole, [NAME]
[NAME], [NAME], [NAME]
[NAME], [NAME], [NAME]
Searls, [NAME]
Stonebaker, [NAME], [NAME]
[NAME], Landon + Faurote, [NAME]
Lehman, [NAME], [NAME]
Hamman, [NAME], [NAME]
Hinton, [NAME], Chance
Grant, Zach + Howenstine, [NAME]
Craddock, [NAME], [NAME]
Groves Jr, Rocky + Groves, Rocky
Mcinturff, [NAME]
Gull + Gull1