tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 689951d1596776940-how-to-put-the-multiple-value-in-one-cell-from-multiple-cell-sample-show-multiple-value
Sheet: Data Source

Module | Category | Process | Action | Group | Helper | Helper For mutilple criteria lookup
HR | Claims | Rejection | Cancel | Manager
HR | Claims | Rejection | Cancel | HR training
HR | Claims | Rejection | Cancel | Employee
HR | Claims | Rejection | Cancel | Administrator
HR | Claims | Rejection | [NAME] | HR training
HR | Claims | Rejection | [NAME] | Employee
HR | Claims | Rejection | View | Manager
HR | Claims | Rejection | View | HR training
HR | Claims | Rejection | View | Employee
HR | Claims | Rejection | View | Administrator
HR | Claims | Rejection | View | HR Manager
Spreadsheet: 268460d1380647337-salary-calculation-my-requirements-22
Sheet: Sheet1

 |  |  |  | Actual_salary | Basic_Salary | Workind Days | Days_Worked | FIRST_PAYMENT | SECOND_PAYMENT | REMARKS
 |  |  | example 3 | 260 | 200 | 26 | 19 | 190 | 60 | THIS IS WRONG…CUZ THERE IS NO MORE SALARY FOR THIS PERSON
 |  |  | example 3 | 260 | 200 | 26 | 21 | 150 | 60 | THIS IS CORRECT. CUZ I HAVE TO PAY HIM 260-190 BALANCE 60
Spreadsheet: 810970d1672213393-formula-to-extract-column-using-specified-column-title-file
Sheet: Sheet2

NAMES | PERCETAGE | POSITION | URDU | ENGLISH
Spreadsheet: 790893d1660051251-formula-for-totals-across-multiple-tabs-game-scores1
Sheet: Totals

Name | Total Games Played | Total Full Time Different to Half Time | Manual Total Full Time Different to Half Time
[NAME] |  |  | 16
[NAME] |  |  | 16
[NAME] |  |  | 12
[NAME] |  |  | 12
[NAME] |  |  | 20
[NAME] |  |  | 16
Bethany |  |  | 16
[NAME] |  |  | 16
[NAME] |  |  | 12
Nicki |  |  | 16
Spreadsheet: 107600d1304712040-lookup-within-a-if-statement-copy-of-lookup-help-2
Sheet: Matrix

 | #N/A | Part Numbers (no duplicates) | 0 | Lines |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Cold Saw - Slugs | Cold Saw - Long Bar | Band Saw - Slugs | Band Saw - Long Bar | Modern1 | Modern2 | Lathe1 | [NAME] | Lathe3 | Lathe4 | Lathe5 | Lathe6 | Lathe7 | Lathe8 | Lathe9 | Integrex | Integrex2 | Lathe (Holding) | Mill1 | Mill2 | Mill3 | Mill4 | Mill5 | Mill6 | Vert HT | Long Horz HT | Horz HT | Furnace | Spindle HT | BullDozer | Magnaflux | Centerless Grind | CNC GRIND1 | CNC GRIND2 | CNC GRIND3 | CNC GRIND4 | CNC GRIND5 | CNC GRIND6 | CNC GRIND7 | Plunge Grind | SemiAuto Weld | Weld (Robot) | Dual Welder | Identification | Push Off Test | [NAME] | Hob | Tapered Hob | Press | Outsource | Outsource (HT) | Outsource (Paint) | Outsource (Plate) | Bridgeport | Chamfer | Engine Lathe | Manuals | Parts Washer | PH Drills | Threader | Wheelabrator | Inspection | Assembly | Packaging | Pull from Inventory | Broach | Deburr
 | N123 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3,7 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 469
 | W456 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3,7 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 469
 | TEST1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4
EXAMPLE | TEST1 | I need the values in cells J-BX to return the number in Routing!F:F as shown in this row instead of "x" that is in the formula |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  | IF(COUNTIFS(Routing!$B:$B,$B6,Routing!$D:$D,P$2),"X","")
 |  |  | the "X" is what I am struggling with, I need the IF true statement to reference what is in
 |  |  | column F in the routing tab
Spreadsheet: 78985d1279224132-sumproduct-by-qtr-kpi
Sheet: Chart_Data

 | 2009-01-07 00:00:00 | 2009-01-14 00:00:00 | 2009-01-21 00:00:00 | 2009-01-28 00:00:00 | 2009-02-04 00:00:00 | 2009-02-11 00:00:00 | 2009-02-18 00:00:00 | 2009-02-25 00:00:00 | 2009-03-04 00:00:00 | 2009-03-11 00:00:00 | 2009-03-18 00:00:00 | 2009-03-25 00:00:00 | 2009-04-01 00:00:00 | 2009-04-08 00:00:00 | 2009-04-15 00:00:00 | 2009-04-22 00:00:00 | 2009-04-29 00:00:00 | 2009-05-06 00:00:00 | 2009-05-13 00:00:00 | 2009-05-20 00:00:00 | 2009-05-27 00:00:00 | 2009-06-03 00:00:00 | 2009-06-10 00:00:00 | 2009-06-17 00:00:00 | 2009-06-24 00:00:00 | 2009-07-01 00:00:00 | 2009-07-08 00:00:00 | 2009-07-15 00:00:00 | 2009-07-22 00:00:00 | 2009-07-29 00:00:00 | 2009-08-05 00:00:00 | 2009-08-12 00:00:00 | 2009-08-19 00:00:00 | 2009-08-26 00:00:00 | 2009-09-02 00:00:00 | 2009-09-09 00:00:00 | 2009-09-16 00:00:00 | 2009-09-23 00:00:00 | 2009-09-30 00:00:00 | 2009-10-07 00:00:00 | 2009-10-14 00:00:00 | 2009-10-21 00:00:00 | 2009-10-28 00:00:00 | 2009-11-04 00:00:00 | 2009-11-11 00:00:00 | 2009-11-18 00:00:00 | 2009-11-25 00:00:00 | 2009-12-02 00:00:00 | 2009-12-09 00:00:00 | 2009-12-16 00:00:00 | 2009-12-23 00:00:00 | 2009-12-30 00:00:00 | 2010-01-06 00:00:00 | 2010-01-13 00:00:00 | 2010-01-20 00:00:00 | 2010-01-27 00:00:00 | 2010-02-03 00:00:00 | 2010-02-10 00:00:00 | 2010-02-17 00:00:00 | 2010-02-24 00:00:00 | 2010-03-03 00:00:00 | 2010-03-10 00:00:00 | 2010-03-17 00:00:00 | 2010-03-24 00:00:00 | 2010-03-31 00:00:00 | 2010-04-07 00:00:00 | 2010-04-14 00:00:00 | 2010-04-21 00:00:00 | 2010-04-28 00:00:00 | 2010-05-05 00:00:00 | 2010-05-12 00:00:00 | 2010-05-19 00:00:00 | 2010-05-26 00:00:00 | 2010-06-02 00:00:00 | 2010-06-09 00:00:00 | 2010-06-16 00:00:00 | 2010-06-23 00:00:00 | 2010-06-30 00:00:00 | 2010-07-07 00:00:00 | 2010-07-14 00:00:00 | 2010-07-21 00:00:00 | 2010-07-28 00:00:00 | 2010-08-04 00:00:00 | 2010-08-11 00:00:00 | 2010-08-18 00:00:00 | 2010-08-25 00:00:00 | 2010-09-01 00:00:00 | 2010-09-08 00:00:00 | 2010-09-15 00:00:00 | 2010-09-22 00:00:00 | 2010-09-29 00:00:00 | 2010-10-06 00:00:00 | 2010-10-13 00:00:00 | 2010-10-20 00:00:00 | 2010-10-27 00:00:00 | 2010-11-03 00:00:00 | 2010-11-10 00:00:00 | 2010-11-17 00:00:00 | 2010-11-24 00:00:00 | 2010-12-01 00:00:00 | 2010-12-08 00:00:00 | 2010-12-15 00:00:00 | 2010-12-22 00:00:00 | 2010-12-29 00:00:00
Annuities - Submitted
Spreadsheet: 110808d1307399468-excel-2007-extracting-patterns-from-lists-find-patterns
Sheet: Sheet1

code | type | invoice | value
35 | RCVD-190 | 4020455 | 68 |  |  |  | invoice | code | Count | Sum |  | Test
35 | ENT-190 | 4020455 | 68 |  |  |  | 4020455 | -35 | 1 | 68
35 | ENT-190 | 4020455 | 68 |  |  |  |  | 35 | 3 | 204
-35 | ENT-190 | 4020455 | 68 |  |  |  | 4020455 Total |  | 4 | 272
12 | RCVD-190 | 4059983 | 30 |  |  |  | 4059983 | -12 | 1 | 30
-12 | RCVD-190 | 4059983 | 30 |  |  |  |  | 12 | 2 | 60
12 | ENT-190 | 4059983 | 30 |  |  |  | 4059983 Total |  | 3 | 90
Spreadsheet: 0cf93cc4-c77d-4758-9802-8f31b0b212d2
Sheet: Sheet1

Wyoming  Tuberculosis Control and Prevention Program : TB Test Summary Log | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
The log is to be completed with every State issued test completed.  State issued testing supplies are only to be used with high risk screening activities.                                                                                                                                                                                                                                                                         This log must be submitted when reordering State issued testing supplies.  Failure to complete log will result in denied request to fill testing supplies.
Facility name: _______________________________________________________________________________________________________________________ |  |  |  |  |  |  |  |  |  |  |  | Log Date Range (MM/YY-MM/YY): _______________________________________
Test Type (include lot # if PPD) | Last Name | First Name | DOB | Assessment ONLY                No TST/IGRA | Reason for Screening | Employment reason for screening | Additional Reason for Screening | Date of test (planted or drawn) | Test planted by | Result date | Result +/- | [NAME] if PPD | Result read by | [NAME] | Patient Started on Therapy
PPD #10251 | [NAME] | SOLOMON | 1983-01-02 00:00:00 |  | Foreign-born |  |  | 2010-10-01 00:00:00 | SHERI-RN | 2010-10-04 00:00:00 | Positive | >5 | SHERI - RN | Normal | LTBI treatment
TSPOT | [NAME] | MINI | 1975-11-26 00:00:00 |  |  | Hospital/Health Care |  | 2010-12-15 00:00:00 |  | 2010-12-20 00:00:00 | Positive |  | JESSICA -- FNP | Abnormal | Active TB treatment
 | SMITH | [NAME] |  | No risk identified-Screening not conducted
Person completing log (signature): | ______________________________________________________________ |  |  |  |  |  |  |  |  | Date _________________________________________
 |  |  |  |  | Please fax to [PHONE]
Spreadsheet: 743929d1628821831-sum-multiple-calculations-includes-an-if-statement-bo-backtesting
Sheet: CALCS

TIME (WINNING TRADES)
START | END | TOTAL TIME | ENTRIES | AVE PRICE | TRADED %
08:00:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
Spreadsheet: 488091d1478490639-automated-model-help-data-flow-reporting-metrics1
Sheet: Sourcing - pivot

 |  | 1 | 1 | 1
Row Labels | Average of Total days from description received to vendor submitted candidate to labor | Average of Total days from manager decision to interview to phone interview | Average of Total days from phone interview date to in person interview date | Average of Total days from phone interview to date offer extended | Average of Total days from phone interview to offer accepted | Average of Total days from date vendor submitted to offer extended | Average of Total days from date vendor submitted to reject date | Average of Total days from offer accepted to start date | Average of Total days from date vendor submitted to reject date 2
Humcap | 29 | 2 | 2 | 5 | 6 | 18 | 20 | 12 | 20
Lucas Inc. | 29 | 2 | 2 | 5 | 6 | 18 | 20 | 12 | 20
RH | 29 | 2 | 2 | 5 | 6 | 18 | 20 | 12 | 20
ServTech | 29 | 2 | 2 | 5 | 6 | 18 | 20 | 12 | 20
TEK | 28.88990825688073 | 1.99009900990099 | 2.087912087912088 | 5.087912087912088 | 6.134146341463414 | 18.30769230769231 | 20 | 12.35365853658537 | 20
Grand Total | 28.96417910447761 | 1.996632996632997 | 2.029739776951673 | 5.029739776951673 | 6.045081967213115 | 18.10408921933086 | 20 | 12.11885245901639 | 20
 | Total days from description received to vendor submitted candidate to labor
Spreadsheet: 03514bfe-78de-411d-a2bf-585dcfbd3e4a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  |  |  |  | Lineups must have first initial, last name, numbers, and
 |  | 8:30  F2   (2 |  |  |  |  |  |  | base burglar when turned into the scorekeeper. If not this
 |  |  |  |  |  |  |  |  | will not be a protestable.
 |  |  | 10:40  F2 |  |  |  |  |  | Run Rules: 15 after 3, 12 after 4, 10 after 5
 |  |  | (15
 |  | 8:30  F5    (3
 |  |  |  | 2:10  F5
 |  |  |  | (23
 |  | 8:30   F4   (4
 |  |  | 11:50  F2
 |  |  | (16 |  |  |  |  | 1 homerun then IEO's
 |  | 9:30  F1    (5 |  |  | 5:40  F4
 |  |  |  |  | (29
 |  | 9:30  F3     (6
 |  |  | 1:00  F1
 |  |  | (17
 | 8:30   [NAME](1
 |  | 10:40  F3  (9
 |  |  |  | 3:20  F4
 |  |  |  | (24 |  |  |  | 8:00  F3
 |  | 9:30  F4   (7
 |  |  |  |  |  |  |  | (32
 |  |  | 11:50  F4
 |  |  | (18
 |  | 9:30  F5    (8
 | Loser's Bracket |  |  |  |  |  | L29
 |  | L7 |  |  | [NAME] |  |  |  | 9:00  F3
 | L1 | (14 |  |  |  |  | 06:50:00
 |  | 1:00  F2 | 2:10  F2 |  | 4:30  F2 |  | F3
 | 10:40  F4     (10 |  | (22 |  | (27 |  | (31 |  | (33
 | L2 |  | L15
 |  |  |  | 3:20  F2
 |  | L3 |  | (25
 |  | 10:40  F5 |  |  |  | 5:40  F3
 |  | (11 | 2:10  F3
 |  | L-4 | (21 |  |  | (30
 |  |  | L16
 |  | L-6 |  |  | L24
 |  | 11:50  F1
 |  | (12 | 2:10  F1 |  | 4:30  F3
 |  | [NAME] | (20 |  | (28
 |  |  | L17
 |  |  |  | 3:20  F3
 |  | L9 |  | (26 |  |  |  |  | L-32
 |  | 11:50  F3
 |  | (13 | 1:00  F3
 |  | L-8 | (19
 |  |  | L18
Spreadsheet: 793035d1661270024-help-with-comparison-needed-sample
Sheet: Sheet1

CONDITION | [NAME] | DATE & TIME | CONDITION | [NAME] | DATE & TIME | DIFFERENCE
Door Forced | SE Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SE Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SE Stairs | 2021-01-01 00:00:00
Door Forced | CR E Stairs 2 Out | 2021-01-01 00:00:00
Door Forced | CR E Stairs 1 In | 2021-01-01 00:00:00
Door Forced | CR W Stairs 2 Out | 2021-01-01 00:00:00
Door Forced | CR W Stairs 1 In | 2021-01-01 00:00:00
Door Forced | CR [NAME] | 2021-01-01 00:00:00
Door Forced | CR HV Switch Rm A | 2021-01-01 00:00:00
Door Forced | [NAME] A | 2021-01-01 00:00:00
Door Forced | CR HV Switch Rm A | 2021-01-01 00:00:00
Door Held Open | [NAME] IN | 2021-01-01 00:05:00
Door Alarm Reset | BR Ext Loading Store IN | 2021-01-01 00:07:00
Door Held Open | CR Office | 2021-01-01 01:21:00 | Door Alarm Reset | CR  Office | 2021-01-01 01:22:00
Door Alarm Reset | CR  Office | 2021-01-01 01:22:00
Door Held Open | [NAME] IN | 2021-01-01 04:28:00 | Door Alarm Reset | [NAME] IN | 2021-01-01 04:29:00
Door Alarm Reset | [NAME] IN | 2021-01-01 04:29:00
Door Held Open | CR Office | 2021-01-01 04:31:00
Door Alarm Reset | CR  Office | 2021-01-01 04:34:00 | Door Alarm Reset | CR  Office | 2021-01-01 04:34:00
Door Forced | [NAME] | 2021-01-01 07:29:00 | Door Alarm Reset | [NAME] | 2021-01-01 07:29:00
Door Alarm Reset | [NAME] | 2021-01-01 07:29:00
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 17 Jan 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-01-17 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: a8f82165-44d7-47ec-a3e4-d2b15ef1b642
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 961644 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor
 |  |  |  |  | Area
 |  |  |  |  | Affected
 | Reason for Project
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | x |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  | X |  | For
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | x |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Plan Submitted |  |  | for CPC of | Final CPC |  |  |  |  |  | Revised Plans Received
Projected Start Date                                              Projected Completion or Occupancy Date
Fact Sheet Prepared by: |  |  |  | Date:
Reviewed by: |  |  |  | Date:
Reference or Case Numbers
Spreadsheet: 811560d1672652486-lookup-function-from-column-base-to-row-base-sample-case
Sheet: SOURCE

 | CITY | ABC | ABC | ABC | ABC | ABC | DEF | DEF | DEF | DEF | DEF | GHI | GHI | GHI | GHI | GHI
 | PRODUCT | W1 | [NAME] | W3 | W4 | TOTAL | W1 | [NAME] | W3 | W4 | TOTAL | W1 | [NAME] | W3 | W4 | TOTAL
 | AQR-D190(S) | 0 | 55 | 75 | 75 | 205 | 10 | 15 | 55 | 45 | 125 | 22 | 5 | 22 | 0 | 49
 | AQR-D190(LK) | 0 | 5 | 180 | 105 | 290 | 0 | 7 | 32 | 10 | 49 | 0 | 10 | 0 | 0 | 10
 | AQR-D190(LB) | 5 | 15 | 99 | 55 | 174 | 0 | 10 | 35 | 14 | 59 | 5 | 11 | 13 | 5 | 34
 | AQR-D225(MDS) | 0 | 20 | 211 | 291 | 522 | 0 | 0 | 42 | 8 | 50 | 15 | 5 | 28 | 5 | 53
 | AQR-D225(MLS) | 0 | 25 | 75 | 55 | 155 | 0 | 10 | 40 | 5 | 55 | 25 | 22 | 45 | 11 | 103
 | AQR-D225(MSG) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AQR-D225(MSB) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AQR-D191(DS) | 100 | 185 | 285 | 466 | 1036 | 12 | 45 | 92 | 70 | 219 | 56 | 124 | 125 | 68 | 373
 | AQR-D191(LS) | 0 | 0 | 19 | 0 | 19 | 0 | 10 | 5 | 5 | 20 | 0 | 3 | 2 | 0 | 5
 | AQR-D191(LK) | 0 | 46 | 70 | 155 | 271 | 0 | 69 | 90 | 60 | 219 | 45 | 24 | 24 | 0 | 93
 | AQR-D191(LB) | 5 | 30 | 55 | 90 | 180 | 0 | 29 | 29 | 5 | 63 | 0 | 15 | 20 | 15 | 50
 | AQR-D205(MDS) | 5 | 83 | 230 | 262 | 580 | 0 | 15 | 44 | 10 | 69 | 0 | 12 | 5 | 5 | 22
 | AQR-D205(MLS) | 0 | 15 | 33 | 50 | 98 | 0 | 5 | 32 | 0 | 37 | 0 | 5 | 0 | 0 | 5
 | AQR-D205(MSG) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 6 | 1 | 18
 | AQR-D205(MSB) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AQR-D251(DS) | 45 | 280 | 467 | 514 | 1306 | 10 | 79 | 113 | 80 | 282 | 55 | 62 | 60 | 22 | 199
 | AQR-D251(LS) | 0 | 17 | 0 | 10 | 27 | 5 | 14 | 7 | 5 | 31 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 100807d1299046469-index-match-problems-sample
Sheet: Sheet1

Type | Definition | Distance | Gradient
Toyota | PFSL | 2000 | -0.1
 |  |  |  | Gradient | Gradient | Gradient | Gradient
Type | Definition |  | Distance | -0.12 | -0.1 | -0.08 | -0.06 |  |  |  |  | Index and Match | 13
Toyota | PFSL | 0 | 100 | 10 | 12 | 14 | 16 |  |  |  |  | Vlookup/Hlookup | #N/A
Toyota | PFSL | 100 | 200 | 11 | 13 | 15 | 17
Toyota | PFSL | 200 | 300 | 12 | 15 | 18 | 21
Toyota | PFSL | 300 | 400 | 13 | 16 | 19 | 22
Toyota | PFSU | 0 | 100 | 20 | 25 | 30 | 35
Toyota | PFSU | 100 | 200 | 21 | 26 | 31 | 36
Toyota | PFSU | 200 | 300 | 22 | 27 | 32 | 37
Toyota | PFSU | 300 | 400 | 23 | 28 | 33 | 38
Isuzu | PFSL | 0 | 100 | 55 | 56 | 57 | 58
Isuzu | PFSL | 100 | 200 | 56 | 57 | 58 | 59
Isuzu | PFSL | 200 | 300 | 57 | 58 | 59 | 60
Isuzu | PFSL | 300 | 400 | 58 | 59 | 60 | 61
Isuzu | PFSU | 0 | 100 | 59 | 60 | 61 | 62
Isuzu | PFSU | 100 | 200 | 60 | 61 | 62 | 63
Isuzu | PFSU | 200 | 300 | 61 | 62 | 63 | 64
Isuzu | PFSU | 300 | 400 | 62 | 63 | 64 | 65
Spreadsheet: 169688d1343028247-if-a-cell-equals-a-value-invclude-in-an-average-sum-sample-amonty78-oeldere-
Sheet: Sheet1

 |  |  | 0.5583333333333332
 |  |  | 0.5583333333333332 |  |  |  |  |  | 3.7 |  | 3 | 6 | 13
 |  | 1 | 12 |  | 0.5 |  | -0.1
 |  | 2 | 3 |  | 0.6 |  | 0.5
 |  | 3 | 5 |  | 0.8 |  | 0.6
 |  | 4 | 2 |  | 0.9 |  | 0.7
 |  | 5 | 11 |  | 0.1 |  | -0.8
 |  | 6 | 7 |  | 0.5 |  | 0.1
 |  | 7 | 4 |  | 0.4 |  | 0.5
 |  | 8 | 1 |  | 0.1 |  | 0.6
 |  | 9 | 6 |  | 0.9 |  | 0.1
 |  | 10 | 8 |  | 0.8 |  | -0.5
 |  | 11 | 9 |  | 0.1 |  | 0.6
 |  | 12 | 10 |  | 0.5 |  | 0.7
Spreadsheet: 30456d1225978339-conditional-formatting-with-two-conditions-within-one-formula-example-conditional-formatting
Sheet: Sheet1

 |  | This is what I am trying to accomplish; i.e. "fresh fruit" is always GREEN, "rotten bananas" is always RED but "rotten apples and oranges" is neutral
 |  |  |  |  | Name | Fruit | Status
 |  |  |  |  | [NAME] | Apple | Fresh
 |  |  |  |  | [NAME] | Orange | Fresh
 |  |  |  |  | [NAME] | [NAME] | Fresh
 |  |  |  |  | [NAME] | Apple | Rotten
 |  |  |  |  | Klaus | Orange | Rotten
 |  |  |  |  | [NAME] | [NAME] | Rotten
 |  |  |  |  | Name | Fruit | Status
 |  |  |  |  | [NAME] | Apple | Fresh
 |  | How can I do this??????? |  |  | [NAME] | Orange | Rotten
 |  |  |  |  | [NAME] | [NAME] | Fresh
 |  |  |  |  | [NAME] | Apple | Rotten
 |  |  |  |  | Klaus | Orange | Fresh
 |  |  |  |  | [NAME] | [NAME] | Rotten
 |  |  |  |  | List
 |  |  |  |  | Fresh
 |  |  |  |  | Rotten
 |  |  |  |  | List
 |  |  |  |  | Apple
 |  |  |  |  | Orange
 |  |  |  |  | [NAME]
Spreadsheet: 582432d1531880309-how-to-populate-names-from-one-tab-into-another-tab-rsvp-tracker
Sheet: RSVP Bride

Last Name | First Name 1 | First Name 2 | Child Name 1 | Child Name 2 | Child Name 3 | # Adults Invited Sangeet | # Adults Attending Sangeet | # Adults Invited Wedding | # Adults Attending Wedding | # Adults Invited Reception | # Adults Attending Reception | # of Kids Invited Sangeet | # of Kids Attending Sangeet | # of Kids Invited Wedding | # of Kids Attending Wedding | # of Kids Invited Reception | # of Kids Attending Reception | Contact Email | Contact Phone Number | Contact Address 1 | Contact Address 2 | City | State | Zip | Table #
Smith | [NAME] | [NAME] | Duke | Camden |  | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | [EMAIL] | [PHONE] | 1234 Main Street | #4 | [NAME] | TX | 78729 | 1
[NAME] | Amit | Seetha |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | [EMAIL] | [PHONE] | 2 Crossroads |  | Lansing | MI | 20000 | 2
Desai | Varun |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3