how do I substitute precedants in long excel formulas

O

ognavtra

i have generated long formulas (eg the sum of all variables in one column
multiplied by the variables in another column). is there a way to 'find &
replace' one set of precedants with another for a different column without
having to manually change all the precedant references one by one?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clever formula required (to find the word directly preceding mychosen word) 5
How can I find paragraph breaks that are not preceded by a period? 0
Excel does not accept text format! 0
Consolidation Table from Different Excel Tabs with Different Format 1
HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S? 2
how do i delete spaces in multiple cells thoughout the workbook? 3
How do I reference a cell to another in the preceding worksheet 8
formula for arriving net difference 0

Top