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

[Excel]

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

 

[Jason Morin]

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

 

[Biff]

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

 

[Gord Dibben]

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

Assuming you mean duplicates.......

Select range then Data>Filter>Advanced Filter>check "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