I have a spreadsheet that I am having difficulty sorting. I have a number of usernames with associated information to them
contained within their row of data. I am able to sort by username very easily.
What I need though is a way to
organize the data in a different manner. I only need the usernames that have been logged multipule times to display, or be
separated from those that only appear once.
If I can seperate the usernames that appear two or more times from
those that only appear once
I would like to be able to sort by the number of times that the username repeats in
the sheet. (i.e) Usernames that have appeard 5 times by alpha at the top followed by 4 ect. This would allow me to
eliminate those that only appear once easily and allow me to work with the data I need.
If there is a way to
organize the usernames by alpha, but keep those that have not appeared multiple times from displaying, that would be fine as
Here is essentially what I have now. The Usernames are sorted by Alpha
I need UsernameB and E separated, I can't do it manually, because I have
thousands of lines of this, and a low percentage are repeat Usernames.
Ideally it would look either like this:
With the other data hidden or Like this.:
I know I've seen data organized in this manner before, I just need a way to do
it. Any Help is greatly appreciated.