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.

One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y20,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copypaste 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(Y20,"active",Y2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Colin Hayes" wrote:
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.

In article , Max
writes
One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y20,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copypaste 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(Y20,"active",Y2))


Max

excellent , thanks. That fixed it.

Very grateful.



Best Wishes


Colin

Glad it did, Colin.
Thanks for feedback.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Colin Hayes" wrote in message
Max
excellent , thanks. That fixed it.
Very grateful.
Best Wishes
Colin

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




In article , Colin Hayes
writes
In article , Max
writes
One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y20,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copypaste 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(Y20,"active",Y2))


Max

excellent , thanks. That fixed it.

Very grateful.



Best Wishes


Colin

You have a reply at your next post.

Colin Hayes wrote:

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

In article , Colin Hayes
writes
In article , Max
writes
One way - use an adjacent helper col

Assuming numbers running in Y2 down
Put in Z2: =IF(Y20,"active",Y2)
Copy down. Kill the formulas in col Z with an "in-place" copypaste 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(Y20,"active",Y2))


Max

excellent , thanks. That fixed it.

Very grateful.



Best Wishes


Colin

--

Dave Peterson

Instead of
=IF(Y2="","",IF(Y20,"active",Y2))

you could use:
=IF(Y2="","NULL",IF(Y20,"active",Y2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Colin Hayes" wrote in message
...
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