I am having trouble with a lookup formula and was hoping someone could
help me. I have one list of invoices one on sheet and a column next to
them where it says paid or not paid. I am trying to pull only the "not
paid" amounts into another sheet but want to do this without the zeroes
or spaces in between rows. Any ideas how to do this?

Thanks!!!


--
danioma
------------------------------------------------------------------------
danioma's Profile: http://www.excelforum.com/member.php...o&userid=35112
View this thread: http://www.excelforum.com/showthread...hreadid=548678