tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lynn_blair__24477__packstat01
Sheet: Mar01

COMMENTS | Plan Status Code | packet # | CUST | REGION | POI | CONTRACT # | TRANS TYPE | DEAL TYPE | ACCT MGR | DEAL MONTH | DEAL DATE | INJ/WD | PROD MTH | PROJ MTH TOTAL | PACKET BALANCE AS OF 3/22/01 | Days Remaining | Approx Daily Volume Required to Balance Contract (may require rounding adj)
 | MTM | 107525 | Aquila Energy Marketing Corporation | SOUTH | 62389 | 21230 | BACK | MB | Branney | 2001-01-01 00:00:00 | 2001-01-31 00:00:00 | w | 2001-02-01 00:00:00 | -38000
 | MTM | 107525 | Aquila Energy Marketing Corporation | SOUTH | 62389 | 21230 | BACK | MB | Branney | 2001-01-01 00:00:00 | 2001-01-31 00:00:00 | i | 2001-03-01 00:00:00 | 38000 | 38006
 |  | 107525 Total
 | Traditional | 106432 | Dynegy Gas Transportation | SOUTH | 71460 | 21357 | BACK | MB | Gottsponer | 2000-03-01 00:00:00 | 2000-03-15 00:00:00 | w | 2000-11-01 00:00:00 | -500996
 |  | 106432 | Dynegy Gas Transportation | SOUTH | 71460 | 21357 | BACK | MB | Gottsponer | 2000-03-01 00:00:00 | 2000-03-15 00:00:00 | i | 2001-02-01 00:00:00 | 464393
 |  | 106432 | Dynegy Gas Transportation | SOUTH | 71460 | 21357 | BACK | MB | Gottsponer | 2000-03-01 00:00:00 | 2000-03-15 00:00:00 | i | 2001-03-01 00:00:00 | 36603 | 36603
 |  | 106432 Total
 | MTM | 107529 | Tenaska Gas Storage, LLC | SOUTH | 62389 | 21229 | BACK | MB | Branney | 2001-02-01 00:00:00 | 2001-02-01 00:00:00 | w | 2001-02-01 00:00:00 | -20000
 | Incremental Seasonal Pkg | 107529 | Tenaska Gas Storage, LLC | SOUTH | 62389 | 21229 | BACK | MB | Branney | 2001-02-01 00:00:00 | 2001-02-01 00:00:00 | i | 2001-03-01 00:00:00 | 20000 | 20000
 |  | 107529 Total
 | Incremental Seasonal Pkg | 107530 | Williams Energy Marketing & Trading Co. | SOUTH | 62389 | 100648 | BACK | MB | Branney | 2001-02-01 00:00:00 | 2001-02-01 00:00:00 | w | 2001-02-01 00:00:00 | -40819
 | Incremental Seasonal Pkg | 107530 | Williams Energy Marketing & Trading Co. | SOUTH | 62389 | 100648 | BACK | MB | Branney | 2001-02-01 00:00:00 | 2001-02-01 00:00:00 | i | 2001-03-01 00:00:00 | 40819 | 40827
 |  | 107530 Total
 |  | Grand Total
 | Traditional
 | MTM
 | MTM
 | MTM
 | Traditional
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | MTM
 | Traditional
 | Traditional
 | Traditional
 | Traditional
Customer has option to change withdrawal month from dec to nov 2000 if they notify us no later than 10/27/00 | Traditional
Customer has option to change withdrawal month from dec to nov 2000 if they notify us no later than 10/27/03 | Traditional
 | Traditional
Spreadsheet: 88306d1288174646-multi-lookup-multi-lookup
Sheet: Data

LINE 1
Day | 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 | Cum
Total Day
Time run
Breakdown
Output
Manufacturing Order 1
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 2
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 3
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 4
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 5
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 6
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 7
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 8
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 9
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Manufacturing Order 10
Time run | 1 | 1 | 1 | 1 | 1
Breakdown | 0.25 | 0.5 | 0 | 0.25 | 0.75
Output | 1000 | 750 | 1500 | 1250 | 250
Spreadsheet: 663097fc-f751-455d-a3b1-2f24226e4ac9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
IMAX | Test | IMAX | Interpretation of Outside Muscle Biopsy Slide | Interpretation Muscle Slide Maximum |  | Varies: Var |  |  |  | Varies | These will be read out like a surgical consult. Therefore, a letter from the referring pathologist describing his findings along with any pertinent history and suspected diagnosis, is needed. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Interpretive report |  |  | 7 days | 1 | 88325 |  |  |  |  | Rochester
IMAX | [NAME] | TISSUE | Tissue |  |  |  | Ambient
IMAX | Result | IMAX | Interpretation Muscle Slide Maximum | Interpretation Muscle Slide Maximum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 105737d1303006897-using-controls-or-index-i-think-help-please-testing
Sheet: MID

 | mid
Ticker | $ Holdings | Rank | % Growth | Sector
XEC | 3430480 | 294 | 1 | Energy
NBL | 3140711 | 170 | 0 | Energy
DOV | 2995014 | 240 | 0.6276858595913196 | [NAME]
ORI | 2719688 | 695 | 0 | Financial Services
CAG | 2677991 | 274 | 0.0969678393220635 | Consumer Staples
FRX | 2351268 | 316 | 0 | Health Care
AGO | 2345142 | 800 | 0 | Financial Services
ENR | 2099130 | 508 | 0 | Consumer Staples
DNR | 2077674 | 292 | 0 | Energy
FLO | 2035432 | 988 | 0.3788237093637217 | Consumer Staples
Spreadsheet: 599755d1543298519-calculate-customer-outstanding-amounts-for-a-given-date-book1
Sheet: Sheet1

 | Name | Product | Date of Purchase | Total Value | PKR | Installment No. 1 | Installment No. 2 | Installment No. 3 | Installment No. 4 |  | Receivable Due Till Date |  | Receivable Due Till Date
 |  |  |  |  | Date |  |  |  |  |  |  |  | Need a formula at this cell so that when an installment become due, it automatically show it here against it customer.
 | [NAME] | 201 | 2018-10-03 00:00:00 | 45000 | Amount |  |  |  |  |  | 4500
 |  |  |  |  | Date
 | NISAR MUHAMMAD [NAME] | 206 | 2018-11-13 00:00:00 | 65000 | Amount |  |  |  |  |  | 0
 |  |  |  |  | Date
 | [NAME] | 207 | 2018-09-01 00:00:00 | 45000 | Amount
 |  |  |  |  | Date
 | [NAME] | 209 | 2018-10-15 00:00:00 | 50000 | Amount |  |  |  |  |  | 5000
 |  |  |  |  | Date
 | [NAME] | 201 | 2018-11-16 00:00:00 | 46950 | Amount |  |  |  |  |  | 4695
 |  |  |  |  | Date
 | Umer Farooq | 209 | 2018-11-08 00:00:00 | 65500 | Amount |  |  |  |  |  | 0
Spreadsheet: 115447d1311066349-budget-calc-help-2011budget
Sheet: April

2011 Budget
Payday |  |  |  |  | Amount
1st |  |  |  |  | 0
15th
Total Monthly
Expenses |  | Product |  |  | Amount |  | Paid? | Remainder
1st |  | Ring |  |  | 100 |  | False
 |  | Easynews |  |  | 15 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Verizon |  |  | 100 |  | False
 |  | Bi-Weekly Remainder
15th |  | Chase |  |  | 54 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Insurance |  |  | 120 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Bi-Weekly Remainder
Total Monthly
Total Remainder
Spreadsheet: 867678d1714485260-i-am-trying-to-pull-data-from-a-cell-based-on-another-cells-value-beginner-help-forum-test
Sheet: MHC - Paste Sheet

OUTLET | TEXT | START TIME | TOWN | MINUTES DW / TIPPING | [NAME] | TEXT3 | RETURN TIME | REG | PASTE BOX
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
Spreadsheet: 0a7a64cc-7b56-4535-abcb-b9a8a0b85277
Sheet: Sheet1

[NAME] (2-) | 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
 |  |  |  |  |  |  |  |  |  |  |  |  | (1)
 |  |  |  |  |  |  |  |  |  |  |  |  | (2) ASPON
 |  |  |  |  |  |  |  |  |  |  |  |  | (3)
 |  |  |  |  |  |  |  |  |  |  |  |  | (4)
 |  |  |  |  |  |  |  |  |  |  |  |  | (5)
 |  |  |  |  |  |  |  |  |  |  |  |  | (6)
 |  |  |  |  |  |  |  |  |  |  |  |  | (7)
 |  |  |  |  |  |  |  |  |  |  |  |  | (8)
 |  |  |  |  |  |  |  |  |  |  |  |  | (9)
 |  |  |  |  |  |  |  |  |  |  |  |  | (10)
 |  |  |  |  |  |  |  |  |  |  |  |  | (11)
 |  |  |  |  |  |  |  |  |  |  |  |  | (12)
 |  |  |  |  |  |  |  |  |  |  |  |  | (13)
 |  |  |  |  |  |  |  |  |  |  |  |  | (14)
 |  |  |  |  |  |  |  |  |  |  |  |  | (15)
 |  |  |  |  |  |  |  |  |  |  |  |  | (16)
 |  |  |  |  |  |  |  |  |  |  |  |  | (17)
 |  |  |  |  |  |  |  |  |  |  |  |  | (18)
 |  |  |  |  |  |  |  |  |  |  |  |  | (19)
 |  |  |  |  |  |  |  |  |  |  |  |  | Ethyl Guthion
 |  |  |  |  |  |  |  |  |  |  |  |  | (20)
 |  |  |  |  |  |  |  |  |  |  |  |  | (21)
 |  |  |  |  |  |  |  |  |  |  |  |  | (22)
 |  |  |  |  |  |  |  |  |  |  |  |  | (23)
 |  |  |  |  |  |  |  |  |  |  |  |  | (24)
 |  |  |  |  |  |  |  |  |  |  |  |  | FONOFOS
 |  |  |  |  |  |  |  |  |  |  |  |  | (25)
 |  |  |  |  |  |  |  |  |  |  |  |  | (26)
 |  |  |  |  |  |  |  |  |  |  |  |  | IMIDAN
 |  |  |  |  |  |  |  |  |  |  |  |  | (27)
 |  |  |  |  |  |  |  |  |  |  |  |  | LEPTOPHOS
 |  |  |  |  |  |  |  |  |  |  |  |  | (28)
 |  |  |  |  |  |  |  |  |  |  |  |  | MALATHION
 |  |  |  |  |  |  |  |  |  |  |  |  | (29)
Spreadsheet: 762341d1641503735-look-at-row-indicate-70-of-values-are-the-same-example7
Sheet: Sheet1

Full | Last | First | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-11-05 00:00:00 | 2022-11-06 00:00:00 | 2022-11-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-09 00:00:00 | 2022-11-10 00:00:00 | 2022-11-11 00:00:00 | 2022-11-12 00:00:00 | 2022-11-13 00:00:00 | 2022-11-14 00:00:00 | 2022-11-15 00:00:00 | 2022-11-16 00:00:00 | 2022-11-17 00:00:00 | 2022-11-18 00:00:00 | 2022-11-19 00:00:00 | 2022-11-20 00:00:00 | 2022-11-21 00:00:00 | 2022-11-22 00:00:00 | 2022-11-23 00:00:00 | 2022-11-24 00:00:00 | 2022-11-25 00:00:00 | 2022-11-26 00:00:00 | 2022-11-27 00:00:00 | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | [NAME] | >70% 0f value in row =8 return Yes
 | Doe | [NAME] | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 6 | 8 |  |  | 8 | 8 | 8 | 4 | 8 |  |  | 8 | 8
 | Dog | [NAME] | 8 | 8.1 | 8.2 | 8.5 | 8 |  |  | 8 | 8.1 | 8.2 | 8.5 | 8 |  |  | 8 | 8.1 | 8.2 | 8.5 | 8 |  |  | 8 | 8.1 | 8.2 | 8.5 | 8 |  |  | 8.2 | 8
 | Cat | [NAME] | 8 | 8 | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 | 6 | 8 | 8.5 |  | 8 | 8 | 8 | 4 | 8 |  |  | 8 | 8
Spreadsheet: 35069d1232573369-table-searching-problems-book1a
Sheet: Sheet6

[NAME] double and triple pinch pleat or goblet
Widths per Pair |  |  | (2w) | (4w) | (6w) | (8w) | (10w)
 |  |  | 1 | 2 | 3 | 4 | 5
upto 125cm |  |  | 41.21 | 73.29 | 100.54 | 129.31 | 167.79
126cm to 200cm |  |  | 47.41 | 84.26 | 115.55 | 148.73 | 192.99
201cm to 400cm |  |  | 53.97 | 95.81 | 133.77 | 171.68 | 223.91
401cm and over |  |  | 62.21 | 108.94 | 151.94 | 199.66 | 256.67
Spreadsheet: 750115d1633277919-help-with-formulas-that-will-populate-a-quick-view-of-household-bills-and-payments-rent
Sheet: Monthly Family Budget

 | 2021 Monthly Rent/Utilities
 | Summary | Total Monthly  Cost | Total Actually Paid | Total Remaining Balance
 |  | 505
 | Housing
 | Housing | Rent | Utilities | Total | Payments | Balance |  | Monthly Charges
 | 2021-01-01 00:00:00 |  |  |  |  |  |  | Lot Rent | 295
 |  |  |  |  |  |  |  | Electric | 135
 | 2021-02-01 00:00:00 |  |  |  |  |  |  | Gas | 75
 |  |  |  |  |  |  |  | Total monthly
 | 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
 | 2021-09-01 00:00:00
 | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
 | Total
 | Payments
 | Month | Date | Cash/Check No. | Amount | Total Amount
 | Jan
 | Feb
 | March
 | April
 | may
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 |  |  | TOTAL
Spreadsheet: 71270d1271951509-if-then-if-then-example
Sheet: Sheet1

 | Inspector |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Certification #: |  |  |  |  | 21-10282
 |  |  |  |  | INSPECTORS |  |  |  |  |  |  |  |  |  |  |  |  |  | Certification #
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-10282
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | L-17-9010
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | K-450-0006
 | Inspector / Tester |  |  |  |  |  |  |  | Signed |  |  |  |  |  |  |  |  |  | AWWA Certification #
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-10282
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L-17-9010
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K-450-0006
Spreadsheet: 847562d1698420428-bulk-substitute-in-a-spilling-array-bulk-substitute
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array)
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty |  |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty |  |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty |  |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty |  |  | ID:aze|Size:32|Label:rty
Spreadsheet: 293c27c0-7771-451f-87d9-1104393fa716
Sheet: Total

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
US Total | this year | last year | this year | last year | this year | last year
Spreadsheet: 158742d1338384741-excel-2007-help-with-sorting-numbers-and-text-sorting
Sheet: Sheet1

list | helper
101 | 101 | enter formula =TEXT(A2,0)   in b2 and fill down
102 | 102
103 | 103
104 | 104
105 | 105
106 | 106
102A | 102A
102B | 102B
102C | 102C
105A | 105A
105B | 105B
now select a and b then sort by helper column either ascending or decending your choice column
list | helper
101 | 101
102 | 102
103 | 103
104 | 104
105 | 105
106 | 106
102A | 102A
102B | 102B
102C | 102C
105A | 105A
105B | 105B
list | helper
101 | 101
102 | 102
102A | 102A | <<<<< | result
102B | 102B |  | you can now delete col b
102C | 102C
103 | 103
104 | 104
105 | 105
105A | 105A
105B | 105B
106 | 106
Spreadsheet: 801823d1666388939-consolidation-of-data-from-multiple-sheets-with-different-headers-excel-sample
Sheet: Project 2

DEVELOPMENT PROFORMA
Offset Reference | 10
Period | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Year 13 | Year 14 |  | 1
Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00
Year | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 683076d1592475953-counting-weekends-that-have-off-test1
Sheet: Sheet1

 |  |  |  | 2019-12-30 00:00:00
 |  | Employee | W1 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | W3 |  |  |  |  |  |  |  | W4 |  |  |  |  |  |  |  | W5
 |  | 1 |  |  | OFF | OFF |  |  |  |  |  |  | OFF | OFF |  |  |  |  |  | OFF |  |  |  | OFF |  |  |  |  |  |  |  |  | OFF | OFF |  |  |  |  |  |  | OFF | OFF
 |  | 2 |  |  | OFF | OFF |  |  |  |  |  |  | OFF |  | OFF |  |  |  |  |  | OFF |  |  |  |  |  |  | OFF |  |  |  |  | OFF | OFF |  |  |  |  |  |  | OFF | OFF
 |  | 3 |  | OFF | OFF | OFF |  |  |  |  |  |  | OFF |  |  |  |  |  |  | OFF |  |  |  |  | OFF | OFF |  |  |  |  |  |  | OFF |  |  |  |  |  | OFF | OFF
 |  | 4 |  |  | OFF | OFF |  |  |  |  |  |  | OFF |  |  | OFF |  |  |  |  |  |  | OFF | OFF |  |  |  |  |  |  |  |  | OFF | OFF |  |  |  |  |  |  | OFF | OFF
 |  | 5 |  |  |  |  |  |  |  | OFF |  | OFF |  |  | OFF |  |  |  |  |  |  | OFF | OFF |  |  |  |  |  |  |  |  |  |  | OFF |  |  |  |  |  |  | OFF | OFF
 |  | 6 |  | OFF |  |  |  |  |  | OFF |  | OFF |  |  |  |  |  | OFF |  |  |  |  |  |  | OFF | OFF |  |  |  | OFF |  |  |  | OFF |  | OFF |  |  |  |  | OFF | OFF
Spreadsheet: 858835d1707363403-multiple-if-condition-based-on-date-today-datestatus
Sheet: Sheet1

 | Example Today Date is | 2023-03-28 00:00:00
 | Planning Date | Advertisment Date | Date Selling (Start) | Actual Closing Date | Status
 | 2023-02-12 00:00:00 |  |  |  | Planning
 |  | 2023-02-15 00:00:00 |  |  | Advertisement
 |  | 2023-03-25 00:00:00 | 2023-03-01 00:00:00 | 2023-03-30 00:00:00 | Selling
 |  | 2023-01-27 00:00:00 | 2023-02-02 00:00:00 | 2023-03-03 00:00:00 | Closing
Spreadsheet: 851232d1701451897-applying-predetermined-formatting-logic-to-a-downloaded-table-procurement-template
Sheet: Sheet1

Spec Section Number | Title | Responsible Contractor | Planned Submit By Date | Received Date | Distributed Date | Lead Time | Required On Site Date | Ball In Court | Status
123456789 | Axle | Axle Co | 2023-12-01 00:00:00 | 2023-11-25 00:00:00 | 2023-12-03 00:00:00 | 20 | 2024-02-04 00:00:00 | Axle Co | Open
1234 | [NAME] | [NAME] | 2023-11-05 00:00:00 | 2023-10-05 00:00:00 | 2023-10-06 00:00:00 | 10 | 2023-12-31 00:00:00 |  | Closed
987654 | Trees | Fern Co | 2024-02-04 00:00:00 |  |  |  |  |  | Open
***Highlighted YELLOW cells need formatting/logic*** |  |  | Column D formats cells to red/green to show if the Planned Submit By [NAME] is less than or equal to TODAY() | Column E: Red if greater than D2, green if less than D2 | Column F: Red if greater than D2, green if less than D2 | Simply spits out what the database finds online | Column H: Red if F2 + G2 > H2 Green if F2 +G2 <= H2 | Status simply spits out what the database finds online | Status simply spits out what the database finds online
Spreadsheet: 883620d1732253308-filtering-a-list-down-to-display-only-items-with-annual-due-dates-matching-current-month-sample-annualfees
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ITEM |  | Annual payment | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0 | 2024-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 5 | 2024-12-03 00:00:00 |  |  | formula in T column =CHOOSECOLS(FILTER(Items!$B$5:$H$49,(Items!$C$5:$C$49=Items!$J$11)*(Items!$H$5:$H$49>0),""),1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | item6 |  | 0 | 2024-12-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | item8 |  | 0 | 2024-11-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | item11 |  | 0 | 2024-11-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | item13 |  | 0 | 2024-11-28 00:00:00 |  |  | formula in V column =[NAME]))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The table referenced in AA71:AB85 is used to sort my items. I'm trying to get away from this and use more Filter functions. I'd like to eliminate this table. formula in W column =IF($T6="","",EDATE(TODAY()-DAY(TODAY())+(VLOOKUP($T6,Items!$AA$71:$AB$85,2,0)),--(DAY(TODAY())>(VLOOKUP($T6,Items!$AA$71:$AB$85,2,0)))))
Spreadsheet: 107632d1304761274-lookup-function-mixed-with-sumif-month-x-product
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Product1
Product2
Spreadsheet: 85775d1285807332-multiple-pivot-table-filters-example-attached-example-ss
Sheet: Financials

 | EURO | USD
Client | ABC Deal - 5.6% | [NAME]
[NAME] | 35000000 | 15000000
[NAME] | 0 | 120000000
XYZ Investors | 45000000 | 100000000
… | … | …
… | … | …
Spreadsheet: 214033d1360778711-populating-1st-and-2nd-highest-occurence-of-an-instance-per-category-book-1-sample
Sheet: Data Entry & Parameters

Data Entry Table |  |  |  | Teams |  |  |  |  |  | Infraction Type
Infraction | Team | Name |  | Retail_FL_Orlando | [NAME] | Retail_CA_Sacramento | [NAME] | Retail_CA_Oakland |  | Type
Late to work | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | Late to Work
No lunch taken | Retail_FL_Orlando | [NAME] |  | [NAME] | [NAME] | [NAME] |  | Nate Tims |  | No lunch taken
Complaint-Communication | [NAME] | [NAME] |  | [NAME] | [NAME] |  |  | Shania Tims |  | Complaint-Communication
Complaint-Ethical Conduct | Retail_CA_Sacramento | [NAME] |  |  | [NAME] |  |  |  |  | Complaint-Attire Violation
Complaint-Attire Violation | Retail_FL_Orlando | [NAME] |  |  |  |  |  |  |  | Complaint-Ethical Conduct
Late to Work | Retail_FL_Orlando | [NAME]
No lunch taken | [NAME] | [NAME]
Complaint-Attire Violation | Retail_CA_Oakland | Shania Tims