• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Names in Excel

gadiyasunny

gadiyasunny

New Member
Is there any way that we can use the Concatenate formula to provide formulas to excel to execute.

For Eg. if we use the formula =Concatenate("=",2,"+",2)
Excel gives output as =2+2 and not 4. is there a way we can do this. I have read about the Morefunc Addon but it does not work with Excel 2013 64-bit. Also I have heard about Indirect function, but its not working.

And if there is a way to do that then, I have a table and I have named all the rows and columns of the table using the name manager. Now I want to use those names in a formula.

The problem is that the names are in a cell and the cell is referenced in the formula.

Can that be done?
 
You can do that, but for that you'll have to rely on the Excel4 Evaluate function. You can define your name using the Evaluate function (that's the only way to make it work), and based on your formed argument within the Evaluate function, you'll be able to define it's calculation.

Check the sample attached.
 

Attachments

  • Evaluate.xls
    43 KB · Views: 6
Hi ,

The solution provided by Sam may be what you were looking for , but I am confused by what your problem really is.

Excel does not need the convoluted things that you are thinking of.

Firstly , there is no need to create range names for individual rows and columns of a table , unless you are using the word table in a loose sense ; in Excel , the word table has a specific connotation , and one of the advantages to using tables is that Excel expects it to have headers which can be used to refer to any range within the table. For more on tables , refer to :

http://www.techrepublic.com/blog/10-things/10-reasons-to-use-excels-table-object/

http://www.techhive.com/article/259633/10_secrets_for_creating_awesome_excel_tables.html

http://www.excel-easy.com/data-analysis/tables.html

http://chandoo.org/wp/2009/09/10/data-tables/

Secondly , if you can specify clearly what you want to do , you will get a solution to your problem ; at present you have specified what you are trying to do !

Narayan
 
You must log in or register to reply here.
Back
Top