tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: stacey_white__39211__Heat Rate
Sheet: Sheet1

Heat Rate | 10000 | gas conv. Power | Choose gas index,+HR +costs = fixed power price compated against power curve | mmbtu/mw
[NAME] | 400 | per hour
Utilization | 0.9
Days in year | 365 |  |  |  |  | mmbtu/day vs mh/hour
Gas
total gen
Gen * HR
Total gas K
Spreadsheet: 139739d1328429608-fetch-value-of-a-cell-if-its-row-contain-a-value-0-sales_record_my_doubt-pending-cash
Sheet: Customer List

 | Customer ID | Customer Name | candy price
 | 001-001 | ABC Stores | 10
 | 001-002 | [NAME] and [NAME] | 10
 | 001-003 | Kids World | 8
 | 001-004 | Fun Time | 12
 | 001-005 | Animalz | 12
 | 001-006 | Kids Corners | 12
 | 001-007 | Kidddies | 10
 | 001-008 | The Family Shop | 12
 | 001-009 | The Roundabout | 11
 | 001-010 | Walky | 8
 | 001-011 | Rainbow | 11
 | 001-012 | Kids Park | 9
 | 001-013 | Fun Park | 12
 | 001-014 | The Sea Side | 12
 | 001-015 | [NAME] | 12
 | 001-016 | The Sunny | 12
 | 001-017 | Romantic | 11
 | 001-018 | Seasons | 8
 | 001-019 | Paragon | 12
 | 001-020 | Sagar | 12
Spreadsheet: 777451d1650385388-looking-for-a-formula-to-transpose-data-from-one-table-to-another-schedule-template
Sheet: Sheet1

Template 1 |  |  |  |  | Template 2
7/31-8/27 | Su | M | T |  | 7/31-8/27 | Su | M | T
 | 2022-07-31 00:00:00 | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 |  |  | 2022-07-31 00:00:00 | 2022-08-01 00:00:00 | 2022-08-02 00:00:00
Greg | V1 | V1 | V1 |  | A
[NAME] |  |  | S |  | S
[NAME] | V2 | V2 | V2 |  | P
[NAME] | P | P |  |  | V1
[NAME] |  | S | P |  | V2
Mark |  | A | A
Justin | A
Template 1
7/31-8/27 | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa
 | 2022-07-31 00:00:00 | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00 | 2022-08-14 00:00:00 | 2022-08-15 00:00:00 | 2022-08-16 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00
Greg | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 | V1 |  | S |  |  |  | A | A |  | S |  |  |  | A
[NAME] |  | S | S | S |  | P | P | P |  |  | A | A |  |  | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3 | V3
[NAME] | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 | V2 |  |  | S | S | S |  |  |  |  | S |  | P | P
[NAME] | P | P | P |  | A | A |  |  | P | P |  |  |  | A | A |  |  | P | P |  |  |  | A | A |  | P
[NAME] |  |  |  | P | P |  | A | A |  |  | P | P |  |  |  | P | P |  |  | A |  |  |  |  | A | A | A
Mark |  | A | A | A |  |  |  |  | A |  |  |  | P | P | P |  | A | A |  |  |  |  | P | P | P
Justin | A
 | A= day shift, P= night shift, S= swing shift, V= vacation
Template 2
 | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa
 | 2022-07-31 00:00:00 | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00 | 2022-08-14 00:00:00 | 2022-08-15 00:00:00 | 2022-08-16 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00
A
S
P
V1
V2
V3
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Mexico

Mexico
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Mexico |  | 2998463
[NAME] |  | Gas |  | Mexico |  | 388431
[NAME] |  | Gas |  | Mexico |  | 4515
Total
Spreadsheet: jeffrey_a_shankman__13829__Presentation 2001
Sheet: Sheet1

[NAME]
[NAME]
EVENT: | Presentation
DATE: | Wednesday, January 24th
TIME: | 18:00:00
PLACE: | University of Pennsylvania
Contacts: | [NAME] | Cell Phone: | (713) 594-3154
 | [NAME]: Recruiting co-ordinator | Work Phone: | (713) 345-8369
 | Career Services: [NAME] | Office : | (215) 898-5582
What: | Presentation | Acceptance Dinner
When: | Wednesday, January 24th | Wednesday, January 24th
Where: | [NAME] Penn | La Terrasse
 | Woodlands CD room (Hors d' Oeuvres will be served) | 3432 Samson Street
Time: | 18:00:00 | 20:00:00
Contact: | [NAME] @ [PHONE] | [NAME] (215)-386-5000
Enron | [NAME] | [NAME]
Participants: | [NAME], [NAME] | [NAME], [NAME]
 | [NAME], [NAME], | [NAME], [NAME],
 | Miguel Nasser & [NAME] | Miguel Nasser & [NAME]
Flight
Arrangements: | Should be made by each participant
Hotel
Information: | To all participants, rooms are reserved under your name at the following hotel:
 | [NAME] Penn
 | 3600 Samson Street
 | Philadelphia, PA 19104
 | (215)222-0200
Hotel Contact | [NAME]
 | Cancellation by 4:00 PM date of arrival
 | 3:00 PM check in 12:00 PM check out
Hotel | Name | In | Out | Confirmation
Guests: | [NAME] | 24th | 25th | 80343939
 | [NAME] | 24th | 25th | 85061155
 | [NAME] | 24th | 25th | 85927298
 | [NAME] | 24th | 25th | 81471234
 | [NAME] | 24th | 25th | 87238466
 | [NAME] | 24th | 25th | 85141410
 | [NAME] | 24th | 25th | 87499458
Ground
Information: | [NAME], Rental Car (You are responsible for arranging transportation)
Additional
Information: | The attire for the Presentation  is Business Casual.  Please remember to bring your business cards.  Please submit
 | all completed/signed SAP expense reimbursements to [NAME] at EB1167 for coding and processing.  Please
 | keep a copy of your expense report for your files.
Spreadsheet: 136645d1326756585-excel-formula-help-needed-on-time-delivery-excel-help
Sheet: Forum

WEEKLY SCHEDULE | SHIP TIME | ETA | ACTUAL | Diff | Comment | On Time / Late
Store 1 | 12:00:00 | 14:00:00 | 13:25:00 | 1903-12-31 23:25:00 |  | On Time
Store 2 | 12:00:00 | 15:00:00 | 14:25:00 | 1903-12-31 23:25:00 |  | On Time
Store 3 | 12:00:00 | 16:00:00 | 11:25:00 | 1903-12-31 19:25:00 | A | On Time
Store 4 | 12:00:00 | 17:00:00 | 17:20:00 | 00:20:00 |  | Late
Store 5 | 12:00:00 | 18:00:00 | 18:20:00 | 00:20:00 | B | On Time
Store 6 | 12:00:00 | 19:00:00 | 19:20:00 | 00:20:00 | B | On Time
Store 7 | 12:00:00 | 20:00:00 | 08:20:00 | 00:20:00 |  | Late
Store 8 | 12:00:00 | 21:00:00 | 11:00:00 | 1903-12-31 14:00:00 | C | On Time
Store 9 | 12:00:00 | 22:00:00 | 10:30:00 | 1903-12-31 12:30:00 |  | Early
Spreadsheet: 83894d1283934244-how-to-code-according-to-income-range-sample
Sheet: Sheet1

Income | Code
3000 | 1
5000 | 1
8000 | 2
10000 | 3
15000 | 4
9000 | 2 |  | How to convert the code from 1-5 from Income criteria?
1000 | 1
4500 | 1
2000 | 1
25000 | 5
3000 | 1
15000 | 4
 |  | Income criteria | Code
 |  | <=5000 | 1
 |  | 5000-10000 | 2
 |  | 1000-15000 | 3
 |  | 15000-20000 | 4
 |  | 20000 and above | 5
Spreadsheet: eric_saibi__9805__092001R
Sheet: Northside 03

Owner Name | Jacksonville Electric Authority
Station Name | Northside Power Station
Unit Name | Northside 03
NERC Region | FRCC
State | FL
Fuel Type | Fuel Oil / Natural Gas
Capacity | 564 MW
Start Date | 2001-10-20 00:00:00
End Date | 2001-11-06 00:00:00
Prv. Start Date | 2001-10-15 00:00:00
Prv. End Date | 2001-11-11 00:00:00
Comments
SIC | 4911
Plant ID | 1021650
Unit ID | 1007151
Outage ID | 17507
Spreadsheet: 851643d1701829717-conditional-formatting-using-responses-from-ms-forms-scheduling-test-newtonus_prime-
Sheet: GS

GS | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | Light Smoothing | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]
Spreadsheet: 761915d1641298680-multiple-dynamic-rows-to-be-filter-based-criteria-on-another-sheet-demo_v01
Sheet: Sheet3

Team C
DATE | NAME | SITE | SHIFT | PROJECT | TASK | Complexity | HOURS WORKED | NOTES
2021-12-05 00:00:00 | Alina | Russia | Morning | love_watch | 889 | Hard | 6 | Average
2021-12-05 00:00:00 | Alyona | Russia | Morning | love_watch | 15696 | Hard | 6 | Average
2021-12-07 00:00:00 | Maria | Russia | Morning | [NAME] | 15362 | Simple | 6 | Good
2021-12-08 00:00:00 | Inessa | Russia | Morning | Leave | - | - | - | -
2021-12-08 00:00:00 | Aksana | Russia | Night | P_6255 | 6546 | Mid | 8 | Good
2021-12-09 00:00:00 | Margarita | Russia | Morning | love_watch | 7651 | Hard | 4 | Good
2021-12-09 00:00:00 | Alyona | Russia | Evening | [NAME] | 9858 | Hard | 4 | Average
2021-12-09 00:00:00 | Galina | Russia | Evening | P_6255 | 3696 | Mid | 4 | Good
2021-12-09 00:00:00 | Isabel | Russia | Evening | [NAME] | 15974 | Simple | 8 | Good
2021-12-10 00:00:00 | Ksenia | Russia | Night | Leave | - | - | - | -
2021-12-10 00:00:00 | Inessa | Russia | Night | Qalityfood | 3621 | Hard | 8 | Good
2021-12-10 00:00:00 | Yulia | Russia | Morning | bmwnr-156 | 364444 | Simple | 8 | Average
2021-12-12 00:00:00 | Alina | Russia | Evening | Top_h_456 | 4545 | Mid | 6 | Average
2021-12-15 00:00:00 | Maria | Russia | Evening | Leave | - | Simple | - | -
Spreadsheet: 758397d1638847174-pull-data-from-other-tabs-into-a-summary-tab-only-if-certain-data-selected-in-column-pull-data-from-other-tabs-into-a-summary-tab-only-if-certain-data-selected-in-column
Sheet: POST SSU TRAINING

 |  |  | POST SSU TRAINING
 | SMALL EQUIP |  |  |  | HANDPIECES & TIPS |  |  |  | SURGICAL & IMPLANTS |  |  |  | ENDODONTICS |  |  |  | CONSUMABLES |  |  |  | IMS & CASSETTES |  |  |  | OTHER
 | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING
Spreadsheet: 130596d1322480084-combining-2-formulae-form
Sheet: Sheet1

Date | Time | Course |  | Conf | Rating | Computer |  | Early | On [NAME] | Result | S/P | Win | Place | Place | Early Odds
 |  |  | Selections |  |  | Forecast |  | Odds | before |  |  | Return | calculation | Return | Bank
 |  |  |  |  |  | Odds |  | Available | 11.00 am |  |  |  |  |  | Balance
 |  |  |  |  |  |  |  |  | By: |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  | 6 |  | 0
Spreadsheet: 170564d1343315950-vlookup-that-returns-multiple-values-from-a-prior-column-form
Sheet: Charts

Period:
Number of Deals:
Total Raised [mUSD]:
Average Size [mUSD]:
 | Coupon |  |  | Yield |  |  | Spread |  |  |  |  | Shares Issued [millions]
 |  | Percent |  |  | Percent |  |  | BP
 | Average |  |  | Average |  |  | Average |  |  |  |  | Primary |  |  | Greenshoe |  |  | Secondary
 | Median |  |  | Median |  |  | Median |  |  |  |  | Average |  |  | Average |  |  | Average
 |  |  |  |  |  |  |  |  |  |  |  | Median |  |  | Median |  |  | Median
Spreadsheet: 773436d1647865501-countif-based-on-two-conditions-over-non-continuous-cells-test_new-1-
Sheet: More columns added

Count | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C
3 | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 | z |  | 1
2 | 1 |  |  | 1 |  |  | 1 | z |  | 0 | y |  | 1 | z |  | 1 | z
3 | 1 |  |  | 1 | y |  | 1 | y |  | 1 |  |  | 1 | y |  | 1 | a
0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1 | 1 | z |  | 1 | z |  | 1 |  |  | 1 | z |  | 1 | z |  | 0 | z
COUNTIF | Column: A > 0 AND column B is either blank OR equal to 'y'
 | The green cells are the ones COUNTED in each row.
Spreadsheet: 43274278-6653-4160-b216-5d29ac82a352
Sheet: Sheet1

NOTICE OF PRIMARY ELECTION
A Notice is hereby given that on Tuesday, the fifteenth day of May, 2012, at the usual polling places in the precincts of Garden County,
Nebraska, an election will be held.  The polls will be open at 7:00 a.m. and close at 7:00 p.m.  [NAME] election will be for nominating or electing
candidates to various offices, for special issues, and for proposed amendments to the Constitution.
Some races will not appear on the Primary Election as the number of candidates filing for office did not exceed twice the number of vacancies;
these candidates are declared nominated and will advance to the November 6th General Election.
Presidential Ticket |  | County Ticket |  | For Board Member
For President of the United States |  | For County Commissioner Dist #1 |  | Creek Valley School Dist. 25-0001
REPUBLICAN |  | REPUBLICAN |  | [NAME]
[NAME] |  | [NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  |  |  | For Board Member
[NAME] |  | Nonpartisan Ticket |  | South Platte School Dist. 25-0095
 |  | For Member of Legislature Dist #47 |  | [NAME]
DEMOCRAT |  | [NAME] |  | [NAME]
[NAME] |  |  |  | Stanley Rhoads
 |  | For Board Member of the
LIBERTARIAN |  | Garden County Airport Authority |  | For Board Member
[NAME] |  | [NAME] |  | Garden County School Dist. 35-0001
RJ [NAME] |  |  |  | [NAME]
[NAME] |  | For Board Member of the Western |  | [NAME]
[NAME] |  | Community College Dist #2 |  | [NAME]
[NAME] Still |  | [NAME]
[NAME] |  |  |  | For Board Member
 |  | For Board Member of the Western |  | City of Oshkosh Council
Senatorial Ticket |  | Community College At Large |  | [NAME]
For United States Senator |  | [NAME] |  | [NAME]
REPUBLICAN |  |  |  | [NAME]
[NAME] |  | For Board Member of the North Platte
[NAME] |  | Natural Resources District Subdistrict #1
[NAME] |  | [NAME]
Deb Fischer
[NAME] |  | For Board Member of the North Platte
[NAME] |  | Natural Resources District Subdistrict #2
DEMOCRAT
[NAME] |  | For Board Member of the North Platte
[NAME] |  | Natural Resources District Subdistrict #3
Sherman Yates |  | [NAME]
[NAME]
[NAME] |  | For Board Member of the North Platte
 |  | Natural Resources District Subdistrict #4
Congressional Ticket |  | [NAME]
For Representative in Congress |  |  |  | I, [NAME], [NAME] of
REPUBLICAN |  |  |  | Garden County, do hereby certify that the
[NAME] |  |  |  | persons whose names are printed in the
[NAME] |  |  |  | certification have made personal filings
 |  |  |  | and each has fulfilled all requirements of
DEMOCRAT |  |  |  | law and each is entitled to have their
[NAME] |  |  |  | name printed upon the official ballot as a
 |  |  |  | candidate for public office, as designated
 |  |  |  | in the certification.
 |  |  |  | _______________________________________
 |  |  |  | Garden County Election Commissioner
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Sea Wych

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-03-08 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-03-08 00:00:00
Spreadsheet: 685805d1594207856-index-choose-match-issue-index-choose-match
Sheet: Sheet1

 |  |  |  |  |  | table 1 | model | cost |  | order | model | table | result
 |  |  |  |  |  |  | A | 20 |  | 1340 | A | 1
 |  |  |  |  |  |  | B | 45 |  | 1340 | B | 2
 |  |  |  |  |  |  | C | 43 |  | 1340 | C | 1
 |  |  |  |  |  |  | D | 56 |  | 1340 | D | 2
 |  |  |  |  |  |  |  |  |  | 1340 | A | 1
 |  |  |  |  |  | table 2 | model | cost |  | 1340 | B | 2
 |  |  |  |  |  |  | A | 30
 |  |  |  |  |  |  | B | 25
 |  |  |  |  |  |  | C | 98
 |  |  |  |  |  |  | D | 65
Spreadsheet: 767665d1644577024-variable-column-for-vlookup-possible-book3a
Sheet: Sheet2

Aantal ronden aan de leiding gereden per race. |  |  |  | Aantal
 |  |  | Totaal |  | 10° Targa [NAME] | 1° Circuito di Mugello | 11° Targa [NAME]
 |  |  |  |  | nWK | nWK | nWK
 |  |  |  |  | 108 | 64.9 | 108
Abate | Carlo |  |  |  |  |  |  | IFERROR((VLOOKUP($C5;Sheet1!$C$5:H$5000;6)*H$4);"-")
Ábate | Walter
Abecassis | George
Abney | [NAME]
[NAME] | Lino
Accadia | Agostino
Achard | [NAME]
Acheson | Kenny
Ación | [NAME]
Adams | [NAME]
Adant | [NAME]
Adas | [NAME]
Ader | [NAME]
Adolff | Kurt
Agabashian | Fred
Agostini | Giacomo
Agúero | [NAME]
Aguirre | Juan
Aguirre | [NAME]
Ahrens | Kurt
[NAME] | Guido
Aitken | [NAME]
Alabern | [NAME]
Albanese | [NAME]
Albers | Christijan
Alberti | Augustín
Spreadsheet: 51377d1251030492-one-main-article-one-price-three-or-more-versions-book1_v1_3-1-
Sheet: Sheet1

Article |  |  |  | Article | Price
CARBLACK | 1500 |  |  | CAR | 1500
CARRED | 1500 |  |  | TRUCK | 1243
CARWHITE | 1500 |  |  | BICYCLE | 887
TRUCKWHITE | 1243
TRUCKBLACK | 1243
TRUCKRED | 1243
BICYCLEWHITE | 887
BICYCLERED | 887
BICYCLEBLACK | 887
Spreadsheet: 801521d1666244864-formula-to-get-unique-ids-from-one-sheet-to-another-formula-to-get-invoice-number-from-rows-containing-total-only-ans
Sheet: 2A Extract

[NAME] of supplier | A | B | Invoice number
Spreadsheet: 760147d1640019685-how-to-produce-multiple-results-using-index-match-or-vlookup-sample
Sheet: Sheet1

Products | Type |  | Products | Type
Pencil | Yellow |  | Pencil
Stapler | Black |  | Stapler
Ruler | Yellow1 |  | Ruler
Paper | Green |  | Paper
Pencil | Red |  | Pencil |  | <<<This should be "Red"
Paper | Blue |  | Paper |  | <<<This should be "Blue"
Spreadsheet: 180400d1347577608-macro-for-copy-and-pasting-duplicates-sample
Sheet: result2

[NAME] | im beautiful
[NAME] | im not beautiful
[NAME] | maybe im beautiful
[NAME] | maybe im not beautiful
[NAME] | im fat
[NAME] | im not fat
[NAME] | maybe im fat
[NAME] | maybe im not fat
[NAME] | im thin
[NAME] | im not thin
[NAME] | maybe im thin
[NAME] | maybe im not thin
Spreadsheet: 850350d1700720511-retrieve-all-entries-of-data-based-on-several-criteria-help-2
Sheet: Sheet1

Individual
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Individual | FY Qtr | Status
 |  |  |  |  |  |  |  |  |  |  |  |  | - | - | -
 | Q1-2024 | Q2-2024 | Q3-2024 | Total |  |  |  |  |  |  |  |  | [NAME] | Q1-2024 | Likely
Value |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Q2-2024 | Unlikely
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Q3-2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4-2024
 |  |  |  |  |  |  |  |  |  |  |  | THIS INFORMATION LIVES IN DIFFERENT WORKSHEETS
 |  |  |  |  |  |  |  |  |  |  |  |  | Main | Contributor | Status | Name | Value | Date | Open Duration | Qtr
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 1 | 949341.5571235716 | 2023-09-18 00:00:00 | 300 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Unlikely | Job 2 | 620542.7314814815 | 2023-09-18 00:00:00 | 22 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 3 | 607525.4421148185 | 2023-09-18 00:00:00 | 25 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 4 | 523661.7935816891 | 2024-06-01 00:00:00 | 500 | Q3-2024
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Likely | Job 5 | 450526.5480562501 | 2023-09-18 00:00:00 | 20 | Q1-2024
FY Qtr | Status |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 6 | 446820.7080492995 | 2023-09-18 00:00:00 | 333 | Q1-2024
Q1-2024 | Unlikely |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 7 | 423105.9867414866 | 2023-09-18 00:00:00 | 641 | Q2-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 8 | 410648.018245858 | 2024-02-01 00:00:00 | 95 | Q3-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Likely | Job 9 | 394325.80825093 | 2024-06-01 00:00:00 | 661 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 10 | 374007.5766874127 | 2023-09-18 00:00:00 | 22 | Q1-2024
Name | Value | Date | Open Duration |  |  |  |  |  |  |  |  |  | [NAME] |  | Unlikely | Job 11 | 369480.0642801212 | 2023-09-18 00:00:00 | 258 | Q2-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Unlikely | Job 12 | 363119.7857068661 | 2024-02-01 00:00:00 | 211 | Q3-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 13 | 352942.7583610414 | 2024-06-01 00:00:00 | 100 | Q1-2024
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Likely | Job 14 | 352512.5646852856 | 2023-09-18 00:00:00 | 5446 | Q1-2024
 |  |  |  | Question: Is it possible for this table from A27 to D46 to autopopulate the fields from the information in N15 to U29 based on the infidvidual selected in A2, the FYQtr in A21 and Status in B22  The query: - If I select Q1-2024 and Likely status in cells A & B 22  -show me the information (Name, Value, Date, Open Duration)  -for the individual in A2 if they are the 'Main' or 'Contributor'    I have just linked for the pupose of this example to demonstrate what i want the formula to automatically do
Spreadsheet: 743902d1628800015-double-match-and-total-sample
Sheet: Sheet1

Company | Product | Domain | QTY
Company X | Product A | ABC.COM | 1
Company Y | Product B | DEF.COM | 2
Company Z | Product A | GHI.COM | 3
Company X | Product B | ABC.COM | 4
Company Y | Product A | DEF.COM | 5
Company Z | Product B | GHI.COM | 6
Company X | Product A | ABC.COM | 7
Company Y | Product B | DEF.COM | 8
Company Z | Product A | GHI.COM | 9
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 15

Wed 16 Aug                    00:00 |  |  |  |  |  |  |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  | 7.1 | 7.1 | 6.5
Thu 17 Aug                     00:00 |  |  |  |  |  |  |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  | 6.6
Fri 18 Aug |  |  |  |  |  | 00:00 |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  | 6.3 6.1
Sat 19 Aug                      00:00 |  |  |  |  |  |  |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  | 5.2
Sun 20 Aug                     00:00 |  |  |  |  |  |  |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  |  | 5.9
Mon 21 Aug                    00:00 |  |  |  |  |  |  |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  |  | 6.1
Tue 22 Aug                     00:00 |  |  |  |  |  |  |  | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Glucose mmol/L |  |  |  |  |  |  |  |  |  |  |  | 5.6
Wed 23 Aug Glucose mmol/L |  |  |  |  |  |  | 00:00       02:00            04:00            06:00            08:00            10:00            12:00            14:00            16:00            18:00            20:00            22:00        00:00
 |  |  |  |  |  |  |  |  | 7.2
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Thu 24 Aug Glucose mmol/L