How to find out who retired Vkontakte?
The majority of Vkontakte users in the list of friends can count thousands of acquaintances, some can even exceed tens of thousands, there are also more modest people who have no more than 30 acquaintances. But each of them wants to be aware of the changes among his friends. Regardless of how many and how well they are familiar. How many friends would you have, you always wondered how to find out who retired Vkontakte? Who added you to your list and who deleted. How to find out who retired and who added? Here is a question constantly worrying many users. There are several options for how to solve this issue.
With Excel spreadsheet
With the help of an Excel spreadsheet, you can easily find out who your friends have retired and who have added. To do this, open Excel 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 network Vkontakte. You will have a column of first and last names. In the first column, enter the date when your list was created and save the file.After a few days, open your document and in the next column enter the next list of your friends. In one of the columns should be a list for one day and the other for the next.
We proceed to the comparison of the two columns. Friends in the second column and not in the first column are friends who have been 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 retired from the list.
If you need to know who added, use the following formula: = VLOOKUP (B2; $; $ A $ 2: $ A $ 11; 1; FALSE). This formula is available only in English-language Excel. In the Russian version, enter the formula in Cyrillic: VPR () - is similar to writing in the Latin alphabet: VLOOKUP (). The only thing that is inconvenient, if you have a thousand friends, this method will not work. Then how to find out who retired VKontakte, if you have a lot of friends?
In this situation, you can use the application that automatically calculates how many people you have in the list. It is called "My Friends". Everything you need to 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.
The social network Vkontakte also provides an opportunity to follow the list of your friends. After one of the friends has retired, you will find it in the "friends", "friend requests", "outgoing requests" section. There will be the person who may have deleted you or not yet added. Deciding who did not add, and who deleted, will not be so difficult.
Using these options, it is now easy to find out how to find out who retired VKontakte or added as a friend. Choose the most suitable option for you personally, the one that will be more convenient. And always be aware of changes among your contacts.