copying selective data

S

scottcts

I have 2 columns, the first is a listing of names, the second is a number
associated with the names. Not all names will have a number. I'm trying to
find a way to "shrink" the list of names to only include those names that
have a number associated with them without having to manually go through and
hide or delete the rows that don't have numbers and names. Any help would be
appreciated.
 
J

Jason Morin

Select the data and go to Data > Filter > AutoFilter. On
the Number column, click the drop-down list and select
(NonBlanks).

HTH
Jason
Atlanta, GA
 
S

swatsp0p

Use AutoFilter. Give each column a heading e.g. Name, Number, Select
Data>Filter>AutoFilter
In the Number column, click the down arrow and select Non-Blanks (usually
the last option on the list).

Copy and paste the resulting display to a location of your choice.

HTH

Bruce
 
Top