Replace value

[juanp21]

Hi

I would like to know if this is posible to program.

I would like to replace the value in column K with -1 if the value in column G is FT.

Any help or advise is greatly appreciated.

[humdingaling]

you want that in VBA or will a formula in a seperate column suffice?

[juanp21]

in VBA would be I deal

[humdingaling]

try this code

Please Login or Register  to view this content.

[jolivanes]

This would be one of many ways.

Please Login or Register  to view this content.

[jindon]

↑ will give you wrong result when there is no "FT"....?

Please Login or Register  to view this content.

[juanp21]

Thank you it worked perfectly

[jolivanes]

@jindon.
Of course, you're right. Never thought about that.
Thanks for pointing that out jindon.

[apo]

Maybe something like this will also work...? (Change ranges to suit)

Please Login or Register  to view this content.