I have a data list of 7,000, what is the easiest way to check for
 

I sorted the 7,000 names, but going down the list takes to long, I need an
easier way, I just know basics in excel

One word: Autofilter. To learn what it is and how to use
it, take a look at Debra Dalgleish's site:

http://www.contextures.com/xlautofilter01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I sorted the 7,000 names, but going down the list takes
to long, I need an
easier way, I just know basics in excel
.

I have a data list of 7,000, what is the easiest way to
check for

To check for what?

I need an easier way

An easier way to do what?

You can easily do that by setting .... <g

Biff

-----Original Message-----
I sorted the 7,000 names, but going down the list takes
to long, I need an
easier way, I just know basics in excel
.

Your subject line is truncated so can't see past "check for"

Assuming you mean duplicates.......

Select range then DataFilterAdvanced Filtercheck "unique records only" and
"copy to another location".

For more on this see Debra Dalglesih's site at

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben Excel MVP

On Mon, 21 Mar 2005 11:31:05 -0800, "Excel"
wrote:

I sorted the 7,000 names, but going down the list takes to long, I need an
easier way, I just know basics in excel