I would just copy the whole list over to the new sheet and then sort on the
column with the numbers and that woud put all the zeros together, then just
delete those rows.....you're left with only the names that have numbers....

Vaya con Dios,
Chuck, CABGx3


"cd22" <cd22.245s1a_1141498205.6327@excelforum-nospam.com> wrote in message
news:cd22.245s1a_1141498205.6327@excelforum-nospam.com...
>
> Hello,
>
> I have a list of names and numbers in two separate columns. Some
> columns have positive or negative numbers and some only have zeros.
> I'm trying to create a formula that I can put on a separate worksheet
> to only pull the names and numbers from the worksheet that do not
> contain zeros. In other words, I want to condense the list to only
> include "active" names and numbers. Is there a formula that can be
> used to do this? i.e.
>
> Original List
> John 1
> Jeff -4
> Vince 0
> Jeremy 0
> Cindy 7
>
> List I want to end up with:
> John 1
> Jeff -4
> Cindy 7
>
> Thanks!
>
>
> --
> cd22
> ------------------------------------------------------------------------
> cd22's Profile:
http://www.excelforum.com/member.php...o&userid=32151
> View this thread: http://www.excelforum.com/showthread...hreadid=519018
>