Selective Deletion within a column
 

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' ,
'Used' , 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the
word 'New' and replace all others , irrespective of present content ,
with the word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin

Selective Deletion within a column
 

Colin
Say that your column is Column A, and your data starts in A1. In any
blank column, in row 1, enter this formula:
=IF(A1="New","New","Used")

Drag this formula down as far as the Column A data goes.

Select all the data in this new column.

Click Edit - Copy.

Select A1.

Click on Edit - PasteSpecial.

Click on "Values".

Click OK.

Delete the new column.

Done.

HTH Otto

"Colin Hayes" wrote in message
...

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' , 'Used'
, 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the word
'New' and replace all others , irrespective of present content , with the
word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin

Selective Deletion within a column
 

Hi Otto

Thanks Otto - that works perfectly. You've solved my problem.I don't
know how you do it - great stuff thanks.

Just out of interest , can the formula be extended to take account of
two parameters?

For example , in the formula below , if A1 is 'New' then B1 is New.
Just one qualifying cell.

Could it be extended so that A1 AND B1 would need to be 'New' for C1 to
Match? Without both columns matching then C1 would be 'Used'...


Just wondering. Thanks for helping me out on this one Otto.



Best Wishes


Colin





In article , Otto Moehrbach
writes
Colin
Say that your column is Column A, and your data starts in A1. In any
blank column, in row 1, enter this formula:
=IF(A1="New","New","Used")

Drag this formula down as far as the Column A data goes.

Select all the data in this new column.

Click Edit - Copy.

Select A1.

Click on Edit - PasteSpecial.

Click on "Values".

Click OK.

Delete the new column.

Done.

HTH Otto

"Colin Hayes" wrote in message
...

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' , 'Used'
, 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the word
'New' and replace all others , irrespective of present content , with the
word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin

Selective Deletion within a column
 

Colin
This formula in C1 produces "New" if BOTH A1 and B1 say "New".
Otherwise you get "Used". HTH Otto
=IF(AND(A1="New",B1="New"),"New","Used")

"Colin Hayes" wrote in message
...

Hi Otto

Thanks Otto - that works perfectly. You've solved my problem.I don't know
how you do it - great stuff thanks.

Just out of interest , can the formula be extended to take account of two
parameters?

For example , in the formula below , if A1 is 'New' then B1 is New. Just
one qualifying cell.

Could it be extended so that A1 AND B1 would need to be 'New' for C1 to
Match? Without both columns matching then C1 would be 'Used'...


Just wondering. Thanks for helping me out on this one Otto.



Best Wishes


Colin





In article , Otto Moehrbach
writes
Colin
Say that your column is Column A, and your data starts in A1. In any
blank column, in row 1, enter this formula:
=IF(A1="New","New","Used")

Drag this formula down as far as the Column A data goes.

Select all the data in this new column.

Click Edit - Copy.

Select A1.

Click on Edit - PasteSpecial.

Click on "Values".

Click OK.

Delete the new column.

Done.

HTH Otto

"Colin Hayes" wrote in message
...

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' ,
'Used'
, 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the
word
'New' and replace all others , irrespective of present content , with
the
word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin

Selective Deletion within a column
 

In article , Otto Moehrbach
writes
Colin
This formula in C1 produces "New" if BOTH A1 and B1 say "New".
Otherwise you get "Used". HTH Otto
=IF(AND(A1="New",B1="New"),"New","Used")


Hi Otto

OK that's great. It works perfectly!

Thanks again for your expert help.



Best Wishes


Colin





"Colin Hayes" wrote in message
...

Hi Otto

Thanks Otto - that works perfectly. You've solved my problem.I don't know
how you do it - great stuff thanks.

Just out of interest , can the formula be extended to take account of two
parameters?

For example , in the formula below , if A1 is 'New' then B1 is New. Just
one qualifying cell.

Could it be extended so that A1 AND B1 would need to be 'New' for C1 to
Match? Without both columns matching then C1 would be 'Used'...


Just wondering. Thanks for helping me out on this one Otto.



Best Wishes


Colin





In article , Otto Moehrbach
writes
Colin
Say that your column is Column A, and your data starts in A1. In any
blank column, in row 1, enter this formula:
=IF(A1="New","New","Used")

Drag this formula down as far as the Column A data goes.

Select all the data in this new column.

Click Edit - Copy.

Select A1.

Click on Edit - PasteSpecial.

Click on "Values".

Click OK.

Delete the new column.

Done.

HTH Otto

"Colin Hayes" wrote in message
...

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' ,
'Used'
, 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the
word
'New' and replace all others , irrespective of present content , with
the
word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin

Selective Deletion within a column
 

Good job Otto.

Many a time I run into a problem like this.

Do you use excel often?

Parker

Selective Deletion within a column
 

Parker
I'm a retired old geezer. I don't "use" Excel at all. That is, as a
job. Tinkering with it and perusing these newsgroups and helping people
where I can is a hobby. Plus, it keeps the old brain working. Otto
wrote in message
oups.com...
Good job Otto.

Many a time I run into a problem like this.

Do you use excel often?

Parker

Selective Deletion within a column
 

In article , Otto Moehrbach
writes
Colin
This formula in C1 produces "New" if BOTH A1 and B1 say "New".
Otherwise you get "Used". HTH Otto

=IF(AND(A1="New",B1="New"),"New","Used")


HI Otto

Just a quick extra question on this. :

At the moment the formula above checks for a single content in cells A1
and B1 , and if both match it produces 'New' in C1. If either fails to
match , it produces 'Used'.

Now , is it possible to add and 'OR' to the code referring to A1?

For example , if A1 is 'New' OR 'Just Added' AND B1 says 'New' then
produce 'New' in C1. Otherwise get used.

Is that possible? I know it's asking to check for two types of content
in the same cell , but can excel do this?

Grateful for any help.


Best Wishes

Colin



"Colin Hayes" wrote in message
...

Hi Otto

Thanks Otto - that works perfectly. You've solved my problem.I don't know
how you do it - great stuff thanks.

Just out of interest , can the formula be extended to take account of two
parameters?

For example , in the formula below , if A1 is 'New' then B1 is New. Just
one qualifying cell.

Could it be extended so that A1 AND B1 would need to be 'New' for C1 to
Match? Without both columns matching then C1 would be 'Used'...


Just wondering. Thanks for helping me out on this one Otto.



Best Wishes


Colin





In article , Otto Moehrbach
writes
Colin
Say that your column is Column A, and your data starts in A1. In any
blank column, in row 1, enter this formula:
=IF(A1="New","New","Used")

Drag this formula down as far as the Column A data goes.

Select all the data in this new column.

Click Edit - Copy.

Select A1.

Click on Edit - PasteSpecial.

Click on "Values".

Click OK.

Delete the new column.

Done.

HTH Otto

"Colin Hayes" wrote in message
...

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' ,
'Used'
, 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the
word
'New' and replace all others , irrespective of present content , with
the
word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin

Selective Deletion within a column
 

Colin
=IF(AND(OR(A1="New",A1="Just Added"),B1="New"),"New","Used")

HTH Otto

"Colin Hayes" wrote in message
...
In article , Otto Moehrbach
writes
Colin
This formula in C1 produces "New" if BOTH A1 and B1 say "New".
Otherwise you get "Used". HTH Otto

=IF(AND(A1="New",B1="New"),"New","Used")


HI Otto

Just a quick extra question on this. :

At the moment the formula above checks for a single content in cells A1
and B1 , and if both match it produces 'New' in C1. If either fails to
match , it produces 'Used'.

Now , is it possible to add and 'OR' to the code referring to A1?

For example , if A1 is 'New' OR 'Just Added' AND B1 says 'New' then
produce 'New' in C1. Otherwise get used.

Is that possible? I know it's asking to check for two types of content in
the same cell , but can excel do this?

Grateful for any help.


Best Wishes

Colin



"Colin Hayes" wrote in message
...

Hi Otto

Thanks Otto - that works perfectly. You've solved my problem.I don't
know
how you do it - great stuff thanks.

Just out of interest , can the formula be extended to take account of
two
parameters?

For example , in the formula below , if A1 is 'New' then B1 is New.
Just
one qualifying cell.

Could it be extended so that A1 AND B1 would need to be 'New' for C1 to
Match? Without both columns matching then C1 would be 'Used'...


Just wondering. Thanks for helping me out on this one Otto.



Best Wishes


Colin





In article , Otto Moehrbach
writes
Colin
Say that your column is Column A, and your data starts in A1. In
any
blank column, in row 1, enter this formula:
=IF(A1="New","New","Used")

Drag this formula down as far as the Column A data goes.

Select all the data in this new column.

Click Edit - Copy.

Select A1.

Click on Edit - PasteSpecial.

Click on "Values".

Click OK.

Delete the new column.

Done.

HTH Otto

"Colin Hayes" wrote in message
...

Hi all

I have a column which contains multiples of several different text
entries. These entries vary , but involve the single words 'New' ,
'Used'
, 'Sold' , 'Open' , Closed' and so on.

I want to run a command on the column to keep all the cells with the
word
'New' and replace all others , irrespective of present content , with
the
word 'Used'. Is this possible?

I've been playing with this for some time now and find no luck. It's
the
implementation of a 'Not Equal to' command I'm having trouble with.


Grateful for any help.



Best Wishes


Colin