G Guest Mar 21, 2005 #1 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 sorted the 7,000 names, but going down the list takes to long, I need an easier way, I just know basics in excel
J Jason Morin Mar 21, 2005 #2 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
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
B Biff Mar 21, 2005 #3 I have a data list of 7,000, what is the easiest way to check for Click to expand... To check for what? I need an easier way Click to expand... An easier way to do what? You can easily do that by setting .... <g> Biff
I have a data list of 7,000, what is the easiest way to check for Click to expand... To check for what? I need an easier way Click to expand... An easier way to do what? You can easily do that by setting .... <g> Biff
G Gord Dibben Mar 21, 2005 #4 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
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
