Hi,

I've looked and looked and cannot find any reference that this capability even exists.

I want to have named ranges and then access the individual row/col. It works, sort of. I'd like to know if it can use other functions.

This is just a dummy example: I have two named ranges: Col_1 & Col_2, and I've used them in a few formulas and here is the result and the formulas:

Col_1 Col_2 1 + 2 1 * 2 sum max
1 5 6 5 138 12
2 5 7 10 138 12
3 5 8 15 138 12
4 5 9 20 138 12
5 5 10 25 138 12
6 5 11 30 138 12
7 5 12 35 138 12
8 5 13 40 138 12
9 5 14 45 138 12
10 5 15 50 138 12
11 5 16 55 138 12
12 5 17 60 138 12





Col_1 Col_2 1 + 2 1 * 2 sum max
1 5 =Col_2+Col_1 =Col_2*Col_1 =SUM(Col_2,Col_1) =MAX(Col_2,Col_1)
2 5 =Col_2+Col_1 =Col_2*Col_1 =SUM(Col_2,Col_1) =MAX(Col_2,Col_1)

I apologize for the above, but my attempts to copy this were spectacularly bad.



I hope you can see that: "+" and "*" work fine and "sum" and "max" do not. I know I can change this into a table but for various reasons I do not wish to.

I was wondering if there is something that functions similarly to "@" for named ranges.

Any ideas?