aynı karakterleri silme

[esintemel]

acil..excelde her satırda farklı farklı numaralar var. fakat bazı satırlarda aynı numaralar var bunları tek seferde nasıl silebilirim. liste yaklaşık 6000 satır.
teşekkürler.

 

[serqet]

değiştirmek istediğiniz alanı seçin, ctrl+f ye basın aranan kısmına silmek istediğiniz değeri yazın altına birşey yazmadan tamam deyin.

 

[esintemel]

teşekkürler
fakat silmem gereken yaklaşık 200 numara var tek tek silmek yerine çok lu nasıl silebilirim. eklenti de listenin bir örneği mevcut.

 

[serqet]

teşekkürler
fakat silmem gereken yaklaşık 200 numara var tek tek silmek yerine çok lu nasıl silebilirim. eklenti de listenin bir örneği mevcut.

Tam olarak neyi sileceksiniz bu listeden?

 

[Ömer]

Merhaba,

Veriler tekrarsız farklı bir sütunuma aktarılacak yoksa tekrarlı olan verilerin bulunduğu satır mı silinecek ? Silme olursa tüm satırdamı olacak yoksa ilgili hücre yukarı sürüklenerek mi olacak.

.

 

[serqet]

Buyrun.

102024596
102024597
102025564
102025565
102025566
102026014
102026015
102026016
102026017
102026018
102914807
102917110
102918071
102919396
102919424
102919496
102919560
103040019
103040175
103040195
103041835
103044261
103044838
103044957
103045748
103048145
103049755
103060019
103060101
103060187
103060206
103060213
103060246
103060266
103060314
103060331
103060359
103060397
103060459
103060527
103060540
103060596
103060627
103060731
103060955
103061123
103061175
103200021
103250018
103410002
103917285
103919399
103920545
104062230
104062232
104062496
104062497
104063291
104914556
104914557
104914558
104914559
104914572
104914573
104914982
104915271
104915610
104915771
104915772
104915823
104916096
104916097
104916476
104917252
104918902
104918903
104919097
106030327
106030961
106030967
106031430
106031556
106031713
106032199
106032200
106034791
106913975
107911528
107913171
107913920
109096903
109096938
109096972
109097018
109097027
109097032
109097035
109097076
109097085
109097109
109097162
109097381
109130073
109911575
109912519
109916048
109916057
109916344
109916421
109916660
109916780
109916810
109916834
109916980
109917013
109919104
109919137
111110379
111110469
111913199
112121600
112910471
112910987
112913083
112914679
113131449
113911214
113911342
113911343
113911903
113911917
113912606
113913080
113913899
113913946
113914098
113921636
113922143
123030009
123230663
123230764
131310076
131310092
131310094
131310119
131310176
131310177
145030007
159000336
181910288
181910457
181910663
181910728
181910794
181910890
181910923
181910931
181911027
181911158
181911227
181911263
181911283
181911316
181911590
181911653
181911732
181911747
181911857
181912132
181912811
181913408
181913480
181913592
181913597
181913622
181913908
181914121
181914212
181914264
181914409
181914586
181914834
181914865
181914982
181915111
181915137
181915155
181915234
181915344
181915357
181915499
181915709
181915753
181915977
181916146
181916328
181916522
181916652
181916978
181917561
181917741
181918173
181918425
181919013
181919451
181919540
181919541
181919800
1590000034
1590000035
1590000114
1590000336
1590000377
1590000600
1590000616
1590000664
1590000667
1800012041
1800012042
1801161321
1801224721
1801302136
1806266217
1806313828
1806337358
1806706519
1806904755
1807028923
1807037272
1807041077
1807054766
1807056942
1807056951
1807057437
1807057603
1807063119
1807080930
1807080936
1807082449
1807128121
1807132321
1807132334
1807134167
1807135112
1807146872
1807163081
1807163082
1807163083
1807163088
1807181078
1807189179
1807191032
1807192197
1807192571
1807204333
1807209738
1807211601
1807227991
1807229519
1807236733
1807240481
1807249426
1807251370
1807252258
1807297177
1807297800
1807297807
1807297813
1807297961
1807312352
1807312360
1807338775
1807345622
1807381901
1807399209
1807424102
1807430527
1807436025
1807441152
1807443843
1807445199
1807446850
1807475116
1809007261
1809044734
1810258243
1816253928
1816269059
1816358717
1816626061
1821046022
1821067973
1826007951
1833243734
1834063137
1834223105
1834416383
1834693917
1834693933
1834708164
1834709246
1834763507
1834940974
1834994611
1834998390
1835080328
1835080329
1835150248
1835162712
1835162713
1835218004
1835289595
1835289596
1835289597
1835299175
1835342017
1835426537
1835433729
1835433742
1835433743
1835444768
1835444771
1835453937
1835456919
1835456923
1835468230
1835472547
1835472602
1835472804
1835476414
1835522790
1835528544
1835528545
1835532228
1835541089
1835592665
1835615268
1835615324
1835618333
1835633670
1835634994
1835653779
1835707534
1835713559
1835740684
1835758466
1835768235
1835802313
1835815215
1835827629
1835830988
1835830991
1835834114
1835837082
1835837827
1835851161
1835880074
1835946120
1841033536
1841168039
1844043801
1844114412
1845083470
1848004933
1848004935
1848081356
1848085985
1848131143
1848139257
1848139506
1848139508
1848141526
1848153030
1848165223
1848208007
1848230617
1848236533
1854038697
1855116580
1855126959
1855133246
1855158126
1855159454
1859014910
1859087552
1861068835
1861102035
1877039318
1890015071
1890015138
1890015139
1890065270
1890065332
1890065758
1890065962
1890065963
1890066039
1890070054
1890075010
1890075029
1890075030
1890075040
1890075096
1890075109
1890165142
1890215138
1890345060
1890345062
1890345105
1890345430
1890345542
1890345562
1890345612
1890345642
1890345738
1890345815
1890345832
1890345843
1890350012
1890355009
1890355088
1890355194
1890355303
1890485026
1890545017
1890555107
1890590008
1890615043
1890990065
1890990530
1890990837
1890990909
1890995075
1890995495
1890995496
1890995524
1890995695
1890995864
1890995961
1890996003
1890996080
1890996176
1890996240
1890996397
1890996422
1890996430
1890996534
1890996553
1890996652
1892599323
1893008647
1893019481
1893054568
1893055924
1893088929
1893134324
1894021766
1894021769
1894021778
1894043728
1894055557
1894057682
1894059244
1894062214
1894117300
1894126250
1894141617
1894150553
1894155243
1894155409
1894159642
1894205994
1894251008
1894270415
1894284874
1894341432
1894341436
1894361580
1894368095
1894393509
1894442687
1894470751
1894567108
1894571568
1894614764
1894638258
1894660194
1894660296
1894679635
1894701660
1894703095
1894732168
1894758309
1894777829
1894839298
1894896098
1897006442
1897019940
1897022817
1897023220
1897031892
1897034013
1897041538
1897044230
1897081336
1897082292
1897136010
1897186061
1897295652
1897393443
1897403035
1897418593
1897423036
1897440700
1897455095
1897470472
1897505997
1897513761
1897517333
1897532212
1897551009
1897581523
1897581657
1897582866
1897608375
1897663700
1897673029
1897702070
1897823018
1897839641
1897855522
1898003326
1898024540
1898024568
1898040246
1898080710
1898090402
1898100172
1898233007
1898278231
1898330837
1898463144
1898463161
1898472184
1898474184
1898474224
1898510377
1898517697
1898535171
1898535180
1898537705
1898555284
1898608597
1898630989
1898633097
1898635913
1898641697
1898658046
1898660072
1898660086
1898673384
1898687281
1898695837
1898700716
1898717096
1898734784
1898739876
1898792280
1898802199
1898803534
1898834364
1898836829
1898839090
1898850390
1898904982
1898904994
1898908386
1898908394
1898908401
1898909068
1898909071
1898909131
1898912651
1898945135
1898945138
1898957774
1898982540
1899082746
1899137441
1899342667
1899343021
1899411510
1899643483
1899780388
1904115893
1906515151
2324550001
2324554080
2422990015
2422990030
3121505005
3623531080
3623531220
4422991003
4422991004
8104608780
8104608979
10000000966
10000001143
10000001253
10000001775
10000001996
10000002142
10000003524
10000003656
10000004372
158200000035

 

[esintemel]

excel karıştırırken buldum verinin altında yinelenenleri kaldır diye bir bölüm vardı oradan yaptım oldu.
çok teşekkür ederim.