tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 47008d1245926352-moving-values-around-example
Sheet: Output

 | Dato | 2009-01-01 00:00:00 | 2009-01-04 00:00:00 | 2009-01-07 00:00:00 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 2009-01-14 00:00:00
 | [NAME] | 1 | 2 | 3 | 4 | 5 | 6
Budsjettpost | Sum
Billetter    (3100) | -80000 | -50000 |  |  | -30000
Honorar  (7200) | 70000 |  | 20000 | 50000
Rider        (7220) | 10000 |  |  |  |  | 10000
Other       (7290) |  |  |  |  |  |  | 500
Spreadsheet: 220580d1363196724-link-word-object-with-excel-cells-sample-word-po
Sheet: Sheet1

Invoice to
Defiance Technologies Limited
No.52/37, 5th Floor
ASV N Ramana Towers
Venkatanarayana Road
T.Nagar, Chennai 600017
Purchase order
Order No.
2012-13/824
Dated
2013-03-12 00:00:00
Terms of payment
Against Delivery
Supplier
S K Electricals
137, [NAME]
Chennai – 600 001
[NAME]'s Ref.
Other Reference(s)
Sl No.
Description
Due on
Quantity
Rate
Amount
1
Almonard 24” wall Mounting
Air Circulator
2011-07-13 00:00:00
1
Rs.4,275.00
Rs.4,275.00
Total
Rs 4,275.00
Amount Chargeable (in words)
Rs  Four Thousand Two Hundred And Seventy Five Only
Remarks:
The above mentioned amount is exclusive of Taxes.
Company's VAT TIN
33251582703
Company's CST No
1002124/18.9.09
Company's Service Tax No
AADCD2152NSD002
Company's PAN
AADCD2152N
For Defiance Technologies Limited
Authorised Signatory
Spreadsheet: 835415d1688569018-complex-formula-split-text-into-several-chunks-based-on-character-count-test-copy
Sheet: Sheet1

 |  |  |  | Source copy: | Text_Chunk_1 | Text_Chunk_2 | Text_Chunk_3 | Text_Chunk_4 | Text_Chunk_5 | Text_Chunk_6 | Text_Chunk_7 | Text_Chunk_8 | Text_Chunk_9 | Text_Chunk_10
 |  |  |  | [NAME] ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Sapien eget mi proin sed libero enim sed faucibus turpis. Donec adipiscing tristique risus nec feugiat in fermentum. [NAME] ut porttitor [NAME] a [NAME] tempor. Eget duis at tellus at. Faucibus et molestie ac feugiat sed. Arcu felis bibendum ut tristique et egestas quis. Dictum varius duis at consectetur lorem donec. Ullamcorper a lacus vestibulum sed arcu. Eget felis eget nunc lobortis mattis. [NAME] eget egestas purus [NAME] in nisl. In hac habitasse platea dictumst quisque sagittis purus sit. [NAME] adipiscing enim [NAME] turpis egestas pretium aenean pharetra. Arcu ac tortor dignissim convallis aenean et tortor at risus. Egestas fringilla phasellus faucibus scelerisque eleifend donec pretium vulputate. [NAME] turpis nunc eget lorem dolor.  [NAME] augue ut lectus arcu bibendum at varius. Tristique risus nec feugiat in fermentum posuere urna nec. Sagittis vitae et leo [NAME] [NAME] porttitor. Eget egestas purus [NAME] in nisl nisi scelerisque eu. Tincidunt eget nullam non nisi est sit amet facilisis magna. [NAME] fringilla urna porttitor rhoncus dolor purus non enim praesent. Ut [NAME] [NAME] justo eget magna. Et malesuada fames ac turpis egestas integer. Mattis molestie a iaculis at erat pellentesque adipiscing. Condimentum vitae sapien pellentesque habitant morbi tristique senectus et. In fermentum posuere urna nec.  [NAME] rhoncus mattis rhoncus urna neque viverra justo nec. [NAME] duis ultricies lacus sed turpis tincidunt id. [NAME] sed vulputate mi sit amet [NAME].
Spreadsheet: 792717d1661096836-how-to-lookup-data-by-date-and-time-and-get-a-range-of-data-lookup-and-get-a-range-hd
Sheet: Sheet1

Data table(Source data) |  |  |  |  |  | Helprow
Date | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00
Time | 02:00:00 | 10:00:00 | 02:00:00 | 10:00:00
Subject Code-1 | 66451 |  | 66751 | 66751
[NAME] | 66751 |  | 67051 | 67051
Subject Code-3 | 67051 | 66751 | 67151 | 67151
Subject Code-4 | 67151 | 67051 | 66851 | 66851
Subject Code-5 | 66851 | 67151
Subject Code-6 | 68651 | 66851
Subject Code-7
Subject Code-8
(Input data)
Date input: | 2022-08-22 00:00:00
Time input: | 02:00:00
Subject Code (Required Output)
66451 |  |  | <<------
66751 |  | 66751
67051 |  | 67051
67151 |  | 67151
66851 |  | 66851
68651 |  | 68651
Spreadsheet: 677692d1589472773-search-multiple-columns-return-corresponding-value-search
Sheet: Sheet1

Tens | Color | Code | Hundreds | Color | Code | Thousand | Color | Code
10 | Red | 1R | 100 | Red-Yellow | 1RW | 1000 | Red-Green-Blue | 1RGB
20 | Blue | 2B | 200 | Blue-Red | 2BR | 2000 | Blue-Red-Green | 2BRG
30 | Green | 3G | 300 | Green-Indigo | 3GI | 3000 | Green-Indigo-Purple | 3GIP
40 | Orange | 4O | 400 | Orange-Blue | 4OB | 4000 | Orange-Blue-Red | 4OBR
50 | Purple | 5P | 500 | Purple-Orange | 5PO | 5000 | Purple-Orange-Yellow | 5POY
 | Search | 300
 | Return
 | Search | 4000
 | Return
 | Search | 20
 | Return
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Hantsport

Hantsport To: | [NAME]
Berwick, NS | 31
Bridgewater, NS | 63
Dartmouth, NS | 44
Debert, NS | 97
Digby, NS | 96
Halifax, NS | 47
[NAME], NB | 197
North Sydney, NS | 282
[NAME], NB | 285
Scoudouc, NB | 192
Sydport-Term, NS | 293
Truro, NS | 89
Spreadsheet: chris_stokley__3877__FERC1stQtr2001
Sheet: FERC

 | SALES |  |  |  |  |  | PURCHASES
 | NP15 |  |  | SP15 |  |  | NP15 |  |  | SP15
 | [NAME] | MIN price | MAX price | [NAME] | MIN price | MAX price | [NAME] | MIN price | MAX price | [NAME] | MIN price | MAX price
JAN
LOAD DEVIATION | 3755.33 | 0 | 150 | 4043.51 |  |  | -4609.94 | 0 | 150 | -5808.61
SUPPLEMENTAL | 50 | 150 | 150 | 0 |  |  | 0 |  |  | 0
FEB
LOAD DEVIATION | 77.21 | 0 | 150 | 541.09 | 0 | 150 | -512.8 | 0 | 150 | -12210.32 | 0 | 150
SUPPLEMENTAL | 0 |  |  | 0 |  |  | 0 |  |  | 0
[NAME]
LOAD DEVIATION | 3163.44 | 0 | 150 | 3610.51 | 0 | 150 | -2460.38 | 0 | 150 | -3117.27 | 0 | 150
SUPPLEMENTAL | 0 |  |  | 0 |  |  | 0 |  |  | 0
1st Qtr
LOAD DEVIATION
SUPPLEMENTAL
[NAME]
Spreadsheet: 735571d1623079148-extract-unique-values-from-a-range-extract-unique-values-from-a-range
Sheet: Sheet1

1 | 2 | 3 |  | a | b | c | d | e | f | g
a | 3 | c
d | e | 4
5 | a | b
e | f | d
2 | 4 | b
d | a | f
Spreadsheet: 811842d1672829469-index-match-approximate-with-two-criteria-between-two-worksheets-index-match-approximate-with-two-criteria-between-two-worksheets
Sheet: Love

 | S/No | Name | Company | Name on "Hello"
 | 1 | [NAME] | ABC | [NAME]
 | 2 | [NAME] | ABC | [NAME]
 | 3 | [NAME] | XYZ | Not Found
 | 4 | [NAME] | XYZ | [NAME]
 | 5 | [NAME] | XYZ | [NAME]
 | 6 | [NAME] | 123 | Not Found
 | 7 | [NAME] [NAME] | 123 | Not Found
 | 8
 | Need a formula to do the matching from this two worksheet with the outcome on this worksheet column E.   If the matching fits the two criteria (name when it is approximate match & company), then the name on "Hello" sheet will be on column E.  Example the name on this worksheet cell C3 & cell C4, the company matches exactly and name approximate matches both on worksheet "Hello". Therefore it return the name on worksheet "Hello" on this worksheet column E.
Spreadsheet: 56188d1256280772-row-data-lookup-sort-query-book1
Sheet: Sheet1

 |  | SHEET1
 |  | Name | CustID | Lines | Cases | Time Out | Time In | Time |  | NAME DATA
 |  | [NAME] | ABC | 5 | 22 | 12:12:00 | 13:19:00 | 01:07:00 |  | ADAM
 |  | DAVE | ABC | 1 | 5 | 13:20:00 | 13:30:00 | 00:10:00 |  | DAVE
 |  | [NAME] | DEF | 7 | 59 | 12:25:00 | 14:45:00 | 02:20:00 |  | [NAME]
 |  | DAVE | DEF | 1 | 10 | 10:00:00 | 12:00:00 | 02:00:00 |  | MIKE
 |  | TERRY | DEF | 1 | 12 | 13:05:00 | 13:33:00 | 00:28:00 |  | TERRY
 |  | DAVE | ABC | 1 | 4 | 13:05:00 | 13:33:00 | 00:28:00
 |  | ########
 |  | Name column is data validated to a list of names as on right
 |  | SHEET2 - what I'm after it looking like
 |  | [NAME]
 |  |  | Totals | 6 | 32 |  |  | 05:27:00
 |  | Name | CustID | Lines | Cases | Time Out | Time In | Time
 |  | [NAME] | ABC | 5 | 22 | 12:12:00 | 13:19:00 | 01:07:00
 |  | [NAME] | DEF | 7 | 59 | 12:25:00 | 14:45:00 | 02:20:00
 |  | [NAME] | DEF | 1 | 10 | 10:00:00 | 12:00:00 | 02:00:00
Spreadsheet: 741382d1627016357-total-quantity-to-be-calculated-of-the-quantities-of-part-in-the-assembly-total-quantity-to-be-calculated-of-the-quantities-of-part-in-the-assembly
Sheet: joseph

https://www.excelforum.com/excel-formulas-and-functions/1355174-total-quantity-to-be-calculated-of-the-quantities-of-part-in-the-assembly.html |  |  |  |  |  |  |  |  |  | Workings
 |  |  |  |  |  |  |  |  |  |  |  |  | Qty | Qty | Qty | Qty | Combined
ITEM.NO | QTY | SAMPLE TOTAL QTY CALC | TOTAL QTY | [NAME] | LENGTH | MATERIAL | PART CATEGORY | PART NUMBER |  | Level 1 | Level 2 | Level 3 | Level 1 | Level 2 | Level 3 | Total | [NAME]
1 | 1 | 1
1.1 | 1
1.1.1 | 1
1.1.2 | 2
1.1.3 | 2
1.1.4 | 1
1.1.5 | 1
1.2 | 2
1.2.1 | 1
1.2.2 | 1
1.2.3 | 1
1.2.4 | 1
1.3 | 4
1.3.1 | 2
1.3.1.1 | 1
1.3.1.2 | 1
1.3.1.3 | 1
1.3.2 | 1
1.3.3 | 1
1.4 | 2
1.4.1 | 6
1.4.1.1 | 3
1.4.1.2 | 3
1.4.1.3 | 2
1.4.1.4 | 2
1.4.2 | 1
1.4.2.1 | 2
1.4.2.2 | 2
1.4.3 | 4
Spreadsheet: benjamin_rogers__1070__gencomodel
Sheet: Base Hours

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly | Monthly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Monthly | Yearly | Seasonal | Seasonal
 | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4 | Bucket 5 | Bucket 6 | Bucket 7 | Bucket 8 | Bucket 9 | Bucket 10 | Bucket 11 | Bucket 12 | Bucket 13 | Bucket 14 | Bucket 15 | Bucket 16 | Bucket 17 | Bucket 18 | Bucket 19 | Bucket 20 | 2nd Call | PPA | Total | Total | Availability | Capacity
 | 5 | 5 | 10 | 20 | 20 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 110
2000-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 786664d1657350493-re-structuring-a-table-with-different-sample-data-associated-with-an-asset-excel-help-forum-query
Sheet: Sheet1

SAP Equipment No | Facility Name | Substation | Factory |  | Hydrogen(H2) | Oxygen(O2) | Nitrogen (N2) | Carbon Dioxide (CO2) | [NAME] (C2H2) | Ethylene (C2H4) | Ethane(C2H6)
1 | 5 | 7 | 13 | 13 | 39 | 40 | 41 | 42 | 43 | 44 | 45
Sample no | Serial No | Equipment # | Sampling Date | Sampling Date | PN | Total Furanic Compounds | DP | DBDS | TC | H2S | MMG (CH3SH)
27460 | M0094 | 2106850 | 2021-04-05 00:00:00 |  | 2.88 | 0.05 | 800 | 128 | 0.1 | 0.1 | N/A
27461 | 96.2.4015 | 2150645 | 2021-04-04 00:00:00 |  | 0.97 | 0.67 | 497 | 106 | 0.1 | 0.1 | N/A
14293 | 7853557 | 2166686 | 2015-03-25 00:00:00 |  | #N/A | <0.1 | #N/A | 52.5 | #N/A | #N/A | <0.1
26864 | 941892 | 2205519 | 2021-04-14 00:00:00 |  | 0.1 | 0.05 | 800 | 46 | 0.1 | 0.1 | N/A
27809 | 941892 | 2205519 | 2022-01-11 00:00:00 |  | 9.18 | 0.05 | 800 | 148 | 0.1 | N/A | 1.4
26875 | 941893 | 2205542 | 2021-04-14 00:00:00 |  | 0.59 | 0.05 | 800 | 119 | 0.1 | N/A | 2.6821
27866 | 941893 | 2205542 | 2022-01-11 00:00:00 |  | 16 | 0.05 | 800 | 120 | 0.1 | N/A | 0.9
27807 | 941893 | 2205542 | 2022-01-11 00:00:00 |  | 4.5 | 0.05 | 800 | 113 | 1.1 | N/A | 1.4
27857 | 97.4.1841 | 2322424 | 2022-01-11 00:00:00 |  | 0.5 | 0.05 | 800 | 119 | 0.1 | 0.1 | 1.1
18659 | 97.4.1842 | 2322458 | 2017-05-07 00:00:00 |  | 5.02 | 0.03 | 800 | 105 | 1.1 | 0.1 | 0.1
27859 | 97.4.1842 | 2322458 | 2022-01-11 00:00:00 |  | 7.4 | 0.05 | 800 | 96 | 0.75 | 0.1 | 0.8
27844 | 76289 1 | 2336842 | 2022-01-11 00:00:00 |  | 1.3 | 0.05 | 800 | 147 | 0.14 | 0.1 | 0.4
27845 | 76289/2 | 2336865 | 2022-01-11 00:00:00 |  | 0.3 | 0.05 | 800 | 147 | 0.1 | 0.1 | 0.5
27846 | 76289/3 | 2336887 | 2022-01-11 00:00:00 |  | 0.2 | 0.05 | 800 | 139 | 0.1 | 0.1 | 0.8
27847 | 76289/4 | 2337309 | 2022-01-11 00:00:00 |  | 0.5 | 0.05 | 800 | 151 | 0.1 | 0.1 | 1
27856 | 762290/1 | 2337327 | 2022-01-11 00:00:00 |  | 1.1 | 0.05 | 800 | 112 | 0.99 | 0.1 | 0.8
27843 | 762290/2 | 2337346 | 2022-01-11 00:00:00 |  | 0.4 | 0.05 | 800 | 98 | 1.9 | 0.1 | 0.6
Spreadsheet: 0ebe2acd-4a2a-4fca-bfe4-62e98e93bfd7
Sheet: AS FIF

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. AS) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and        seeking answers | M
[NAME] (e.g. AS) and Number | PSY | AS | AS | AS | AS | AS | AS
Discipline codes:  AS = 2900                                                (4 digits) | 4200 | 2900 | 2900 | 2900 | 2900 | 2900 | 2900
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
No Local Code for AS                                            (leave blank)
Long (L)  Forms | L | L | L | L | L | L | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 215548d1361404726-order-form-worksheet-populated-sequentially-with-items-selected-from-other-worksheets-ef360_sample
Sheet: LED

SKU | CAT # | [NAME] | PRICE |  |  |  |  | <-- NOTE: picks up the [NAME] number from previous sheet
616169 | LED 54 | 2400 L Recessed | 225 |  |  | False
695228 | LED 98 | 5400 L Recessed | 285 |  |  | False
96321 | LED 887 | 6000 L Recessed | 305 |  |  | True
651851 | LED 442 | 6" Retrofit | 98 |  |  | False
618224 | LED 420 | 4" Retrofit | 115 |  |  | True
66658985 | LED 918 | 3600 L Post Top | 65 |  |  | False
 |  |  |  |  |  |  |  | <-- [NAME] copied
 |  |  |  |  |  |  |  | down to row 15 - copy
 |  |  |  |  |  |  |  | further if needed
Spreadsheet: 76695d1277212465-sum-and-separate-numbers-in-text-perhapsthisway
Sheet: Sheet1

 | Below is a sample of what I have mixed over 45 cells. For all cells in column A that are "FIC" I need the dollars (that are mixed with text in column C) totaled (Column B would be blank). For all cells in column A that are "Outside". I need Column C to just be the dollars (no text). If Column A is "GSU" then I need the number following "Total Value" in column C
 | FIC | IV1234 | MV: $26,453.42***Blah Blah text (IRA) | 26453.42
 | FIC | NV1234 | MV: $1,307.76***Blah Blah text (IRA) | 1307.76
 | Outside | 12345 | Market Value: $251,655.62***Blah Blah text | 251655.62
 | GSU | 6Z1234 | $35.29***MONEY $42,676.95***(PNRA) Total Value: $42,712.24 | 42712.24
 | How can I get totaled and formated something like this:
 | FIC |  | 27761.18
 | Outside | 1234 | 251655.62
 | GSU | 6Z1234 | 42712.24
Spreadsheet: 14f93eff-6033-457e-bdda-537ff33efdc8
Sheet: EPR BS

Consolidated Balance Sheet ([NAME] and Condensed)
 | September 30,
 | 2013 |  | 2012
(In millions)
Assets
Current assets
Cash and equivalents | 713.3 |  | 206.3
Investment securities | 28.8 |  | 0
Restricted cash and investments | 67 |  | 81.9
Jackpot annuity investments | 56.5 |  | 60.2
Receivables, net | 577.9000000000001 |  | 564.8
Inventories | 90.10000000000001 |  | 92.9
Other assets and deferred costs | 242.4 |  | 257.2
Total current assets | 1776 |  | 1263.3
Property, plant and equipment, net | 483.9 |  | 555.7
Jackpot annuity investments | 268.6 |  | 295.7
Contracts and notes receivable, net | 165.6 |  | 139.3
Goodwill and other intangibles, net | 1601.7 |  | 1663.1
Other assets and deferred costs | 317 |  | 368
Total Assets | 4612.799999999999 |  | 4285.1
Liabilities and Shareholders' Equity
Current liabilities
Short-term debt | 826.6 |  | 0
Accounts payable | 110 |  | 87.5
Jackpot liabilities, current portion | 131.7 |  | 152.4
Dividends payable | 25.9 |  | 16
Other accrued liabilities | 414.3 |  | 374.4
Total current liabilities | 1508.5 |  | 630.3000000000001
Long-term debt | 1366.3 |  | 1846.4
Jackpot liabilities | 293.3 |  | 328.6
Other liabilities | 190.6 |  | 282
Total Liabilities | 3358.7 |  | 3087.3
Total Equity | 1254.1 |  | 1197.8
Total Liabilities and Shareholders' Equity | 4612.8 |  | 4285.1
Spreadsheet: 542883d1508156436-auto-populate-the-nth-large-value-modified
Sheet: Working

 |  | Department | PRO |  | By selecting the Dept & company , data should get auto populated from the Master sheet.
 |  | Company | FCE2 |  | Objective: To find the large Total by selecting 3 conditions (Dept, Company, Top)
 |  | Top | 10 |  | Top can be any Numbers
 |  |  |  |  | If I Select "ALL" in Dept & Company, according to Top, the output need to be derived
 |  |  | S.no | Emp No. | Emp Name | Job Description | Department | Company | Pay Grade | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | TOTAL
 | Example
Spreadsheet: 545782d1509649783-to-automatically-leave-some-cells-blank-when-i-copy-and-paste-a-chunk-post
Sheet: Sheet1

Obs | Min_Village_1 | Max_Village_1 | Mean_Village_1 |  | Min_Village_2 | Max_Village_2 | Mean_Village_2 |  | Delta_Min | Delta_Max | Delta_mean
1 | 10 | 20 | 4 |  | 8 | 14 | 2
2 | 0 | 10 | 0 |  | 0 | 0 | 0
3
4
5 | -999 | 571 | -571.0957668285913 |  | 0 | 706 | 263.9411490900064
6
7
8
9
10 | 0 | 8 | 0.04233171408743928 |  | 0 | 1 | 0.02730756698887527
11
12
13
14
15 | 0 | 0 | 0 |  | 0 | 178699 | 50.30904873469768
Spreadsheet: 724663d1616295934-trying-to-match-a-series-of-colors-to-a-related-code-formula-question
Sheet: Color Codes

Attribute Value Code | Attribute Value Description
[NAME] | Amber
AMTH | Amethyst
APCT | [NAME]
AQUA | Aqua
AQMN | Aquamarine
ASH | Ash
ASPG | Asparagus
AVOC | Avocado
AZUR | Azure
BABY | [NAME]
BEIG | [NAME]
BISQ | Bisque
BLCK | Black
BLUE | Blue
BLGR | Blue-Green
BONE | Bone
BRNZ | [NAME]
BRWN | [NAME]
BURG | Burgundy
BTOR | Burnt Orange
BTSI | Burnt [NAME]
BTUM | Burnt Umber
BUTR | Butter
CAML | Camel
CAMO | Camoflauge
CELA | Celadon
CERI | Cerise
CHCL | Charcoal
[NAME] | Chartreuse
CINN | Cinnamon
CBLT | Cobalt
COCO | Cocoa
[NAME] | Copper
CORA | Coral
CFBL | Cornflower Blue
CSLK | Cornsilk
CREM | Cream
CRIM | Crimson
CYAN | [NAME]
[NAME] | Cypress
DBLU | [NAME]
[NAME] | [NAME]
DRED | Dark Red
[NAME] | [NAME]
DENM | [NAME]
[NAME] | Ecru
EGGP | Eggplant
EMER | Emerald
EVGR | Evergreen
FAWN | [NAME]
FUCH | Fuchsia
GING | [NAME]
GOLD | Gold
GBRN | [NAME]
GROD | Goldenrod
GRAY | Gray
GREN | Green
HONY | Honey
HPNK | Hot Pink
INDG | Indigo
IVRY | Ivory
JADE | Jade
KGRN | [NAME]
LAVE | Lavender
LEMN | Lemon
LBLU | Light Blue
LBRN | Light Brown
LGRY | Light Gray
LILC | Lilac
LIME | Lime Green
LNCN | Lincoln Green
LINN | Linen
LODN | Loden
MAGE | Magenta
MARN | Maroon
MAUV | Mauve
MBLU | Midnight Blue
MINT | Mint
MOSS | Moss
MUST | Mustard
NATL | Natural
NAVY | Navy
OCHR | Ochre
OLIV | Olive
ORNG | Orange
ORCH | Orchid
PEAC | Peach
PERI | Periwinkle
PINK | Pink
PLAD | Plaid
PLUM | Plum
PBLU | Powder Blue
PURP | Purple
RAIN | Rainbow
RASP | [NAME]
RED | Red
RWB | Red, White & Blue
RDOR | Red-Orange
RDVI | Red-Violet
ROSE | Rose
RBLU | Royal Blue
RUBY | Ruby
RUST | Rust
SAGE | Sage
SALM | Salmon
SAND | Sand
SAPP | Sapphire
SCAR | Scarlet
SIEN | [NAME]
SILV | Silver
[NAME] | Slate Blue
SMOK | Smoke
[NAME] | Straw
TAN | [NAME]
TANG | Tangerine
TAUP | Taupe
TEAL | Teal
TERR | Terra Cotta
TURQ | Turquoise
UMBR | Umber
USA | USA Stars&Stripes
VANI | Vanilla
VARI | Various
VERM | Vermilion
VIOL | Violet
WHEA | Wheat
WHIT | White
WINE | Wine
WIST | Wisteria
YELL | Yellow
YLOR | Yellow-Orange
-NA- | -Not Assigned-
Spreadsheet: 542368d1507823323-request-form-help-equipment-request-form
Sheet: Draft 1

EQUIPMENT REQUEST FORM
 |  |  | Selected Items
Equipment Required | 6-figure Micro-balance Acculab |  | Asset Tag | Discription | Type | Serial No | Model | Cat A/B | Amount
Amount
Spreadsheet: 839796d1692225069-to-sort-a-list-abc123
Sheet: Sheet1 (2)

[NAME] | العمر | الفئة | الفئة
ID | Age | Category | Category |  | Count |  | Category-1 | Category-2 | Category-3 | Category-4 | Category-5
1 | 16
2 | 15
3 | 15
4 | 3
5 | 4
6 | 5
7 | 1
8 | 2
9 | 4
10 | 16
11 | 20
12 | 18
13 | 20
14 | 23
15 | 23
16 | 23
17 | 24 |  |  |  |  |  | Dear All,
18 | 21
19 | 24 |  |  |  |  |  | May I kindly request to assist me in this formula
20 | 22 |  |  |  |  |  | my formula in column E (Cell E3) if possible to amened the formula to include sort
21 | 26 |  |  |  |  |  | from 1-5 to 66-70
22 | 29 |  |  |  |  |  | Taking inconsideration that I am using excel 365 but at work most employee use Excel 2010 or 2016
23 | 27
24 | 28
25 | 26 |  |  |  |  |  | Many thanks for any help
26 | 35
27 | 31
28 | 33
29 | 35
30 | 64
31 | 31
32 | 66
33 | 33
34 | 34
35 | 40
36 | 38
37 | 38
38 | 37
39 | 38
40 | 42
41 | 45
42 | 44
43 | 41
44 | 44
45 | 47
46 | 50
47 | 48
48 | 49
49 | 54
50 | 53
51 | 53
52 | 55
53 | 70
54 | 64
55 | 57
56 | 59
57 | 69
58 | 68
59 | 7
60 | 10
61 | 6
62 | 6
63 | 10
64 | 57
65 | 8
66 | 59
67 | 9
68 | 13
69 | 58
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Complete

First Name | Surname | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 9 | Unit 12 | Unit 19 | Unit 25 | Unit 28 | Final Score Year 1 | Final Grading  18 Units | Final Grading  9 Units | Final Grading 3 Units | Diploma Achieved | 90 Credit Achieved | Certificate Achieved
[NAME] | Ayed
Jordan | Barnes
Emma | [NAME]
[NAME] | Curtis
Tiffany | [NAME]
Cheran | Friedman
[NAME] | Garrard
Emily | Gilham
[NAME] | Joy
[NAME] | McShane
Leah | Malherbe
Ashton | [NAME]
[NAME] | [NAME]
[NAME] | Weston
 |  | Unit 13 | Unit 17 | Unit 18 | Unit 20 | Unit 26 | Unit 27 | Unit 29 | Unit 30 | Unit 31 | Final Score  Year 2
[NAME] | Ayed
Jordan | Barnes
Emma | [NAME]
[NAME] | Curtis
Tiffany | [NAME]
Cheran | Friedman
[NAME] | Garrard
Emily | Gilham
[NAME] | Joy
[NAME] | McShane
Leah | Malherbe
Ashton | [NAME]
[NAME] | [NAME]
[NAME] | Weston