How To Know Who Deleted Me On Facebook: Discovering that unfriended you on Facebook can be challenging to find out on your own given that there is currently no main 'unfriend tracker' in place. With some Excel understanding nevertheless, it is feasible compare an older pals list with a current one as well as quickly deduce who is missing.
How To Know Who Deleted Me On Facebook
1. Go to facebook.com. Log into your account if you typically aren't visited immediately.
2. Click the arrowhead icon. This is the down pointing triangle located on top right, alongside the 'Privacy Shortcuts' symbol.
3. Click 'Settings'.
4. Click 'Download a copy of your Facebook data'. This is at the bottom of the basic account settings page.
5. Click 'Begin My Archive'.
6. Enter your password.
7. Wait on an e-mail. You must quickly receive the email 'Your Facebook download is ready' at your linked email address.
8. Open the email.
9. Click the link. This is at the bottom of the email.
10. Click 'Download Archive'. Clicking this will certainly download a folder entitled 'Facebook * YourName *'.
1. Open your downloaded and install Facebook folder.
2. Open the html folder.
3. Open the buddies documents.
4. Highlight your buddies checklist. Beginning on top of your close friends list, click as well as drag your computer mouse down till you reach the bottom of the listing.
5. Copy your list. To replicate, press Ctrl+ C (COMPUTER) or ⌘ Cmd+ C (Mac).
6. Open Excel or Google Sheets.
7. Click cell A1.
8. Paste your listing. To paste, press Ctrl+ V (PC) or ⌘ Cmd+ V (Mac).
If you are using Excel, conserve your data below as well.
1. Download and install another friends checklist. Describe component I.
2. Replicate your new pals checklist. Refer to part II right here, particularly actions 1-5.
3. Open Excel/Google Sheets.
4. Click your buddies listing file.
5. Click cell B1.
6. Paste your new checklist. To paste, press Ctrl+V (PC) or ⌘ Cmd+V (Mac).
7. Click cell C1.
8. Go Into =VLOOKUP(A1, B: B,1, FALSE). This is a vlookup function targeting cell A1, looking for your close friend's name in all of column B, and just trying to find precise matches.
9. Click cell C1 once again.
10. Click and hold on the square icon. This is a small green square situated at the bottom right of a highlighted cell.
11. Drag your arrow down the column. Drag with your cursor down column C till there is a vlookup formula in column C for each name in column A.
12. Look for #N/ A values. A vlookup formula that returns an '#N/ A' worth indicates that the linked good friend's name in column A was not found in your brand-new close friends list.
