As the title suggested, the names in the "DT update log" should be in alphabetical order for easy identify of a DT member (s) whenever a user is trying to find out any. I was looking for a particular DT member in the log and I noticed that it was somehow difficult for me to get to the DT member name because the names are not arrange in alphabetical order so I have to check one after the other but if the names were arranged in alphabetical order, I would have gone straight to the alphabet of the particular username and make a search from there and get the name.
Use search. If you want to find a user, use its username and Ctrl+F to find it in the DT update log list.Quote
But for now the scanning or skimming process is somehow difficult because the names are not alphabetically organized.
Search it and you can find it in few seconds.Quote
Whenever the log is updated, we the active forum users check it to know the current DT members in the forum, that is who was removed and who was added, so I am suggesting that the names should be alphabetically arrange in the next updates.
theymos will not use his time to do it for you. You can copy the username list to Excel and use Sort & Filter (Sort A to Z or Sort Z to A). Choose "Continue with the current selection. A few minutes to do it.Who was Removed and who was added
Sort data in a range or table
If you want to compare two lists.
Find new added DT members
Copy two lists into two columns.
Old list in the first column, new list in a second column.
Use VLOOK command in the third column.
Code:
=VLOOKUP(B1,$A$1:$A$100,1,0)
DT members who are in both old and new list will have their usernames appear in the third column.
New added DT members will be displayed as N/A, in the third column.
Find removed DT members
Use VLOOK command in the fourth column.
Code:
=VLOOKUP(A1,$B$1:$B$100,1,0)
DT members who are in both old and new list will have their usernames appear in the third column.
Removed DT members will be displayed as N/A, in the fourth column.
