Washcare
asked on
Find and Replace
Good Afternoon
I am looking to do a find and replace on the following sum:
=(SUMPRODUCT((Centre=C$4)* (TEXT(Date ,"mmmm yyyy")="JANUARY 2011")*(Group=$A5)*(Value> 0)*(Value) ))
Replace *(Value)
For ,Value)
When I do the find and repalce I am left with ,Value) as the value in the cells?
Many thanks
I am looking to do a find and replace on the following sum:
=(SUMPRODUCT((Centre=C$4)*
Replace *(Value)
For ,Value)
When I do the find and repalce I am left with ,Value) as the value in the cells?
Many thanks
select Exact word option do the replace operaton
ASKER
I do not seem to have that option?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks