Spreadsheet example
Compare Followers and Following with COUNTIF
FollowGrid exports the lists; you run this comparison in Excel or Google Sheets.
- Prepare two sheets. Import both exports into one workbook and name the tabs
FollowersandFollowing. Preserve User ID as text during import so long IDs stay intact. Remove duplicate IDs within each sheet. These formulas assume headers in row 1, User ID in column C, and empty columns G and H; adjust the references if your columns differ. - Create a text match key in both sheets. Label G1
Match key, enter this in G2, and fill down through every exported row. Theid:prefix keeps the comparison keys as text.=IF(C2="","","id:"&C2) - Check each Following entry against Followers. In the Following sheet, label H1
In Followers, enter this in H2, and fill down. The range covers 10,000 data rows; extend it if your sheet contains more.
Filter H to 1 for shared accounts or 0 for following-only entries. A value above 1 means duplicate match keys remain in the Followers sheet.=IF(G2="","",COUNTIF(Followers!$G$2:$G$10001,G2)) - Find followers-only entries. In the Followers sheet, label H1
In Following, use the reverse formula in H2, fill down, and filter H to 0.=IF(G2="","",COUNTIF(Following!$G$2:$G$10001,G2))
A small example to check your results
Fictional IDs: Followers contains 5841209361 and 5290773814; Following contains 5841209361 and 6104882745.
- In both lists
5841209361— match count 1 in either sheet.- Following only
6104882745— count 0 in Following.- Followers only
5290773814— count 0 in Followers.
Formula syntax: Excel COUNTIF · Google Sheets COUNTIF. Examples use English function names and comma separators.