tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834334d1687687150-sum-values-where-account-numbers-before-are-the-same-s666-pq-sum-values-ignoring-items-after-sslash
Sheet: Sheet1

Val | Acc |  |  |  |  |  |  | 0999/000 |  |  | TBD | Sum
-78895.03 | 1000/000 |  |  |  |  |  |  | 1000/000 |  |  | 1000 | -78895.03
-66350 | 1100/000 |  |  |  |  |  |  | 1100/000 |  |  | 1100 | -66350
-19380 | 1200/000 |  |  |  |  |  |  | 1200/000 |  |  | 1200 | -19380
-1500 | 1300/000 |  |  |  |  |  |  | 1300/000 |  |  | 1300 | -1500
-7130 | 1500/000 |  |  |  |  |  |  | 1400/000 |  |  | 1500 | -7130
 | 2750/000 |  |  |  |  |  |  | 1500/000 |  |  | 2750
0 | 2750/001 |  |  |  |  |  |  | 1900/000 |  |  | 2760 | -85090.41
-30869.03 | 2750/006 |  |  |  |  |  |  | 2000/000 |  |  | 2770 | 0
-85090.41 | 2760/000 |  |  |  |  |  |  | 2750/000 |  |  | 3000
0 | 2770/000 |  |  |  |  |  |  | 2760/000 |  |  | 3010 | 48400
 | 3000/000 |  |  |  |  |  |  | 2750/002 |  |  | 3100 | 6050
3000 | 3000/002 |  |  |  |  |  |  | 2770/000 |  |  | 3200 | 1677
48400 | 3010/000 |  |  |  |  |  |  | 2750/006
6050 | 3100/000 |  |  |  |  |  |  | 2760/000
1677 | 3200/000
Spreadsheet: 681025d1591301475-grouping-continuous-dates-dates-example
Sheet: Sheet1

Tenant | From | To | Tenancy
A | 2011-04-10 00:00:00 | 2011-08-31 00:00:00 |  |  | 2011-04-10 00:00:00 | 2014-08-31 00:00:00
A | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 2015-09-01 00:00:00 | 2015-12-20 00:00:00
A | 2012-09-01 00:00:00 | 2013-06-30 00:00:00 |  |  | 2016-09-01 00:00:00 | 2017-08-31 00:00:00
A | 2013-07-01 00:00:00 | 2013-08-31 00:00:00 |  |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00
A | 2013-09-01 00:00:00 | 2014-08-31 00:00:00
A | 2015-09-01 00:00:00 | 2015-12-20 00:00:00
B | 2016-09-01 00:00:00 | 2017-08-31 00:00:00
C | 2020-09-01 00:00:00 | 2021-08-31 00:00:00
C | 2019-09-01 00:00:00 | 2020-08-31 00:00:00
B | 2017-09-01 00:00:00 | 2019-08-31 00:00:00
Spreadsheet: 880453d1728236329-how-to-get-results-in-minutes-cell-n-at-glance-from-sheet-1-to-sheet-2-ef1653_forum_test
Sheet: Sheet2

 |  |  | Week
Floor |  |  | NAME
1 |  |  | DOE, [NAME]
 |  |  | DOE, [NAME]
Service |  |  | DOE, [NAME]
All |  |  | FLORIDA, ANA
 |  |  | PARIS, ARTHUR
Week_range |  |  | WASHINGTON, TED
31-42
Spreadsheet: 96967d1296193475-looking-for-advice-to-improve-function-of-workbook-lab-stuff
Sheet: Chemical Usage

Chemical Tracking Log
Acetone |  |  | Ammonium Nitrate |  |  | Distilled Water |  |  | Erythritol |  |  | Hexamine |  |  | Nitric Acid |  |  | Potassium Nitrate |  |  | Sodium Bicarbonate |  |  | Sulfuric Acid |  |  | Ethanol
On Hand (ml) | 0 |  | On Hand (g) | 0 |  | On Hand (ml) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (ml) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (ml) | 0 |  | On Hand (ml) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0 |  | On Hand (g) | 0
Running Total (ml) |  |  | Running Total (g) |  |  | Running Total (ml) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (ml) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (ml) |  |  | Running Total (ml) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g) |  |  | Running Total (g)
Remaining (ml) |  |  | Remaining (g) |  |  | Remaining (ml) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (ml) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (ml) |  |  | Remaining (ml) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g) |  |  | Remaining (g)
Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining % |  |  | Remaining %
Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used |  | Date | Amount Used
Spreadsheet: 888255d1738744474-check-value-with-date-input-etaf
Sheet: Sheet1

ID | Birthday | Result
1 | 2002-03-20 00:00:00 | Yes | yes
2 | 2003-04-10 00:00:00 | Yes | yes
3 | 1999-10-24 00:00:00 | No | No
4 | 2024-01-01 00:00:00 | Yes | yes
5 | 2002-02-28 00:00:00 | No | No
6 | 2004-07-18 00:00:00 | Yes | yes
Spreadsheet: 864152d1711452982-conditional-formatting-excel-club-query
Sheet: Sheet2

Medications 2 |  |  | updated | 2024-03-26 00:00:00 |  | Date =
Name | Reference | Pack size | Quantity | Backroom | Top up | Total | Total | Grand | Daily | Supply lasts | Supply lasts .. | Earliest "10 day" | Latest operstional | Safety | Alarm
 | Date |  | p pack | Stock | Packs | in | in | Total | Usage | till ..? | Website Reorder | Pre-Order | reorder | Margin
 |  |  |  | Packs | Deliv'd | Backroom | kitchen |  |  |  | Date | Date | Date | days
 |  |  |  |  | 2024-02-15 00:00:00
Compound 1 | 2024-03-26 00:00:00 | 100 x 100 mg | 100 | 0 |  |  | 50 |  | 4 |  | 2023-12-18 00:00:00
Compound 2 | 2024-03-26 00:00:00 | 28 x 10 mg | 28 | 4 |  |  | 6 |  | 5 |  | 2023-12-13 00:00:00
Compound 3 | 2024-03-26 00:00:00 | 28 x 5 mg | 28 | 0 |  |  | 18 |  | 1 |  | 2023-08-10 00:00:00
Compound 4 |  | 4 x 70 mg | 4 | 2 |  |  | 6 |  |  |  | 2023-04-13 00:00:00
Compound 5 | 2024-03-26 00:00:00 | 28 x 15 mg | 28 | 0 |  |  | 28 |  | 2 |  | 2023-08-10 00:00:00
Compound 6 | 2024-03-26 00:00:00 | 28 x 15 mg | 28 | 0 |  |  | 28 |  | 4 |  | 2023-08-10 00:00:00
Compound 7 | 2024-03-26 00:00:00 |  | 28 | 0 |  |  | 16 |  | 1 |  | 2023-09-07 00:00:00
Compound 8 | 2024-03-26 00:00:00 | 28 x 15 mg | 28 | 1 |  |  | 9 |  | 0.5 |  | 2022-12-13 00:00:00
Compound 9 | 2024-03-26 00:00:00 | 30 | 30 | 0 |  |  | 7 |  | 1 |  | 2023-07-29 00:00:00
Compound 10 |  | 10 ml |  | 1 |  |  |  |  |  |  | 2023-08-10 00:00:00
Compound 11 | 2024-03-26 00:00:00 | 28 x 1500 mg | 28 | 2 |  |  | 10 |  | 2 |  | 2023-08-14 00:00:00
Compounf 12 |  |  |  | 1 |  |  |  |  |  |  | 2023-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | OK to re-order | less than | 6.9 | order
Spreadsheet: mike_carson__27560__KOCH01032002
Sheet: Sheet1

 | [NAME] for power delivered 1/3/2002
 | On-Peak
 |  |  | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee | COST | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 100 | 24.5 |  | 1 |  |  |  |  | 26.03
 | TVA | -100 | 26 |  | 1 |  |  |  |  | 31
 | Cinergy | -1050 | 25.24 |  | 1 |  |  |  |  | 30.96
 | Comed | -50 | 25.75 |  | 1 |  |  |  |  | 34.75
 | Off-Peak
 |  |  | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total |  | Existing Positions |  | Net Profit
 |  | Postion | Price |  | Fee |  | Dollars |  | Net Cost/Gain |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 17 |  | 1 |  |  |  |  | 18.25
 | Comed | 0 |  |  | 1
 |  |  |  |  | Grand
 |  |  |  |  | Total | >>>>>>
 |  |  |  |  |  |  | 2002-01-03 00:00:00 |  | Existing |  | Gain for 1/03/2002
Spreadsheet: louise_kitchen__22532__2base329c
Sheet: Financials QTR

Income Statement |  |  | Income Statement |  |  | Income Statement
For the period ending 6/29/00 to | 2001-03-31 00:00:00 |  | For the period ending 6/29/00 to |  |  | to
Option Premiums Earned | 34266411 |  | Option Premiums Earned |  |  | Option Premiums Earned
Permitted Investment Income | 2520990.282677362 |  | Permitted Investment Income |  |  | Permitted Investment Income
Interest Income--Harrier Note | 2673611.111111111 |  | Interest Income--Harrier Note |  |  | Interest Income--Harrier Note
Discount Amortization | 52721889.42307692 |  | Discount Amortization |  |  | Discount Amortization
Discount [NAME] | 389903.2626044569 |  | Discount [NAME] |  |  | Discount [NAME]
Interest Expense | -22398320.25127438 |  | Interest Expense |  |  | Interest Expense
 | 70174484.82819547
[NAME] / (Losses) | 162248387.25 |  | [NAME] / (Losses) |  |  | [NAME] / (Losses)
[NAME] / (Losses) [NAME] | 26767548.33999996 |  | [NAME] / (Losses) [NAME] |  |  | [NAME] / (Losses) [NAME]
Reserve for Shares | -178829673.4583114 |  | Reserve for Shares |  |  | Reserve for Shares
[NAME] / (Losses) Derivative | 0 |  | [NAME] / (Losses) Derivative |  |  | [NAME] / (Losses) Derivative
[NAME] / (Losses) | -41817537.472 |  | [NAME] / (Losses) |  |  | [NAME] / (Losses)
Realized Gains / (Losses) | -11278182.528 |  | Realized Gains / (Losses) |  |  | Realized Gains / (Losses)
 | -42909457.86831141
Net Gain/(Loss) | 27265026.95988406 |  | Net Gain/(Loss) |  |  | Net Gain/(Loss)
Timberwolf Balance Sheet |  |  | Timberwolf Balance Sheet |  |  | Timberwolf Balance Sheet
As of: | 2001-06-30 00:00:00 |  | As of: |  |  | Changes to:
Assets |  |  | Assets |  |  | Assets
Cash/Investment | 37648522.29688895 |  | Cash/Investment |  |  | Cash/Investment
Note due from Enron | 50000000 |  | Note due from Enron |  |  | Note due from Enron
Interest Receivable | 9722.222222222223 |  | Interest Receivable |  |  | Interest Receivable
Enron Shares | 0 |  | Enron Shares |  |  | Enron Shares
[NAME] | 382390207.2620056 |  | [NAME] |  |  | [NAME]
ENE Share Derivative | 118425531 |  | ENE Share Derivative |  |  | March ENE Shares
Collar Receivable | 330578582.59 |  | Collar Receivable |  |  | Collar Receivable
Swap Receivable | 0 |  | Swap Receivable |  |  | Swap Receivable
Total | 919052565.3711166 |  | Total |  |  | Total
Liabilities & Owner's Equity |  |  | Liabilities & Owner's Equity |  |  | Liabilities & Owner's Equity
Option Obligation | 0 |  | Option Obligation |  |  | Option Obligation
Swap Obligation | 41817537.472 |  | Swap Obligation |  |  | Swap Obligation
Collar Obligation | 0 |  | Collar Obligation |  |  | Collar Obligation
Note Due to Enron | 950124200.5789979 |  | Note Due to Enron |  |  | Note Due to Enron
LJMII | 0 |  | LJMII |  |  | LJMII
Enron | -72889172.67988122 |  | Enron |  |  | Enron
Total | 919052565.3711166 |  | Total |  |  | Total
Spreadsheet: 84250d1284276836-vlookup-and-return-all-values-by-matching-2-cells-sample-1-
Sheet: Sheet1

Fruit | Quantity |  | Color
apple | 2 |  | blue
orange | 5 |  | black
banana | 6 |  | green
grape | 3 |  | [NAME]
orange | 5 |  | yellow
plum | 5 |  | white
Lookup fruit | Lookup Quantity
orange | 5 |  |  | I want to get a result of "black, yellow" by matching [NAME] and [NAME].
Spreadsheet: 724846d1616418723-calculating-sales-lift-only-for-cells-based-on-effective-date-pbg-chain-activity-program-template-test
Sheet: TEMPLATE

 | Brand |  | SKU
 | Size |  | CHAIN |  |  |  |  | CHAIN EVENT
 | Event Type |  | Event Length |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
 |  |  |  |  |  |  |  | 4.28571428571428 | 4 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | weeks
 | State | PODs |  | CPSPW |  | EFFECTIVE DATE |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
 | ALABAMA | Current | 100 | Current | 0.5
 |  | Change (+/-) | 50 | Upper | 0.8
 |  | New |  | Lower | 0.4 | APR
 | ALASKA | Current | 100 | Current | 0.2
 |  | Change (+/-) | 50 | Upper | 2
 |  | New |  | Lower | 0.5 | MAY
 | ARIZONA | Current | 100 | Current | 1
 |  | Change (+/-) | 50 | Upper | 3
 |  | New |  | Lower | 1.5 | JUN
 | ARKANSAS | Current | 100 | Current | 0.2
 |  | Change (+/-) | 50 | Upper | 1
 |  | New |  | Lower | 0.5 | JUL
 | CALIFORNIA | Current | 100 | Current | 1
 |  | Change (+/-) | 50 | Upper | 2
 |  | New |  | Lower | 1 | AUG
 | TOTAL | Current |  | Current
 |  | Change (+/-) |  | Upper
 |  | New |  | Lower
Spreadsheet: 768776d1645116254-how-to-count-total-number-of-colors-efproductsum
Sheet: Sheet1

 |  |  |  |  | Color | Type | Quantity |  | Color | SUMTotal
 |  |  |  |  | Red | Shirt | 3 |  | Blue |  | 6
 |  |  |  |  | Green | Pants | 9 |  | Green |  | 10
 |  |  |  |  | Red | Shorts | 14 |  | Red |  | 37
 |  |  |  |  | Red | Hoodies | 20
 |  |  |  |  | Blue | Pants | 6
 |  |  |  |  | Green | Shirts | 1
Spreadsheet: 193518d1352858317-match-and-sort-large-table-match-and-sort
Sheet: Sheet1

 | Name  (From Company X R4 Issue Tracking Sheet) |  | Line Item Matches (Y, N, N/A) |  | Name  Company Z [NAME] |  | Column Match      (or ECO) | Date Ass'd to Company Z Team Member |  | Was [NAME] To |  | Company Z  Issue Status | Initial Held / BFR Req. Date | BFR Type Needed | BFR Description & Feedback Status | Company Z BFR Target Date to Close | BFR Status [NAME] | BFR Resolution Date | ECO Closed Date | Issue Closed Date |  | TAT
 | AA |  |  |  | AB
 | AB |  |  |  | AB
 | AA |  |  |  | AB
 | AB |  |  |  | AB
 |  |  |  |  | AB
 | AB |  |  |  | AA
 | AA |  |  |  | AA
 |  |  |  |  | AA
 | AA |  |  |  | AA
 | AB |  |  |  | AA
Spreadsheet: 111755d1308066524-create-pivot-table-agent-summary1
Sheet: Pivot table

 | Agent Name | Data
 | Agent 1 |  |  | Agent 2 |  |  | Agent 3 |  |  | Agent 4 |  |  | Agent 5 |  |  | Agent 6 |  |  | Total Sum of Calls Handled | Total Sum of Calls  Presented | Total Sum of Handle Ratio
Month/Year | Sum of Calls Handled | Sum of Calls  Presented | Sum of Handle Ratio | Sum of Calls Handled | Sum of Calls  Presented | Sum of Handle Ratio | Sum of Calls Handled | Sum of Calls  Presented | Sum of Handle Ratio | Sum of Calls Handled | Sum of Calls  Presented | Sum of Handle Ratio | Sum of Calls Handled | Sum of Calls  Presented | Sum of Handle Ratio | Sum of Calls Handled | Sum of Calls  Presented | Sum of Handle Ratio
2010-07-01 00:00:00 | 259 | 272 | 0.95 | 127 | 141 | 0.9 | 286 | 315 | 0.91 | 207 | 214 | 0.97 | 386 | 399 | 0.97 | 175 | 205 | 0.85 | 1440 | 1546 | 5.55
2010-08-01 00:00:00 | 233 | 254 | 0.92 | 181 | 198 | 0.91 | 151 | 159 | 0.95 | 278 | 290 | 0.96 | 259 | 273 | 0.95 | 188 | 230 | 0.82 | 1290 | 1404 | 5.510000000000001
2010-09-01 00:00:00 | 286 | 303 | 0.94 | 93 | 99 | 0.94 | 241 | 255 | 0.95 | 189 | 197 | 0.96 | 345 | 353 | 0.98 | 222 | 255 | 0.87 | 1376 | 1462 | 5.64
2010-10-01 00:00:00 | 378 | 400 | 0.95 | 162 | 170 | 0.95 | 266 | 279 | 0.95 | 301 | 313 | 0.96 | 316 | 323 | 0.98 | 238 | 273 | 0.87 | 1661 | 1758 | 5.659999999999999
2010-11-01 00:00:00 | 326 | 355 | 0.92 | 121 | 137 | 0.88 | 301 | 314 | 0.96 | 313 | 330 | 0.95 | 214 | 216 | 0.99 | 290 | 329 | 0.88 | 1565 | 1681 | 5.58
2010-12-01 00:00:00 | 335 | 362 | 0.93 | 111 | 126 | 0.88 | 264 | 274 | 0.96 | 279 | 300 | 0.93 | 277 | 291 | 0.95 | 193 | 222 | 0.87 | 1459 | 1575 | 5.52
2011-01-01 00:00:00 | 348 | 374 | 0.93 | 164 | 188 | 0.87 | 347 | 365 | 0.95 | 313 | 320 | 0.98 | 344 | 356 | 0.97 | 241 | 282 | 0.85 | 1757 | 1885 | 5.55
2011-02-01 00:00:00 | 320 | 362 | 0.88 | 126 | 139 | 0.91 | 321 | 342 | 0.94 | 336 | 357 | 0.94 | 304 | 314 | 0.97 | 307 | 340 | 0.9 | 1714 | 1854 | 5.54
2011-03-01 00:00:00 | 408 | 456 | 0.89 | 122 | 135 | 0.9 | 410 | 436 | 0.94 | 408 | 424 | 0.96 | 511 | 524 | 0.98 | 343 | 370 | 0.93 | 2202 | 2345 | 5.6
2011-04-01 00:00:00 | 338 | 380 | 0.89 | 82 | 102 | 0.8 | 328 | 357 | 0.92 | 294 | 311 | 0.95 | 384 | 391 | 0.98 | 340 | 362 | 0.94 | 1766 | 1903 | 5.479999999999999
2011-05-01 00:00:00 | 339 | 381 | 0.89 | 127 | 166 | 0.77 | 358 | 381 | 0.94 | 291 | 306 | 0.95 | 427 | 440 | 0.97 | 278 | 288 | 0.97 | 1820 | 1962 | 5.489999999999999
Grand Total | 3570 | 3899 | 10.09 | 1416 | 1601 | 9.71 | 3273 | 3477 | 10.37 | 3209 | 3362 | 10.51 | 3767 | 3880 | 10.69 | 2815 | 3156 | 9.75 | 18050 | 19375 | 61.12
Spreadsheet: 724758d1616353933-averaging-cells-in-one-column-based-on-another-book1-etaf
Sheet: Sheet1

ArrayList | Time to Run
34 | 8800 |  |  | Row Labels | Average of Time to Run
30 | 10500 |  |  | 30 | 9800
30 | 10900 |  |  | 31 | 7800
30 | 8000 |  |  | 32 | 8300
31 | 7600 |  |  | 33 | 8500
31 | 8000 |  |  | 34 | 8600
34 | 8400 |  |  | 35 | 9050
33 | 8500 |  |  | 36 | 9100
34 | 8800 |  |  | 37 | 9200
32 | 8300 |  |  | 39 | 9900
35 | 9100 |  |  | Grand Total | 8917.64705882353
35 | 9000
39 | 9900
37 | 9200
34 | 8400
36 | 8900
36 | 9300
Spreadsheet: 44801d1243541629-lookup-worksheets-and-do-sumifs-criteria-lookupsumifa
Sheet: 66505

braches rates account
NL Code | Month | J R | Date | Ref 1 | Ref 2 | Amount
266505 | 1 | 187 | 2009-05-28 00:00:00 | CB |  | 250
366505 | 1 | 188 | 2009-05-29 00:00:00 | CB |  | 250
 |  |  |  |  |  | 500
Spreadsheet: 2c8c5fd2-5c6e-4536-afdd-0d990a4e10e3
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Apr. | May | June | June
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 215806.119 | 242916.198 | 246900.529 | 267878.752
Cotton | 101185.214 | 122404.056 | 130678.625 | 154170.126
Linen | 7187.924 | 7029.989 | 7061.234 | 6579.852
Wool | 3090.662 | 3329.681 | 3005.697 | 3234.003
Silk | 959.582 | 1187.411 | 976.785 | 1390.765
Manmade | 103382.737 | 108965.061 | 105178.188 | 102504.006
Apparel: | 22205.352 | 25192.224 | 25421.876 | 25888.795
Cotton | 9980.317 | 11255.011 | 11597.963 | 11284.602
Linen | 414.623 | 307.434 | 377.69 | 589.641
Wool | 1132.27 | 1246.979 | 1344.946 | 1499.453
Silk | 952.011 | 1158.504 | 1235.758 | 1381.843
Manmade | 9726.131 | 11224.296 | 10865.519 | 11133.256
Home furnishings: | 4337.601000000001 | 6145.53 | 4728.948 | 3693.361
Cotton | 2131.214 | 3051.567 | 2259.585 | 1713.883
Linen | 187.281 | 260.241 | 227.793 | 144.022
Wool | 90.436 | 129.118 | 113.775 | 144.226
Silk | 103 | 156.528 | 123.687 | 70.979
Manmade | 1825.67 | 2548.076 | 2004.108 | 1620.251
Floor coverings: | 28044.203 | 33349.636 | 32465.581 | 31121.387
Cotton | 1778.046 | 2110.363 | 2133.148 | 2108.841
Linen | 873.512 | 1069.49 | 1113.67 | 946.676
Wool | 3343.977 | 2946.957 | 2592.043 | 2553.981
Silk | 39.215 | 33.711 | 42.011 | 40.291
Manmade | 22009.453 | 27189.115 | 26584.709 | 25471.598
Total exports: 2/ | 270526.588 | 307728.194 | 309636.412 | 328840.409
Cotton | 115171.764 | 138915.158 | 146759.28 | 169381.285
Linen | 8663.339 | 8667.153 | 8780.387 | 8267.354
Wool | 7661.714 | 7656.504 | 7059.988 | 7440.285
Silk | 2053.862 | 2536.153 | 2378.241 | 2883.878
Manmade | 136975.909 | 149953.226 | 144658.516 | 140867.607
1/ Raw-fiber equivalent.  2/ Includes headgear.
Last update:  09/13/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 723525d1615751985-max-if-not-working-properly-test
Sheet: CODES

IIAXX | IIAXX
AAGIY | AAGIY
AAPL | AAPL
ADBE | ADBE
ADDYY | ADDYY
ADSK | ADSK
AHKSY | AHKSY
AMADY | AMADY
AMD | AMD
AMT | AMT
AMX | AMX
AMZN | AMZN
ASAZY | ASAZY
ASBFY | ASBFY
ASML | ASML
ATVI | ATVI
AVGO | AVGO
AZN | AZN
BGNE | BGNE
BLK | BLK
BSX | BSX
BTI | BTI
BUD | BUD
CABGY | CABGY
CB | CB
CME | CME
CRSP | CRSP
DNHBY | DNHBY
DNNGY | DNNGY
DSDVY | DSDVY
EADSY | EADSY
EFX | EFX
EQIX | EQIX
FB | FB
GDDY | GDDY
GOOG | GOOG
GS | GS
HD | HD
HESAY | HESAY
HKXCY | HKXCY
HLT | HLT
HON | HON
IBN | IBN
ICE | ICE
IEX | IEX
IHG | IHG
IIAXX | IIAXX
INCY | INCY
ISRG | ISRG
JPM | JPM
KMTUY | KMTUY
KSRYY | KSRYY
LIN | LIN
LNSTY | LNSTY
LVMUY | LVMUY
LYB | LYB
MA | MA
MCO | MCO
MELI | MELI
MSFT | MSFT
NFLX | NFLX
NJDCY | NJDCY
NKE | NKE
NOW | NOW
NSRGY | NSRGY
NVO | NVO
NVS | NVS
PDRDY | PDRDY
PODD | PODD
PPRUY | PPRUY
PROSY | PROSY
PYPL | PYPL
QSR | QSR
RARE | RARE
RDSB | RDSB
RDSMY | RDSMY
REGN | REGN
RNLSY | RNLSY
RYAAY | RYAAY
SAFRY | SAFRY
SE | SE
SFTBY | SFTBY
SGEN | SGEN
SHECY | SHECY
SHOP | SHOP
SHW | SHW
SLB | SLB
SMAR | SMAR
SMCAY | SMCAY
TCOM | TCOM
TEVA | TEVA
TMO | TMO
TRMB | TRMB
TSLA | TSLA
TSM | TSM
V | V
VALE | VALE
VRTX | VRTX
ZTS | ZTS
Spreadsheet: 792091d1660735610-conditional-formatting-of-one-cell-based-on-comparison-of-two-columns-excel-forum-17-hd-1-
Sheet: Sheet1

 |  | Case 1 |  | Case 1 |  |  |  |  |  | Case 2
 |  | Case 2 |  | No . Of items | Total |  |  |  |  | No . Of items | Total
 |  |  |  | 1 | Not found |  |  |  |  | 1 | 1
 |  |  |  | 1 | 2 |  |  |  |  | 2 | 2
 |  |  |  | 1 | 1 |  |  |  |  | 2 | 2
 |  |  |  | 1 | 1 |  |  |  |  | 1 | 1
 |  |  |  | 1 | 1 |  |  |  |  | 1 | 1
 |  |  |  | 1 | 1 |  |  |  |  | 1 | 1
 | I want cell C1 to turn green only if the values in column titled (no. of items) equal the values in column titled (total).
 | Given that case 1 in my sheet have equal sum between first and second column, i assure that i want only C1 to be filled green when equality is on the basis of every row.
 | Based on my sheet, case 2 should render cell C1 to be filled green.
 |  |  |  | 1
Spreadsheet: 771701d1646800487-aggregate-statistics-across-multiple-sheets-if-multiple-critereon-met-tiers-statistics-ans
Sheet: Statistics

Total Tasks |  |  |  |  |  |  |  |  |  |  |  | Sheet Names |  | Enter all sheet names in column M
Simple |  |  |  |  |  |  |  |  |  |  |  | Client00001
Medium |  |  |  |  |  |  |  |  |  |  |  | Client00002
Complex
Total Scope
Simple
Medium
Complex
Average Tasks Per Project
Simple
Intermediate
Complex
Spreadsheet: 273052d1382600402-formula-for-tagging-sample-scenario
Sheet: BEFORE

date | tag | final tag
2012-02-01 00:00:00 | red
2012-02-02 00:00:00 | orange
2012-02-02 00:00:00 | orange
2012-02-02 00:00:00 | green
2012-02-02 00:00:00 | blue |  | *I've been manually tagging the dominant color as a final tag for the date, please see sheet after for more details
2012-02-02 00:00:00 | indigo
2012-02-03 00:00:00 | violet
2012-02-04 00:00:00 | red
2012-02-04 00:00:00 | red
2012-02-04 00:00:00 | violet
2012-02-04 00:00:00 | violet
2012-02-04 00:00:00 | violet
2012-02-04 00:00:00 | violet
2012-02-05 00:00:00 | blue
2012-02-05 00:00:00 | indigo
2012-02-05 00:00:00 | green
2012-02-05 00:00:00 | red
2012-02-05 00:00:00 | orange
2012-02-05 00:00:00 | yellow
2012-02-05 00:00:00 | white
2012-02-05 00:00:00 | black
2012-02-05 00:00:00 | gray
2012-02-05 00:00:00 | pink
Spreadsheet: 878226d1725288835-golf-pairs-team-admin-tool-c-team-pairings-2025
Sheet: Team

 |  | Team
 |  | Name | Handicap | Avaliable |  | Order | PAIRINGS | Handicap | Result pts ([NAME])
 |  | Player 1 | 2 | x |  | 1 | Player 1 | 2 | 3
 |  | Player 2 | 3 |  |  |  | Player 3 | 5 | 3
 |  | Player 3 | 5 | x
 |  | Player 4 | 4 |  |  | 2 | Player 5 | 12 | 1
 |  | Player 5 | 12 | x |  |  | Player 6 | 23 | 1
 |  | Player 6 | 23 | x
 |  | Player 7 | 13 |  |  | 3 | Player23 | 14 | 0
 |  | Player 8 | 22 |  |  |  | Player 12 | 2 | 0
 |  | Player 9 | 21
 |  | Player 10 | 14 |  |  | 4 | Player 14 | 5 | 1
 |  | Player 11 | 22 |  |  |  | Player 16 | 12 | 1
 |  | Player 12 | 2
 |  | Player 13 | 3 |  |  | 5 | Player 20 | 21 | 3
 |  | Player 14 | 5 | x |  |  | Player 24 | 22 | 3
 |  | Player 15 | 4
 |  | Player 16 | 12 | x |  | 6 | Player 20 | 21 | 1
 |  | Player 17 | 23 |  |  |  | Player 24 | 22 | 1
 |  | Player 18 | 13
 |  | Player 19 | 22
 |  | Player 20 | 21 | x
 |  | Player 21 | 22
 |  | Player 22 | 21 | x
 |  | Player 23 | 14
 |  | Player 24 | 22 | x
 |  | Player 25 | 2
 |  | Player 26 | 3
 |  | Player 27 | 5
 |  | Player 28 | 4
 |  | Player 29 | 12
 |  | Player 30 | 22
 |  | Player 31 | 2 | x
 |  | Player 32 | 3
 |  | Player 33 | 5
 |  | Player 34 | 4
 |  | Player 35 | 12
 |  | Player 36 | 2 | x