copying selective data

[Guest]

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.

 

[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

 

[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