tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 437645d1451431852-weighted-average-for-totals-in-pivot-table-copy-of-book2-1
Sheet: Sheet1

Channel | Start | Contracts | Month | Amount | Average
Category1 | February | 104 | 2013 August | -
Category1 | February | 104 | 2013 September | -
Category1 | February | 104 | 2013 October | -
Category1 | February | 104 | 2013 November | -
Category1 | February | 104 | 2013 December | -
Category1 | February | 104 | 2014 January | -
Category1 | February | 104 | 2014 February | 6
Category1 | February | 104 | 2014 March | 10
Category1 | February | 104 | 2014 April | 14
Category1 | February | 104 | 2014 May | 19
Category1 | February | 104 | 2014 June | 14
Category1 | February | 104 | 2014 July | 19
Category1 | February | 104 | 2014 August | 14
Category1 | February | 104 | 2014 September | 10
Category1 | February | 104 | 2014 October | 12
Category1 | February | 104 | 2014 November | 13
Category1 | February | 104 | 2014 December | 15
Category1 | February | 104 | 2015 January | 19
Category1 | February | 104 | 2015 February | 13
Category1 | February | 104 | 2015 March | 1
Category1 | February | 104 | 2015 April | -
Category1 | February | 104 | 2015 May | -
Category1 | February | 104 | 2015 June | -
Category1 | February | 104 | 2015 July | -
Category1 | February | 104 | 2015 August | -
Category1 | February | 104 | 2015 September | -
Category1 | February | 104 | 2015 October | -
Category1 | February | 104 | 2015 November | -
Category1 | September | 114 | 2013 August | -
Category1 | September | 114 | 2013 September | -
Category1 | September | 114 | 2013 October | -
Category1 | September | 114 | 2013 November | -
Category1 | September | 114 | 2013 December | -
Category1 | September | 114 | 2014 January | -
Category1 | September | 114 | 2014 February | -
Category1 | September | 114 | 2014 March | -
Category1 | September | 114 | 2014 April | -
Category1 | September | 114 | 2014 May | -
Category1 | September | 114 | 2014 June | -
Category1 | September | 114 | 2014 July | -
Category1 | September | 114 | 2014 August | -
Category1 | September | 114 | 2014 September | 27
Category1 | September | 114 | 2014 October | 17
Category1 | September | 114 | 2014 November | 18
Category1 | September | 114 | 2014 December | 11
Category1 | September | 114 | 2015 January | 12
Category1 | September | 114 | 2015 February | 11
Category1 | September | 114 | 2015 March | 17
Category1 | September | 114 | 2015 April | 9
Category1 | September | 114 | 2015 May | 6
Category1 | September | 114 | 2015 June | 21
Category1 | September | 114 | 2015 July | 27
Category1 | September | 114 | 2015 August | 20
Category1 | September | 114 | 2015 September | 10
Category1 | September | 114 | 2015 October | -
Category1 | September | 114 | 2015 November | -
Spreadsheet: 135682d1326182948-solved-unable-to-sort-by-date-after-vlookup-sorting100112
Sheet: Sheet2

Login | Account Created
bisst | 01/06/2009
gatcl | 22/09/2009
spear | 22/09/2009
thokr | 22/09/2009
[NAME] | 22/09/2009
[NAME] | 23/09/2009
morka | 24/02/2009
[NAME] | 24/09/2009
yeoem | 24/09/2009
mashu | 24/09/2009
brola | 24/09/2009
freln | 24/09/2009
simro | 24/09/2009
oshbr | 24/09/2009
metcr | 24/09/2009
walgh | 24/09/2009
hawbr | 24/09/2009
kergr | 24/09/2009
gooro | 24/09/2009
robjh | 24/09/2009
[NAME] | 24/09/2009
schst | 24/09/2009
setba | 24/09/2009
warjo | 24/09/2009
[NAME] | 24/09/2009
piegr | 24/09/2009
smibe | 24/09/2009
hinst | 24/09/2009
comst | 24/09/2009
comgr | 24/09/2009
hargr | 24/09/2010
Spreadsheet: 96508d1295896971-excel-2007-using-isna-to-prevent-n-a-in-index-match-function-sample-wkbk
Sheet: SEL

YEAR | LRMAKE | LRCOV | LRGRCT | LRCNCT | LRPRM | LREP | LRCLC | [NAME]
2001 | ACUR | N
 | AUDI
 | BMW
 | BUIC
 | CADI
 | CHEV
 | CHRY
 | DAEW
 | DODG
 | EGIL
 | FORD
 | GEO
 | GMC
 | HOND
 | HUMM
 | HYUN
 | INFI
 | ISU
 | JAGU
 | JEEP
 | KIA
 | LEXS
 | LINC
 | LNDR
 | MAZD
 | MERC
 | MERZ
 | MITS
 | MNNI
 | NISS
 | OLDS
 | PLYM
 | PONT
 | [NAME]
 | SAA
 | SMRT
 | STRN
 | SUBA
 | SUZI
 | TIMP
 | TOYT
 | [NAME]
 | VOLV
Spreadsheet: 18828cd0-958d-4bdb-9ef6-62183e20862e
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
COD | Test | COD | Codfish, IgE | Codfish, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
COD | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
COD | Result | COD | Codfish, IgE | Codfish, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6082-2 | Gadus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 86700d1286658643-sum-where-application-employees-diff-but-charge-code-same-dummy-sample-dupes-1-
Sheet: Details Tab

 | Application | Proj ID | Title | Totals
 | App 1 | 55555 | Project 1
 | App 1 | 121212 | Project 2
 | App 2 | 3232323 | Project 3
 | App 3 | 434343 | Project 4
 | App 1 | 434356 | Project 5
 | App 2 | 55555 | Project 1
Spreadsheet: 25be474b-cb78-49ba-b73a-13ed1ba2b511
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
KIWI | Test | KIWI | Kiwi Fruit, IgE | Kiwi Fruit, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
KIWI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
KIWI | Result | KIWI | Kiwi Fruit, IgE | Kiwi Fruit, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6154-9
Spreadsheet: 740363d1626293026-function-to-convert-numbers-in-to-binary-numbers-jm6544088-test1
Sheet: Sheet1

Table A |  |  |  |  |  | TableB |  |  |  |  | Solution
6 | 8 | 7 | 4566 |  |  | 2 | 2 | 1 | 2122 |  |  |  |  |  |  | Objective
7 | 568 | 19 | 8 |  |  | 1 | 122 | 11 | 2 |  |  |  |  |  |  | [NAME] all data from Table A to binary numbers 1 or 2
2 | 89 | 33 | 12 |  |  | 2 | 21 | 11 | 12 |  |  |  |  |  |  | Given
4 | 1236 | 3 | 4 |  |  | 2 | 1212 | 1 | 2 |  |  |  |  |  |  | Table has numbers 1 to 9
279 | 56 | 33 |  |  |  | 211 | 12 | 11 |  |  |  |  |  |  |  | Function to [NAME] all even numbers to 2 and all odd numbers to 1
1267 | 237 |  |  |  |  | 1221 | 211 |  |  |  |  |  |  |  |  | 1 will remain 1
167 | 26 | 33 |  |  |  | 121 | 22 | 11 |  |  |  |  |  |  |  | 2 will remain2
 | 345 | 137 | 8 |  |  |  | 121 | 111 | 2 |  |  |  |  |  |  | 3 will be converted to1
5 | 359 | 1 | 25 |  |  | 1 | 111 | 1 | 21 |  |  |  |  |  |  | 4 will be converted to 2
 | 15 | 379 | 26 |  |  |  | 11 | 111 | 22 |  |  |  |  |  |  | 5 will be converted to 1
247 | 16 | 33 |  |  |  | 221 | 12 | 11 |  |  |  |  |  |  |  | 6 will be converted to 2
57 | 368 | 37 |  |  |  | 11 | 122 | 11 |  |  |  |  |  |  |  | 7 will be converted to 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 will be converted to 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 will be converted to 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current method used
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select data in table A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Control+F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | in find selction put "3" and select Replace put "1" and click "all"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | repeat above replacing 3 by 4,5,6,7,8,9
Spreadsheet: 872062d1718427152-calculating-overtime-to-be-paid-after-deductions-are-made-forum-sheet-ot-build-up-rev-02-aligw
Sheet: Sheet1

DAY | [NAME] |  | [NAME] | CUMULATIVE TIME |  | LATE RUNNING OVERTIME WORKED | CUMULATIVE TIME |  | OVERTIME TO BE PAID
Monday | 7.3 |  | 0 |  |  | 0
Tuesday | 7.55 |  | 0.75 |  |  | 0
Wednesday | 7.4 |  | 0.4 |  |  | 0.35
Thursday | 7.65 |  | 0 |  |  | 0.2
Friday | 8.25 |  | 0.45 |  |  | 0.45
TOTAL :
Spreadsheet: 66651d1267298527-index-match-and-transpose-sample1
Sheet: Clients_funds

Name | Client Since: | Fees:YTD | Fees: Accrued | AUM (YTD) mln | Comments | Risk
Some company | 2009-01-01 00:00:00 | 1 | 2 | 10
Bigger company | 2009-04-01 00:00:00 | 2 | 3 | 20
Bag of monies company | 2010-05-01 00:00:00 | 3 | 4 | 30
Spreadsheet: 126625d1319790683-help-drawing-and-placing-information-from-my-table-excel-help-forum-2
Sheet: Winter Lab Income Report (2)

Winter Lab Income Report |  |  |  |  |  |  |  |  | Commissions
Date | Guest Name | [NAME] | [NAME] | Instructor | Instructor % | Booking Agent % | Winter Lab % |  | [NAME] | [NAME] | Instructor 3 | Instructor 4 | WinterLab
2012-01-01 00:00:00 | [NAME] | Morning P | 10500 | [NAME]
2012-01-02 00:00:00 | [NAME] | Morning G | 15000 | [NAME]
2012-01-03 00:00:00 | [NAME] | Morning P | 19500 | [NAME]
2012-01-04 00:00:00 | [NAME] | Morning G | 24000 | [NAME]
2012-01-05 00:00:00 | [NAME] | Morning P | 28500 | [NAME]
2012-01-06 00:00:00 | [NAME] | Morning G | 33000 | [NAME]
2012-01-07 00:00:00 | [NAME] | Morning P | 37500 | [NAME]
2012-01-08 00:00:00 | [NAME] | Morning G | 42000 | [NAME]
2012-01-09 00:00:00 | [NAME] | Morning P | 46500 | [NAME]
2012-01-10 00:00:00 | [NAME] | Morning G | 51000 | [NAME]
2012-01-11 00:00:00 | [NAME] | Morning P | 55500 | [NAME]
2012-01-12 00:00:00 | [NAME] | Morning G | 60000 | [NAME]
2012-01-13 00:00:00 | [NAME] | Morning P | 64500 | [NAME]
2012-01-14 00:00:00 | [NAME] | Morning G | 69000 | [NAME]
2012-01-15 00:00:00 | [NAME] | Morning P | 73500 | [NAME]
2012-01-16 00:00:00 | [NAME] | Morning G | 78000 | [NAME]
2012-01-17 00:00:00 | [NAME] | Morning P | 82500 | [NAME]
2012-01-18 00:00:00 | [NAME] | Morning G | 87000 | [NAME]
2012-01-19 00:00:00 | [NAME] | Morning P | 91500 | [NAME]
2012-01-20 00:00:00 | [NAME] | Morning G | 96000 | [NAME]
2012-01-21 00:00:00 | [NAME] | Morning P | 100500 | [NAME]
2012-01-22 00:00:00 | [NAME] | Morning G | 105000 | [NAME]
2012-01-23 00:00:00 | [NAME] | Morning P | 109500 | [NAME]
2012-01-24 00:00:00 | [NAME] | Morning G | 114000 | [NAME]
2012-01-25 00:00:00 | [NAME] | Morning P | 118500 | [NAME]
2012-01-26 00:00:00 | [NAME] | Morning G | 123000 | [NAME]
2012-01-27 00:00:00 | [NAME] | Morning P | 127500 | [NAME]
2012-01-28 00:00:00 | [NAME] | Morning G | 132000 | [NAME]
2012-01-29 00:00:00 | [NAME] | Morning P | 136500 | [NAME]
Spreadsheet: 594697d1539899722-maths-query-working-out-how-the-individual-variable-contributes-to-the-overall-loss-book1-copy
Sheet: Sheet1

 |  | 2018-01-01 00:00:00 |  | 2018-09-01 00:00:00 |  | [NAME]
 | Gross Received | 3691716 |  | 3448800
 | Deduction | 0.25 |  | 0.2772748782185108
 | Net Received
 | Yield | 0.0355 |  | 0.036
 | Deduction | 2076590.25 |  | 1869400.8
 | Selling Costs | 0.063 |  | 0.068
 | Price
Spreadsheet: 485287d1476805991-trying-to-make-a-payroll-form-that-divides-reg-time-and-ot-after-8-and-after-44-hours-payroll-form
Sheet: Sheet1

 |  |  |  |  |  |  | PAY ROLL FORM
 | Date | 2016-10-09 00:00:00 |  |  | 2016-10-10 00:00:00 |  |  | 2016-10-11 00:00:00 |  |  | 2016-10-12 00:00:00 |  |  | 2016-10-13 00:00:00 |  |  | 2016-10-14 00:00:00 |  |  | 2016-10-15 00:00:00 |  |  | Week Totals
Employee |  | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT |  |  | OT after in one day |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT after in one week |  |  | 44
 | Date | 2016-10-16 00:00:00 |  |  | 2016-10-17 00:00:00 |  |  | 2016-10-18 00:00:00 |  |  | 2016-10-19 00:00:00 |  |  | 2016-10-20 00:00:00 |  |  | 2016-10-21 00:00:00 |  |  | 2016-10-22 00:00:00 |  |  | Week Totals |  |  |  | 2 Week Totals
Employee |  | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT |  | Total | Reg | OT
Spreadsheet: 107613d1304722964-copying-multiple-columns-into-single-row-index15
Sheet: input

 |  | Return on assets | Return on equity | Current ratio
company "A" | Y1 | -0.1355283944458302 | 0.4449094713856792 | 0.2319686411149826
 | Y2 | -0.004214359596857609 | -0.03646719431910644 | 0.4087801217376803
 | Y3 | 0.07733865496699563 | 0.1261204515722661 | 0.9403198172472872
 | Y4 | 0.07356177583212391 | 0.1606001973820902 | 1.789343965204784
 | Y5 | 0.09791454655831264 | 0.1594770554995629 | 0.8489134295585908
company "B" | Y1 | 0.009146393272688532 | 0.05321640985077805 | 2.38419855552452
 | Y2 | -0.04653300040291228 | -0.3165285620004399 | 2.016933261901117
 | Y3 | -0.05481229460043081 | -0.4175902244955954 | 2.073707270042349
 | Y4 | 0.007620341029123284 | 0.06668576838748255 | 2.093521972294437
 | Y5 | 0.02548828431246775 | 0.1539064046616917 | 1.925402536603454
company "C" | Y1 | 0.1018091299470296 | 0.2364745416244514 | 0.7643643382944335
 | Y2 | -0.148623009749071 | -0.4720763614927674 | 0.9270019362423069
 | Y3 | -0.6903166076784354 | 4.603205736242183 | 1.429731914320356
 | Y4 | -0.2754837091159961 | 0.6061519778650236 | 1.143366867406969
 | Y5 | -0.2716170656576682 | 0.2844232039147294 | 0.8649672338123009
Spreadsheet: 886599d1736649444-create-a-vertical-array-from-a-table-create-a-vertical-array-from-a-table
Sheet: Sheet1

Equipment | Count |  | Equipment List
Photostat Machine | 5
Binding Machine | 1 |  | 2. Photostat Machine
Desktop Computer | 2 |  | 3. Photostat Machine
Refrigerator | 3 |  | 4. Photostat Machine
Shredder | 2 |  | 5. Photostat Machine
 |  |  | 1. Binding Machine
 |  |  | 1. Desktop Computer
 |  |  | 2. Desktop Computer
 |  |  | 1. Refrigerator
 |  |  | 2. Refrigerator
 |  |  | 3. Refrigerator
 |  |  | 1. Desktop Computer
 |  |  | 2. Desktop Computer
Spreadsheet: 771115d1646417627-filter-row-based-on-values-in-a-different-row-book3
Sheet: Sheet1

1 Dry environment.  Interior of habitable buildings and offices | 20 | 20 | 20 | 20 | 20
2a Humid environment no frost • Interior of buildings with high humidity • Exterior components • Components in non-aggressive soil |  | 35 | 35 | 30 | 30
2b Humid environment with frost • Exterior components exposed to frost • Components in non-aggressive soil and/or water and exposed to frost • Interior components; high humidity with frost |  |  | 35 | 30 | 30
3 Humid environment with frost and  de-icing salts  • Interior and exterior components exposed to frost and salts |  |  | 40 | 35 | 35
4a Seawater environment  no frost • Components completely/partially submerged in seawater or in splash zone • Components in saturated salt air |  |  | 40 | 35 | 35
4b Seawater environment  with frost • Components completely/partially submerged in seawater or in splash zone • Components in saturated salt air |  |  | 40 | 35 | 35
5a Aggressive  • Slightly aggressive chemical environment [NAME] industrial atmosphere |  |  | 35 | 30 | 30
5b   • Moderately aggressive chemical environment |  |  |  | 35 | 35
5c   • Highly aggressive chemical environment |  |  |  |  | 45
 | 0.65 | 0.60 | 0.55 | 0.50 | 0.45
 | 260 | 280 | 300 | 300 | 300
 | C25/35 | C30/37 | C35/45 | C40/50 | C45/55
4a Seawater environment  no frost • Components completely/partially submerged in seawater or in splash zone • Components in saturated salt air | C35/45 | C40/50 | C45/55
5b   • Moderately aggressive chemical environment | C40/50 | C45/55
2a Humid environment no frost • Interior of buildings with high humidity • Exterior components • Components in non-aggressive soil | C30/37 | C35/45 | C40/50 | C45/55
Spreadsheet: 836727d1689608170-sumifs-returning-zero-forum-section-odm-planner
Sheet: Sheet1

 | Type | Session | Start Date | End Date | ODM1 | ODM2 | Reserve/Shadow | Shadow | Venue/Room | Days of delivery | Home | Away
Workshop | Workshop | Legal Phase 3 Workshop |  |  | ODM | Ray | ODM |  | TR 3&4 | 5 |  |  |  |  |  |  | Virtual / Home | Workshop / Away | Total
Virtual | Workshop | VO Workshop |  |  | Mark | [NAME] | ODM |  | TR 3&4 | 3 |  |  |  |  |  | Niki | 2 | 7
 | Virtual | Standardisation |  |  | ODM | ODM | ODM |  | Virtual | 1 |  |  |  |  |  | [NAME] | 2 | 2.5
 | Virtual | Health and Safety Phase 1 |  |  | Niki | Michelle | [NAME] |  | Virtual | 2 |  |  |  |  |  | Michelle | 4 | 2
 | Workshop | Legal Phase 3 Workshop |  |  | ODM | Graeme | ODM |  | Southern Venue | 5 |  |  |  |  |  | Nicola | 2 | 2
 | Virtual | Health and Safety Phase 1 |  |  | [NAME] | Michelle | Niki |  | Virtual | 2 |  |  |  |  |  | Mark | 1 | 10
 | Virtual | Standardisation meeting |  |  | ODM | ODM | ODM |  | Virtual | 1 |  |  |  |  |  | Ray
 | Workshop | Health and Safety Workshop |  |  | ODM | Mark | ODM |  | TR 3&4 | 5 |  |  |  |  |  | Graeme | 0 | 5
 | Workshop | CPD-Confined Spaces |  |  | [NAME] | [NAME] | Ray |  | TR 3&4 | 3 |  |  |  |  |  | [NAME] | 0 | 10
 | Virtual | Standardisation |  |  | ODM | ODM | ODM |  | Virtual | 1
 | Workshop | Health and Safety Phase 2 Tutorial |  |  | Ray | Mark | [NAME] |  | North/Scotland Venue | 2
 | Virtual | Assessor Standardisation |  |  | ODM | ODM | ODM |  | Virtual | 0
 | Workshop | Health and Safety Phase 2 Tutorial |  |  | [NAME] | Niki | Michelle |  | North Venue | 2
 | Workshop | Legal Phase 6 |  |  | ODM | Niki | ODM |  | Delta Hotel | 2.5
 | Workshop | Legal Phase 6 |  |  | ODM | [NAME] | ODM |  | Delta Hotel | 2.5
 | Workshop | Health and Safety Phase 2 Tutorial |  |  | Ray | Michelle | ODM |  | Southern Venue | 2 |  |  |  |  |  | R8 should show 2 : from Column L
 | Virtual | Assignment Webinar |  |  | ODM | Mark | ODM |  | Virtual | 1 |  |  |  |  |  | S8 should show 9 : from Column M
 | Workshop | Health and Safety Phase 2 Tutorial |  |  | Nicola | [NAME] | Graeme |  | Southern Venue | 2 |  |  |  |  |  | Green cells counted manually
 | Virtual | Legal Phase 2 Tutorial |  |  | Ray | Nicola | Michelle |  | Virtual | 2
I have simplified the formulae in cells R8 & S8, by inserting "Virtual", "Workshop" & "Ray", as these make it clearer what the formulae are looking at, rather than reference cells (A2, A3 & Q8)
Both Columns F & G need looking at in the SUMIFS, as us ODMs can be added to either column
Spreadsheet: 864071d1711394579-if-nested-formula-test-file-v1
Sheet: Sheet1

Pay Group | Home Department | Worked Department | Location | Level
ABZ | 170734 - LAX - Hourly Billing (R15) | 170734 - LAX - Hourly Billing (R08) | 100122
ABZ | 170728 - Beverly Hilton - Fees | 170728 - Beverly Hilton - Fees | 100123
LA3 | 170734 - LAX Taxi/TNC - Hourly Billing (R22) |  | 100124
OFF | 100122 - Data Entry | 100122 - Data Entry | 100125
OFF | 100122 - Enforcement | 100122 - Enforcement | 100126
TAE | 100122 - Enforcement | 100122 - Enforcement | 100127
PA9 | 100122 - Enforcement | 100122 - Enforcement | 100128
SOL | 140455 - Del Mar Plaza | 140455 - Del Mar Plaza | 100129
SOL | 140112 - 714 E. Sano Blvd (RSD) |  | 100130
Spreadsheet: 698872d1602210799-remove-duplicate-value-in-the-list-of-name-myfilename
Sheet: myfilename

Source Data
CompanyName | CompanyRegNo | Name | NRIC | [NAME] | Language | DateCreated | GSCB | GSP | PSB | DOSB | GSV | DOSBTech | Potential
aa sdn bhd | 106-u | [NAME] | 1234 | [EMAIL] | English | 2020-10-08 10:45:19 | False | True | False | False | False | False | False
ABC SDN BHD | 368-W | SOH TECK PIN | 789 | [EMAIL] | English | 2020-10-08 10:55:57 | False | True | False | False | False | False | False
ABC SDN BHD | 368-W | SOH TECK PIN | 789 | [EMAIL] | English | 2020-10-08 11:02:22 | False | True | False | False | False | False | False
DEF SDN BHD | 1997 (451-A) | [NAME] | 1019 | [EMAIL] | English | 2020-10-08 11:53:56 | False | True | False | False | False | False | False
DEF SDN BHD | 1997 (451-A) | [NAME] | 1019 | [EMAIL] | English | 2020-10-08 11:55:08 | False | True | False | False | False | False | False
xx sdn bhd | 436-D | Madam Chai | 6754 | [EMAIL] | English | 2020-10-08 11:59:04 | False | True | False | False | False | False | False
yy sdn bhd | 00219-X | LIM JIA SOON | 6622 | [EMAIL] | English | 2020-10-08 14:47:39 | False | True | False | False | False | False | False
zz sdn bhd | 19740C | SOH CHIAW GUAN | 2322 | [EMAIL] | English | 2020-10-08 17:05:40 | False | True | False | False | False | False | False
Expect data
CompanyName | CompanyRegNo | Name | NRIC | [NAME] | Language | DateCreated | GSCB | GSP | PSB | DOSB | GSV | DOSBTech | Potential |  | Note
aa sdn bhd | 106-u | [NAME] | 1234 | [EMAIL] | English | 2020-10-08 10:45:19 | False | True | False | False | False | False | False
ABC SDN BHD | 368-W | SOH TECK PIN | 789 | [EMAIL] | English | 2020-10-08 11:02:22 | False | True | False | False | False | False | False |  | The table here keep ABC and DEF with the latest date update
DEF SDN BHD | 1997 (451-A) | [NAME] | 2325 | [EMAIL] | English | 2020-10-08 11:55:08 | False | True | False | False | False | False | False
xx sdn bhd | 436-D | Madam Chai | 6754 | [EMAIL] | English | 2020-10-08 11:59:04 | False | True | False | False | False | False | False
yy sdn bhd | 00219-X | LIM JIA SOON | 6622 | [EMAIL] | English | 2020-10-08 14:47:39 | False | True | False | False | False | False | False
zz sdn bhd | 19740C | SOH CHIAW GUAN | 2322 | [EMAIL] | English | 2020-10-08 17:05:40 | False | True | False | False | False | False | False
Spreadsheet: 822630d1679458820-a-little-complicated-range-selection-example
Sheet: List1

Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
12 |  | 12 | 5 | 7 |  |  | 12 | 5 | 7 |  | 12 | 12 | 5 | 7
FIRST |  |  |  |  |  |  |  | SECOND
 |  | Here are only 2 sequence
Spreadsheet: 732586d1621024367-multiple-match-data-excel-exampleindexandaggregate
Sheet: Sheet2

Table A |  |  |  |  |  | Table B
ID | AMOUNT |  |  | dif |  | ID | AMOUNT
A100 | -50 |  |  |  |  | A100 | -100
C100 | 300 |  |  |  |  | C100 | 300
B100 | -200 |  |  |  |  | B100 | 300
D100 | -87 |  |  |  |  | A100 | -50
E100 | 1020 |  |  |  |  | C100 | -200
 |  |  |  |  |  | B100 | -200
 |  |  |  |  |  | D100 | 667
 |  |  |  |  |  | D100 | -1300
 |  |  |  |  |  | D100 | -87
 |  |  |  |  |  | E100 | -1020
 |  |  |  |  |  | E100 | 1020
 |  |  |  |  |  | E100 | 6000
Spreadsheet: 742331d1627662382-dynamic-dropdowns-needed-in-onlyoffice-but-cant-include-certain-excel-functions-example
Sheet: Employees Master List

Employee Name | Employee Code | Employee Branch
[NAME] | 6000001 | Seattle
[NAME] |  | Seattle
Clyde |  | Denver
Terrence |  | Bristol
Louis |  | San Diego
Herb |  | San Diego
Vance |  | San Diego
[NAME] |  | San Diego