Hello,
Attached please find the spreadsheet. In it i have the formula i want to use in cell F1 as text. I want to apply this formula in column B. This is possible by just copy and pasting and typing an equals sign. I was trying to use the define name and EVALUATE approach to cut down on the redundancy but with no success.
Any suggestions? I don't know if i made a mistake or if perhaps there is a better approach?
Thank You
What is the formula meant to do and where's the 'redundacy'?
If posting code please use code tags, see here.
ROW() and COLUMN() cannot be used with Evaluate, since it doesn't know what cell to use as it base.
A different approach might be to put X*.9 in F2 and change the definition of Test to =EVALUATE(SUBSTITUTE(Sheet1!$F$2,"x",Sheet1!A2))
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
The redundancy is that in reality my actual is many thousands of rows long and the formula i am using is also long. This creates a spreadsheet that takes up alot of disk space and takes awhile to open.
I want to have one formula and reference it. This will cut down on the size of the file and make it easier for me to edit the formula if i have to.
mikerickson your suggestion works great. I ran into a problem though. Im actually using named ranges with condition formatting. if i enter a value into cell M4 on sheet one that doesnt fit the range on sheet two, it should illuminate. This is working however it should also work if the value isnt a number. what i dont understand is that i have the formula in cell X6 and it appears to be working correctly. Ive attached a copy to take a look.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks