Hi guys,
I have a dataset with 150 rows and 50 columns. At the end of this I have a series of formula, like, SUM (B2:B160). In the same section I also have formula like (SUM(C2:C160))-1 and headers like 95% confidence interval.
I am trying to use the find and replace function to apply the formulas only to specific rows I need. While I can do this for the large part, sometimes when I say find 1 and replace by 10, it ends up replacing the (SUM(C2:C160))-1 both these 1 (in red). Similiar to replace 5 with some other number, it replaces the 5 part of the 95% CI.
My questions are as follows:
1. Is there a way to enter some numbers in the formula which is hidden from the find function and cannot be replaced. For ex: (SUM(C2:C160))-1. IN this is there a way that the Find function doesnt look at the (-1).
2. How can I ensure that the find function finds 1 and not 1 in the number 160.
thanks in advance.
Bookmarks