tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 76809d1277299312-matrix-array-if-formula-risks-for-forum
Sheet: Guidance Notes

 |  |  | Assessment
 | Assessment | Probability (%) | Cost Impact (£K) | Time Impact (Days) |  |  |  | Assessment | Prob*Cost Impact (£K) | Time Impact (Days)
 | VHI | >90% | > £500k | >30 |  |  |  | VLO | 0 | >0 - 5
 | HI | 60% - 90% | £250k - £500k | 21 - 30 |  |  |  | LO | 10 | 2009-10-06 00:00:00
 | MED | 40% - 59% | £100k - £249k | 2020-11-01 00:00:00 |  |  |  | MED | 40 | 2020-11-01 00:00:00
 | LO | 20% - 39% | £50k - £99k | 2009-10-06 00:00:00 |  |  |  | HI | 150 | 21 - 30
 | VLO | >0% - 19% | < £50k | >0 - 5 |  |  |  | VHI | 450 | >30
 | NIL | - | No effect on cost | No effect on schedule |  |  |  | NIL | - | No effect on schedule
 |  |  | Priority
Spreadsheet: 73528d1274194341-conditional-formating-3-conditions-only-i-need-7-possible-kpi-trial
Sheet: MAIN

 | U2 Packaging Key Performance Indicator
 |  | Shift | DS1 |  |  | Efficiency |  |  |  |  |  |  |  | Staff 4x4 off work
 |  | Date | 2010-05-10 00:00:00 |  |  | No. of Staff | Man hours used | Sets packed | Process credits | [NAME] to target
 |  | Sets to pack | 142
 |  | Room leader | [NAME] |  |  | 26 | 271 | 280 | 673 | 1.971830985915493 |  |  |  | Staff 4x4
 |  |  |  |  |  | Efficiency indicator |  |  | 2.483394833948339 |  |  |  |  | Holidays | Sick | Unpaid leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DayShift1 name3 | DayShift1 name12 | DayShift1 name22
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DayShift1 name8 | DayShift1 name14 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DayShift1 name20 | DayShift1 name17 | #N/A
 | Products |  | Tasks |  |  |  |  |  |  |  | Process credits |  |  | #N/A | #N/A | #N/A
 |  |  | COLOUR | CARAMEL | TOPPING | CUTTING | BOATING | PACKING | REWRAPING | MISC |  |  |  | #N/A | #N/A | #N/A
 | WTWBNL |  | Black |  |  | 77 |  | 100 |  |  | 177 |  |  | #N/A | #N/A | #N/A
 | STAGFB |  | Pink |  |  | 34 |  | 55 |  |  | 123 |  |  | #N/A | #N/A | #N/A
 | STARR2 |  | Green |  |  | 56 |  | 79 |  |  | 135 |  |  | H | S | UNPD
 | WTABFJNL1 |  | Yellow |  |  | 100 |  | 46 |  |  | 238
 | MSFTGCDFJ2 |  | Pink |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 hrs shifts (hours) |  |  |  | DS1 | DS2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Early shift | Late shift | Weekends |  | DS2 | DS1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1.5 | 8 |  | NS1 | NS2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Overtime | Hours transferred |  |  | NS2 | NS1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DayShift2 name 6 | IN | OUT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DayShift2 name 14 | 4 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | Where from? | Where to?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | TOTAL | 673
Spreadsheet: 480159d1473798248-coping-worksheet-lists-to-include-new-inserts-to-edit-formula-
Sheet: Shows

Show | Contacted | Booked | Forms sent | Confirmed | Deposit | Paid | Show cost | Paid | Total | Date | Takings | Date | Takings | Date | Takings | Date | Takings | Total | Details | Number | email
Field Dog - Southwell | Yes | Yes
Field Dog - Southwell | Yes | Yes
Barnby Road School | Yes | Yes
Field Dog - Stamford | Yes
Gateway to [NAME] | Yes | Yes
Splendour
Final Whistle | Yes | Yes
Gloworm - Clumber | Yes | Prov
Field Dog - Southwell | Yes | Yes
[NAME] | Yes | Yes
[NAME] | Yes
[NAME] | Yes | Yes
South Scarle | Yes | Yes
Big Craft Show - Lincoln
[NAME]
[NAME] ? | Yes | No
Lark in the Park
Spreadsheet: 839841d1692265123-count-how-many-times-a-number-appears-example-sheet
Sheet: Sheet2

Reference | LeadGroup | Status | Telephone1 | Total Dials | Total Duration Talking
196219131 | PPC Leads | [NAME] | 7302089232
196235552 | Web Leads | No Answer | 7469193999
196215613 | Web Leads | IVA Prospect | 7470082888
196240648 | PPC Leads | DNQ - Other Reason | 7488303232
196180071 | Web Leads | [NAME] | 7512672111
196181054 | PPC Leads | Call Back - Initial stage | 7534562232
196217750 | PPC Leads | Sold PBS | 7547264232
196221053 | PPC Leads | No Answer | 7725126232
196229828 | Web Leads | DNQ - Affordability Issue | 7776755222
196225583 | Web Leads | Not Interested | 7908358232
Spreadsheet: 835548d1688652838-drag-a-formula-to-increment-column-reference-pettycash
Sheet: PETTYCASH

Vendor ID | Check Number | Date | Memo | Cash Account | Number of Distributions | Description | G/L Account | Amount |  | 149843.28
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | AIR CONDITION & FIXTURES | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | BANK CHARGES | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | CONTRACT LABOR | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | COURIER SERVICES | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | PROPERTY & BUILDING | 60070
PETTYCASH | PCV230115 | 2023-01-15 00:00:00 |  | 23998 | 10 | SALARIES | 60071
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | STAFF WELFARE | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | STATIONERY & OFFICE | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | SUBSCRIPTIONS & LICENCES | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | TELEPHONE & INTERNET | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | VEHICLE & EQUIPMENT | 60070
PETTYCASH | PCV230114 | 2023-01-14 00:00:00 |  | 23998 | 10 | PETTY CASH - VAT | 23999
Spreadsheet: 883504d1732116748-calculate-interest-on-a-loan-book1-q2000-
Sheet: Sheet1

Loan start: | 2024-09-09 00:00:00 |  | Month | Interest | Total Interest | Balance
Amount (DKK): | 10000000 |  | 2024-09-09 00:00:00
Weekly interest: | 0.015
Daily interest:
Monthly interest:
Spreadsheet: 748934d1632418085-display-unique-value-based-upon-latest-time-stamp-example
Sheet: Sheet1

Original Columns  -  Has Duplicates |  |  |  | Desired Result - No Duplicates
Data | Times |  |  | Data | Times
00T464154 | 2021-09-21 09:44:37 |  |  | 00T464154 | 2021-09-21 19:20:02 | Last Instance
00T464154 | 2021-09-21 12:08:51 |  |  | 02U572083 | 2021-09-21 03:19:49
00T464154 | 2021-09-21 19:20:02 | Display Last Instance |  | 07U632089 | 2021-09-21 13:52:25
02U572083 | 2021-09-21 03:19:49 |  |  | 07U632090 | 2021-09-21 15:36:16
07U632089 | 2021-09-21 13:52:25 |  |  | 08T720293 | 2021-09-21 09:44:30
07U632090 | 2021-09-21 15:36:16 |  |  | 08T720629 | 2021-09-21 20:36:43
08T720293 | 2021-09-21 09:44:30 |  |  | 08T720630 | 2021-09-21 12:31:53 | Last Instance
08T720629 | 2021-09-21 20:36:43 |  |  | 08T720631 | 2021-09-21 17:14:39
08T720630 | 2021-09-21 19:37:26 |  |  | 08T720633 | 2021-09-21 20:53:15 | Last Instance
08T720630 | 2021-09-21 15:26:14
08T720630 | 2021-09-21 12:31:53 | Display Last Instance
08T720631 | 2021-09-21 17:14:39 |  |  | Display each unique value for the latest time
08T720633 | 2021-09-21 13:42:19
08T720633 | 2021-09-21 20:53:15 | Display Last Instance
Spreadsheet: 162235d1339772273-excel-2007-formula-issue-occupancy-schedule-budget-template-excel-formula-question
Sheet: Occupancy Schedule

 |  |  |  |  | Occupancy Schedule
 |  |  |  |  | Please enter [NAME] for each month space is occupied
 | 2013 |  |  |  | Check that move ins and move outs are entered only in the months occupied
 |  |  |  |  | If a space is vacant there should be a 0 for each month the space is vacant
Suite | [NAME] | S.F. |  | 2013-01-01 00:00:00
100A |  | 807
110 |  | 5222
112 |  | 915
118 |  | 2038
120 |  | 868
150 |  | 1069
170 |  | 3294
200 |  | 2860
205 |  | 1996
210 |  | 1695
220 |  | 4097
240 |  | 1500
245 |  | 2034
250 |  | 902
300 |  | 2001
310 |  | 2050
312 |  | 518
315 |  | 1495
320 |  | 2006
325 |  | 907
330 |  | 711
340 |  | 1753
350 |  | 1456
360 |  | 6007
365 |  | 1221
400 |  | 5443
440 |  | 2984
450, 450A |  | 5412
460 |  | 6985
500 |  | 16538
520 |  | 3950
600 |  | 5332
650 |  | 4600
625 |  | 2739
660 |  | 2073
675 |  | 2383
680 |  | 1497
690 |  | 1903
 |  | 68
250- Mid-Year Replacement |  | 150
0 |  | 0
0 |  | 0
`
 | TOTALS SF
Spreadsheet: 160872d1339263445-is-there-a-formula-that-can-be-used-to-return-sections-of-data-xmpl
Sheet: example

Brown, [NAME]
Brown, [NAME] | Bloomingdale, [NAME] R | 8255909297755693 | 2012-05-07 00:00:00 | C | nc | 2012-05-03 00:00:00 | 4 | CARRIE | SALDANA | relocated dish from rail to patio mount
Brown, [NAME] | Bloomingdale, [NAME] R | 8255909298429611 | 2012-06-01 00:00:00 | O | tc | 2012-05-30 00:00:00 | 2 | [NAME] | WASHINGTON
 |  |  |  |  | OR
[NAME], [NAME]
[NAME], [NAME] | Fenrick, [NAME] | 8255909704475430 | 2012-05-08 00:00:00 | C | ch | 2012-05-02 00:00:00 | 6 | MIRIAM | MARTINEZ ENRIQUEZ | CCI 722 signal issue, tech replaced rec, ground block and diplexers
[NAME], [NAME] | Fenrick, [NAME] | 8271909290532156 | 2012-05-29 00:00:00 | O | sc | 2012-05-19 00:00:00 | 10 | JR | COBB | CCI  311 signal issue, 129 low due to skew. Bad check switch 311 replaced
 |  |  |  |  | OR
[NAME], [NAME]
[NAME], [NAME] | Parcells, [NAME] | 8255909299795374 | 2012-05-06 00:00:00 | C | nc | 2012-05-06 00:00:00 | 0 | REGINALD | [NAME] | no programming on new reciever. 0 day fix
[NAME], [NAME] | Parcells, [NAME] | 8255909293738081 | 2012-05-11 00:00:00 | R | tc | 2012-05-06 00:00:00 | 5 | JOCELYN | PITMAN | w/o set up wrong. Should have been set up as DIU
[NAME], [NAME] | Parcells, [NAME] | 8255909293694227 | 2012-05-24 00:00:00 | O | ch | 2012-05-23 00:00:00 | 1 | LAVERNE | [NAME]
[NAME], [NAME] | Parcells, [NAME] | 8255909296223172 | 2012-05-28 00:00:00 | O | ch | 2012-05-27 00:00:00 | 1 | SONJOY | KARMOKAR
[NAME], [NAME] | Parcells, [NAME] | 8255909295502329 | 2012-05-29 00:00:00 | C | nc | 2012-05-27 00:00:00 | 2 | JORGE | RAMIREZ
[NAME], [NAME] | Parcells, [NAME] | 8255909293747355 | 2012-05-31 00:00:00 | O | ch | 2012-05-30 00:00:00 | 1 | PABLO | ROMERO
[NAME], [NAME] | Parcells, [NAME] | 8255909297522895 | 2012-06-01 00:00:00 | O | nc | 2012-05-28 00:00:00 | 4 | GERARDO | MARQUEZ
Spreadsheet: 116598d1311939209-function-that-copy-certain-numbers-to-another-sheet-something-like-this-maybe
Sheet: one

stuff | 0,1,2or>2 | data 1 | data 2 | data 3 | data 4 | data 5
NEW001 | 1 | 30 | 117 | 378 | 1161 | 3510
NEW004 | 1 | 10 | 19 | 28 | 37 | 46
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 8

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | G | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: OKLAHOMA-35

 | COUNTY | CODE
 | Adair | 1
 | [NAME]
 | Atoka
 | Beaver
 | Beckham
 | Blaine
 | [NAME]
 | Caddo
 | Canadian
 | [NAME]
 | Cherokee
 | Choctaw
 | Cimarron
 | Cleveland
 | Coal
 | Comanche
 | Cotton
 | [NAME]
 | Creek
 | Custer
 | Delaware
 | Dewey
 | Ellis
 | [NAME]
 | Garvin
 | Grady
 | Grant
 | Greer
 | [NAME]
 | Harper
 | Haskell
 | Hughes
 | [NAME]
 | [NAME]
 | Johnston
 | [NAME]
 | [NAME]
 | [NAME]
 | Latimer
 | Le Flore
 | Lincoln
 | Logan
 | Love
 | McClain
 | McCurtain
 | McIntosh
 | Major
 | [NAME]
 | Mayes
 | [NAME]
 | Muskogee
 | Noble
 | Nowata
 | [NAME]
 | Oklahoma
 | Okmulgee
 | Osage
 | Ottawa
 | Pawnee
 | Payne
 | Pittsburg
 | Pontotoc
 | [NAME]
 | Pushmataha
 | [NAME]
 | Rogers
 | Seminole
 | Sequoyah
 | [NAME]
 | Texas
 | Tillman
 | Tulsa
 | Wagoner
 | Washington
 | Washita
 | Woods
 | Woodward
Spreadsheet: 6cbdaa25-83e9-4701-8549-c9bc85869edc
Sheet: EPR 1X PQY

Second Quarter Ended March 31, 2012
 |  |  |  | Continuing Operations
 | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 227.6 | 195.6 | 117.9999999999999 | 62.39999999999988 | 0.21
% of revenue |  | 0.3614190687361419 | 0.2180339985218032
Acquisition related charges: (b)
Contingent retention & earn-out | 0 | -11.7 | 11.7 | 7.499999999999999 | 0.03
Amortization of intangibles | -2.3 | -3.9 | 6.199999999999999 | 4 | 0.01
Professional fees | 0 | -4.5 | 4.5 | 2.8 | 0.01
Distributor settlement | 0 | -3.1 | 3.1 | 2 | 0.01
Severance | 0 | -1.2 | 1.2 | 0.7999999999999999 | 0
Total non-GAAP adjustments | -2.3 | -24.4 | 26.7 | 17.1 | 0.06
Adjusted measures | 225.3 | 171.2 | 144.6999999999999 | 79.49999999999989 | 0.27
% of revenue |  | 0.3163340724316334 | 0.2673688100517367
Six Months Ended March 31, 2012
 |  |  |  | Continuing Operations
 | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 421.2 | 347.6999999999999 | 217.8999999999999 | 112.6999999999999 | 0.38
% of revenue |  | 0.3523510336441021 | 0.2208147547628697
Acquisition related charges: (b)
Contingent retention & earn-out | 0 | -11.7 | 11.7 | 7.499999999999999 | 0.03
Amortization of intangibles | -2.3 | -3.9 | 6.199999999999999 | 4 | 0.01
Professional fees | 0 | -5.7 | 5.7 | 3.6 | 0.01
Distributor settlement | 0 | -3.1 | 3.1 | 2 | 0.01
Severance | 0 | -1.2 | 1.2 | 0.7999999999999999 | 0
Total non-GAAP adjustments | -2.3 | -25.6 | 27.9 | 17.9 | 0.06
Adjusted measures | 418.9 | 322.0999999999999 | 245.7999999999999 | 130.5999999999999 | 0.44
% of revenue |  | 0.3264085934333197 | 0.2490879610863396
(a) Adjustments tax effected at 36%
(b) Primarily related to DoubleDown
Spreadsheet: 48458d1247669241-extracting-selected-data-into-new-worksheets-example
Sheet: Sheet1

JV | [NAME] | Scheme | ScemeName | Product | Product Name | CoverageType | Coverage Type Description | CoverageSub Type | CoverageSub Type Description | Claim Limit | Claims per Policy limit
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_AF | American Style Fridge Freezer | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_CA | Cooker (all electric) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_CG | Cooker (all gas) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_CE | Cooker (dual - electirc hob/gas oven) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_CD | Cooker (dual - gas hob/electric oven) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_CH | Cooker hood | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_DF | Dishwasher (full size) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_DS | Dishwasher (slimline) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1696 | [NAME] | [NAME] | Kitchen Appliances | P_KA_FR | [NAME] (side by side) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_AF | American Style Fridge Freezer | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_CA | Cooker (all electric) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_CG | Cooker (all gas) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_CE | Cooker (dual - electirc hob/gas oven) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_CD | Cooker (dual - gas hob/electric oven) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_CH | Cooker hood | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_DF | Dishwasher (full size) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_DS | Dishwasher (slimline) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_FR | [NAME] (side by side) | 0 | 0
AP | Alpha Boilers | 165 | Alpha Boilers | 1703 | [NAME] -3 App | [NAME] | Kitchen Appliances | P_KA_FS | Fridge (side by side) | 0 | 0
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: FJ05 EFG

 |  |  |  |  | FJ05 EFG
Registration number : | FJ05 EFG |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | IVECO |  | 2005-06-30 00:00:00 | 12 Months | 2006-07-01 00:00:00 | 650
Specification : | 6 x 2 RTC |  | 2006-06-30 00:00:00 | 12 Months | 2007-07-01 00:00:00 | 650
Type : | STRALIS |  | 2007-06-29 00:00:00 | 12 Months | 2008-07-01 00:00:00 | 650
1st Registered : | 04.07.05 |  | 2008-06-30 00:00:00 | 12 Months | 2009-07-01 00:00:00 | 650
Engine : | F2BE 0681 |  | 2009-06-30 00:00:00 | 12 Months | 2010-07-01 00:00:00 | 650
[NAME] : | 26,000kg |  | 2010-06-30 00:00:00 | 12 Months | 2011-07-01 00:00:00 | 650
 |  |  | 2011-06-30 00:00:00 | 12 Months | 2012-07-01 00:00:00 | 650
 |  |  | 2011-10-31 00:00:00 | 12 Months | 2013-07-01 00:00:00 | 280 | RP HGV
 |  |  | Exchanged tax disc from HGV to RP Euro 3 to Euro 4 by Eminox.
Back To Index
Spreadsheet: 738896d1625324502-the-number-of-consecutive-days-in-a-week-is-greater-than-or-equal-to-the-sum-of-3-days-0703-sample-forum-ans2
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  | Item | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  |  | FORMULA | HELPER1 | HELPER2
 |  |  | 5 |  | 1 | 10 | 20 | 30 |  | 5 | 8 |  | 60 |  |  | 60 | 1 | 3
 |  |  | 0 |  | 2 |  | 12 | 36 | 80 |  | 1 | 8 | 128 | '=H6+I6+J6 |  | 128 | 2 | 4
 |  |  |  |  | 3 | 5 |  |  |  |  |  | 7 | 0
 |  |  |  |  | 4 |  | 25 | 3 | 8 | 8 | 1 | 1 | 46 |  |  | 46 | 2 | 7
 |  |  |  |  | 5 |  |  |  |  |  | 4 | 2 | 0
 |  |  |  |  | 6 | 2 | 3 | 9 |  |  | 7 | 1 | 14 | '=G10+H10+I10 |  | 14 | 1 | 3
 |  |  |  |  | 7 |  |  |  | 5 |  |  |  | 0
 |  |  |  |  | 8 | 2 | 3 | 4 |  |  |  |  | 0 |  |  | 9 | 1 | 3
 |  |  |  |  | 9 |  | 3 | 4 | 5 | 8 |  | 1 | 20 | '=H13+I13+J13+K13 |  | 20 | 2 | 5
 |  |  |  |  | 10 | 7 | 3 | 1 | 8 | 9 |  |  | 28 | '=G14+H14+I14+J14+K14 |  | 28 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | The number of consecutive days in a week is greater than or equal to the sum of 3 days
 |  |  |  |  |  |  |  |  |  |  |  |  | Final answer
Spreadsheet: 1afc4617-5488-4309-8e27-b079080428b5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5218 | 32652 | [NAME] | Fisher | USA | 0 | 00:33:02 | 00:02:21 | 01:24:50 | 00:02:14 | 01:01:21 | 1 | 03:03:47
5218 | 25147 | [NAME] | Dodson | USA | 0 | 00:44:06 | 00:02:06 | 01:21:56 | 00:02:35 | 01:00:31 | 2 | 03:11:12
5218 | 32650 | [NAME] | Draper | USA | 0 | 00:56:30 | [NAME] | 01:35:44 | 00:02:20 | 01:02:51 | 3 | 03:39:56
Spreadsheet: 292190d1390511776-unwanted-conditional-format-range-change-when-formula-is-dragged-1-jan23-excel-forum-example
Sheet: PA

xx |  |  | NUMBER OF SCHEDULED PAYMENTS |  |  |  |  | ACTIVE MO PAYMENT INCL SALES TAX | MONTH 1 |  |  |  |  |  |  |  | MONTH 2 |  |  |  |  |  |  |  | MONTH 3 |  |  |  |  |  |  |  | MONTH 4 |  |  |  |  |  |  |  | MONTH 5 |  |  |  |  |  |  |  | MONTH 6
 |  |  |  | NUMBER of PAYMENTS REMAINING | AMT NET TAX | 1-ACTIVE     2-PAID OFF 3-REPO'D | PAYOFF AMT RCVD |  | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | DATE PAYMENT RCVD | PAYMENT SHORTAGE | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD
1 | XXX0001 | CUST0001 | 35 |  | 1645 | 1
2 | XXX0002 | CUST0002 | 35 |  | 2105 | 1
3 | XXX0003 | CUST0003 | 35 |  | 1745 | 1
4 | XXX0004 | CUST0004 | 35 |  | 4745 | 1
5 | XXX0005 | CUST0005 | 35 |  | 1950 | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 271805d1382053589-count-distinct-records-that-meet-multiple-conditions-summary
Sheet: Sheet1

Employee | Month | Hours Worked
[NAME] | 1 | 0
[NAME] | 2 | 5
[NAME] | 3 | 9
[NAME] | 1 | 0
[NAME] | 2 | 0
[NAME] | 3 | 6
 |  | sumproduct | [NAME]
 | 1
 | 2
 | 3
Spreadsheet: 87612d1287500727-identifiying-dup-values-in-column-and-retrieve-oldest-date-in-dup-values-row-dup-values-and-retrieving-unique-results
Sheet: Sheet1

Name | Fruit | Fruit (Concatenated) | Results Sought
[NAME] | Apple | Apple | Apple
[NAME] | Apple | Apple | Apple
[NAME] | Grape | Grape | Grape
[NAME] | Orange | Orange
[NAME] | Orange | Orange, Orange | Orange, Orange
[NAME] | [NAME] | [NAME]
[NAME] | Bananna | Bananna,Orange, Orange | Bananna, Orange, Orange
[NAME] | Pinapple | Pinapple
[NAME] | [NAME] | Pinapple, [NAME] | Pinapple, [NAME]
[NAME] | Kiwi | Kiwi
[NAME] | Kiwi | Kiwi, Kiwi | Kiwi, Kiwi
[NAME] | Mango | Mango | Mango
[NAME] | Watermelon | Watermelon | Watermelon
[NAME] | Peach | Peach | Peach
Spreadsheet: 808299d1670400472-pc-asset-tracker-get-value-in-new-sheet-sample-pc-asset-tracker-update1-
Sheet: Berlin

Employee ID | Asset Tag | Serial No | Hostname | Owner | Departement | Location | Brand | Model | Type | Service Start | Service End | Status | Return | Asset Tag 2 | Serial No | Hostname 2 | Brand | Model | Type | Service Start | Service End | Status
A1234 | 7022.02.0040 | 5CD7338GXD | BERNBLGL001 | [NAME] | Legal | Berlin | HP | HP ProBook 430 G3 | Notebook | 2017-10-07 00:00:00 | 2021-10-07 00:00:00 | Expired | Yes | 22K.70B.D001 | 5CD14585TP | BERNBLGL001 | HP | HP ProBook 440 G8 16 Gb | Notebook | 2022-02-18 00:00:00 | 2026-02-18 00:00:00 | Active
[NAME] | 22A.70B.D001 | 5CD14585T5 | BERNBITD001 | Tania | IT | Berlin | HP | HP ProBook 440 G8 | Notebook | 2022-01-27 00:00:00 | 2026-01-27 00:00:00 | Active | No
A9870 | 18K.70B.D006 | 5CD8278P3H | BERNBSLS001 | [NAME] | Sales | Berlin | HP | HP ProBook 430 G3 | Notebook | 2018-11-07 00:00:00 | 2022-11-07 00:00:00 | Expired | No
Spreadsheet: 36689d1234547780-mutiple-selection-one-cell-mult_drop_down
Sheet: Sheet1

 |  |  |  | Current:
 |  |  |  | Name |  |  |  |  |  |  | [NAME]
 | [NAME] down |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  | Debbie |  |  |  |  |  |  | [NAME]
 |  |  |  | Edgar |  |  |  |  |  |  | Debbie
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Edgar
 |  |  |  | What I want to do: |  |  |  |  |  |  | [NAME]
 |  |  |  | Name
Need to select more than one and have that fill the cell |  |  |  | [NAME], [NAME]
 |  |  |  | Debbie. [NAME]. [NAME]