tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 810480d1671801062-need-an-automated-list-updater-rating-system-test
Sheet: RATING SYSTEM

XCL RATING SYSTEM
ELO FACTOR |  | RATING LIST | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
50 |  | FACTOR | 1 | 0.95 | 0.9 | 0.85 | 0.8 | 0.75 | 0.7 | 0.65 | 0.6 | 0.55 | 0.5 | 0.45 | 0.4 | 0.35 | 0.3 | 0.25 | 0.2 | 0.15 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0 | -0.05 | -0.1 | -0.2 | -0.4 | -0.5
ID | Gamertags | RACE NUMBER | BASE RATING | LAST RACE RESULT | NEW RATING |  | TRANSFORMED RATING | WIN CHANCE | FACTOR
#229830 | Klorpte |  |  | 2
#229309 | SLR oluvion |  |  | 1 |  |  |  |  |  |  | How do I easily update the new ratings to the "ID List" tab without creating a loop??
#227153 | Baspw |  |  | 3
#224285 |  |  |  |  |  |  |  |  |  |  | The calculation of rating is inside the hidden tabs.
#228477
#226005 |  |  |  |  |  |  |  |  |  |  | On the original sheet, I import a list with csv's  from a website that has the gamertags in it.
#224542
#226970 |  |  |  |  |  |  |  |  |  |  | Then I put the Gamertags in the same kind of calculator like the one on the left
#225885
#223944 |  |  |  |  |  |  |  |  |  |  | After that, I now need to update everyones new rating by hand, one by one. This becomes too much work.
#229606
#228993 |  |  |  |  |  |  |  |  |  |  | And then the list gets displayed on a website with the new ratings.
#221051
 |  |  |  |  |  |  |  |  |  |  | We don't need to store  or keep the old ratings/results (would be a good extra feature, but not necessary for now)
 |  |  |  |  |  |  |  |  |  |  | NOTE: List gets updated every day!
Spreadsheet: 184726d1349362485-index-show-multiple-results-of-adjacent-cells-example
Sheet: Find

ZIP-code: | 1000 | 1000 | city2 | 0 | <---- should show dealername
 |  | 1000 | city1 | 0 | <---- should show dealername
Not matching, don't know why  ----> |  | 3000 | city4 | 0 | <---- should show dealername
 |  | #N/A | #N/A | #N/A
 |  | #N/A | #N/A | #N/A
Spreadsheet: daren_farmer__6590__hpl0215
Sheet: Sheet1

HPLN0215.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective February 15, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-02-15 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | Delhi TOG #3 |  |  | 4.75 | 4.75
Empire (Enron) |  | [NAME]. |  |  | 8 | 8
Empire (Enron) |  | Oasis Turine |  |  | 2.65 | 2.65
Empire (Enron) |  | Sterling Plant |  |  | 2.6 | 2.6
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 150604d1334616310-overtime-total-is-diferent-when-made-by-excel-than-when-made-by-hand-tecnico_book3_16apr12_02
Sheet: Sheet1

PAY RATE | days | in | out | total hrs worked | base hrs pay | over  hrs pay | total pay |  | compute made by hand
10 | Monday | 09:00:00 | 13:00:00
10 | Tuesday | 09:20:00 | 18:00:00
10 | Wednesday | 08:10:00 | 17:42:00
10 | Thursday | 09:05:00 | 18:00:00
10 | Friday | 08:00:00 | 16:40:00
applied the formula and the previous number in green was fixed  but then when changed some data on the hrs worked another error appeared in this case
the number in yellow vs the blue one ,  the employee is reciving  15 CENTS  more  : ( , SO WOULD APRECIATE YOUR COMENTS ON HOW TO FIX THE FORMULA TO GIVE THE CORRECT OUTPUT OF 10.05
THANKS : )
Spreadsheet: 230541d1366807181-return-multiple-values-from-multiple-sheets-example-1-
Sheet: OVERVIEW

EQUIPMENT LIST | EQUIPMENT | DATE | TEMP | BEGIN PSIG | MCF LOSS
COMPRESSOR #1
COMPRESSOR #1 DISCHARGE COALESCER
COMPRESSOR #2
COMPRESSOR #2 DISCHARGE COALESCER
COMPRESSOR #3
COMPRESSOR #3 DISCHARGE COALESCER
COMPRESSOR #4
COMPRESSOR #4 DISCHARGE COALESCER
COMPRESSOR #5
COMPRESSOR #5 DISCHARGE COALESCER
SLUG  CATCHER
DEHY CONTACTOR
INLET FILTER COALESCER
AFTER FILTER COALESCER
Spreadsheet: 35e4efb9-7e1d-489c-9388-bcda9b5031ae
Sheet: Advanced

Advanced
WEEK | MON | TUE | WED | THU | FRI | SAT | SUN
1 | 3 m run | 5 x 400 | Rest or easy run | 30 min tempo | Rest | 4 m fast | 60 min run
2 | 3 m run | 8 x 200 | Rest or easy run | 30 min tempo | Rest | 4 m fast | 65 min run
3 | 3 m run | 6 x 400 | Rest or easy run | 35 min tempo | Rest | 5 m fast | 70 min run
4 | 3 m run | 9 x 200 | Rest or easy run | 35 min tempo | Rest or easy run | Rest | 5-K Test
5 | 3 m run | 7 x 400 | Rest or easy run | 40 min tempo | Rest | 5 m fast | 75 min run
6 | 3 m run | 10 x 200 | Rest or easy run | 40 min tempo | Rest | 6 m fast | 85 min run
7 | 3 m run | 8 x 400 | Rest or easy run | 45 min tempo | Rest | 6 m fast | 90 min run
8 | 2 m run | 6 x 200 | 30 min tempo | Rest or easy run | Rest | Rest | 5-K Race
Spreadsheet: 83948d73-5633-4f82-8094-2a7fbccc478c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-23 09:34:43.680000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 102.101 | 101.976 | 101.851 | 101.476
3.75 | 101.887 | 101.762 | 101.637 | 101.262 |  | Note: | Refer To Price [NAME]
3.625 | 101.49 | 101.365 | 101.24 | 100.865 |  |  | For all Price Adjs
3.5 | 100.927 | 100.802 | 100.677 | 100.052
3.375 | 100.079 | 99.954 | 99.829 | 99.204
3.25 | 99.155 | 99.03 | 98.905 | 98.28
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 101.854 | 101.729 | 101.604 | 101.229
3.125 | 101.56 | 101.435 | 101.31 | 100.935
3 | 101.21 | 101.085 | 100.96 | 100.585
2.875 | 100.618 | 100.493 | 100.368 | 99.743
2.75 | 99.96 | 99.835 | 99.71 | 99.085
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-06 09:34:43.680000
30 DAY | 2012-08-21 09:34:43.680000
45 DAY | 2012-09-05 09:34:43.680000
60 DAY | 2012-09-20 09:34:43.680000
90 DAY | 2012-10-20 09:34:43.680000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: dcd31f64-65e2-432b-8eb4-eff670bc311e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | General Information | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Inspector: __________________________  Date: _______________   Time: ____________ AM / PM
Project Name: _____________________________________________________ |  |  |  |  |  |  |  |  | Proj. ID: _______________________
Site Address: ______________________________________________________ |  |  |  |  |  |  |  |  | APN: __________________________
Type: ____ Non-Storm ____ Winterization  ____ PreStorm  ____ During Storm    ____ Post-Storm
Weather: ____ Sunny      _____ Cloudy         _____ Rain     Rain Amount: _______ inches
Best Management Practices (Site Review)
E = Effective, F = Failed/Not Appropriate, NM = Needs Maintenance,  PI = Poor Installation, NI = Not Implemented,                                                                     NA = Not Applicable,  NE = Not Evaluated
1. Run-on Management BMPs
a) Diversion of Run-On |  |  |  |  |  |  | b) Surface Roughening
Comments:
2. Erosion Control BMPs
a) Temporary Slope Stabilization |  |  |  |  |  |  | Blanket | Seed | Mulch | BFM | Landscaped
b) Temporary Flat Lot Stabilization |  |  |  |  |  |  | Blanket | Seed | Mulch | BFM | Landscaped
c) Permanent Slope Stabilization |  |  |  |  |  |  | Blanket | Seed | Mulch | BFM | Landscaped
d) Permanent Flat Lot Stabilization |  |  |  |  |  |  | Blanket | Seed | Mulch | BFM | Landscaped
Comments:
3. Sediment Control BMPs
a) Silt Fence |  |  |  |  |  |  | f) Stabilized CST Entrance
b) Fiber Roll |  |  |  |  |  |  | g) Check Dams
c) Perimeter Control |  |  |  |  |  |  | h) [NAME]
d) Storm Water Inlet Protection |  |  |  |  |  |  | i) Sediment Basin
e) Outlet Protection |  |  |  |  |  |  | j) Dust Control
Comments:
4. Post Construction BMPs
a) Post CST Implemented
Comments:
5. Material Management BMPs, and Non-Stormwater Mangement BMPs
a) Street Sweeping |  |  |  |  |  |  | g) Dewatering Operations
b) Waste Collection/Litter |  |  |  |  |  |  | h) Vehicle and Equipment Fueling
c) Material Storage (asphalt, concrete, treated lumber, etc.) |  |  |  |  |  |  | i) Vehicle and Equipment Maintenance
d) Hazardous Material Storage |  |  |  |  |  |  | j) Spill Kit On Site
e) Stockpile Management |  |  |  |  |  |  | k) Portable Toilet
f) Concrete Wash-Out |  |  |  |  |  |  | l)
Comments:
Pictures:
____________________________________________________________
Inspector's Signature |  |  |  |  |  | Date
Spreadsheet: 215703d1361460497-conditional-formating-budget-2
Sheet: Dashboard

 |  |  | Budget Dashboard |  |  |  |  | Expenditures & Income | 'Expenditures & Income'!A1 | 'Expenditures & Income'!A1
 |  |  |  |  | 3 |  |  |  |  |  | 2013
 |  |  | MONTH TOTALS | Monthly Totals |  |  |  |  |  | ANNUAL TOTALS |  | Annual Totals
 |  |  | INCOME | Expenditures |  |  |  |  |  | INCOME |  | Expenditures
 |  |  | EXPENDITURES | Income |  |  |  |  |  | EXPENDITURES |  | Income
 |  |  |  |  |  |  | Savings Goal - $2,000
 |  |  | SAVINGS TOTALS | Monthly Totals
 |  |  | USAA
 |  |  | KAYLEE'S PIGGIE BANK
 |  |  | WATER JUG FUND
 |  |  | Savings
 |  |  | Goal | 2000
 |  |  | Percent of Goal
Spreadsheet: 146292d1332062010-excel-2007-shift-data-up-if-there-is-any-empty-cell-book1
Sheet: Sheet1

 | first
 | second
 | third
 | fourth
 | fifth
 | sixth
 | seventh
 | eighth
 | ninth
 | tenth
 | eleventh
 |  |  | if I delete the Value in this cell automatically it will deleted from sheet 2
 | thirteenth
 | fourteenth |  | I want the data in sheet 2 to be shifted up to full the empty cell that i just delete.
 | fifteenth |  | and it make the empty cell the last one
 | sixteenth
 | seventeenth
 | eighteenth
 | nineteenth
 | twentieth
 | twenty-first
 | twenty-second
 | twenty-third
 | twenty-fourth
 | twenty-fifth
 | twenty-sixth
 | twenty-seventh
 | twenty-eighth
 | twenty-ninth
 | thirtieth
 | thirty-first
 | thirty-second
 | thirty-third
 | thirty-fourth
 | thirty-fifth
 | thirty-sixth
 | thirty-seventh
 | thirty-eighth
 | thirty-ninth
 | fortieth
 | forty-first
 | forty-second
 | forty-third
 | forty-fourth
 | forty-fifth
 | forty-sixth
 | forty-seventh
 | forty-eighth
 | forty-ninth
 | fiftieth
Spreadsheet: 880220d1727859797-colour-scales-with-if-function-example-data-colour-scales-with-if
Sheet: Sheet1

NAME | ACADEMIC PAPER | SCORE | OVERALL RANK | RANK BY PAPER
1 | Math & Science | 10
2 | Math & Science | 28
3 | Arts & Humanities | 14
4 | Arts & Humanities | 29
5 | Math & Science | 49
6 | Math & Science | 17
7 | Math & Science | 42
8 | Arts & Humanities | 44
9 | Arts & Humanities | 43
10 | Arts & Humanities | 6
11 | Math & Science | 11
12 | Arts & Humanities | 24
13 | Math & Science | 30
14 | Arts & Humanities | 21
15 | Math & Science | 43
16 | Arts & Humanities | 5
Spreadsheet: 519d4387-dade-417a-b02a-2cc80f1be18c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Hospitality and Tourism: Lodging
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Lodging Pathway of the Hospitality and Tourism Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career
path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational
institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for         Lodging Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | Management Level                                                                         ►Chief Engineer ►Director of Human Resources ►Director of Operations ►Director of Sales and Marketing ►Executive Housekeeper ►Food and Beverage Director ►Food and Beverage Manager ►Front Office Manager ►General Manager ►Lodging Manager ►Owner ►Reservations Manager ►Revenue Manager ►Rooms Executive ►Services Manager                                                                            Skill Level                                                                                          ►Bell Captain ►Concierge ►Front Desk Supervisor ►Laundry Supervisor ►[NAME] ►Night Auditor                                                                                    Entry Level                                                                                       ►Front Desk Employee ►Laundry Attendant ►PBX Operator ►[NAME] (Many of the occupations listed on the Restaurants and Food/Beverage Services Pathway may also be obtained through this pathway.)
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 697566d1601408421-need-help-with-sumif-and-subtotal-copy-of-grossmargin_quote-log_v2_2019
Sheet: PivotTable

Row Labels | Sum of Won | Sum of Lost | Sum of Bid Amount | Sum of Pending
[NAME] | 488431.88 | 8477758.100000001 | 9806034.240000002 | 839844.26
Cameron | 0 | 0 | 6646 | 6646
[NAME] | 0 | 366671.75 | 6587322.3 | 6220650.55
[NAME] | 656422.6100000001 | 14712681.54 | 16006033.15 | 636929
[NAME] | 7990975.859999999 | 1985834.32 | 11638625.16 | 1661814.98
Roco | 9566224.73 | 36841321.74999999 | 68793461.92000002 | 22385915.44
Travis | 2422130.24 | 11375143.59 | 15357745.81000001 | 1560471.98
Grand Total | 21124185.32 | 73759411.04999998 | 128195868.58 | 33312272.21
Spreadsheet: 269987d1381340425-count-if-yes-1-copy-value-of-a-diff-cell-from-another-worksheet-count-if-1-yes-multiple-return-formula-
Sheet: monthly sheet

orginazation | interested |  |  | count of interested |  |  | count of sign up |  |  | orginazation | signed up
Spreadsheet: 850747d1701127308-analyse-customer-feedback-by-team-member-filterratings_v1
Sheet: Sheet2

Captain | Trip | # | Avg. Rating |  | I think you'll find this is a better layout.
 |  |  |  |  | You can filter by column to analyse.
[NAME] | Scotland
[NAME] | Ireland
[NAME] | West country
[NAME] | Scotland
[NAME] | West country
[NAME] | Scotland
[NAME] | West country
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 2867 | 10090 | 26941 | 33942 | 32272 | 199207 | 14632 | 281 | 320232
Spreadsheet: 697909d1601611603-multiple-match-formula-4-criterion-question-help-multiple-match
Sheet: Payment

1986000609 | W | 2020-09-21 00:00:00 | 128.72
1986001233 | U | 2020-09-16 00:00:00 | 16.78
1986002210 | W | 2020-09-21 00:00:00 | 14.46
1986003435 | R | 2020-09-28 00:00:00 | 30
1987000868 | * | 2020-09-28 00:00:00 | 1287.67
1987001576 | * | 2020-05-13 00:00:00 | 1200
1987001687 | W | 2020-09-30 00:00:00 | 0.4
1987003177 | W | 2020-09-30 00:00:00 | 30.92
1987003183 | R | 2019-06-05 00:00:00 | 150
1988000526 | 3 | 2018-11-02 00:00:00 | 42.37
1988000561 | W | 2019-08-14 00:00:00 | 73.24
1988002061 | T | 2020-09-29 00:00:00 | 2.02
1989000708 | W | 2019-11-17 00:00:00 | 49.29
1989001416 | * | 2016-05-23 00:00:00 | 133
1989001866 | W | 2020-09-30 00:00:00 | 0.97
1989002041 | W | 2020-09-24 00:00:00 | 117
1989002633 | W | 2020-09-23 00:00:00 | 47.59
1989003738 | W | 2020-09-03 00:00:00 | 60.9
1989003837 | U | 2020-09-25 00:00:00 | 14.37
1990000391 | * | 2020-06-02 00:00:00 | 1200
Spreadsheet: 860283d1708439628-formula-for-entering-a-beginning-number-and-ending-number-and-result-is-lower-or-higher-john-asset-management-sheet
Sheet: IRA Chatham High Yield Asset

IRA Chatham High Yield Asset
 | Opening | Closing | Total Value | Percent Change
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 831562d1685716812-project-and-keywords-problem-solving-s666-projects-keywords-pb
Sheet: Sheet1

Mot-clef \ Projet | (All)
Attribute | Count of Value
1. DEPth | 5
10. SynPPR | 7
11. BODYTEG | 12
12. [NAME] | 7
13. CORELMAG | 8
14. C-Sil | 4
15. Digital-LbL | 6
16. EVOBAR | 8
17. GOT | 8
18. LipidTrans4NeuroTraffic | 4
19. LUCAS | 7
2. LatexDry | 3
20. MESAMM | 7
21. [NAME] | 2
22. NetOnTime | 5
23. PA-Box | 5
24. POPSYCLE | 12
25. SignOp | 6
26. [NAME] | 12
27. URBANTIT | 10
3. LIPIDIC_PURGE | 11
4. MISSION | 4
5. PESTIPOND | 7
6. POLYGLOT | 6
7. Pristine | 10
8. ReinitiaTOR | 5
9. SOFTACTION | 9
u01. [NAME] | 6
u02. DInnAMICS | 3
u03. BattAllox | 6
u04. [NAME] | 7
u05. N-FLAMS | 6
u06. PSLM | 3
u07. InsuRAF | 4
u08. GIGA | 6
u09. LeBHel-Amzymes | 5
u10. [NAME] | 4
u11. SPERRY | 6
u12. [NAME] | 4
u13. BrightSwitch | 8
u14. QDDA | 4
u15. SP-Fluo | 4
u16. [NAME] | 2
u17. AFINITE | 6
u18. TROC | 4
u19. [NAME] | 8
u20. nano-NET | 3
u21. NanoLys | 5
u22. BioconjUgi | 4
u23. [NAME] | 4
u24. MethAmAbs | 4
Spreadsheet: 812574d1673260736-count-with-two-conditions-book1
Sheet: Data

District | Contact Number | Description of Actions Taken to Address Issue | Issue Resolved Date | Project Status
South Fly | 1 | Desc | 2019-01-01 00:00:00 | In Progress
North Fly | 2 | Desc | 2019-01-02 00:00:00 | In Progress
Middle Fly | 3 | Desc | 2019-01-03 00:00:00 | In Progress
Middle Fly | 4 | Desc | 2019-01-04 00:00:00 | In Progress
Middle Fly | 5 | Desc | 2019-01-05 00:00:00 | In Progress
Middle Fly | 6 | Desc | 2019-01-06 00:00:00 | Resolved
South Fly | 7 | Desc | 2019-01-07 00:00:00 | Resolved
South Fly | 8 | Desc | 2019-01-08 00:00:00 | Resolved
Middle Fly | 9 | Desc | 2019-01-09 00:00:00 | Resolved
Delta Fly | 10 | Desc | 2019-01-10 00:00:00 | Resolved
Delta Fly | 11 | Desc | 2019-01-11 00:00:00 | In Progress
Delta Fly | 12 | Desc | 2019-01-12 00:00:00 | In Progress
North Fly | 13 | Desc | 2019-01-13 00:00:00 | In Progress
North Fly | 14 | Desc | 2019-01-14 00:00:00 | In Progress
South Fly | 15 | Desc | 2019-01-15 00:00:00 | Unresolved
South Fly | 16 | Desc | 2019-01-16 00:00:00 | Unresolved
North Fly | 17 | Desc | 2019-01-17 00:00:00 | Unresolved
Delta Fly | 18 | Desc | 2019-01-18 00:00:00 | In Progress
Spreadsheet: 757874d1638482292-counting-cell-after-a-reference-point-and-restart-when-the-reference-point-is-meet-count-after-a-landmark-is-meet2
Sheet: Sheet1

 | results
 |  |  |  | Counting cell after a reference point and restart when the refference point is meet.
 |  |  |  | RF = refference point
RF | 3 |  |  | B = cells to count
 | 2
7 | 5
B | 1
B
D
B
F
RF
G
B
23
B
N
25
RF
B
R
B
10
B
B
M
B
RF
B
15
Spreadsheet: 775273d1648977283-sumifs-dsum-index-match-help-excel-training-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Employee ID | Department | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | Total Sales | Row Labels | Count of Jan-16
 |  |  |  |  |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 1006 | Development | 1 | 9 | 3 |  | Development | 2
 |  |  |  | Finance |  |  |  |  | 1007 | Finance | 2 | 7 | 5 |  | Finance | 2
 |  |  |  | Support |  |  |  |  | 1009 | Finance | 6 | 1 | 4 |  | MD | 2
 |  |  |  | Development |  |  |  |  | 1100 | Finance | 54 | 67 | 7 |  | Support | 5
 |  |  |  | MD |  |  |  |  | 3900 | Support | 5 | 2 | 1 |  | Grand Total | 11
 |  |  |  |  |  |  |  |  | 4500 | Support | 41 | 45 | 7
 |  |  |  |  |  |  |  |  | 133 | Support | 66 | 77 | 21
 |  |  |  | Emoloyee ID |  | Department |  |  | 133 | Support | 44 | 33 | 88
 |  |  |  | 1006 |  | MD |  |  | 133 | Support | 8 | 7 | 5
 |  |  |  | 1007 |  |  |  |  | 1007 | Support | 2 | 7 | 5
 |  |  |  | 1009 |  |  |  |  | 1007 | Support | 55 | 87 | 5
 |  |  |  | 1100 |  |  |  |  | 99 | MD | 5 | 56 | 5
 |  |  |  | 3900 |  |  |  |  | 100 | Support | 2 | 2 | 56
 |  |  |  | 4500 |  |  |  |  | 100 | Support | 1 | 56 | 5
 |  |  |  | 133 |  |  |  |  | 1009 | Finance | 3 | 6 | 5
 |  |  |  | 133 |  |  |  |  | 1009 | Development | 2 | 5 | 1
 |  |  |  | 133 |  |  |  |  | 1009 | Development | 500 | 700 | 700
 |  |  |  | 1007 |  |  |  |  | 3900 | MD | 77 | 23 | 29
 |  |  |  | 1007 |  |  |  |  | 3900 | MD | 55 | 33 | 44
 |  |  |  | 99 |  |  |  |  | 3900 | Development | 99 | 66 | 99
 |  |  |  | 100 |  |  |  |  | 3900 | Development | 7 | 8 | 9
 |  |  |  | 100 |  |  |  |  | 1100 | Finance | 54 | 67 | 7
 |  | CountIf |  | 1009 |  |  |  |  | 1006 | Development | 76 | 8 | 78
 |  |  |  | 1009 |  |  |  |  | 1006 | Finance | 34 | 44 | 65
 | Finance |  |  | 1009 |  |  |  |  | 1006 | Finance | 22 | 28 | 7
 | Support |  |  | 3900 |  |  |  |  | 1006 | MD | 9 | 110 | 21
 | Development |  |  | 3900 |  |  |  |  | 1006 | MD | 45 | 34 | 8
 | MD |  |  | 3900 |  |  |  |  | 1007 | MD | 78 | 78 | 8
 |  |  |  | 3900 |  |  |  |  | 1100 | Finance | 54 | 67 | 7
 |  |  |  | 1100 |  |  |  |  | 1100 | Finance | 54 | 67 | 7
 |  |  |  |  |  |  |  |  | 1100 | MD | 98 | 106 | 99
 |  |  |  |  |  |  |  |  | 1100 | MD | 3 | 2 | 3
 |  |  |  |  |  |  |  |  | 1100 | Development | 101 | 101 | 101
 |  |  |  |  |  |  |  |  | 1100 | Development | 6 | 4 | 3
 |  |  |  |  |  | Hi all,
 |  |  |  | In G13 I am trying to get the department by Employee Id with the highest number of sales based on column O, so for example for G13 the result shoud be MD.
 |  |  |  | Tried index and match with [NAME] but gives the wrong answer as I am looking for the total amount of sales for a department based on the iD.
 |  |  |  | Much , much appreciated your help!