create named array formula to use it in many cells

[drom]

Hi and thanks in advance!

I have a array formula, to get the first visible cells value in a table no matter if the table is filtered.

the formula is a array formula and works perfect

Now i would like to create a named formula with this formula

the same way I do when I go to Manage names add...
But when I put in a cell =MyName


I get the string ogf the formula not the answer.


So I guess to put a array formula in names... I have to use something I do not know

PS:
this is the array formula I would like to create, to use within my names:

=INDIRECT("D"&MIN(IF(SUBTOTAL(3;OFFSET(OFFSET(xGX;1;0;1;1);ROW(rColData)-ROW(OFFSET(xGX;1;0;1;1));;1));ROW(rColData))))​

 

[p45cal]

Too many unknowns in your formula - supply an Excel file.

 

[NARAYANK991]

Hi ,

I tried this :

=INDIRECT("D" & MIN(IF(SUBTOTAL(3,OFFSET(OFFSET(xGX,1,0,1,1),ROW(rcoldata)-ROW(OFFSET(xGX,1,0,1,1)),,1)),ROW(rcoldata))))

by using it in the RefersTo box of a named range called MyName , and in a worksheet cell , I entered =MyName ; this then displayed the data correctly.

rcoldata refers to an entire column of data in the table ; xGX refers to the header cell of the table for that particular column.

In your case , all commas in the above formula will be replaced by semicolons.

Your formula works correctly at my end.

Narayan