tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 695191d1600092389-generate-list-of-invoice-dates-based-on-start-date-and-invoice-frequency-problem_model
Sheet: Sheet2

 | Revenues per year |  | Start date | 2000-01-01 00:00:00 |  | Invoice dates
1 | 850000 |  | Revenue fy 1 | 850000 |  | 0
2 | 2389653 |  | Invoice frequency in m | 3
3 | 9999999 |  |  |  |  |  |  |  |  |  | 2000 | 2001 | 2002
4 | 896 |  |  |  |  |  |  |  |  | jan | IF(COUNTIF(invoice,L4),E2/12,"") | (COUNTIF(year 1, then /12))+L18
5 | 897698 |  |  |  |  |  |  |  |  | feb
6 |  |  |  |  |  |  |  |  |  | march
7 |  |  |  |  |  |  |  |  |  | april
8 |  |  |  |  |  |  |  |  |  | may
9 |  |  |  |  |  |  |  |  |  | june
10 |  |  |  |  |  |  |  |  |  | july
11 |  |  |  |  |  |  |  |  |  | aug
12 |  |  |  |  |  |  |  |  |  | sep
13 |  |  |  |  |  |  |  |  |  | oct
14 |  |  |  |  |  |  |  |  |  | nov
15 |  |  |  |  |  |  |  |  |  | dec
16
17
18
19
20
Spreadsheet: 822991d1679634833-listing-the-winner-s-of-a-golf-skin-in-separate-cell-money-hole-formula
Sheet: Sheet2

Player | CC |  | TL |  | CR |  | SH |  |  | WINNERS OF CC
A | 5 |  |  |  | 5 |  | 5 |  |  | B | C | D | F
B
C
D
E | 5
F | 3
G | 5
As you can see above, the winners for Round 1 (column B) were players B, C, D, and F because they all have a score less than a "4". I would love a formula that automatically places them under WINNERS over on the right.
Spreadsheet: 845258d1696788636-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-copy-of-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-v5
Sheet: Sheet1

Store | Apple | Pear | Orange | [NAME] | Lemon | Kiwi | Duran
Wal-Mart | Yes | No | No | Yes | Yes | No | No
Target | Yes | Yes | Yes | No | No | No | No
Kroger | No | No | Yes | No | Yes | Yes | Yes
Aldi | Yes | No | Yes | Yes | Yes | Yes | No
[NAME]'s | Yes | Yes | No | Yes | No | No | Yes
Item | Kiwi | Orange | Lemon
Store
 | Aldi | Kroger | Kroger
 |  | Aldi | Aldi
Spreadsheet: 771581d1646744223-extract-numbers-from-cell-exampleroundedlength
Sheet: Sheet1

UnitMark | Length | RoundedLength
Conveyor1 | 2.8
Conveyor2 | 2.8
Conveyor3 | 2.8
Conveyor4 | 13.6
Conveyor5 | 13.6
Conveyor6 | 13.6
Conveyor7 | 13.6
Conveyor8 | 4
Conveyor9 | 2.8
Conveyor10 | 12.6
Conveyor11 | 12.6
Conveyor12 | 4
Conveyor13 | 2.8
Conveyor14 | 6
Conveyor15 | 2.8
Conveyor16 | 2.8
Conveyor17 | 2.8
Conveyor18 | 13.6
Conveyor19 | 13.6
Conveyor20 | 13.6
Conveyor21 | 13.6
Conveyor22 | 4
Conveyor23 | 2.8
Conveyor24 | 12.6
Conveyor25 | 12.6
Spreadsheet: 827824d1683042723-3-criteria-lookup-in-excel-2021-match3
Sheet: Sheet1

 |  |  | Tulip | < [NAME]
Criteria 3
 | Profit | Loss | < [NAME]
Lion
Parrot
Apple |  |  | 0 | Tulip | 0 | -21843 | 0 | 0 | -21843 | -2111 | -30595 | -22734 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mango
Total
Spreadsheet: 687534d1595264137-counting-one-column-and-totaling-the-corresponding-column-hours-2020-07-20-oeldere-kathlin409-687521d1595259244-counting-one-column-and-totaling-the-corresp
Sheet: Sheet2

name | value
Social Awareness | 1
Cataloging | 1 |  | Rijlabels | Sum | Count | Average
Social Awareness | 2 |  | Adult Services | 3 | 1 | 3
Children's Literature | 1 |  | Cataloging | 1 | 1 | 1
Research and Homework | 3 |  | Children's Early Literacy | 1 | 1 | 1
Library Services | 1 |  | Children's Literature | 2 | 2 | 1
Leadership | 1 |  | Communication | 2 | 1 | 2
Professional Development | 1 |  | Leadership | 9 | 5 | 1.8
Technology | 4 |  | Library Services | 7 | 4 | 1.75
Leadership | 1 |  | Professional Development | 7 | 3 | 2.333333333333333
Professional Development | 1 |  | Research and Homework | 3 | 1 | 3
Communication | 2 |  | Social Awareness | 4 | 3 | 1.333333333333333
Adult Services | 3 |  | Technology | 5 | 2 | 2.5
Technology | 1 |  | Youth Services | 2 | 1 | 2
Library Services | 1 |  | Eindtotaal | 46 | 25 | 1.84
Leadership | 5
Library Services | 1
Leadership | 1
Social Awareness | 1
Professional Development | 5
Children's Early Literacy | 1
Youth Services | 2
Children's Literature | 1
Library Services | 4
Leadership | 1
Spreadsheet: 300799d1393571648-copying-last-6-columns-of-152-excel-sheets-tabs-into-1-sheet-micro_2004-4-
Sheet: Page 66

DAIHATSU | DELTA | 4600 | (D) |  |  | KK-XZU347 | S05C | 02/06～ | 15613-89105 | T2209 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD |  | KK-XZU362 | S05C | 99/05～ | 15613-89102 | T2204 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD |  | KK-XZU362 | S05C | 02/06～ | 15613-89105 | T2209 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD |  | KK-XZU372 | S05C | 99/05～ | 15613-89102 | T2204 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD |  | KK-XZU372 | S05C | 02/06～ | 15613-89105 | T2209 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD | STD | KK-XZU382 | S05C | 99/05～ | 15613-89102 | T2204 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD | STD | KK-XZU382 | S05C | 02/06～ | 15613-89105 | T2209 | 17801-78010 | A1396 | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD | WIDE  CAB | KK-XZU382 | S05C | 99/08～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) | 4WD | WIDE  CAB | KK-XZU382 | S05C | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU400 | J05C | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU400 | J05C | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU410 | J05C | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU410 | J05C | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 4900 | (D) |  |  | KK-XZU411 | S05D | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 4900 | (D) |  |  | KK-XZU411 | S05D | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) |  |  | KK-XZU412 | S05C | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 4600 | (D) |  |  | KK-XZU412 | S05C | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU420 | J05C | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU420 | J05C | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 4900 | (D) |  |  | KK-XZU421 | S05D | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 4900 | (D) |  |  | KK-XZU421 | S05D | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23390-64480 | FT1910
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU430 | J05C | 99/05～ | 15613-89102 | T2204 | 17801-78020 | [NAME] | 23304-89102 | FT8813
DAIHATSU | DELTA | 5300 | (D) |  |  | KK-XZU430 | J05C | 02/06～ | 15613-89105 | T2209 | 17801-78020 | [NAME] | 23304-89102 | FT8813
Spreadsheet: 718107d1612984634-rolling-range-evaluation-rolling-range-example-layout
Sheet: Sheet1

 | Year | 2020 |  |  |  |  |  |  |  |  |  |  | Year | 2021
Name: | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Rule 1 | Rule 2 | Rule 3 | Rule 4
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result Here | Result Here | Result Here | Result Here
Category 1
Category 2
Category 3
Category 4
Category 5
Category 6
Category 7
Category 8
Spreadsheet: 138391d1327639792-reading-a-coded-list-and-copying-associated-data-values-to-a-new-column-easypeasy
Sheet: Sheet1

Letter | Number |  | A | B | C | D
A | 1 |  |  |  |  |  | <<Note the formula in A2.  Type it once and pull it across and down
B | 2
C | 3
D | 4
A | 5
B | 6
C | 7
D | 8
D | 9
C | 10
B | 11
A | 12
D | 13
C | 14
B | 15
A | 16
Spreadsheet: 681899d1591803991-solved-drop-down-box-changing-avalible-selections-based-on-a-second-drop-down-box-character-sheet-creator
Sheet: Ascension

Base Tier |  | [NAME]
Ascension |  | Total Cost
Benefits
Keywords:
Influence/Tier:
Story:
Wargear:
Base Tier |  | [NAME]
Ascension |  | Total Cost
Benefits
Keywords:
Influence/Tier:
Story:
Wargear:
Base Tier |  | [NAME]
Ascension |  | Total Cost
Benefits
Keywords:
Influence/Tier:
Story:
Wargear:
Base Tier |  | [NAME]
Ascension |  | Total Cost
Benefits
Keywords:
Influence/Tier:
Story:
Wargear:
Base Tier |  | [NAME]
Ascension |  | Total Cost
Benefits
Keywords:
Influence/Tier:
Story:
Wargear:
Base Tier |  | [NAME]
Ascension |  | Total Cost
Benefits
Keywords:
Influence/Tier:
Story:
Wargear:
Spreadsheet: 734827d1622534041-help-with-formula-to-extract-multiple-values-from-table-test-workbook
Sheet: Table

 |  | Framer |  |  |  |  |  |  |  |  |  | Help with formula to extract multiple values from table
Address | Job# | Framer | Start | Finish | Bricky | Actual start | Actual Finish |  |  |  |  | GDay guys. First post on here. I will preface this with saying that Im not an excel expert but have a good understanding of using formulas
123 Sample St | 1234 | Mark | 2018-04-04 00:00:00 | 2018-04-11 00:00:00 | [NAME] | 2018-04-30 00:00:00 | 2018-05-11 00:00:00 |  |  |  |  | That being said i have a task that i have no idea how to solve. Have tried using various lookup methods but cant get it to do what i want
Test st 1 |  | Ian | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | [NAME] | 2021-06-01 00:00:00 | 2021-06-10 00:00:00 |  |  |  |  | I have a table (list of jobs and trades allocated to work on that job) that i want to pull data from and group together on another sheet. See attached excel sheet
Test st 2 |  | [NAME] | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | [NAME] | 2021-06-02 00:00:00 | 2021-06-11 00:00:00 |  |  |  |  | The list of jobs will get added to over time so i need something that can search a growing list
Test st 3 |  | Mark | 2021-05-13 00:00:00 | 2021-05-20 00:00:00 |  |  |  |  |  |  |  | What i want to do is search the framer column (F) on my Table sheet for a specific name (eg [NAME]) and then pull the address (column A), start date (column G) and finish date (column H) and then list them in order of date on a separate sheet. The output has been done manually
test st 4 |  | Mark | 2021-05-21 00:00:00 | 2021-05-28 00:00:00 |  |  |  |  |  |  |  | Then i want to do the same for various other trades like brick layers
Test st 5 |  | Ian | 2021-05-18 00:00:00 | 2021-05-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | I have no idea if this is even possible or if maybe it can be done with a pivot table?
Spreadsheet: 268063d1380396587-need-to-pull-data-from-multiple-columns-only-if-value-in-column-a-book1
Sheet: completed

GL | Description | Total
12 | info1 | 5
15 | info2 | 1
13 | [NAME] | 65
15 | info5 | 12
16 | info6 | 32
15 | info9 | 321
12 | info10 | 321
Spreadsheet: 746187d1630566118-adding-up-data-in-different-sheets-sample-64-ans
Sheet: results

 | DROP DOWN MENU
 | Ealing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01/01/20222
 | . |  | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | YTD
 | ACTON | Total Number of claimants
 |  | 25+ Claimants
 |  | Ratio: Total Number of claimants to 25+ Claimants
 | EALING | Total Number of claimants
 |  | 25+ Claimants
 |  | Ratio: Total Number of claimants to 25+ Claimants
Spreadsheet: 145201d1331369114-specific-formating-question-for-column-of-data-book1_utc2012
Sheet: Sheet1

Input |  |  |  |  |  | Result | Required |  | Sample data from thread
1H2406 | 1 | H2406 | 2406 | H | HO | 001HO02406 | 001HO02406 |  | 1H2406 needs to be formatted to 001HO02406
501H7052 | 501 | H7052 | 7052 | H | HO | 501HO07052 | 501HO07052 |  | 501H7052 = 501HO07052
97WW5247 | 97 | WW5247 | 5247 | WW | WW | 097WW05247 | 097WW05247 |  | 97WW5247 = 097WW05247
11G3764 | 11 | G3764 | 3764 | G | GU | 011GU03764 | 011GU3764 | ??? | 11G3764 = 011GU3764
203SR5846 | 203 | SR5846 | 5846 | SR | SR | 203SR05846 | 203SR05846 |  | 203SR5846 = 203SR05846
Spreadsheet: 688864d1595986326-how-to-lookup-result-of-game-and-add-results-to-table-record-tracker
Sheet: Scores

Date | Home Team | Away Team | Home Score | Away Score |  |  | ARI | ATL | BAL | BOS | CHC | CHW | CIN | CLE | COL | DET | HOU | KCR | LAA | LAD | MIA | MIL | MIN | NYM | NYY | OAK | PHI | PIT | SDP | SEA | SFG | STL | TBR | TEX | TOR | WSN
2020-07-23 00:00:00 | SFG | LAD | 1 | 8 |  | 1 | L | L | L | W | W | L | W | W | L | L | W | L | L | W | W | L | W | W | W | W | L | L | W | L | L | W | L | W | W | L
2020-07-23 00:00:00 | NYY | WSN | 4 | 1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  |  |  |  |  | L
2020-07-24 00:00:00 | BAL | BOS | 2 | 13 |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | L
2020-07-24 00:00:00 | MIN | CHW | 10 | 5 |  | 4
2020-07-24 00:00:00 | MIL | CHC | 0 | 3
2020-07-24 00:00:00 | DET | CIN | 1 | 7
2020-07-24 00:00:00 | KCR | CLE | 0 | 2
2020-07-24 00:00:00 | SEA | HOU | 2 | 8
2020-07-24 00:00:00 | SFG | LAD | 1 | 9
2020-07-24 00:00:00 | ATL | NYM | 0 | 1
2020-07-24 00:00:00 | LAA | OAK | 3 | 7
2020-07-24 00:00:00 | MIA | PHI | 5 | 2
2020-07-24 00:00:00 | ARI | SDP | 2 | 7
2020-07-24 00:00:00 | PIT | STL | 4 | 5
2020-07-24 00:00:00 | TOR | TBR | 6 | 4
2020-07-24 00:00:00 | COL | TEX | 0 | 1
2020-07-25 00:00:00 | BAL | BOS | 7 | 2
2020-07-25 00:00:00 | MIN | CHW | 3 | 10
2020-07-25 00:00:00 | MIL | CHC | 8 | 3
2020-07-25 00:00:00 | DET | CIN | 6 | 4
2020-07-25 00:00:00 | KCR | CLE | 3 | 2
2020-07-25 00:00:00 | SEA | HOU | 2 | 7
2020-07-25 00:00:00 | SFG | LAD | 5 | 4
2020-07-25 00:00:00 | ATL | NYM | 5 | 3
2020-07-25 00:00:00 | LAA | OAK | 4 | 1
2020-07-25 00:00:00 | MIA | PHI | 1 | 7
2020-07-25 00:00:00 | ARI | SDP | 1 | 5
2020-07-25 00:00:00 | PIT | STL | 1 | 9
2020-07-25 00:00:00 | TOR | TBR | 1 | 4
2020-07-25 00:00:00 | COL | TEX | 3 | 2
2020-07-25 00:00:00 | NYY | WSN | 2 | 9
2020-07-26 00:00:00 | BAL | BOS | 7 | 4
2020-07-26 00:00:00 | MIN | CHW | 14 | 2
2020-07-26 00:00:00 | MIL | CHC | 1 | 9
2020-07-26 00:00:00 | DET | CIN | 3 | 2
2020-07-26 00:00:00 | KCR | CLE | 2 | 9
2020-07-26 00:00:00 | SEA | HOU | 7 | 6
2020-07-26 00:00:00 | SFG | LAD | 3 | 1
2020-07-26 00:00:00 | ATL | NYM | 14 | 1
2020-07-26 00:00:00 | LAA | OAK | 4 | 6
2020-07-26 00:00:00 | MIA | PHI | 11 | 6
2020-07-26 00:00:00 | ARI | SDP | 4 | 3
2020-07-26 00:00:00 | PIT | STL | 5 | 1
2020-07-26 00:00:00 | TOR | TBR | 5 | 6
2020-07-26 00:00:00 | COL | TEX | 5 | 2
2020-07-26 00:00:00 | NYY | WSN | 3 | 2
2020-07-27 00:00:00 | NYM | BOS | 7 | 4
2020-07-27 00:00:00 | CHC | CIN | 8 | 7
2020-07-27 00:00:00 | KCR | DET | 14 | 6
2020-07-27 00:00:00 | SEA | HOU | 5 | 8
2020-07-27 00:00:00 | LAA | OAK | 0 | 3
2020-07-27 00:00:00 | MIL | PIT | 6 | 5
2020-07-27 00:00:00 | ARI | SDP | 2 | 6
2020-07-27 00:00:00 | ATL | TBR | 5 | 14
2020-07-27 00:00:00 | TOR | WSN | 4 | 1
Spreadsheet: 148394d1333386464-excel-2007-calculating-a-30-day-close-ratio-appointment-tracking
Sheet: Campaign 0001

Merchant | City / State | Date Assigned | Status | Assigned Rep | Projected Volume | Notes |  | Definitions:
Tri-State Tire | Wallingford, CT | 2012-03-29 00:00:00 | New | Walnum | High | Projected volume not yet validated against statement |  | New | Merchant not yet visited
[NAME] | Waterbury, CT | 2012-03-29 00:00:00 | New | Walnum | Mid | Projected volume not yet validated against statement |  | Statement | Statement analyzed but proposal not presented to merchant yet
Alternative Spoke | Willington, CT | 2012-03-30 00:00:00 | New | Walnum | Low | Projected volume not yet validated against statement |  | Proposed | Formal proposal given to merchant
A&M Automotive Ctr | [NAME], CT | 2012-03-30 00:00:00 | New | Walnum | High | Projected volume not yet validated against statement |  | Sold | Merchant has signed a processing agreement
 |  |  |  |  |  |  |  | Lost | Merchant will not be signing a processing agreement
 |  |  |  |  |  |  |  | Today's Date:
 |  |  |  |  |  |  |  | Volume: | Bonus: | Appts: | Sold
 |  |  |  |  |  |  | Low | <$10,500 | 100
 |  |  |  |  |  |  | Mid | >$10,500 | 200
 |  |  |  |  |  |  | High | >$20,000 | 500
 |  |  |  |  |  |  |  | Totals:
 |  |  |  |  |  |  |  | 30-Day Ratios
 |  |  |  |  |  |  |  | Reps: | Appts: | Sales: | Ratio
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Jones
 |  |  |  |  |  |  |  | Lynam
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Thaller
 |  |  |  |  |  |  |  | Walnum
 |  |  |  |  |  |  |  | Wirth
 |  |  |  |  |  |  |  | Campaign Projected Bonuses:
 |  |  |  |  |  |  |  | Deposits: |  |  | 500
 |  |  |  |  |  |  |  | Balance:
 |  |  |  |  |  |  |  | Budget
 |  |  |  |  |  |  |  | Overage
 |  |  |  |  |  |  |  | Roll-over
 |  |  |  |  |  |  |  | Balance = Deposits minus $20/appt
 |  |  |  |  |  |  |  | Budget = Appointments times $70
 |  |  |  |  |  |  |  | Overage = Amount over budget from projected bonuses and deposits
 |  |  |  |  |  |  |  | Roll-over = Amount of deposit to be rolled over to the next campaign
Spreadsheet: 258793d1376854846-adult-baseball-league-schedule-2013fall-schedule-1-
Sheet: SENATORS

Game # | week # | Visitors | Home | Field
2 | 1 | SENATORS | MUDCATS | CCC
5 | 1 | KEYS | SENATORS | [NAME]
9 | 2 | BAYSOX | SENATORS | DP
13 | 3 | SENATORS | KEYS | CCC
16 | 3 | MUDCATS | SENATORS | [NAME]
19 | 4 | SENATORS | BYE
22 | 4 | SENATORS | BAYSOX | [NAME]
27 | 5 | SENATORS | REDWINGS | LBU
33 | 6 | TIGERS | SENATORS | DP
39 | 7 | SENATORS | SEADOGS | GHS
Spreadsheet: 35730d1233332973-auto-display-data-book1
Sheet: Sheet2

Id | Value1 | Value2 | value3
1 | Value2 | Value3 | value4
2 | Value3 | Value4 | value5
8 | Value4 | Value5 | value6
4 | Value5 | Value6 | [NAME]
6 | Value7 | Value8 | value9
7 | Value8 | Value9 | [NAME]
9 | Value10 | Value11 | value12
* data from sheet 1 that the value of Id column are between 0 to 10.
Spreadsheet: 646540d1571904740-conditional-formatting-formula-and-arrays-formulas-dummy-data
Sheet: Sheet1

Batch | Spec | C | Mn | Si | Ni | Cr | Mo | S | P | Cu | Al | Co | Fe | Nb | [NAME] | V | W | Ti | N | Ce | B | Ca | Se | Sn | Pb | Te | Zn | Zr | Sb | As | Ta | La | Bi
Column1 | Column3 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38
1 | Type 8 | 3.41 | 0.238 | 2.45 | 0.0297 | 0.0889 | 0.0082 | 0.0063 | 0.016 | 0.0149 | 0.0167 | 0.0167 |  |  | 0.0438 | 0.0022 | 0.007 | 0.0081
2 | Type 2 | 3.48 | 0.233 | 2.51 | 0.0128 | 0.0982 | 0.0054 | 0.0066 | 0.0154 | 0.0154 | 0.0122 | 0.014 | 92.2 |  | 0.041 | 0.0015 | 0.007 | 0.0049
1 | Type 8
1 | Type 8
1 | Type 8
1 | Type 8 | 3.41 | 0.238 | 2.45 | 0.0297 | 0.0889 | 0.0082 | 0.0063 | 0.016 | 0.0149 | 0.0167 | 0.0167 |  |  | 0.0438 | 0.0022 | 0.007 | 0.0081
1 | Type 8 | 3.41 | 0.238 | 2.45 | 0.0297 | 0.0889 | 0.0082 | 0.0063 | 0.016 |  |  |  |  |  |  |  | 0.007
1 | Type 8
2 | Type 2 |  |  |  |  |  |  |  |  |  |  |  | 92.2
3 | Type 1 |  |  |  | 0.04 | 0.0156 | 15 |  |  | 1.04 | 12.5 |  | 64.04 |  |  | 6
4 | Type 13
5 | Type 15
6 | Type 16
7 | Type 7
8 | Type 4
9 | Type 14
 |  | Sheet 1 contains dummy information
 |  | Sheet 1, row 4 -5 contains sample data
 |  | sheet 1 =c10 contains the dummy array formula, then dragged across
 |  | Manual yellow formatting to indicate what I would like to highlight in rows 12-17
 |  | Row 20-25 contains more sample data to test with
 |  | column B is normally a dynamic drop down menu (sheet 2 A2:A17), so no fear of wrong things being entered, no duplicate entries either
 |  | Sheet 3 contains dummy Specifications on the table named
 |  | sheet 4 is a for named values for lookups, so that when the master (another file) is updated, its easy to fix all the other formulae,
Spreadsheet: 829194d1684019618-merging-index-and-sumproduct-formula-schedulecheck_lln01
Sheet: Sheet1

https://www.excelforum.com/excel-programming-vba-macros/1405379-merging-index-and-sumproduct-formula.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mark
 | Dept 1 |  |  |  | Dept 2 |  |  |  | Dept 3 |  |  |  | Dept 4 |  |  |  |  |  | [NAME]
 | Person | Start Date | Hrs | Finish date | Person | Start Date | Hrs | Finish date | Person | Start Date | Hrs | Finish date | Person | Start Date | Hrs | Finish date |  |  | [NAME]
Item A | [NAME] | 2023-05-15 00:00:00 | 15 |  | [NAME] | 2023-05-15 00:00:00 | 23 |  | [NAME] | 2023-05-15 00:00:00 | 31 |  | [NAME] | 2023-05-12 00:00:00 | 39 |  |  |  | [NAME]
Item B | Mark | 2023-05-15 00:00:00 | 15 |  | [NAME] | 2023-05-15 00:00:00 | 7 |  | [NAME] | 2023-05-15 00:00:00 | 15 |  | [NAME] | 2023-05-15 00:00:00 | 23 |  |  |  | [NAME]
Item C | [NAME] | 2023-05-17 00:00:00 | 15 |  | [NAME] | 2023-05-18 00:00:00 | 23 |  | [NAME] | 2023-05-19 00:00:00 | 31 |  | [NAME] | 2023-05-12 00:00:00 | 39 |  |  |  | [NAME]
Item D | Mark | 2023-05-17 00:00:00 | 23 |  | [NAME] | 2023-05-16 00:00:00 | 7 |  | [NAME] | 2023-05-17 00:00:00 | 15 |  | [NAME] | 2023-05-18 00:00:00 | 23 |  |  |  | [NAME]
 | Dept 1 | Dept 1 | Dept 2 | Dept 2 | Dept 3 | Dept 3 | Dept 4 | Dept 4
 | [NAME] | Mark | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2023-05-15 00:00:00
2023-05-16 00:00:00
2023-05-17 00:00:00
2023-05-18 00:00:00
2023-05-19 00:00:00
Spreadsheet: 779603d1651893786-lookup-function-with-4-different-parameters-milestone-calculator
Sheet: Milestones

Milestone Calculator
Project Size: | Small
Urgency: | High |  |  |  |  | The goal is for the user to indicate the desired completion date, the size and the urgency of the project and the dates would appear automatically, using the duration for each scenario that are indicated in the calculation tab.  It would probably have to take the required completion date and sustract the durations of all the activities to come
Required Completion Date: | 2022-12-20 00:00:00
 | Date
Milestone 1
Milestone 2
Milestone 3
Milestone 4
Milestone 5
Milestone 6
Milestone 7
Milestone 8
Milestone 9
Milestone 10
Spreadsheet: 36869d1234844796-transfer-data-between-sheets-trial-roster
Sheet: Source

Date | Time | Service type | Officiate | Sentence | Topic | Welcomer
2009-03-01 00:00:00 | 08:00:00 | HC 2 | Rod | a | World | Fred
2009-03-01 00:00:00 | 09:30:00 | MP 1 | Rod | b | Local | [NAME]
2009-03-01 00:00:00 | 16:00:00 | Chinese W | Jessica | c | Global | [NAME]
2009-03-08 00:00:00 | 08:00:00 | HC 1 | [NAME] | a | Money | George
2009-03-08 00:00:00 | 09:30:00 | P & P | Rod | b | Goods | Stella
2009-03-08 00:00:00 | 16:00:00 | Chinese HC | Jessica | c | Mind | [NAME]
2009-03-15 00:00:00 | 08:00:00 | HC 3 | [NAME] | a | Hard | [NAME]
2009-03-15 00:00:00 | 09:30:00 | HC 1 | Rod | b | Soft | Lloyd
2009-03-15 00:00:00 | 16:00:00 | Chinese +meal | Jessica | c | Medium | Janice
2009-03-22 00:00:00 | 08:00:00 | HC 3 | Rod | a | Black | [NAME]
2009-03-22 00:00:00 | 09:30:00 | MP 2 | Rod | b | White | [NAME]
2009-03-22 00:00:00 | 16:00:00 | Chinese P | Rod | c | [NAME] | [NAME]