• 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.

Link a Data Table Name with a Range

Hi guys!


I have a doubt regarding Excel Data Tables.


I was wondering if it's possible to refer to it using a range. For example:


The formula is:


=COUNTIF(abcp11[Data];">=01/09/10")


I want to make the "abcp11" part variable, using the name "abcp11" in the range B5:


=COUNTIF(B5[Data];">=01/09/10")


The objective is that when I need to recall lots of data tables using this formula above, I lost a lot of time changing the name of various data tables. If I have ranges with the name of the data tables I could do this in no time!


I'm attaching the file if you want to take a deeper look at it:


http://www.megaupload.com/?d=FII6SCH9


Thanks for the attention!


Henrique Carvalho
 

Hui

Excel Ninja
Staff member
Henrique

You will have to use the Indirect function to help out here

=COUNTIF(INDIRECT(B5&"[Data]"),">=01/09/10")
 
Top