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