Курманбек Жолдошев

{"header":{"subsiteData":{"id":183410,"name":"\u041a\u0443\u0440\u043c\u0430\u043d\u0431\u0435\u043a \u0416\u043e\u043b\u0434\u043e\u0448\u0435\u0432","karma":25,"subscribers":{"count":0,"url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/details\/subscribers"},"isVerified":false,"isPlus":false,"isMe":false},"stats":[{"icon":"ui_egg","label":"\u041d\u0430 \u043f\u0440\u043e\u0435\u043a\u0442\u0435 \u0441 1 \u0438\u044e\u043b 2018"}],"cover":"","coverPositionY":0,"avatar":"ff5a78ad-4417-c00e-940e-8ad4ef289979","avatarSize":[0,0],"description":"","tabs":[{"url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries","label":"\u0421\u0442\u0430\u0442\u044c\u0438","analytics":"Articles","minCount":0,"isActive":true,"counter":1},{"url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/comments","label":"\u041a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0438","analytics":"Comments","minCount":0,"isActive":false,"counter":14},{"url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/details","label":"\u041f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435","minCount":0,"analytics":"Details","isActive":false,"counter":0}],"isVideoCover":false,"isAvatarChangeAvailable":false,"isCoverChangeAvailable":false,"isDescriptionChangeAvailable":false,"detailsUrl":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/details"},"hasCustomCss":false,"hasCustomHtml":false,"actions":{"subscribe":{"id":183410,"isSubscribed":false,"isNotificationsEnabled":false}},"etcControls":null}

{
            "config": {"baseUrl":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries","active":"new","items":[],"filters":[{"label":"\u041f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0435","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/popular","isActive":false,"children":[{"label":"\u041f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0435","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries","isActive":false},{"label":"\u0417\u0430 \u0434\u0435\u043d\u044c","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/top\/day","isActive":false},{"label":"\u0417\u0430 \u043d\u0435\u0434\u0435\u043b\u044e","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/top\/week","isActive":false},{"label":"\u0417\u0430 \u043c\u0435\u0441\u044f\u0446","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/top\/month","isActive":false},{"label":"\u0417\u0430 \u0433\u043e\u0434","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/top\/year","isActive":false},{"label":"\u0417\u0430 \u0432\u0441\u0435 \u0432\u0440\u0435\u043c\u044f","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/top\/all","isActive":false}]},{"label":"\u0421\u0432\u0435\u0436\u0435\u0435","url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/entries\/new","isActive":true}],"tags":[]}        }

Вопросы

Курманбек Жолдошев

12.10.2020

Удаление дубликатов в Excel

Помогите как в экселе удалить дубликаты которые находятся в списке таким образом:

Колонка1, Колонка2

4 4 комментария

{"id":166177,"url":"https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel","title":"\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0432 Excel","services":{"facebook":{"url":"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel","short_name":"FB","title":"Facebook","width":600,"height":450},"vkontakte":{"url":"https:\/\/vk.com\/share.php?url=https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel&title=\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0432 Excel","short_name":"VK","title":"\u0412\u041a\u043e\u043d\u0442\u0430\u043a\u0442\u0435","width":600,"height":450},"twitter":{"url":"https:\/\/twitter.com\/intent\/tweet?url=https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel&text=\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0432 Excel","short_name":"TW","title":"Twitter","width":600,"height":450},"telegram":{"url":"tg:\/\/msg_url?url=https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel&text=\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0432 Excel","short_name":"TG","title":"Telegram","width":600,"height":450},"odnoklassniki":{"url":"http:\/\/connect.ok.ru\/dk?st.cmd=WidgetSharePreview&service=odnoklassniki&st.shareUrl=https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel","short_name":"OK","title":"\u041e\u0434\u043d\u043e\u043a\u043b\u0430\u0441\u0441\u043d\u0438\u043a\u0438","width":600,"height":450},"email":{"url":"mailto:?subject=\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0432 Excel&body=https:\/\/vc.ru\/ask\/166177-udalenie-dublikatov-v-excel","short_name":"Email","title":"\u041e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u044c \u043d\u0430 \u043f\u043e\u0447\u0442\u0443","width":600,"height":450}},"isFavorited":false}

–1

{"id":183410,"url":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev","name":"\u041a\u0443\u0440\u043c\u0430\u043d\u0431\u0435\u043a \u0416\u043e\u043b\u0434\u043e\u0448\u0435\u0432","loginedUserId":0,"isMe":false,"description":"","subscribers":{"items":[],"lastId":0,"lastSortingValue":0},"subscriptions":{"items":[{"label":"\u0422\u0440\u0430\u043d\u0441\u043f\u043e\u0440\u0442","image":"https:\/\/leonardo.osnova.io\/27e55426-d8d8-51a2-cc6e-45dadfeeda28\/","url":"https:\/\/vc.ru\/transport","id":199115,"isSubscribed":false},{"label":"\u0422\u0435\u0445\u043d\u0438\u043a\u0430","image":"https:\/\/leonardo.osnova.io\/3e8b2dda-7cf9-8651-c3d2-40a3cedec8d3\/","url":"https:\/\/vc.ru\/tech","id":199117,"isSubscribed":false},{"label":"\u041b\u0438\u0447\u043d\u044b\u0439 \u043e\u043f\u044b\u0442","image":"https:\/\/leonardo.osnova.io\/6cdffc57-5615-d791-e474-c396dbb18c8e\/","url":"https:\/\/vc.ru\/life","id":199123,"isSubscribed":false},{"label":"SEO","image":"https:\/\/leonardo.osnova.io\/af5b898a-6c13-81da-8b48-37ebb3e08cc1\/","url":"https:\/\/vc.ru\/seo","id":199127,"isSubscribed":false},{"label":"\u0412\u043e\u043f\u0440\u043e\u0441\u044b","image":"https:\/\/leonardo.osnova.io\/beb4ac77-dde0-a240-b186-ca042f647e1f\/","url":"https:\/\/vc.ru\/ask","id":199125,"isSubscribed":false}],"page":2,"count":25},"rules":[],"contacts":[{"label":"\u041a\u0443\u0440\u043c\u0430\u043d \u0416\u043e\u043b\u0434\u043e\u0448\u0435\u0432","url":"https:\/\/www.facebook.com\/app_scoped_user_id\/YXNpZADpBWEZAOYlItSmZAEbmtJbEhNSlVGYzBfdjE1RG1FQkh4M3d2VnpwdzBrdUhZAdHNBZAldkZA20xVnZAPSS1KT0tOcENxWW15cFF4V2kyOFdIRzlQb256SGN6OHd5c2VKRy1ZAZAUpHRHkwTkg2NGRocjJ2RTQz\/","icon":{"name":"ui_facebook","width":8,"height":14}}],"counters":{"subscribers":0,"subscriptions":25},"dummy":{"subscribers":"\u0423 \u0431\u043b\u043e\u0433\u0430 \u0435\u0449\u0451 \u043d\u0435\u0442 \u043f\u043e\u0434\u043f\u0438\u0441\u0447\u0438\u043a\u043e\u0432"},"detailsTabBaseUri":"https:\/\/vc.ru\/u\/183410-kurmanbek-zholdoshev\/details"}

Комментарии