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