Selective cell changes

C

Colin Hayes

HI

In column Y I have a row of numbers.

I need to change them so that the cells which are 0 stay the same , and
cells with numbers greater than 0 in them are replaced with the word
'Active' .

Can someone help with this?

Thanks.
 
M

Max

One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y2>0,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copy>paste special
as values. Delete col Y.

If you want any blank cells in col Y to return as "blanks", ie:""
then use instead in Z2:
=IF(Y2="","",IF(Y2>0,"active",Y2))
 
C

Colin Hayes

Max said:
One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y2>0,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copy>paste special
as values. Delete col Y.

If you want any blank cells in col Y to return as "blanks", ie:""
then use instead in Z2:
=IF(Y2="","",IF(Y2>0,"active",Y2))
Click to expand...


Max

excellent , thanks. That fixed it.

Very grateful.



Best Wishes


Colin
 
C

Colin Hayes

Max

I've just had a little extra problem.

Could I use your formula to replace cells in the column with no content
to read 'NULL' , with cells having content remaining the same?


Best Wishes


Colin
 
D

Dave Peterson

You have a reply at your next post.

Colin said:
Max

I've just had a little extra problem.

Could I use your formula to replace cells in the column with no content
to read 'NULL' , with cells having content remaining the same?

Best Wishes

Colin
Click to expand...
 
Top