tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -89270 | -72220 | 0 | -16950
2 | -96891 | -72220 | 0 | -24950 |  |  |  |  |  |  |  |  |  | Avg
3 | -97853 | -72220 |  | -24950 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -102776 | -77338 |  | -24624
5
6 |  |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-08-31 00:00:00 |  |  | 472010
 |  |  |  | 2001-09-04 00:00:00
 | CBS Volume
 |  |  |  | 115270
Spreadsheet: 043ebb0a-4a75-48fc-b498-e4f97124c18b
Sheet: WS 

BWF World Senior Championships 2013
WS 35 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Quarterfinals | Semifinals | Final | Winner
1 | 9696 |  | SCO |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 85907 |  | SWE |  | [NAME]
4 | 69447 |  | JPN |  | [NAME]
5 | 97623 |  | GER |  | [NAME]
6 | 94361 |  | TUR |  | [NAME]
7 | 73354 |  | FRA |  | [NAME]
8 | 56485 |  | IND |  | [NAME]
9 | 8422 |  | UKR |  | [NAME] [3/4]
10 |  |  |  |  | Bye 3
11 | 74876 |  | IND |  | [NAME]
12 | 81897 |  | GER |  | Simone Weisbarth
13 | 68353 |  | TUR |  | Serpil Beyenal Babacan
14 | 6084 |  | ENG |  | [NAME]
15 | 71504 |  | FRA |  | [NAME]
16 | 97009 |  | SWE |  | Eva Maria Lindqvist
17 | 70148 |  | ESP |  | [NAME]
18 | 56296 |  | FRA |  | Celine Bretonniere
19 | 68775 |  | CZE |  | [NAME]
20 | 60341 |  | TUR |  | Rasime [NAME]
21 | 91436 |  | IND |  | Usha Sree Peddisetty
22 | 67645 |  | SWE |  | [NAME]
23 |  |  |  |  | Bye 4
24 | 6891 |  | GER |  | [NAME] [3/4]
25 | 4911 |  | RUS |  | [NAME]
26 | 74392 |  | JPN |  | [NAME]
27 | 66833 |  | TUR |  | [NAME]
28 | 3791 |  | FRA |  | Tatiana Verge
29 | 50063 |  | SWE |  | Sara Rehnstrom Fandriks
30 | 56292 |  | IND |  | [NAME]
31 |  |  |  |  | Bye 2
32 | 10033 |  | SRI |  | [NAME] [2]
Spreadsheet: 777551d1650466776-compare-two-ranges-for-the-2nd-and-3rd-match-position-2nd-match-position
Sheet: Sheet2

 |  |  |  |  |  |  | 10 |  | 22
 |  |  |  |  |  |  | 90 |  | 19
 |  |  |  |  |  |  | 87 |  | 45
 |  |  |  |  |  |  | 44 |  | 33
 |  |  |  |  |  |  | 44 |  | 87
 |  |  |  |  |  |  | 35 |  | 40
 |  |  |  |  |  |  | 73 |  | 44
 |  |  |  |  |  |  | 93 |  | 77
 |  |  |  |  |  |  | 31 |  | 68
 |  |  |  |  |  |  | 89 |  | 93
 |  |  |  |  |  |  | 1ST MATCH POSITION
 |  |  |  |  |  |  | 2ND MATCH POSITION |  | 7 |  | Can we have formular for the 2nd and 3rd match position?
 |  |  |  |  |  |  | 3RD MATCH POSITION |  | 10
Spreadsheet: 834877d1688129397-combine-3-tables-in-one-sheet-into-one-table-in-a-new-sheet-data-archive-test
Sheet: Box_req

 | Column1 | Contents & Comments | Review Date (dd/mm/yyyy) |  | Column1 | Contents & Comments | Review Date (dd/mm/yyyy) |  | Column1 | Contents & Comments | Review Date (dd/mm/yyyy)
Spreadsheet: 765033d1643128948-how-to-populate-all-data-in-other-column-when-choosing-a-certain-parameters-in-a-column-sample
Sheet: reference

Region | ID | Name | Plan ID | Plan Name | Job Type | Plan Element | Element Components | Element Weighting | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | FY2021 | Element Source | Country
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid | Total Revenue |  | 0.7
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid |  | [NAME]
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid |  | Extended Warranty
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid |  | Software
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid |  | Elevate
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid |  | Supplies Winbacks
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid |  | MPS Services
ANZ | 1125279 | Customer A | LXK02430 | Country/Region Manager - Enduser & Hybrid | Country/Region Manager - Enduser & Hybrid | Branded GM$ | Branded Country/Region GM$ | 0.3
Spreadsheet: 722533d1615306983-sum-multiple-items-in-a-table-device-report
Sheet: Totals

Device EVENTS COMPLETED
 | 2021-01-02 00:00:00 |  | January |  | 2021
 | Device 1 | Device 2 | Device 1 | Device 2 | Device 1 | Device 2
Group 1 |  |  | 8 | 22
Group 2 |  |  | 8 | 2
Group 3 |  |  | 8 | 2
Group 4 |  |  | 0 | 0
Group 5 |  |  | 18 | 28
Group 6 |  |  | 11 | 4
Group 7 |  |  | 1 | 3
Group 8 |  |  | 0 | 4
Group 9 |  |  | 0 | 0
Group 10 |  |  | 2 | 0
Group 11 |  |  | 3 | 0
Group 12 |  |  | 1 | 1
Total |  |  | 65 | 66
Device EVENTS LOST
 |  |  | January |  | 2021
 | Device 1 | Device 2 | Device 1 | Device 2 | Device 1 | Device 2
Event 1 |  |  | 0 | 0
Event 2 |  |  | 1 | 0
Event 3 |  |  | 0 | 0
Other |  |  | 0 | 0
Total |  |  | 1 | 0
Spreadsheet: 889923d1740962205-filter-function-nested-if-multi-better-simpler-expression-combobox-filter-4multi-any-sequence-xl21-dyn-spill-srch-cam-slicer-trick-
Sheet: DATA

MAKE | MODEL | FUEL | TYPE | DESC | IG |  | UNIQUE MAKE |  | Formula SRCH Col A | Formula SRCH Col B | Formula SRCH Col C | Formula SRCH Col D
Peugeot | 2O7 | PETROL | Gti | OK | 15
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 |  |  |  | Ford | 3 series | PETROL | Dci
Honda | Civic | PETROL | Type R | [NAME] | 13 |  |  |  | Honda | 3O6 |  | GT Hdi
Fiat | Panda | PETROL | Dlux | Poor |  |  |  |  | Peugeot | 3O7 |  | Hdi
Citreon | Ax | PETROL | Vibe | Poor |  |  |  |  | Renault | Civic |  | TD
Vauxhall | Nova | PETROL | SRI | Dull | 8 |  |  |  |  | Focus |  | TDCi
Rover Metro | Metro | PETROL | Club | Dull |  |  |  |  |  | Megane |  | Tdi
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11 |  |  |  |  |  |  | [NAME]
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | Z4 | PETROL | Sport | Great | 15
Bmw | X4 | PETROL | 4WD | 4x4 | 16
Renault | Megane | DIESEL | Dci | Great | 8
Proton | Impian | PETROL | Sport | Dull | 8
Ford | Focus | DIESEL | TDCi | Great | 11
Honda | Civic | DIESEL | CDTi | Great | 10
Peugeot | 3O7 | DIESEL | Hdi | Super | 11
Fiat | Punto | PETROL | Sport | Tidy | 8
Vauxhall | Astra | PETROL | VXR | Great | 9
Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Honda | Civic | DIESEL | CDTi | Excellent | 10
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Bmw | 3 series | DIESEL | Tdi | Nice | 10
Bmw | 3 series | DIESEL | [NAME] | Nice | 10
Spreadsheet: 535722e4-ee37-428a-8dc7-2b54ebf934ad
Sheet: Sheet1

Nurse Leader Eligibility Table
Note:  Before beginning to enter data, create one line for each unit to be entered.  If additional lines are needed for a Unit Type, right click on a row number within that unit type and select "Insert".  Enter one unit per line.
Dept./Service/Unit | Units | Name (Last, First) | Highest Nursing Degree | Job Title
Medical
Surgical
Med-Surg
Oncology
Step Down
Critical Care
Labor & Delivery
Ante/Post Partum
NICU
Pediatrics
PICU
Operating Room(s)
PACU
Amb. Procedure
Psych.
Rehab.
Ambulatory
Emergency Department
Specialty Practice
Acuity Adaptable
Pre-Operative
LDRP
Home Care
Hospice
Long Term Care
Centralized Function
All Others
Spreadsheet: 67695d1268252354-lookup-list-vlookup-help
Sheet: Sheet4

Company | Description | Code 1 | Code 2 | Code 3
Company A | Office | 65121 | 8711 | 541330
 | Lessors | 65198 | 6531 | 531120
 | Condo | 60999 | 871* | 541330
Company B | Office | 65121 | 6324 | 621491
 | Lessors | 65198 | 6531 | 531120
 | Condo | 60999 | 6324 | 621491
Company C | Office | 65121 | 6411 | 524298
 | Lessors | 65198 | 6531 | 531120
 | Condo | 60999 | 6411 | 524298
Company D | Office | 65121 | 6411 | 524210
 | Lessors | 65198 | 6531 | 531120
 | Condo | 60999 | 6411 | 524210
Company E | Office | 65121 | 7389 | 541410
 | Lessors | 65198 | 6531 | 531120
 | Condo | 60999 | 7389 | 541410
I am trying to get a list of the Company and Description fields that are in the same rows when Code 3 = 524210.
In  other words, what I would like is for Excel to return a small table that shows this, based on Code 3 = 524210:
 | Company D | Office
 | Company D | Condo
Spreadsheet: 872003d1718366507-summing-2-different-columns-only-when-names-match-help3
Sheet: Sheet1

Claimant 03rd | 03/06/2024 | No Appt Reason 3rd | Claimant 10t | 10/06/2024 | No Appt Reason 10th |  |  | without reason | with reason
[NAME] | 1 | ill | [NAME] | 1 | ill |  | [NAME] | 2 | 0
[NAME] | 1 | ill | [NAME] | 1 |  |  | [NAME] | 2 | 2
Spreadsheet: 675202d1588192762-matching-up-to-two-sets-of-data-move-sample
Sheet: Sample

Sample
Client # | DDA Account | Primary Name | RDS | RDS Limit | Setup Date | Review | Visit | Officer | Risk | DDA ACCT | NAME | RISK
4541231 | 668 | ABC CO | Y | 20000 | 06/02/2010 | 01092021 | 05072020 | ALP - PRIETO (60) |  | 668 | ABC CO | M
 | 802 | ABC CO | Y |  |  |  |  | ALP - PRIETO (60) |  | 1234 | PARTNER LP | M
 | 1380 | BBB | Y |  |  | 12102020 | 11262020 | NSK - KAIL (52) |  | 1380 | BBB | L
 | 7499 | BBB | Y |  |  |  |  | NSK - KAIL (52) |  | 7499 | BBB | H
34213453 | 7608 | CORP INC | Y | 750000 | 2019-08-27 00:00:00 |  |  | NSK - KAIL (52) |  | 7616 | CORP INC | M
4543453 | 9505 | BBB | Y | 125000 | 06/22/2011 |  |  | CWM - MILAM (59) |  | 7624 | CORP INC | M
 |  |  |  |  |  |  |  |  |  | 9505 | BBB | M
Spreadsheet: 754804d1636512281-using-sumif-with-an-or-or-else-trades-template-
Sheet: DATA

TICKER | WEEK | DATE | TIME | LONG / SHORT | ENTRY | SIZE | ADD 1 | ADD 1 SIZE | ADD 2 | ADD 2 SIZE | DD | LOW | HIGH | EXIT 1 | EXIT 1 SIZE | EXIT 2 | EXIT 2 SIZE | MAX GAIN | POINTS | G/L $ | STRATEGY | SETUP | EXIT REASON | ENTRY ATTEMPT | RUN LOW | RUN HIGH | RUN 50% | RUN BOUNCE | CONS 1 | CONS 1 RUN | SPACE | MARKET CAP | FLOAT | CHART
ABVC |  | 2021-11-01 00:00:00 | 09:30:00 | Long | 9 | 200 | 9.5 | 300 | 10 | 400 |  |  | 12 | 11.5 | 100 | 11 |  |  |  |  |  | Pivot | Failed |  |  |  |  |  |  |  | Biotech | 62610000 | 1810000 | ..\Charts\abvc-20211101.png
XYZ |  | 2021-11-08 00:00:00 | 09:30:00 | Long | 12 | 200 |  |  |  |  |  |  | 15 |  |  | 14
BNHJ |  | 2021-11-09 00:00:00 | 09:30:00 | Short | 9 | 200 | 8.5 | 300 | 8 | 500 |  |  |  | 6 | 300 | 5
Spreadsheet: 673064d1587140537-need-some-data-validation-or-formula-templet-custmur-try
Sheet: AB AHAD MIR

 |  |  | AB AHAD MIR |  |  |  |  |  |  | 2019-2020
 |  |  |  |  |  |  |  | KHATA.NO | BALANCE
 |  |  | TEMPLET
 |  |  | [NAME]
 | KH.NO | DATE | REFF | N0 | BILL AMOUNT | RECEIVED AMOUNT | MODE | NO/DATE | BALANCE | NOTE
 | Opening Balance | 2020-04-01 00:00:00 |  |  |  |  |  |  | 0
 |  |  | Recp.no |  | 100
 |  |  | Bill.no |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Active
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Defaulter
Spreadsheet: lindy_donoho__22110__Lindypricing
Sheet: Socal-Avg

Eff 09/26 | Nymex |  | Permian |  | Cash |  |  | Nymex |  | San Juan |  | Cash |  |  | Nymex |  | Socal |  | Cash
2001-11-01 00:00:00 | 2.268 |  | -0.18 |  |  |  |  |  |  | -0.3 |  |  |  |  |  |  | -0.04
2001-12-01 00:00:00 | 2.66 |  | -0.175 |  |  |  |  |  |  | -0.235 |  |  |  |  |  |  | -0.01
Cal 2001
2002-01-01 00:00:00 | 2.878 |  | -0.175 |  |  |  |  |  |  | -0.22 |  |  |  |  |  |  | -0.01
2002-02-01 00:00:00 | 2.876 |  | -0.165 |  |  |  |  |  |  | -0.22 |  |  |  |  |  |  | -0.01
2002-03-01 00:00:00 | 2.837 |  | -0.15 |  |  |  |  |  |  | -0.2725 |  |  |  |  |  |  | -0.01
2002-04-01 00:00:00 | 2.754 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-05-01 00:00:00 | 2.782 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-06-01 00:00:00 | 2.83 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-07-01 00:00:00 | 2.875 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-08-01 00:00:00 | 2.912 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-09-01 00:00:00 | 2.911 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-10-01 00:00:00 | 2.936 |  | -0.13 |  |  |  |  |  |  | -0.36 |  |  |  |  |  |  | 0.08
2002-11-01 00:00:00 | 3.126 |  | -0.13 |  |  |  |  |  |  | -0.2 |  |  |  |  |  |  | 0.08
2002-12-01 00:00:00 | 3.336 |  | -0.13 |  |  |  |  |  |  | -0.2 |  |  |  |  |  |  | 0.08
Cal 2002
2001-01-01 00:00:00 | 16.39
2001-02-01 00:00:00 | 12.51
2001-03-01 00:00:00 | 12.53
Apr-01 | 12.51
May-01 | 14.97
[NAME] | 11.71
Jul-01 | 4.76
Aug-01 | 3.75
Sep-01 | 2.66
Spreadsheet: 870226d1716782185-need-help-in-tranposing-table-exam-results-aligw
Sheet: Sheet1

 |  |  |  |  | English Language - EXP |  |  | Chinese Language - EXP |  |  | Mathematics - EXP |  |  | Science - EXP
 |  |  |  |  | % | Grade | highest | % | Grade | highest | % | Grade | highest | % | Grade | highest
 |  |  |  |  | 67 | B3 | 88 | 55 | D7 | 99 | 80 | A1 | 97 | 54 | C6 | 93
 |  |  |  | % | Highest
 |  |  | English | 67 | 88
 |  |  | Chinese | 55 | 99
 |  |  | Mathematics | 80 | 97
 |  |  | Science | 54 | 93
Spreadsheet: 830766d1685089767-return-the-last-value-livro8
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 1000 | 850 | 500 | 1100 | 1200 | 1500 | 1550 | 1350 | 1450 | 1200 | 1150 | 1450
 |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 150 | 250 | 300
 |  |  |  |  |  |  |  |  |  | LOOKUP(25^25;K14:V14,K11:V11)
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 14b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia |  | <100 | 343
 | Europe |  |  | 153760
 | North America | 17653 | 139038 | 1979
Index | Asia | 555 | 8204 | 12356
 | Europe |  |  | 381260
 | North America | 89555 | 367311 | 57924
TOTAL |  | 107762 | 514553 | 607622
Estimated net notional amount outstanding, January 4 weekly snapshot, by product type and grade (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type  as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 78246d1278622953-average-vlookup-book1
Sheet: Sheet1

Customer | Date | Serial Number | Hours
[NAME] | 2010-01-02 00:00:00 | 1234 | 30
[NAME] | 2010-01-03 00:00:00 | 1111 | 60
[NAME] | 2010-01-04 00:00:00 | 2222 | 90
[NAME] | 2010-02-04 00:00:00 | 3333 | 40
[NAME] | 2010-02-05 00:00:00 | 4444 | 80
[NAME] | 2010-02-06 00:00:00 | 4321 | 20
Spreadsheet: 155072d1336662190-x-axis-probklem-in-simple-line-charts-export-m
Sheet: MALAYSIA

MALAYSIA
 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 4750
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5250
%  Total Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.005
% Export Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.008
 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004
[NAME] | 6750 | 9900
[NAME] |  |  | 9500 | 4260 | 4750
DRS Casting |  |  | 2100 |  | 2100
Yeap Electronics |  |  |  |  | 4000 |  |  |  |  |  |  |  | 14400
Total | 6750 | 9900 | 11600 | 4260 | 10850 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14400 | 0
%  Total Sales | 0.007 | 0.009 | 0.008 | 0.004 | 0.008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.009799371479201515 | 0
% Export Sales | 0.01 | 0.014 | 0.012 | 0.006 | 0.012 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.007333879979016955 | 0
 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018
[NAME]
[NAME]
DRS Casting
Yeap Electronics
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
%  Total Sales | 0 | 0 |  |  | 0 | 0
% Export Sales | 0 | 0 |  |  | 0 | 0
Chart data
77 | 0
78 | 0
79 | 0
80 | 0
81 | 0
82 | 0
83 | 0
84 | 0
85 | 0
86 | 0
87 | 0
88 | 0
89 | 0
90 | 5250
91 | 6750
92 | 9900
93 | 11600
94 | 4260
95 | 10850
96 | 0
97 | 0
98 | 0
99 | 0
0 | 0
1 | 0
2 | 0
3 | 14400
4 | 0
05 | 0
06 | 0
07 | 0
08 | 0
09 | 0
10 | 0
11 | 0
12 | 0
13 | 0
14 | 0
15 | 0
16 | 0
17 | 0
18 | 0
Spreadsheet: 82269d1282255656-finding-min-and-max-date-from-list-example
Sheet: Sheet1

 | A | 2010-06-28 00:00:00
 | C | 2010-08-07 00:00:00 |  |  | Min | [NAME]
 | B | 2010-03-10 00:00:00 |  | A | 0 | 2010-06-30 00:00:00
 | B | 2010-03-12 00:00:00 |  | B | 0 | 2010-12-18 00:00:00
 | C | 2010-09-06 00:00:00 |  | C | 0 | 2010-12-04 00:00:00
 | A | 2010-01-02 00:00:00
 | A | 2010-06-30 00:00:00
 | A | 2010-06-17 00:00:00
 | C | 2010-05-16 00:00:00
 | A | 2010-05-11 00:00:00
 | C | 2010-08-18 00:00:00
 | B | 2010-12-18 00:00:00
 | A | 2010-05-05 00:00:00
 | C | 2010-04-27 00:00:00
 | B | 2010-10-03 00:00:00
 | C | 2010-12-04 00:00:00
 | B | 2010-06-14 00:00:00
 | B | 2010-06-10 00:00:00
Spreadsheet: 56303988-b96b-416b-838c-7c7639ec930b
Sheet: Page 4

Permit No.: |  |  | WQ0028552 |  |  | Facility Name: |  | Briar Chapel Development |  |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | B-8D |  | Field Name: |  | B-8E |  | Field Name: |  | B-9A |  | Field Name: |  | B-9C
 |  |  |  |  |  | Area (acres): |  | 0.7 |  | Area (acres): |  | 0.5 |  | Area (acres): |  | 1.1 |  | Area (acres): |  | 0.4
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 37.31
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 176477d1345881120-how-to-get-sum-of-different-criterias-in-one-cell-sample-sheet
Sheet: Sheet1

Invoice | source code | material | sales area | Qty
1 | ABC | ERASER | pune | 10
2 | XYZ | PENCIL | nashik | 10
3 | XYZ | PEN | pune | 10
4 | ABC | RULER | dhule | 10
5 | XYZ | PEN | satara | 10
6 | XYZ | SCALE | nashik | 10
7 | ABC | PENCIL | pune | 10
8 | XYZ | PEN | satara | 10
 | If, I put invice or source code or material or sales area in cell B14 total should come in D14
 | please help its very important
Spreadsheet: 145154d1331323932-excel-2007-sumif-index-match-formula-bop-inventory-composition
Sheet: Men's Fashion

Men's Fashion BOP & Sales Season Code Composition
 | OH Units |  |  |  |  |  |  | Sales Units |  |  |  |  |  |  | WOS |  |  |  |  | AUR |  |  |  | AUC |  |  |  | $ [NAME] |  |  |  | cost $
Delivery | Tot OH Units | % To Total | Reg OH Units | % of [NAME] | Mkdn OH Units | % of [NAME] |  | Tot Sales Units | % To Total | Reg Sales Units | % of [NAME] | Mkdn Sales Units | % of [NAME] |  | Total | Reg | Mark |  | Total | Reg | Mark |  | Total | Reg | Mark |  | TOT | REG | MKD |  | TOT | REG | MKD
SUMMER 1 2011
SUMMER 2 2011
SUMMER 3 2011
TOTAL SUMMER
FALL 1 2011
FALL 2 2011
FALL 3 2011
TOTAL FALL
HOLIDAY 1 2011
HOLIDAY 2 2011
HOLIDAY 3 2011
TOTAL HOLIDAY
SPRING 1 2012
SPRING 2 2012
SPRING 3 2012
TOTAL SPRING 2012
SPRING 2011 & PRIOR
REPLENISHMENT
Grand Total
Spreadsheet: 700279d1603110208-want-to-count-information-in-visable-rows-after-sorting-sample_v3
Sheet: Sheet1

Date | ID# | A | B |  |  | All Unique Dates | Total IDs per date | Total with exclusions | [NAME] of 5 results |  | Exclusions |  | Date | ID# | A | B
2020-01-02 00:00:00 | 1 | 54.93373277057719 | 92.02226197073493
2020-01-02 00:00:00 | 19 | 33.1139939273851 | 79.38926810798753
2020-01-02 00:00:00 | 114 | 54.93373277057719 | 92.02226197073493
2020-01-03 00:00:00 | 1 | 91.73707046839166 | 84.7279771012649
2020-01-03 00:00:00 | 1 | 74.0536733691448 | 73.93934655638779
2020-01-03 00:00:00 | 22 | 69.71853925925922 | 19.7674303677732
2020-01-03 00:00:00 | 13 | 62.26212343952185 | 19.7674303677732
2020-01-03 00:00:00 | 9 | 74.68821686565968 | 10.61938992866364
2020-01-03 00:00:00 | 67 | 48.12849630647683 | 12.71923258434659
2020-01-03 00:00:00 | 81 | 80.30474947006205 | 96.77425598339097
2020-01-03 00:00:00 | 93 | 28.53380158033362 | 100
2020-01-03 00:00:00 | 166 | 32.83582967515364 | 23.99451095624278
2020-01-06 00:00:00 | 7 | 54.63427280498227 | 36.34258522483628
2020-01-06 00:00:00 | 1 | 43.32179238754325 | 34.88373985937797
2020-01-06 00:00:00 | 67 | 70.95862706273718 | 37.10188488883521
2020-01-06 00:00:00 | 1 | 46.20024050660548 | 36.34258522483628
2020-01-06 00:00:00 | 22 | 64.46985562054448 | 36.34258522483628
2020-01-06 00:00:00 | 19 | 45.25993537768078 | 34.88373985937797
2020-01-06 00:00:00 | 1 | 60.50488235634471 | 38.84700265173237
2020-01-06 00:00:00 | 1 | 47.39461065573768 | 42.78079070032325
2020-01-06 00:00:00 | 120 | 35.82320969447344 | 41.79511711651109
2020-01-06 00:00:00 | 126 | 35.2835341778997 | 37.59687984496127
2020-01-06 00:00:00 | 133 | 82.63612871952294 | 27.27274070247464
2020-01-07 00:00:00 | 14 | 47.76728594820836 | 41.79511711651109
2020-01-07 00:00:00 | 1 | 65.65962786670258 | 27.27274070247464
2020-01-07 00:00:00 | 17 | 73.72701929840541 | 36.34258522483628
2020-01-07 00:00:00 | 1 | 50.01643279712235 | 34.88373985937797
Spreadsheet: 73586d1274219871-staff-rota-date-and-day-calculation-rotadate3
Sheet: Dates

Month | Year
12 | 2010 | Change A2 & B2 to change dates from A5 onwards