Conditional Replace without macros

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

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
 
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...
 
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...
 
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
 
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
 
Back
Top