Find out who deleted you facebook

Finding out who unfriended you on Facebook can be difficult to figure out on your own since there is currently no official 'unfriend tracker' in place. With some Excel knowledge however, it is possible compare an older friends list with a current one and quickly deduce who is missing.

Part 1
Downloading Your Facebook Data

  1. Image titled Know Who Deleted You on Facebook Step 1
    1
    Go to facebook.com. Log into your account if you aren't logged in automatically.
  2. Image titled Know Who Deleted You on Facebook Step 2
    2
    Click the arrow icon. This is the downward pointing triangle located at the top right, next to the 'Privacy Shortcuts' icon.
  3. Image titled Know Who Deleted You on Facebook Step 3
    3
    Click 'Settings'.
  4. 4
    Click 'Download a copy of your Facebook data'. This is at the bottom of the general account settings page.
  5. 5
    Click 'Start My Archive'.
  6. 6
    Enter your password.
  7. 7
    Wait for an email. You should soon receive the email ‘Your Facebook download is ready’ at your associated email address.
  8. 8
    Open the email.
  9. 9
    Click the link. This is at the bottom of the email.
  10. 10
    Click 'Download Archive'. Clicking this will download a folder titled 'Facebook*YourName*'.

Part 2
Creating an Excel/Google Sheets Friends List

  1. 1
    Open your downloaded Facebook folder.
  2. 2
    Open the html folder.
  3. 3
    Open the friends file.
  4. Image titled Know Who Deleted You on Facebook Step 14
    4
    Highlight your friends list. Starting at the top of your friends list, click and drag your mouse down until you reach the bottom of the list.
  5. Image titled Know Who Deleted You on Facebook Step 15
    5
    Copy your list. To copy, press Ctrl+C (PC) or  Cmd+C (Mac).
  6. Image titled Know Who Deleted You on Facebook Step 16
    6
    Open Excel or Google Sheets.
  7. Image titled Know Who Deleted You on Facebook Step 17
    7
    Click cell A1.
  8. Image titled Know Who Deleted You on Facebook Step 18
    8
    Paste your list. To paste, press Ctrl+V (PC) or  Cmd+V (Mac).
    • If you are using Excel, save your file here as well.

Part 3
Comparing Friends Lists

  1. 1
    Download another friends list. Refer to part I.
  2. Image titled Know Who Deleted You on Facebook Step 20
    2
    Copy your new friends list. Refer to part II here, specifically steps 1-5.
  3. Image titled Know Who Deleted You on Facebook Step 21
    3
    Open Excel/Google Sheets.
  4. Image titled Know Who Deleted You on Facebook Step 22
    4
    Click your friends list file.
  5. Image titled Know Who Deleted You on Facebook Step 23
    5
    Click cell B1.
  6. Image titled Know Who Deleted You on Facebook Step 24
    6
    Paste your new list. To paste, press Ctrl+V (PC) or  Cmd+V (Mac).
  7. Image titled Know Who Deleted You on Facebook Step 25
    7
    Click cell C1.
  8. Image titled Know Who Deleted You on Facebook Step 26
    8
    Enter =VLOOKUP(A1,B:B,1,FALSE). 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.
  9. Image titled Know Who Deleted You on Facebook Step 27
    9
    Click cell C1 again.
  10. Image titled Know Who Deleted You on Facebook Step 28
    10
    Click and hold on the square icon. This is a small green square located at the bottom right of a highlighted cell.
  11. Image titled Know Who Deleted You on Facebook Step 29
    11
    Drag your cursor down the column. Drag with your cursor down column C until there is a vlookup formula in column C for every name in column A.
  12. Image titled Know Who Deleted You on Facebook Step 30
    12
    Look for #N/A values. 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.
Find out who deleted you facebook Find out who deleted you facebook Reviewed by Efukikata Efet on 08:14 Rating: 5

No comments