| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional FIND and REPLACE | Excel Worksheet Functions | |||
| Create a conditional formula to replace | Excel Worksheet Functions | |||
| Macros & search /replace | Excel Worksheet Functions | |||
| Macros for find and replace and then joining columns | Excel Discussion (Misc queries) | |||
| Hide hyperlink cell & replace with macros | Excel Worksheet Functions | |||
Linear Mode
