I'm trying to get an absolute range address from single input. Something like this.

```
Formula
=SOME.MAGIC(A1:B10)
Output (string)
"$A$1:$B$10"
```

## Attempt 1

I'm able to get this result but using significantly complex approach with following (array) formula.

```
{=ADDRESS(MIN(ROW(A1:B10)),MIN(COLUMN(A1:B10)),1,1)&":"&ADDRESS(MAX(ROW(A1:B10)),MAX(COLUMN(A1:B10)),1,1)}
```

Where (as you can see) is string `A1:B10`

used four time.

## Attempt 2

My other attempt was using function `FORMULATEXT`

. The link for a range is there only once, but it's nasty workaround using one more cell and works relatively good only for relative addresses.It doesn't work for named ranges.

```
C1=$A$1:$B$10
C2=MID(FORMULATEXT(C1),2,LEN(FORMULATEXT(C1))-1) //Returns string "$A$1:$B$10" ✓
But
C1=A1:B10
C2=MID(FORMULATEXT(C1),2,LEN(FORMULATEXT(C1))-1) //Returns string "A1:B10" ✘
And
C1=Named_range
C2=MID(FORMULATEXT(C1),2,LEN(FORMULATEXT(C1))-1) //Returns string "Named_range" ✘
```

## Attempt 3

Next step is combination of attempt 1+2. It works, but I'm not happy with it.

```
C1=A1:B10
C2=MID(FORMULATEXT(C1),2,LEN(FORMULATEXT(C1))-1)
C3{=ADDRESS(MIN(ROW(INDIRECT(C2))),MIN(COLUMN(INDIRECT(C2))),1,1)&":"&ADDRESS(MAX(ROW(INDIRECT(C2))),MAX(COLUMN(INDIRECT(C2))),1,1)}
```

Is there easier way (less complex formula) with same output?