|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 20th, 2009, 04:05 PM
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
May 20th, 2009, 04:12 PM
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
May 20th, 2009, 11:34 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
