Filter duplicate data in excel spreadsheet
 

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

Filter duplicate data in excel spreadsheet
 

hi,

Why you don't use Pivot table?
you can choose reporting you want
--
Regards,

Halim



"eholz1" wrote:

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

Filter duplicate data in excel spreadsheet
 

eholz1

You can use SQL in Excel environment - DATA--IMPORT EXTERNAL DATA -- NEW
DATABASE QUERY"

You will be using a query tool called MS Query.

I appreciate your difficulties ,I too come from a database background - MS
Access Development ; I am also in the accounting profession (so I get it from
all sides).However don't dispair.I suggest getting to VBA - it's not too
difficult,and as you already know SQL transfering across won't be such a
"leap into the dark".

Regards


SysAccountant

"eholz1" wrote:

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