See Who Deleted You On Facebook: Figuring out that unfriended you on Facebook can be tough to determine by yourself considering that there is currently no official 'unfriend tracker' in position. With some Excel understanding nevertheless, it is feasible compare an older buddies listing with a current one and also rapidly deduce who is missing out on.
See Who Deleted You On Facebook
1. Most likely to facebook.com. Log into your account if you aren't logged in instantly.
2. Click the arrow symbol. This is the downward directing triangle situated at the top right, alongside the 'Privacy Shortcuts' symbol.
3. Click 'Setups'.
4. Click 'Download a duplicate of your Facebook information'. This is at the bottom of the basic account setups web page.
5. Click 'Begin My Archive'.
6. Enter your password.
7. Wait for an e-mail. You ought to quickly obtain the e-mail 'Your Facebook download prepares' at your linked email address.
8. Open up the email.
9. Click the web link. This is at the bottom of the email.
10. Click 'Download Archive'. Clicking this will download a folder entitled 'Facebook * YourName *'.
1. Open your downloaded Facebook folder.
2. Open up the html folder.
3. Open up the good friends documents.
4. Highlight your friends list. Beginning on top of your friends listing, click and drag your mouse down until you get to all-time low of the listing.
5. Copy your listing. To replicate, press Ctrl+ C (COMPUTER) or ⌘ Cmd+ C (Mac).
6. Open Up Excel or Google Sheets.
7. Click cell A1.
8. Paste your list. To paste, press Ctrl+ V (PC) or ⌘ Cmd+ V (Mac).
If you are using Excel, save your data here too.
1. Download another friends listing. Describe part I.
2. Duplicate your new buddies list. Refer to component II below, especially actions 1-5.
3. Open Excel/Google Sheets.
4. Click your good friends listing documents.
5. Click cell B1.
6. Paste your brand-new checklist. To paste, press Ctrl+V (PC) or ⌘ Cmd+V (Mac).
7. Click cell C1.
8. Enter =VLOOKUP(A1, B: B,1, FALSE). This is a vlookup function targeting cell A1, searching for your close friend's name in all of column B, as well as only seeking specific matches.
9. Click cell C1 again.
10. Click and also hold on the square symbol. This is a little eco-friendly square located near the bottom right of a highlighted cell.
11. Drag your arrow 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. Try to find #N/ A values. A vlookup formula that returns an '#N/ A' value indicates that the linked buddy's name in column A was not located in your brand-new good friends listing.
