***** A Question About Ms Excel *****

[May1010]

In Column A, I have a data set of just English words. It goes down to about 3,000 words.

I've sorted the column in ascending order.

I notice there are duplicate entries.

Is there a way I can search the column for duplicates?



Thanks in advance,
May1010.

 

[danielson]

ahh

im being very lazy here, as i havent really chchkled as this could take a while.

but a function (that fx button) will do it

what the function is ios the hard part

try MATCH
OR
EXACT
OR
FIND

maybe?

use 1 cell as the refernce to which you are searching and the array of names (the whole column) as where u are looking.

god luck

(p.s. when u typed ms excel i thought u were typing about a woman at first )

 

[FrankRizzo]

Sorry May, I have no good answer for you.

 

[WODIN]

Insert a new row so that a1 is blank

In a1 type in a heading.

In b1 type in the same heading
In b2 type in <>" "

in c1 type in the same heading

Action - Copy to another location.

Goto Data Filter.. Advanced Filter

List range a1 through the end of your table.

Criteria b1.b2

copy to: C1

Check on copy unique records only.

This is the fastest way to eliminate duplicates.