It’s a simple question, and for those of us with an iPhone or other Apple device it’s easy enough to monitor. But this gal is a PC, so until an online application is available, I’ve been able to check this easily using Microsoft Excel.
Step 1: Go To Your Profile And Click On Followers
Step 2: Scroll All The Way To The End (to ensure the names of all of your followers are on the screen)
Step 3: Right Click On The Screen And “Select All”
Step 4: Paste Into A Microsoft Excel Worksheet
Step 5: Create Another Blank Worksheet
Step 6: Click On “Following”
Step 7: Scroll All The Way To The End (to ensure all of the names of those you are following are in your worksheet)
Step 8: Paste Into A Blank Microsoft Excel Worksheet
Step 9: Turn The Gibberish Into Something Useful
You will notice that there is a pattern. The number of rows between each name might vary, depending on what version of Excel you are using. Enter the number 1 next to the first “follower” on the list, and zeros next to the data that you want to remove. When you get to the second name, enter a reference back to the cell with the 1 in it. Then copy and paste that cell all the way to the end of your list.
Step 10: Copy the entire worksheet, and paste as values. There is now a 1 next to each name, and zeros next to lines you’d want to remove.
Step 11: Sort by Column C, and delete all of the zeros. You are now left with only names in your list.
Step 12: Repeat step 1 through 11 for your “Following” list.
Step 13: At this point, you will have two lists that look like the screenshot above. One contains the names of your followers, and the other a list of names you are following. Go to the tab that contains the list of those you are following, and enter a vlookup function with your list of followers as the data source.
Step 14: Copy the vlookup formula all the way down to the end of your list. The names with a “1” are following you in return. The names with a #n/a are not. You can now scroll through your Following list, to determine if these names still deserve you as a “fan” or not.
If you’re looking to see which of your followers has stopped following you, collect these databases over time and use vlookup to compare them to each other!
Questions? Please leave a comment here!
