How to Know Who Deleted You on Facebook

Step-by-Step Guide

1. 1

   Step 1: Go to facebook.com.

   Log into your account if you aren't logged in automatically.
2. 2

   Step 2: Click the arrow icon.

   This is the downward pointing triangle located at the top right, next to the 'Privacy Shortcuts' icon. ,, This is at the bottom of the general account settings page. ,,, You should soon receive the email ‘Your Facebook download is ready’ at your associated email address. ,, This is at the bottom of the email. , Clicking this will download a folder titled 'Facebook*YourName*'. ,,,, Starting at the top of your friends list, click and drag your mouse down until you reach the bottom of the list. , To copy, press Ctrl+C (PC) or ⌘ Cmd+C (Mac). ,,, To paste, press Ctrl+V (PC) or ⌘ Cmd+V (Mac).
   
   If you are using Excel, save your file here as well. , Refer to part I. , Refer to part II here, specifically steps 1-5. ,,,, To paste, press Ctrl+V (PC) or ⌘ Cmd+V (Mac). ,, This is a vlookup function targeting cell A1, searching for your friend's name in all of column B, and only looking for exact matches. ,, This is a small green square located at the bottom right of a highlighted cell. , Drag with your cursor down column C until there is a vlookup formula in column C for every name in column A. , A vlookup formula that returns an ‘#N/A’ value means that the associated friend's name in column A was not found in your new friends list.
3. 3

   Step 3: Click 'Settings'.

4. 4

   Step 4: Click 'Download a copy of your Facebook data'.

5. 5

   Step 5: Click 'Start My Archive'.

6. 6

   Step 6: Enter your password.

7. 7

   Step 7: Wait for an email.

8. 8

   Step 8: Open the email.

9. 9

   Step 9: Click the link.

10. 10

    Step 10: Click 'Download Archive'.

11. 11

    Step 11: Open your downloaded Facebook folder.

12. 12

    Step 12: Open the html folder.

13. 13

    Step 13: Open the friends file.

14. 14

    Step 14: Highlight your friends list.

15. 15

    Step 15: Copy your list.

16. 16

    Step 16: Open Excel or Google Sheets.

17. 17

    Step 17: Click cell A1.

18. 18

    Step 18: Paste your list.

19. 19

    Step 19: Download another friends list.

20. 20

    Step 20: Copy your new friends list.

21. 21

    Step 21: Open Excel/Google Sheets.

22. 22

    Step 22: Click your friends list file.

23. 23

    Step 23: Click cell B1.

24. 24

    Step 24: Paste your new list.

25. 25

    Step 25: Click cell C1.

26. 26

    Step 26: Enter =VLOOKUP(A1

27. 27

    Step 27: FALSE).

28. 28

    Step 28: Click cell C1 again.

29. 29

    Step 29: Click and hold on the square icon.

30. 30

    Step 30: Drag your cursor down the column.

31. 31

    Step 31: Look for #N/A values.

Detailed Guide

About the Author