Copy the value from a cell with condition. Help please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excel_guest - 20 Jun 2006 10:39 GMT

Hi,
I have a column with say 100 cells. There are several 0s in this
column. What is the conditional formula to put ONLY the values
different from 0 to another column whitout cells with false or white
spaces?

Thanks

Signature

excel_guest

Reply to this Message

Mallycat - 20 Jun 2006 10:53 GMT

if(A1="0","",A1)

Signature

Mallycat

Reply to this Message

excel_guest - 20 Jun 2006 10:58 GMT

Thanks,
But I don't want those free spaces in my column for those cells with
0s.

Signature

excel_guest

Reply to this Message

aidan.heritage@virgin.net - 20 Jun 2006 11:14 GMT

the quotes are typed without spaces, but if you are doing it with a
formula you HAVE to have something in the TRUE and FALSE part of the if
statement to avoid seeing FALSE or TRUE in the cell! You COULD do it
with a macro if you want.

> Thanks,
> But I don't want those free spaces in my column for those cells with
[quoted text clipped - 6 lines]
> excel_guest's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35590
> View this thread: http://www.excelforum.com/showthread.php?threadid=553539

Reply to this Message

Pete_UK - 20 Jun 2006 11:16 GMT

Apply a filter to the column which has the numbers (A ?), selecting
Custom | Not Equal To | 0 (zero). Then in the top-most visible cell of
the column next to it, type = then click on the cell next to it that
contains the number - this will have entered a formula like

=A5

into the cell, assuming row 5 is the first visible row. Press Enter,
then with the filter still active, click <copy> on the cell with the
formula and paste the formula into the other cells of that column where
there are numbers visible in column A. You can then remove the filter
(select ALL), and you should have what you want.

Hope this helps.

Pete

Reply to this Message