| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help! Find and replace in formulas
I created concatenated fields of multipe other fields and then counts them
based on what is in the concatenated fields. =COUNTIF('Master Recruit'!AC:AC,"24,de,sc,FAST TRACK") I have to do this on 3,000 times on 15 different tabs and the only part that needs to change is the "de". Next it will be "dc" then "dw" etc... Is there a way I can just find and replace for each tab? I don't want to spend my Holidy going, F2...backarrow...delete...delete... Help me Obi-Wan, you're my only hope... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
| Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
| Find and delete part of formula for multiple formulas? | Excel Worksheet Functions | |||
| Find and Replace Formula Links | Excel Worksheet Functions | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Threaded Mode
