Need to eliminate redundancies in column

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

I'm transferring data from Excel to Access. One of the columns in Excel
is going to be the primary key in Access, but right now there are
redundancies in it. Is there any way I can use Excel to eliminate
reduncancies in a column? Or do I have to eyeball it?

Thanks,
Aaron
 
I guess what I need to do is a little more complicated...
I need to determine which row does not have unique data in column 1, and
then eliminate that whole row (all it's columns). Is this very difficult?

Aaron
 
Back
Top