Conditional Replace without macros
 

Hi

I have a big Excel list with a header row

Right now, I do a filter on two of the columns to display only rows that
meet both criteria. Then I do an Edit, Replace command twice...once to
replace all the values in one of the columns with some other value, then
another Edit Replace to replace all the values in another of the columns with
some other value. Then I remove the filter to get all records shown...but
this takes time...

is there a quicker way to do this or do I need to create a macro??

Thank you

Craig

Conditional Replace without macros
 

that really depends on what your criteria are.

the fields you are changing... can you make them formulas instead? =if(other
cell=x,"This value","That value")

Seems we would need more information to figure out a solution to this one...

"Craig" wrote:

Hi

I have a big Excel list with a header row

Right now, I do a filter on two of the columns to display only rows that
meet both criteria. Then I do an Edit, Replace command twice...once to
replace all the values in one of the columns with some other value, then
another Edit Replace to replace all the values in another of the columns with
some other value. Then I remove the filter to get all records shown...but
this takes time...

is there a quicker way to do this or do I need to create a macro??

Thank you

Craig

Conditional Replace without macros
 

Sounds like your manual method is about the quickest without using VBA.

Have you tried using the macro recorder to see what code you get?


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 08:05:01 -0700, Craig
wrote:

Hi

I have a big Excel list with a header row

Right now, I do a filter on two of the columns to display only rows that
meet both criteria. Then I do an Edit, Replace command twice...once to
replace all the values in one of the columns with some other value, then
another Edit Replace to replace all the values in another of the columns with
some other value. Then I remove the filter to get all records shown...but
this takes time...

is there a quicker way to do this or do I need to create a macro??

Thank you

Craig