I saw @oflyhigh and @kenchung wrote a post about how to find your friends who does not upvote you by using Python. I am not a programmer and I felt is difficult for me to follow their method and also those who are not programmers too. Finally I find that Microsoft Excel can help you find your friends who does not upvote you too.
Step 1: List Down Your Friends' Steemit Username in Microsoft Excel. Change their Username's color to Red for later use.
步骤1：在Microsoft Excel中列出您朋友的Steemit用户名。 将其用户名的颜色更改为红色。
Step 2: Change Your Post URL from steemit.com to steemd.com
Step 3: Click Your Post's Vote Detail and Copy the List of Voters to Excel's Sheet 2
步骤3：点击您的帖子的“VOTE DETAIL" 并将点赞您的帖子的名单复制到Excel的Sheet 2
Step 4: Copy Your Friends' Steemit Username from Sheet 1 to Sheet 2
步骤4：将您的朋友的Steemit用户名单从Sheet 1复制到Sheet 2
Step 5: Click Column A to Select All
Step 6: Click "Data" at Navigation Bar & then Click "Remove Duplicated"
Step 7: Click "Remove Duplicated" at Pop Up Box
Step 8: 1. Click "Unselect All" 2. Uncheck "My Data Has Header" 3. Select "Column A" 4. Click "Ok"
步骤8：1.点击“Unselect All” 2.取消选中“My Data Has Header” 3.选择“Column A” 4.点击“Ok”
A. Number of Duplicated Value Found = The Number of Your Friends Upvote You
A.Number of Duplicated Value Found = 帮您点赞朋友的数量
B. Your Friends Who Does Not Upvote You still in Red Color
C. Now you can send them a reminder to Upvote you