Using names from "insert name paste" in formulae

[Alex Delamain]

Help

I have large quantities of data to analyse against key specifications
The data is imported into excel with the variable names in row1.

I have used "Insert name create" to define each columm as a named rang
and then used "insert name paste" to give me a list of the variables i
a second sheet.

I now want to use the pasted name or range in a countif formula t
check for numbers above or below specifications (from a lookup table
however I cannot get my formulae to work when referencing the paste
names. If I type the name into the formula it works fine but with som
500+ variables to work through I want to automate as much as possible.

Is there any way I can pick up the range name or location that i
produced by "insert name paste"?

Many thank

 

[DDM]

Alex, if you want to reference a name that you've pasted into a worksheet,
use INDIRECT. So:

=COUNTIF(INDIRECT(Sheet2!A1),"Whatever")

where Sheet2!A1 holds the name you pasted.

 

[Alex Delamain]

I cannot thank you enough