Thursday, April 05, 2012

Excel stuff


did you know that you can do a find and replace within formulas in a cell?
as in if you had an elaborate worksheet set up to count values entered in one field and total them in a spread sheet
[units sold, by month, by inventory acct #] and you had to change two of those inventory account numbers, and needed to update the formulas to reflect that new account number.
so you can look for the value '2070' and replace it with '2071' [and look only in the area you have highlighted]?
It took me longer to write this note than to go in and change 24 cell formulas.
Cool!

No comments: