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" wrote in message
...

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