tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: aceeacc2-3bc8-4497-ad6a-9e2c221176df
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
DHEA_ | Test | DHEA_ | Dehydroepiandrosterone (DHEA), Serum | Dehydroepiandrosterone, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Additional Information:  1. Patient's age and sex are required. 2. See Steroid Pathways in Special Instructions. | 0.45 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK <6 hrs; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | Premature: <40 ng/mL* 0-1 day: <11 ng/mL* 2-6 days: <8.7 ng/mL* 7 days-1 month: <5.8 ng/mL* >1-23 months: <2.9 ng/mL* 2-5 years: <2.3 ng/mL 6-10 years: <3.4 ng/mL 11-14 years: <5.0 ng/mL 15-18 years: <6.6 ng/mL 19-30 years: <13 ng/mL 31-40 years: <10 ng/mL 41-50 years: <8.0 ng/mL 51-60 years: <6.0 ng/mL > or =61 years: <5.0 ng/mL   *Source: Dehydroepiandrosterone. In Pediatric Reference Ranges. 5th edition. Edited by [NAME], C Brugnara, [NAME]. Washington, DC, AACC Press, 2005, p 75 | Monday through Friday; 9 a.m. | 2 days | 6 days | 1 | 82626 |  |  |  |  | Rochester
DHEA_ | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
DHEA_ | Result | 81405 | Dehydroepiandrosterone, S | Dehydroepiandrosterone, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2193-1 | Dehydroepiandrosterone:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 792940d1661240951-xlookup-gives-n-a-xlookup
Sheet: Info

Year-month | Quarter
2022-01 | Q1
2022-02 | Q1
2022-03 | Q1
2022-04 | Q2
2022-05 | Q2
2022-06 | Q2
2022-07 | Q3
2022-08 | Q3
2022-09 | Q3
2022-10 | Q4
2022-11 | Q4
2022-12 | Q4
Spreadsheet: 175202d1345455995-3-levels-independent-drop-down-lists-book1
Sheet: List2

2nd |  |  | 3rd
Item | Color |  | Black | Red | Blue | White | Pink | Yellow
Pencil | Black |  | Variant1 | Variant1 | Variant1 | Variant1 | Variant1 | Variant1
Ballpen | Black |  | Variant2 | Variant2 | Variant2 |  |  | Variant2
Ballpen | Red |  | Variant3 |  | Variant3
Ballpen | Blue
Eraser | White
Eraser | Pink
Eraser | Yellow
Spreadsheet: 881811d1730010103-how-to-have-return-results-of-a-function-split-across-multiple-lines-jeff-12345-testfile-3-spill-365-aligw
Sheet: Co-Loader Charges

Co-Loader Charges
 |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges. (Done)
Co-Loader: |  | CoLoad-1
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | Co-Loader | Co-Loader Total Chgs: | THC/ Origin HC | Stripping | Stripping Charge | [NAME] | I.T. Prep | Chassis Usage/ Suchg (CUC) | Equip Schg | Low Sulfur or [NAME] | CFS Fuel Schg | CFS/Port Sec I.S.P.S. Fee
2023-08-10 00:00:00 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | CoLoad-1 | 270 | 50 | 0 | 25 | 55 | 35 | 15 | 10 | 0 | 35 | 45
2023-09-15 00:00:00 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL | CoLoad-1 | 270 | 50 | 25 | 0 | 55 | 35 | 15 | 10 | 0 | 35 | 45
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | CoLoad-1 | 294.84 | 61.45 | 30.73 | 0 | 55 | 35 | 15 | 17.66 | 35 | 0 | 45
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | CoLoad-1 | 275.13 | 50.53 | 25.26 | 0 | 55 | 35 | 15 | 14.34 | 0 | 35 | 45
2023-10-05 00:00:00 | Client-1 | 5 | Barcelona | NY | Boston | 1-box | 72 | 0.15 | LCL | CoLoad-1 | 270 | 50 | 25 | 0 | 55 | 35 | 15 | 10 | 0 | 35 | 45
2023-10-17 00:00:00 | Client-1 | 6 | Barcelona | NY | Boston | 1-box | 103 | 0.17 | LCL | CoLoad-1 | 270 | 50 | 25 | 0 | 55 | 35 | 15 | 10 | 0 | 35 | 45
2023-10-19 00:00:00 | Client-1 | 7 | [NAME] | NY | Boston | 5-box | 1310 | 1.53 | LCL | CoLoad-1 | 270.83 | 50 | 25 | 0 | 55 | 35 | 15 | 10.83 | 0 | 35 | 45
2023-10-26 00:00:00 | Client-1 | 8 | [NAME] | NY | Boston | 5 | 2170 | 1.94 | LCL | CoLoad-1 | 284.32 | 54.25 | 27.13 | 0 | 55 | 35 | 15 | 17.94 | 0 | 35 | 45
Spreadsheet: 30756e73-8437-48ce-bb7d-f90401ea469c
Sheet: netLibrary

NetLibrary
2007-2008
 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Price per access
NetLibrary
Accesses | 48 | 24 | 55 | 180 | 139 | 140 | 59 | 106 | 101 | 79 | 28 | 52 |  | 0 | N/A
Turnaways | 0 | 3 | 7 | 31 | 12 | 18 | 26 | 1 | 1 | 0 | 16 | 15
Note: We have 4,478 shared titles
COUNTER-Compliant?: | No
Spreadsheet: 274623d1383164744-move-data-from-master-job-sheet-to-a-print-sheet-job-list-weekly-print
Sheet: Print Job Sheet

Job | REV | Customer | Description | Engineer | Ship Date | Tool Maker | Active
Job | REV | Customer | Description | Engineer | Ship Date | Tool Maker | Active
867 |  | ABC | Small Cleat | [NAME] | 2013-11-13 00:00:00 | [NAME] | r
947 |  | Walmart | Punch & Ring | hoepner | 2013-11-14 00:00:00 | Chad | r
956 | R | ABC | Handle Cleat | kluger | 2013-11-15 00:00:00 | Chad | r
963 |  | Target | Leeson Switch 6348-09 | [NAME] | 2013-11-16 00:00:00 | [NAME] | r
Spreadsheet: 456333d1460751250-need-help-comparing-products-in-a-family-and-concatenating-their-column-headers-thankyou
Sheet: Sheet1

Product_Article_Number | Family_Article_Number | richContentStatus | orderingAttributeList (comma delimited) | commonSpecs (comma delimited)
#112 | 1 | true | dimMessage,[NAME],Finish,MountingType,SizeEnglish,dimMaterial | dimTemperatureRangeEnglish,Quantity,Shape
#113 | 1 | true | dimMessage,[NAME],Finish,MountingType,SizeEnglish,dimMaterial | dimTemperatureRangeEnglish,Quantity,Shape |  | <Example
#114 | 1 | true | dimMessage,[NAME],Finish,MountingType,SizeEnglish,dimMaterial | dimTemperatureRangeEnglish,Quantity,Shape
#115 | 2 | true
#116 | 2 | true
#117 | 3 | true
#118 | 3 | true
#119 | 5 | true
#120 | 5 | true
#121 | 6 | true
#122 | 6 | true
#123 | 6 | true
Spreadsheet: 47344d1246377973-creating-list-with-true-false-field-delete-rows-based-on-condition
Sheet: Sheet2

1 | a | c | g
1 | b | d | h
1 | c | e | i
1 | d | f | j
1 | e | g | k
1 | f | h | l
1 | h | j | n
1 | i | k | o
1 | j | l | p
1 | k | m | q
1 | l | n | r
1 | m | o | s
1 | n | p | t
1 | o | q | b
1 | q | s | c
1 | r | t | d
1 | s | b | c
Spreadsheet: 718116d1612989596-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 3

 |  |  | Date | 2021-01-03 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 1 day, 0:00:00 | 1 day, 0:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 144850d1331158991-excel-2007-sumifs-into-excel-2003-sumifs-modified-by-tigeravatar-
Sheet: Sheet1

Item | [NAME] | ship
1 | 8 | 2012-03-09 00:00:00
2 | 8 | 2012-03-15 00:00:00
3 | 8 | 2012-03-16 00:00:00
4 | 8 | 2012-03-19 00:00:00
5 | 8 | 2012-03-20 00:00:00
6 | 11 | 2012-03-23 00:00:00
7 | 12 | 2012-03-26 00:00:00
8 | 8 | 2012-03-30 00:00:00
9 | 11 | 2012-04-10 00:00:00
10 | 8 | 2012-04-13 00:00:00
1 | 11 | 2012-04-17 00:00:00
2 | 8 | 2012-04-23 00:00:00
3 | 15 | 2012-04-24 00:00:00
4 | 8 | 2012-04-03 00:00:00
5 | 9 | 2012-04-09 00:00:00
6 | 14 | 2012-05-01 00:00:00
7 | 3 | 2012-03-29 00:00:00
8 | 24 | 2012-03-26 00:00:00
9 | 24 | 2012-03-30 00:00:00
10 | 24 | 2012-04-12 00:00:00
1 | 24 | 2012-04-16 00:00:00
2 | 24 | 2012-04-23 00:00:00
3 | 24 | 2012-04-26 00:00:00
4 | 48 | 2012-04-30 00:00:00
5 | 24 | 2012-04-09 00:00:00
6 | 10 | 2012-03-16 00:00:00
7 | 21 | 2012-03-16 00:00:00
8 | 8 | 2012-04-17 00:00:00
9 | 8 | 2012-04-03 00:00:00
10 | 6 | 2012-04-03 00:00:00
1 | 6 | 2012-03-09 00:00:00
2 | 6 | 2012-03-12 00:00:00
3 | 6 | 2012-03-15 00:00:00
4 | 6 | 2012-03-19 00:00:00
5 | 6 | 2012-03-21 00:00:00
6 | 6 | 2012-03-22 00:00:00
7 | 6 | 2012-03-23 00:00:00
8 | 6 | 2012-03-27 00:00:00
9 | 6 | 2012-03-28 00:00:00
10 | 6 | 2012-04-10 00:00:00
1 | 6 | 2012-04-11 00:00:00
2 | 6 | 2012-04-12 00:00:00
3 | 6 | 2012-04-13 00:00:00
4 | 6 | 2012-04-17 00:00:00
5 | 6 | 2012-04-19 00:00:00
6 | 6 | 2012-04-23 00:00:00
7 | 6 | 2012-04-25 00:00:00
8 | 6 | 2012-04-27 00:00:00
9 | 6 | 2012-04-03 00:00:00
10 | 6 | 2012-04-04 00:00:00
1 | 6 | 2012-04-05 00:00:00
2 | 6 | 2012-05-01 00:00:00
3 | 6 | 2012-05-02 00:00:00
4 | 20 | 2012-03-13 00:00:00
5 | 20 | 2012-03-14 00:00:00
6 | 20 | 2012-03-22 00:00:00
7 | 20 | 2012-04-12 00:00:00
8 | 20 | 2012-04-18 00:00:00
9 | 20 | 2012-04-25 00:00:00
10 | 20 | 2012-04-27 00:00:00
1 | 20 | 2012-04-03 00:00:00
2 | 4 | 2012-03-23 00:00:00
3 | 12 | 2012-03-23 00:00:00
4 | 4 | 2012-03-26 00:00:00
5 | 7 | 2012-03-26 00:00:00
6 | 10 | 2012-03-26 00:00:00
7 | 18 | 2012-03-26 00:00:00
8 | 4 | 2012-03-27 00:00:00
9 | 10 | 2012-03-27 00:00:00
10 | 11 | 2012-03-27 00:00:00
Spreadsheet: 815708d1675163403-looking-for-formula-that-filters-upcoming-due-dates-that-havent-been-filed-sample4
Sheet: Sheet1

 |  |  |  |  | Upcoming Dues |  |  |  | Result I would like to see …
Document # | Filed | Due Date |  |  | Document # | Filed | Due Date |  | Document # | Filed | Due Date
Document 1 | NO | 2023-01-31 00:00:00 |  |  | [NAME] Here … |  |  |  | Document 1 | NO | 2023-01-31 00:00:00
Document 2 | NO | 2023-02-05 00:00:00 |  |  |  |  |  |  | Document 2 | NO | 2023-02-05 00:00:00
Document 3 | YES | 2023-02-05 00:00:00 |  |  |  |  |  |  | Document 4 | NO | 2023-02-15 00:00:00
Document 4 | NO | 2023-02-15 00:00:00 |  |  |  |  |  |  | Document 5 | NO | 2023-02-15 00:00:00
Document 5 | NO | 2023-02-15 00:00:00
Spreadsheet: 731570d1620414795-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: OMG

S.N. | Particulars | Bought  Units | Unit or OMG Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | OMG @ Bittrex - Purchase | 99.25120663 | 0.00115006 |  | -0.11443119 | 18981.9 | 2017-12-18 00:00:00 | 2017-12-18 00:00:00
2 | OMG @ Bittrex - Sale | -99.25120663 | 0.00152778 |  | 0.15125592 | 13820.3 | 2017-12-31 00:00:00
3 | OMG @ Bittrex - Purchase | 25.48869299 | 0.00140885 |  | -0.03599977 | 13338.4 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00
4 | Fees for transferring 110.73 STRAT from Binance to Ledger (via MEW) | -0.35 |  |  |  |  | 2018-01-12 00:00:00
5 | OMG @ Binance - Sale | -25.13 | 0.001194 |  |  | 7083 | 2018-03-29 00:00:00
6
7
8
9
10
 | OMG in [NAME] (via MEW) | 0
 | OMG in Bittrex | 0
 | OMG in Binance | 0.00869299
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 841283d1693480685-find-unique-values-and-copy-them-to-another-tab-financial-administration-2023
Sheet: Overview per quarter 2023

 | Exch. [NAME] | 4.7 | Exch. R. Q2 | 4.7 | Exch. [NAME] | 4.7 | Exch. R. Q4 | 4.7
General: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
January
February
March
Total Q1:
April
May
June
Total Q2:
In-decrease (%)
July
August
September
Total Q3:
In-decrease (%)
October
November
December
Total Q4:
In-decrease (%)
Total:
Projects
January
February
March
Total Q1:
April
May
June
Total Q2:
In-decrease (%)
July
August
September
Total Q3:
In-decrease (%)
October
November
December
Total Q4:
In-decrease (%)
Total:
Spreadsheet: 169891d1343092198-adding-a-column-representing-the-sequence-of-duplicates-in-a-specific-column-countifs-in-column
Sheet: Sheet1

Patient ID | SEQ | SeqFormula
1 | 1 |  | <<Put this formula in A2 and pull down
1 | 2 |  | The A$1 holds the top cell and the A2 follows the row down
2 | 1
3 | 1
4 | 1
4 | 2
5 | 1
6 | 1
7 | 1
8 | 1
9 | 1
10 | 1
10 | 2
11 | 1
12 | 1
13 | 1
14 | 1
15 | 1
16 | 1
17 | 1
18 | 1
18 | 2
18 | 3
19 | 1
19 | 2
Spreadsheet: 35960d1233694186-using-countif-function-with-the-month-and-year-function-sample-data
Sheet: Sheet1

start date |  |  | Month/Year | Total
2009-01-05 00:00:00 |  |  | 2008-04-01 00:00:00
2009-01-16 00:00:00 |  |  | 2008-05-01 00:00:00
2009-05-08 00:00:00 |  |  | 2008-06-01 00:00:00
2008-04-08 00:00:00 |  |  | 2008-07-01 00:00:00
2008-05-05 00:00:00 |  |  | 2008-08-01 00:00:00
2008-08-08 00:00:00 |  |  | 2008-09-01 00:00:00
2009-01-05 00:00:00 |  |  | 2008-10-01 00:00:00
2009-01-20 00:00:00 |  |  | 2008-11-01 00:00:00
2008-06-30 00:00:00 |  |  | 2008-12-01 00:00:00
Spreadsheet: tori_kuykendall__39961__DailyPrices
Sheet: Variable Rates

 |  |  |  |  |  | San Juan | Permian
Pipline | Receipt | Alt. Receipt | Volume | Delivery | Alt. Delivery | Volume | Variable | Fuel | Comm | GRI | ACA | Notes
Transwestern | [NAME] | Any | 40000 | [NAME] | Any | 25000 |  | 0.0156 | 0 | 0 | 0
 |  |  |  | [NAME] | Any | 15000 |  | 0.0156 | 0 | 0 | 0
 | West Texas | None | 8000 | [NAME] | Any EOT | 8000 |  | 0.0131 | 0 | 0 | 0
 | [NAME] | Any La Plata | 25000 | [NAME] | TW SJ Pool | 25000 |  | 0.0025 | 0 | 0 | 0
 | [NAME] | Any La Plata | 12500 | [NAME] | TW SJ Pool | 12500 |  | 0.0025 | 0.06 | 0 | 0
 | SJ Pool | None | 25000 | Thoreau | None | 25000 |  | 0.0025 | 0.0011 | 0 | 0
 | Thoreau | None | 25000 | Citizens | None | 25000 |  | 0.045 | 0.0153 | 0.0072 | 0.0022
El Paso | SJ | None | 16495 | Ivalero | None | 16495 |  | 0.0388 | 0.0031 | 0 | 0.0022 | Havasu
 | Perm | None |  | Ivalero |  |  |  | 0.0158 | 0.0058 | 0 | 0.0022
 | SJ |  | 80000 | Topock (except SWG) |  | 80000 |  | 0.0388 | 0.0166 | 0.0072 | 0.0022
 | Perm |  |  |  |  |  |  | 0.0388 | 0.0341 | 0.0072 | 0.0022
 | Anadarko |  |  |  |  |  |  | 0.0388 | 0.0383 | 0.0072 | 0.0022
 | SJ |  | 20000 | [NAME] |  | 20000 |  | 0.0388 | 0.0166 | 0.0072 | 0.0022
 | Perm |  |  |  |  |  |  | 0.0388 | 0.0341 | 0.0072 | 0.0022
 | Anadarko |  |  |  |  |  |  | 0.0388 | 0.0383 | 0.0072 | 0.0022
 | None | SJ | 467513 | All Topock Deliveries |  | 467513 |  | 0.0388 | 0.0166 | 0 | 0.0022 | Block 1
 |  | Perm |  | Socal [NAME] |  |  |  | 0.0388 | 0.0341 | 0 | 0.0022
 |  | Anadarko |  |  |  |  |  | 0.0388 | 0.0383 | 0 | 0.0022
 |  |  |  |  | Plains |  |  | 0 | 0.04 | 0 | 0
 |  |  |  |  | Felmac (Westar Storage) |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Oasis |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Westar |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Valero |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Delhi |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Lonestar |  |  | 0.0158 | 0.04 | 0 | 0
 |  |  |  |  | Window Rock |  |  | 0.0388 | 0.04 | 0 | 0
 |  |  |  |  | Icanute - TexOK |  |  | 0.0158 | 0.06 | 0 | 0
 |  |  |  |  | NGPL Washita #7 |  |  | 0.0158 | 0.06 | 0 | 0 | Perm to
 |  |  |  |  | NGPL Moore |  |  | 0.0158 | 0.06 | 0 | 0 | Midcon
 |  |  |  |  | [NAME] |  |  | 0.0158 | 0.06 | 0 | 0
 |  |  |  |  | IHUECO - Pemex |  |  | 0.0388 | 0.14 | 0 | 0
 | SJ | None | 593122 | Socal Topock |  |  |  | 0.0388 | 0.0166 | 0 | 0.0022
 | Perm |  |  | PG&E Topock |  |  |  | 0.0388 | 0.0341 | 0 | 0.0022
 | Anadarko |  |  | Mojave Topock |  |  |  | 0.0388 | 0.0383 | 0 | 0.0022
 | SJ | None | 193454 | Socal Topock |  |  |  | 0.0388 | 0.0166 | 0 | 0.0022
 | Perm |  |  | PG&E Topock |  |  |  | 0.0388 | 0.0341 | 0 | 0.0022
 | Anadarko |  |  | Mojave Topock |  |  |  | 0.0388 | 0.0383 | 0 | 0.0022
Spreadsheet: 275988d1383711853-check-for-name-in-sheet-1-and-put-data-from-that-sheet-name-in-to-sheet-2-excel-example-form
Sheet: Sheet2

Mechanic | [NAME] | Hours Clocked | % Prod | [NAME] | Inv Hrs Charged | Inv Hrs Clocked | WIP Hours | Eff % | Charging Eff % | [NAME] | [NAME] | Month
[NAME] | 114.84 | 93.5 | 0.8141762452 | 19.79 | 123.9614 | 93.5 | 0 | 1.3257903743 | 1.0794270289 | 14109 | 24329 | 24329
[NAME] | 171.55 | 158.23 | 0.9223549985 | 13.32 | 190.6776 | 157.26 | 1 | 1.2124990462 | 1.1114986884 | 21342 | 24329 | 24329
[NAME] | 164.39 | 147.07 | 0.8946407932 | 15.77 | 167.5304 | 145.17 | 1.9 | 1.1540290694 | 1.0191033518 | 19671 | 24329 | 24329
[NAME] | 164.46 | 159.82 | 0.9717864526 | 4.64 | 171.0294 | 151.86 | 8.33 | 1.1262307388 | 1.0399452754 | 20488 | 24329 | 24329
[NAME] | 213.92 | 83.07 | 0.3883227375 | 63.84 | 78.8014 | 70.47 | 19.16 | 1.1182261955 | 0.368368549 | 8941 | 24329 | 24329
[NAME] | 171 | 153.03 | 0.8949122807 | 17.57 | 163.9183 | 153.34 | 0.75 | 1.0689859137 | 0.9585865497 | 19066 | 24329 | 24329
[NAME] | 74.62 | 71.49 | 0.958054141 | 3.13 | 80.2588 | 79.14 | 0 | 1.0141369725 | 1.0755668722 | 9107 | 24329 | 24329
[NAME] | 148.08 | 76.55 | 0.5169502971 | 44.93 | 74.2529 | 78.38 | 0 | 0.947344986 | 0.5014377364 | 8572 | 24329 | 24329
[NAME] | 162.81 | 151.78 | 0.9322523187 | 9.88 | 149.9607 | 161.98 | 3.33 | 0.9257976293 | 0.9210779436 | 17770 | 24329 | 24329
[NAME] | 162.07 | 136.08 | 0.8396371938 | 22.61 | 125.5668 | 135.69 | 1.06 | 0.9253946496 | 0.774768927 | 14771 | 24329 | 24329
[NAME] | 80.43 | 63.14 | 0.7850304613 | 16.31 | 71.9818 | 78.94 | 3.23 | 0.9118545731 | 0.8949620788 | 8486 | 24329 | 24329
[NAME] | 173.98 | 163.77 | 0.9413150937 | 9.16 | 115.9635 | 134.92 | 28.85 | 0.8594982212 | 0.6665335096 | 13933 | 24329 | 24329
[NAME] | 150.15 | 130.36 | 0.8681984682 | 18.81 | 110.7187 | 132.14 | 3.4 | 0.8378893598 | 0.7373872794 | 12893 | 24329 | 24329
Check this column for the name then go to sheet 1 |  |  |  |  |  | Place the data from sheet 1 into this sheet in column K against the matching name
 |  |  | The names are not static and change position on a daily basis
Spreadsheet: 680088d1590771429-return-fiscal-week-duration-2020-05-29-oeldere-mandylm-680069d1590763683-return-fiscal-week-duration-excel-forum5
Sheet: Sheet1

 | [NAME] | SUB22 | TM22 | [NAME] | [NAME] | TM23 | [NAME] | SUB24 | [NAME] | LM25 | SUB25 | [NAME] | LM26 | SUB26 | TM26 | Fiscal Week 27
Duration | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM | LM | Sub | TM
22-25 | 1 | 2 | 22 | 1 | 2 | 23 | 1 | 2 | 24 | 1 | 2 | 25
week | TM
22
23
24
Hello,
Is there any way to return the fiscal week duration if the cell has a number in it?
I have all the fiscal weeks for the year and sub categories of LM, Sub and TM for each week. I need to show the duration in Column A only for the weeks that have a number in the TM column. Please see the attached sample worksheet. Thank you!
Spreadsheet: 11845ece-1d3e-4847-bc71-42f3b4cdaf8f
Sheet: Region Data

Idaho Department of Health and Welfare Division of Behavioral Health
Mental Health Public Dashboard for October, 2014
* means on report is that count is less then 5, for details please contact  Idaho Department of Health and Welfare Central Office.
Report Run Date: 11/17/2014
 |  | Mental Health Dashboard |  | Region 1 | Region 2 | Region 3 | Region 4 | Region 5 | Region 6 | Region 7 | State Wide
Admission / Discharge | Monthly | Adult Mental Health | AMH Admission | 16 | * | 17 | 30 | 8 | 9 | 14 | 97
 |  |  | AMH Discharge | 9 | 5 | 33 | 24 | 11 | 25 | 44 | 151
 |  | Children Mental Health | CMH Admission | 8 | 6 | * | 14 | 10 | 5 | 13 | 59
 |  |  | CMH Discharge | 6 | 6 | 8 | 16 | 7 | * | 16 | 63
 | SFY 2015 | Adult Mental Health | AMH Admission | 56 | 30 | 79 | 119 | 41 | 42 | 64 | 431
 |  |  | AMH Discharge | 71 | 44 | 90 | 123 | 50 | 46 | 126 | 550
 |  | Children Mental Health | CMH Admission | 33 | 25 | 26 | 51 | 52 | 21 | 47 | 255
 |  |  | CMH Discharge | 31 | 34 | 35 | 65 | 29 | 29 | 58 | 281
Adult Mental Health | Number of adult served this Month |  |  | 323 | 159 | 616 | 709 | 204 | 242 | 544 | 2797
 | Number of adults served SFY 2015 |  |  | 685 | 310 | 1221 | 1647 | 482 | 437 | 870 | 5652
Children's Mental Health | Number of children served this Month |  |  | 68 | 58 | 71 | 132 | 119 | 53 | 146 | 647
 | Number of children served SFY 2015 |  |  | 103 | 84 | 121 | 215 | 162 | 84 | 254 | 1023
Pre-Sentence Investigation Reports  (I.C. 19-2524) | Monthly |  |  | 26 | 7 | 79 | 93 | 34 | 28 | 39 | 306
 | SFY 2015 |  |  | 165 | 47 | 295 | 367 | 177 | 107 | 157 | 1315
Spreadsheet: 46513d1245346755-conditional-formatting-copy-problem-village-show-pionts-chart
Sheet: Sheet1

ENTRANTS NUMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
ENTRANTS FIRST NAME
SURNAME
PHOTOGRAPHY SECTION | POINTS | POINTS | POINTS | POINTS | POINTS | POINTS | POINTS | POINTS | POINTS | POINTS | POINTS
CLASS 1 | 12 |  |  |  |  | 5
CLASS 2 | 11
CLASS 3 |  |  |  |  |  | 6
CLASS 4
CLASS 5 |  |  | 43 |  |  | 3
CLASS 6 | 3
CLASS 7
TOTAL
Spreadsheet: 109511d1306343965-if-then-formula-tracking
Sheet: BYU

NAME | UNIT | DOR | UNIVERSITY | RRNCO | PMOS | GRAD DATE | MS LEVEL | COMPONENT | LOA | PACKET SUBMITTED | BONUS ELIGIBLE | END ACTION | NOTES | PACKET SUBMISSION DATE | CLASS II PHYSICAL DATE
TTT | TTT | TTT | BYU | SFC. [NAME] | TTT | TT | 2 | UTNG | YES | YES | YES | TTT | TEST | TT | TT
Spreadsheet: darron_c_giron__7915__PositiveMTMCounterparties
Sheet: Sheet1

AARB
AIGCOMARB
ALABAMAGASCOR
ASHLANDCHEM
ASHLANDSPECHE
BALTIMORE
BLUEMOOHOL
BOBWESTRE
BRIDGELIGASMAR
BURLINGTON RES
CASTLEPOWLLC
CENTRALILLLIGCO
CITIZEGASUTIDIS
[NAME]
CLINTONENEMAN
COASTENEGRO
COLUMBIA ENERGY
CONSUMERS
CROSSOILREF
DEGUSSAHULCOR
DEVXENEINC
DUFERCOFCOR
DYNEGYCAN
EMPIREDISTELE
ENERGYMARAD
ENSERCOENE
EOTTENEPARLP
[NAME]
FLORIDAPOWCOR
GENERALMILOPE
GIANTREFCOM
GLOBALOCT
GREATLAKCHECOR
HESSENESER
IGIRES
IMPERIALSUGCO
INTERSTATEPOWE
JOHNSMANINT
KERN
KERRMCGEENESER
[NAME]
LAMINADODEBAR
LAUSCHAFIBINT
LDNGCSER98TRU
LOUISIANAPACOR
MARATHON
MERCEDIRRDIS
MUNICIPALGAS
NATIONALFUEMAR
NAVAJOREFCOM
NEUMINPROCO
NOBLEGASMARKET
NORTHERN
NPC
NUIENEBRO
OCCIDENTENEMAR
OLDWORIND
ORMET
PRAXAIR
PRIORENECOR
PSEGENERES
PTEH
PUBLICUTILITIES
PUBSERCOLORADO
PUGETSOUENE
[NAME]
RG&E
SANDIEGO
SCANAENGRY
SELECTENE
SEMPRAENETRA
SGLCARLLC
SHELLCHELP
[NAME]
SMUD
SPRAGUEENECOR
STATESTRBAN
STONEENECOR
SUNCORENE
SYNGENTAAG
TEXACOGASMKT
TEXLANDLIMPAR
THIELEKAOCOM
TOTAL
TOTALFINAELFGAS
TRCOPECOM
TRISTAGEN
TXUENETRACOM
UNION GAS LTD
USBRICK
VIRGINIAPOWENE
WELCHFOOINC
WEST TEXAS GAS
WHIRLPOOCOR
WILLIAMSPRORMT
WISCONSINGAS
WTGGASMAR
WYMANGORCOM
Spreadsheet: 455255d1460193032-vlookup-headache-multiplelookup
Sheet: Sheet1

Customer ID | Customer | [NAME] | Customer ID | Customer | Ship to Address
 | AC | 1000 avenue |  | AB | 10050 avenue
 | AB | 10050 avenue
 | AB | 101 gensan
 | AX | 69 ave
 | you | 56 street
 | ty | new city
 | f | santiago
 | s | cebu
 | g | manila
Spreadsheet: 39749d1238026892-checks-and-balance-help-checks_balances
Sheet: Checks

Supplier | Invoice Period | Payroll Month | Total | Detail Total | Difference
ABC | 02/01/08 - 02/28/09 | 2009-04-01 00:00:00 | 4397.8 | = sum of all ABC transactions from "[NAME]" | = [NAME]
XYZ | 03/03/09 - 03/25/09 | 2009-04-01 00:00:00 | 6607.55 | = sum of all [NAME] transactions from "[NAME]"
JJJ |  |  | 1320 | = sum of all JJJ transactions from "[NAME]"
OOO |  |  | 2515 | = sum of all OOO transactions from "[NAME]"