E
eholz1
Hello Excel group.
Is there a way (better or easier that the "filter, advanced, unique")
to filter out records with duplicate data.
For example - i have imported a text file into excel (i would prefer a
real database here! SQL is easier).
It has various info in it. It has user names (first and last names,
etc) I might have 10 entries where the same
user name appears. I would like to have a representation (or list)
that would eliminate the duplicate user names, and just show unique
users.
Any suggestions on how to do this. this ability needs to be used by
someone who does not know how to
use VBA, etc.
I have used the Autofilter - which is nice. Perhaps some combo of
autofilter and subtotals??
Thanks
Eholz1
Is there a way (better or easier that the "filter, advanced, unique")
to filter out records with duplicate data.
For example - i have imported a text file into excel (i would prefer a
real database here! SQL is easier).
It has various info in it. It has user names (first and last names,
etc) I might have 10 entries where the same
user name appears. I would like to have a representation (or list)
that would eliminate the duplicate user names, and just show unique
users.
Any suggestions on how to do this. this ability needs to be used by
someone who does not know how to
use VBA, etc.
I have used the Autofilter - which is nice. Perhaps some combo of
autofilter and subtotals??
Thanks
Eholz1