How to find out who has deleted Vkontakte?

Most users of Vkontakte in the listfriends can count thousands of friends, some can even exceed tens of thousands, there are more modest people who have a maximum of 30 acquaintances. But each of them wants to be aware of the changes among his friends. Regardless of how much of them and how well they are familiar. No matter how many Friends you had, you were always interested in how to find out who had retired Vkontakte? Who added you to your list and who deleted it. How do you know who left and who was added? That's the question that constantly excites many users. There are several options for how to solve this issue.

With the Excel table

Using the Excel spreadsheet, you can easily find out whoof your acquaintances retired and who was added. To do this, open the Excel program and drag your friends list from the network to the table. To facilitate this operation, you can use the export of your data from the Vkontakte network. You will have a column of names and surnames. In the first column, enter the date when your list was created and save the file. After a few days, open your document and enter the next list of your friends in the next column. In one of the columns there should be a list in one day and in the other for the next.

Let's start comparing two columns. Friends who are in the second column and not in the first are friends who have added to you. To compare two columns, we can use the Excel function VLOOCUP (). To do this, write down the formula in the first cell of the empty column: = VLOOKUP (A2; $ B $ 2: $ B $ 11; 1; FALSE). This formula will show who has retired from the list.

If you need to know who is added, usea formula of the following form: = VLOOKUP (B2; $; $ A $ 2: $ A $ 11; 1; FALSE). This formula is available only in the English-language Excel program. In the Russian version, enter the formula in Cyrillic: VPR () - similar to writing in Latin: VLOOKUP (). The only thing that is inconvenient, if you have a thousand friends this way will not work. Then how to find out who left the VKontakte, if you have a lot of friends?

Special application

In this situation, you can take advantage ofAn application that automatically calculates how many people you have on the list. It is called "My friends". All you need to do is go to the specified application daily. It will track the list automatically. The application itself is available after clicking on the link: http://vkontakte.ru/app662272.

Social network Vkontakte also gives an opportunityfollow the list of your friends. After the removal of one of the friends, you will find it in the "friends", "friend requests", "outgoing applications". There will be that person who may have deleted you or not yet added. Decide who did not add, and who deleted, it will not be so difficult.

Using these options, it is now easy to find out howfind out who left vkontakte or added to friends. Choose the most acceptable option for you personally, the one that will be more convenient. And always be aware of the changes among your contacts.

Related news

How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte How to find out who has deleted Vkontakte