What does =Indirect(1:3) returns?

[ORoxo]

Don't quite understand what does this function will return. Every value in columns A to C?

Thanks

 

[farmerscott]

For what it is worth, the following link I found useful in discussing array formulas.

https://support.office.com/en-us/ar...formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7

Have a look (approx 3/4 down the page), under the heading "Find the 'n'th largest values in a Range". It looks at INDIRECT("1:3") and the array it generates.

 

[ORoxo]

You left out two critical details.
- There are quotes around the "1:3"
- This is an array formula entered with CTRL-SHIFT-ENTER (it works very different that formulas entered with just "enter").

These are essential details that you want to be sure not to leave it. It changes the nature of the question entirely!
When asking questions, try not to oversimplify it to the extent that it does not make sense, or we cannot tell what you are trying to do.
Post #6 is how your original question should have been posted, as it contains all the pertinent details.

I'm sorry, Joe.

I will try to keep this in mind and make sure that from now on it's clear from the beginning what the question is.

 

[Joe4]

I'm sorry, Joe.

I will try to keep this in mind and make sure that from now on it's clear from the beginning what the question is.

No need to apologize!
Just trying to give you some tips that will allow us to help you better, and get your questions resolved faster!