CHOOSE from a column

[FARAZ QURESHI]

Any idea how to choose the third value from a large selection or full column,
instead of entering each and every cell address like: =CHOOSE(3,A:A), instead
of =CHOOSE(3,A1,A2,A3...)?

 

[Dave Curtis]

Him

How about =OFFSET(A1,2,0)

Dave

 

[FARAZ QURESHI]

Great! Thanx! By the way, does that mean the Choose function can't be used
for an entire column or a large array?

 

[Pete_UK]

Do it this way:

=INDEX(A:A,3)

(non-volatile). Check out the description of CHOOSE in XL Help.

Hope this helps.

Pete

 

[Dave Curtis]

Hi,
I don't think you can use it that way.
You can use

=INDEX(A:A,3,1)

Dave

 

[FARAZ QURESHI]

XCLent!
Thanx

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

XCLent!
Thanx
--

Best Regards,
FARAZ A. QURESHI






- Show quoted text -