tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 147653d1332916131-extract-from-1-sheet-to-many-sum-total-not-working-extract-from-1-sheet-to-many-sheets
Sheet: Sheet1

SAMPLE CYCLE TEST RUNS
[NAME] | TECHNICIAN | CYCLE A |  | CYCLE B |  | CYCLE C |  | CYCLE D |  | CYCLE E |  | CYCLE F
 |  | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart
RUN 1 | [NAME] | 1 | 14.A | 10 | 9.A | 12 | 4.DA | 14 | 11.AC | 16 | 7.ZA | 20 | 12.AE
RUN 2 | [NAME] | 3 | 14.A | 20 | 9.A | 17 | 4.DA | 19 | 11.AC | 21 | 7.ZA | 22 | 12.AE
RUN 3 | IAN BROWN | 5 | 14.A | 30 | 9.A | 22 | 4.DA | 24 | 11.AC |  | 7.ZA | 24 | 12.AE
RUN 4 | [NAME] THORN | 7 | 16.A | 40 | 9.A | 27 | 4.DA | 29 | 11.AC |  | 7.ZB | 26 | 12.AE
RUN 5 | [NAME] | 9 | 16.A | 50 | 11.CB | 32 | 7.ZZ | 34 | 12.GB |  | 7.ZB | 28 | 14.FY
RUN 6 | [NAME] | 11 | 16.A | 60 | 11.CB | 37 | 7.ZZ | 39 | 12.GB |  | 7.ZB | 30 | 14.FY
RUN 7 | [NAME] | 13 | 16.A | 70 | 11.CB | 42 | 7.ZZ | 44 | 12.GB | 46 | 7.ZB |  | 14.FY
RUN 8 | IAN BROWN | 15 | 17.BB | 80 | 11.CB | 47 | 7.ZZ | 49 | 12.GB | 51 | 9.ZH |  | 14.FY
RUN 9 | [NAME] THORN | 17 | 17.BB | 90 | 11.CB | 52 | 9.RR | 54 | 11.DB | 56 | 9.ZH |  | 16.DD
RUN 10 | [NAME] | 19 | 17.BB | 100 | 11.CB | 57 | 9.RR | 59 | 11.DB | 61 | 9.ZH |  | 16.DD
RUN 11 | NEVILLE COLE | 21 | 17.BB | 110 | 13.BB | 62 | 9.RR | 64 | 11.DB | 66 | 9.ZH | 40 | 16.DD
RUN 12 | NEVILLE COLE | 23 | 12.A | 120 | 13.BB | 67 | 11.AH | 69 | 11.DB | 71 | 11.DX | 42 | 16.DD
RUN 13 | [NAME] THORN | 25 | 12.A | 130 | 13.BB | 72 | 11.AH | 74 | 13.DF | 76 | 11.DX | 44 | 18.PO
RUN 14 | [NAME] THORN | 27 | 12.A | 140 | 15.DD | 77 | 11.AH | 79 | 13.DF | 81 | 11.DX | 46 | 18.PO
RUN 15 | [NAME] | 29 | 12.A | 150 | 15.DD | 82 | 12.BD | 84 | 13.DF | 86 | 11.DX | 48 | 18.PO
Spreadsheet: 723349d1615646826-conditional-formatting-and-color-cells-with-formula-testnameamount
Sheet: Blad1

project | datum | nr vlist | nr defensie | vertrek | tijd | aankomst | aantal | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl |  |  |  |  |  | uren inkoop |  |  | km inkoop
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl |  |  |  |  |  | [NAME] |  |  | km verkoop
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | ik | ics |  |  |  |  |  | [NAME] |  |  | [NAME]
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | nl | ics
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 |  | ics |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verschil D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal inkoop |  |  | proj nl in
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal verkoop |  |  | proj nl ver
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  | totaal [NAME] |  |  | [NAME] in
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  |  |  |  | [NAME] ver
5159 | 2021-03-19 00:00:00 | 20404799 | 17NLD108 | Loheide | 00:00:00 | darp | 2 | rene | rene
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | projrct [NAME] |  | project [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | search code | aantal beg | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | amount | name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | nl
Spreadsheet: c013058b-88f1-4b96-8bb7-c9ab98260616
Sheet: Sheet1

C 1  Oil tax trust fund (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 12/11/2013 9:58:33 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | Yes | No | TOTALS
Adams | 483 | 748 | 1231
Barnes | 1486 | 4056 | 5542
Benson | 697 | 1540 | 2237
Billings | 196 | 296 | 492
Bottineau | 1148 | 2244 | 3392
[NAME] | 569 | 1017 | 1586
Burke | 343 | 580 | 923
Burleigh | 15193 | 24747 | 39940
[NAME] | 23386 | 44589 | 67975
Cavalier | 645 | 1393 | 2038
Dickey | 888 | 1572 | 2460
Divide | 383 | 704 | 1087
Dunn | 653 | 954 | 1607
Eddy | 283 | 848 | 1131
Emmons | 760 | 1017 | 1777
[NAME] | 475 | 1124 | 1599
Golden Valley | 389 | 446 | 835
Grand Forks | 10568 | 18259 | 28827
Grant | 495 | 805 | 1300
Griggs | 411 | 850 | 1261
Hettinger | 455 | 847 | 1302
Kidder | 441 | 748 | 1189
[NAME] | 653 | 1498 | 2151
Logan | 311 | 702 | 1013
McHenry | 975 | 1412 | 2387
McIntosh | 562 | 896 | 1458
McKenzie | 1236 | 1307 | 2543
McLean | 1743 | 2855 | 4598
Mercer | 2032 | 2223 | 4255
[NAME] | 4400 | 8350 | 12750
[NAME] | 1039 | 1800 | 2839
[NAME] | 641 | 1056 | 1697
[NAME] | 365 | 647 | 1012
Pembina | 1426 | 1774 | 3200
Pierce | 664 | 1424 | 2088
Ramsey | 1786 | 2777 | 4563
[NAME] | 840 | 1526 | 2366
[NAME] | 413 | 884 | 1297
Richland | 1865 | 5483 | 7348
Rolette | 1449 | 2657 | 4106
Sargent | 691 | 1182 | 1873
[NAME] | 314 | 460 | 774
Sioux | 609 | 682 | 1291
Slope | 164 | 247 | 411
[NAME] | 4294 | 6305 | 10599
Steele | 298 | 707 | 1005
[NAME] | 2650 | 6600 | 9250
Towner | 400 | 761 | 1161
Traill | 979 | 2896 | 3875
Walsh | 1704 | 2997 | 4701
Ward | 8928 | 15407 | 24335
Wells | 781 | 1521 | 2302
[NAME] | 4189 | 4691 | 8880
TOTAL | 108748 | 193111 | 301859
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: jeffrey_a_shankman__13952__Global_Prod 11-20-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
For Curr Exch    Forward                 21Nov01         JPY/USD
For Curr Exch    Forward                 21Nov01         USD/EUR
For Curr Exch    Forward                 21Nov01         USD/GBP
For Curr LME     LME (Spot)              21Nov01         JPY/USD
For Curr LME     LME (Spot)              21Nov01         USD/EUR
For Curr LME     LME (Spot)              21Nov01         USD/GBP
Foreign Currency Reuters BOFC            19Nov01         CAD/USD
FTL Dry Van Cap  Chi - Nwk Spot          20Nov01         USD/M-TL
FTL Dry Van Cap  Col - LA Spot           20Nov01         USD/M-TL
SG Dub Time Spd  Platts                  Q102 v Q202     USD/bl/m
SG Dubai Swap    Platts                  Q2 2002         USD/bl/m
[NAME]ICIS CIF RDAM           Jan-Jun02       USD/mt/m
Tkr Freight Swap IITRA                   Dec01           WS/mt
Tkr Freight Swap IITRA                   Feb02           WS/mt
Tkr Freight Swap IITRA                   Jan02           WS/mt
Tkr Freight Swap IITRA                   Nov01           WS/mt
[NAME]                  Dec01           WS/mt
[NAME]Feb02           WS/mt
[NAME]                  Jan02           WS/mt
[NAME]                  Nov01           WS/mt
US Benzene Swap  CMAI Contract           Dec01           USD/Gl-b
US Benzene Swap  CMAI Spot               Dec01           USD/Gl-b
US [NAME]               Dec01           USD/Gl-b
US N.Butane FOB  MB Enterprise           Dec01           c/Gl-b
US N.Butane Swap OPIS MB NTET            Dec01           c/Gl-b
US NitTol Swap   CMAI Spot               Apr-Jun02       USD/Gl-b
US PuEthane Swap OPIS MB PurEth          Dec01           c/Gl-b
US WTI Swap      Nymex LD                Dec01           USD/bl/m
[NAME]
Spreadsheet: 06fd963c-0297-4280-957f-39673b23c9e5
Sheet: Sheet1

COLORADO DEPARTMENT OF EDUCATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
PUPIL COUNT COMPARISONS BY YEAR
Year | Pupil Count | Change From Previous Year | Percent Change
1992 | 612635 | 19605 | 3.305903579920071
1993 | 625062 | 12427 | 2.02845087205269
1994 | 640521 | 15459 | 2.473194659089818
1995 | 656279 | 15758 | 2.460184755847193
1996 | 673438 | 17159 | 2.614589221962001
1997 | 687167 | 13729 | 2.038643497990906
1998 | 699135 | 11968 | 1.741643588821931
1999 | 708109 | 8974 | 1.283586145737232
2000 | 724508 | 16399 | 2.315886396020951
2001 | 742145 | 17637 | 2.434341649781645
2002 | 751862 | 9717 | 1.309312870126458
2003 | 757668 | 5806 | 0.7722161779688294
2004 | 766657 | 8989 | 1.186403543504543
2005 | 780708 | 14051 | 1.832762239176059
2006 | 794026 | 13318 | 1.705887476495694
2007 | 802639 | 8613 | 1.084725185321388
2008 | 818443 | 15804 | 1.969004745595467
2009 | 832368 | 13925 | 1.701401319334395
2010 | 843316 | 10948 | 1.315283624550679
2011 | 854265 | 10949 | 1.298327080240385
2012 | 863561 | 9296 | 1.088186920920323
Spreadsheet: john_griffith__16092__1_17_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 225 | 23 | 24 | 73.9 | 77.1 | 10.68 | 2002-01-17 14:54:00
 | NG H2 | 225 | 37 | 37.5 | 63.4 | 64.3 | 9.03 | 2002-01-17 14:54:00
 | NG J2 | 230 | 40 | 42 | 51.3 | 53.9 | 7.61 | 2002-01-17 14:54:00
 | NG K2 | 235 | 46 | 47 | 48 | 49 | 7.17 | 2002-01-17 14:54:00
 | NG M2 | 240 | 51 | 53 | 45.2 | 47 | 6.96 | 2002-01-17 14:54:00
 | NG N2 | 250 | 58.5 | 60 | 45.4 | 46.6 | 7.23 | 2002-01-17 14:54:00
 | NG Q2 | 255 | 66 | 68 | 46.2 | 47.6 | 7.52 | 2002-01-17 14:54:00
 | NG U2 | 255 | 70.5 | 73 | 45.8 | 47.5 | 7.48 | 2002-01-17 14:54:00
 | NG V2 | 255 | 77 | 79 | 47.3 | 48.5 | 7.68 | 2002-01-17 14:54:00
 | NG X2 | 280 | 89 | 91 | 47.1 | 48.1 | 8.38 | 2002-01-17 14:54:00
 | [NAME] | 300 | 100 | 103 | 47.3 | 48.7 | 9.05 | 2002-01-17 14:54:00
 | NG F3 | 305 | 108 | 112 | 48.3 | 50.1 | 9.43 | 2002-01-17 14:54:00
 | NG H3 |  |  |  |  |  |  | 2002-01-14 14:57:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 804644d1668195490-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-mmjj-drivosity-scores-test
Sheet: 1556

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | Freit |  |  | 94 | 0.82 | 94 | 1.13 | 98 | 0.65 | 94 | 1.09
Jessica | Gonzales |  |  | n/a | n/a | n/a | n/a | n/a | n/a
[NAME] | [NAME] |  |  | 89 | 1.63 | 93 | 1.12 | 81 | 2.3 | 85 | 2.29
[NAME] | Lewis |  |  | n/a | n/a | n/a | n/a
Vincent | Sbarro |  |  | n/a | n/a | 95 | 0.94 | n/a | n/a | n/a | n/a
 | Store Average
Spreadsheet: 34bee26d-cdd9-43f1-b31f-29d369262841
Sheet: Sheet3

PENGUMUMAN
RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PADA DINAS KESEHATAN  KOTA CILEGON TAHUN ANGGARAN 2013
[NAME] : 027 /                   /Dinkes
Disampaikan kepada seluruh Penyedia Barang/Jasa, bahwa pada [NAME] 2013, [NAME] Cilegon yang beralamat di :  Jl.[NAME]   akan
menyelenggarakan kegiatan [NAME]/jasa sebagai berikut:
NO |  |  | PAKET PEKERJAAN |  |  | CARA | VOLUME |  |  |  | RENCANA PENGANGGARAN |  |  | PERKIRAAN WAKTU | LAMA WAKTU
 | NAMA |  | YANG AKAN |  |  | PENGADAAN |  |  | LOKASI |  | PERKIRAAN |  | SUMBER | MULAI PELAKSANAAN | PELAKSANAAN
 | KEGIATAN |  | DILAKSANAKAN |  |  |  |  |  | PEKERJAAN |  | BESARAN |  | DANA | PENGADAAN
 |  |  |  |  |  |  |  |  | (Provinsi, [NAME]) |  | BIAYA (Rp) |  |  | ([NAME])
1 | 2 |  | 3 |  |  |  | 4 |  | 5 |  | 6 |  | 7 | 10 | 11
Pelaksanaan pengadaan barang/jasa serta persyaratan calon penyedia barang/[NAME] waktu penyelenggaraan akan diumumkan lebih lanjut
 |  |  |  |  |  |  |  |  |  |  |  |  | Cilegon,     [NAME]  2012
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] CILEGON
 |  |  |  |  |  |  |  |  |  |  |  |  | SELAKU PENGGUNA ANGGARAN
 |  |  |  |  |  |  |  |  |  |  |  |  | Hj. S U M I N A R, SE
 |  |  |  |  |  |  |  |  |  |  |  |  | NIP. 19570420 197610 2 001
[NAME]:
• | kolom 1 diisi nomor urut
• | kolom 2 diisi nama kegiatan
• | kolom 3  diisi nama paket [NAME] ada dalam kegiatan tersebut pada kolom 2
• | [NAME] cara pengadaan, misal : [NAME], [NAME],seleksi umum,seleksi sederhana,[NAME], dll
• | [NAME] volume dari paket tersebut pada kolom 3 dengan mencantumkan jmlh paket(misal 1 paket,2 paket,dll)
• | kolom 6  diisi lokasi pekerjaan tersebut dengan menyebitkan provinsi [NAME]
• | kolom 7  diisi perkiraan biaya berdasarkan [NAME]
• | [NAME] sumber pendanaan pekerjaan misal:APBN/APBD,Pinjaman/Hibah Luar Negeri
• | [NAME] perkiraan waktu mulai pelaksanaan [NAME] menyebutkan [NAME]
• | [NAME] waktu pelaksanaan kegiatan
Spreadsheet: 48338d1247566113-changing-a-cell-reference-sample
Sheet: Actual

Actual | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Sales of Item 1 | 80 | 81 | 99 | 100
Sales of Item 2 | 40 | 50 | 99 | 115
Costs | 55 | 9 | 9 | 4
Expense Other | 6 | 9 | 10 | 10
Spreadsheet: 119206d1314269950-duplicate-name-generation-duplicate-name-generation
Sheet: Sheet1

Name | Duplicate count formula |  | Name without duplicate and blank row
Accession | 1 | Accession | Accession | [NAME] is required in column No.F
APJ print world | 1 | APJ print world | APJ print world | In Column F blank should not be there, [NAME] name should there without any blank
Brainy Bytes | duplicate |  | Brainy Bytes
Creative Enterprises | dupicate |  | Creative Enterprises
Digital park | dupicate |  | Digital park
Brainy Bytes | 1 | Brainy Bytes
Creative Enterprises | 1 | Creative Enterprises
Digital park | 1 | Digital park
Spreadsheet: 138093d1327510505-many-if-statements-ef16a_sample2
Sheet: Sheet1

System | Type | ABC |  | $ | XYZ |  | $ |  | System | Type | Category
 |  |  |  |  |  |  |  |  | System <5 | A | ABC
System <5 | A | 10 |  | 10 | 10.2 |  | 11 |  | 5 <System <10 | B | XYZ
 | B | 10.5 |  | 15 | 10.7 |  | 16 |  | System >10
5 <System <10 | A | 11 |  | 20 | 11.2 |  | 21
 | B | 11.5 |  | 25 | 11.7 |  | 26
System >10 | A | 12 |  | 30 | 12.2 |  | 31
 | B | 12.5 |  | 35 | 12.7 |  | 36
System | System <5 | <-Inputs
Type | A
Category | ABC
ABC/XYZ |  | <-Outputs
$
Spreadsheet: eric_saibi__9700__010302R
Sheet: Salem 02

Owner Name |  | PSEG Power LLC
Station Name |  | Salem Nuclear Power Station
Unit Name |  | Salem 02
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1170 MW
Start Date |  | 2001-12-31 00:00:00
End Date |  | 2002-01-02 00:00:00
Prv. Start Date |  | 2001-12-31 00:00:00
Prv. End Date |  | 2002-01-06 00:00:00
Comments |  | Unit tripped due to a pressure spray valve that got stuck in the open position & should be at 100% late today.
SIC |  | 4911
Plant ID |  | 1018459
Unit ID |  | 1004470
Outage ID |  | 19325
Spreadsheet: f27ac86a-c2bf-405e-af5c-5908b3560843
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7694 | 51796 | [NAME] | [NAME] | RSA | 0 | 00:08:22 | 00:00:00 | 00:37:42 | 00:00:00 | [NAME] | 1 | [NAME]
7694 | 57721 | Marlette | Smit | RSA | 0 | 00:07:32 | 00:00:00 | 00:37:07 | 00:00:00 | [NAME] | 2 | 01:02:18
7694 | 30809 | Charne | Prinsloo | RSA | 0 | 00:07:36 | 00:00:00 | 00:41:11 | 00:00:00 | 00:17:48 | 3 | 01:06:37
Spreadsheet: 847790d1698662662-combine-functions-to-return-the-right-values-from-a-matrix-excelforum_1
Sheet: Calendar 1

 |  |  |  |  |  |  |  |  |  |  |  | Function not working → |  |  |  | [NAME] not working
 | MATRIX |  |  |  |  |  |  |  |  |  |  | RETURN VALUES FROM THE MATRIX
 | ↓ |  |  | ↓ |  |  | ↓ |  |  | 2023-10-04 00:00:00
 | Unit | Position | Shift | Staff | 2023-10-01 00:00:00 | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-31 00:00:00 | Oct |  | Day: | 2023-10-03 00:00:00
 | 2C | Position1 | M | Employee 01 | 2C |  | 2C | 2C
 | 3P | Position1 | E | Employee 02 |  | 3P | 3P |  |  |  |  | 2C |  |  | 4C
 | 4C | Position1 | N | Employee 03 | 4C |  | 4C | 4C |  |  |  |  | Employee 04 |  |  | Employee 06
 | 2C | Position1 | M | Employee 04 | 2C | 2C | 2C |  |  |  |  |  | Employee 15
 | 3P | Position1 | E | Employee 05 |  | 3P
 | 4C | Position1 | N | Employee 06 | 4C |  | 4C
 | FLO | Position1 | M | Employee 07 | FLO |  | FLO | FLO
 | 3P | Position1 | E | Employee 08 | HOL | HOL | 3P |  |  |  |  | 3P |  |  | FLO
 | 4C | Position1 | N | Employee 09 | VAC | VAC | VAC | VAC | VAC |  |  |  | Employee 08 |  |  | Employee 11
 | 2C | Position1 | M | Employee 10 | 2C | SICK | SICK | SICK |  |  |  |  | Employee 12 |  |  | Employee 16
 | FLO | Position1 | M | Employee 11 | FLO |  | FLO |  | FLO |  |  |  | Employee 14
 | 3P | Position1 | M | Employee 12 | 3P |  | 3P
 | 2C | Position1 | M | Employee 13 |  | 2C
 | 3P | Position1 | M | Employee 14 | 3P |  | 3P |  |  |  |  | VAC |  | HOL |  | Sick
 | 2C | Position1 | M | Employee 15 | 2C | 2C | 2C
 | FLO | Position1 | M | Employee 16 | FLO |  | FLO |  | FLO |  |  | Employee 18
 | 2C | Position1 | M | Employee 17 |  | 2C
 | 3P | Position1 | M | Employee 18 | VAC | VAC | VAC | VAC | VAC
Spreadsheet: 138802d1327916787-not-able-to-get-sum-of-my-values-in-a-coloumn-bcoz-of-null-value-n-a-in-d-same-colo-aif300112
Sheet: Reports

 | Customer ID | Customer Name | Net [NAME] | Cash Recived | Cash Pending | No of Candy Pack Sold | Returned Candy Packs | no of sales visit made | no of times the candy packs returned
 | 001-001 | ABC Stores | 130 | 130 | 0 | 15 | 2 | 2
 | 001-002 | [NAME] and [NAME] | 300 | 300 | 0 | 30 | 0 | 3
 | 001-003 | Kids World | 200 | 200 | 0 | 25 | 0 | 3
 | 001-004 | Fun Time | 480 | 480 | 0 | 40 | 0 | 4
 | 001-005 | Animalz | 120 | 120 | 0 | 10 | 0 | 2
 | 001-006 | Kids Corners | 144 | 144 | 0 | 12 | 0 | 2
 | 001-007 | Kidddies | 290 | 290 | 0 | 30 | 1 | 2
 | 001-008 | The Family Shop | 180 | 180 | 0 | 15 | 0 | 2
 | 001-009 | The Roundabout | 0 | 0 | 0 | 0 | 0 | 0
 | 001-010 | Walky | 0 | 0 | 0 | 0 | 0 | 0
 | 001-011 | Rainbow | 132 | 132 | 0 | 12 | 0 | 2
 | 001-012 | Kids Park | 108 | 108 | 0 | 12 | 0 | 2
 | 001-013 | Fun Park | 0 | 0 | 0 | 0 | 0 | 0
 | 001-014 | The Sea Side | 0 | 0 | 0 | 0 | 0 | 0
 | 001-015 | [NAME] | 180 | 180 | 0 | 15 | 0 | 2
 | 001-016 | The Sunny | 0 | 0 | 0 | 0 | 0 | 0
 | 001-017 | Romantic | 143 | 143 | 0 | 13 | 0 | 2
 | 001-018 | Seasons | 80 | 80 | 0 | 10 | 0 | 2
 | 001-019 | Paragon | 300 | 300 | 0 | 25 | 0 | 1
 | 001-020 | Sagar | 324 | 324 | 0 | 27 | 0 | 2
Spreadsheet: 788009d1658224559-help-with-index-match-against-a-partial-match-test1
Sheet: Report

 |  |  |  | 3 No. | 79 Sell-to Customer Name | 11013507 Salesperson Code (Intern)
Spreadsheet: 49399d1248765650-sum-total-consultant-income
Sheet: Sheet1

Total Seat Cost per month | 1688402
Seat Cost Per Agent | 35923.45
Desired Apps required Per Day | 10
Desired Cost Per Application | 290
Number of Working Days | 20
Actual Apps Per Day | 8
Apps per Month | 160
[NAME] | 0.55
Cards Issued | 88
Cost Per Card Achieved | 408.2210227272727
Spreadsheet: 116674d1311975639-selective-columns-priors-hall
Sheet: Mj

Marvesley. J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 090e2ff5-230a-4758-af6d-e5f00cd1ce64
Sheet: Del Tax General Obligation Note

WASHTENAW  COUNTY  DELINQUENT  TAX  NOTES
Debt Service Schedule
2012-12-31 00:00:00
 | Del Tax 5320 |  | Del Tax 5231 |  | Total
 | Principal | Interest | Principal | Interest | Principal | Interest
2013 | 8000000 | 80250 | 6000000 | 68625
2014 | 4000000 | 31500 | 1500000 | 12375
Balance at 12-31-12
Del Tax 5320
Issuance Date | 2012-05-30 00:00:00
Issuance Amount | 20000000
Balance 12/31/12 | 12000000
Del Tax 5231
Issuance Date | 2011-05-19 00:00:00
Issuance Amount | 27500000
Balance 12/31/12 | 7500000
Repayment Source:
delinquent tax revenues are pledged to repay the delinquent tax notes.
Spreadsheet: 686910d1594868477-how-to-differentiate-exactly-word-with-and-no-on-the-data-to-countif-iferror-and-vlook-match-data
Sheet: Sheet1

DATA | Enter Sheet2 | Entry Sheet3 | Entry Sheet4 | Match Sheet2 | Match Sheet3 | Match Sheet4 | TOTAL Match From Every Sheet
KOSSAN
TOPGLOV
DUFU* |  |  |  |  |  |  |  | Wrong at Entry Sheet Because DUFU* is different with DUFU & Total Match Should be 1
DUFU
DIALOG
SUPERMX*
MI* |  |  |  |  |  |  |  | Wrong at Entry Sheet Because MI* is different with MI & Total Match Should be 1
MI
HARTA
 | HIGHLIGHT BLUE WAS RIGHT
 | HIGLIGHT WAS WRONG
Spreadsheet: 182756d1348594431-indicate-duplicate-with-small-time-span-id-start-date-stop-date-columns-duplicates-with-varying-date-ranges
Sheet: Sheet1

ID # | Start Date | Stop Date
1 | 2012-08-01 00:00:00 | 2012-08-01 00:00:00
2 | 2012-08-03 00:00:00 | 2012-08-05 00:00:00
4 | 2012-08-01 00:00:00 | 2012-08-12 00:00:00
5 | 2012-08-01 00:00:00 | 2012-08-16 00:00:00
3 | 2012-08-19 00:00:00 | 2012-08-24 00:00:00
2 | 2012-08-01 00:00:00 | 2012-08-05 00:00:00
7 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00
3 | 2012-08-15 00:00:00 | 2012-09-01 00:00:00
8 | 2012-09-01 00:00:00 | 2012-09-03 00:00:00
5 | 2012-08-01 00:00:00 | 2012-08-03 00:00:00
7 | 2012-08-28 00:00:00 | 2012-08-30 00:00:00
1 | 2012-08-01 00:00:00 | 2012-08-11 00:00:00
I have a data set where certain ID #s appear twice.
I need to write a formula in Column D that will indicate the row, that if the
ID # is a duplicate, has the lower amount of days between start date and stop date.
Thanks all!