CHOOSE from a column
 

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...)?
--

Best Regards,
FARAZ A. QURESHI

CHOOSE from a column
 

Him

How about =OFFSET(A1,2,0)

Dave

"FARAZ QURESHI" wrote:

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...)?
--

Best Regards,
FARAZ A. QURESHI

CHOOSE from a column
 

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

Best Regards,
FARAZ A. QURESHI


"Dave Curtis" wrote:

Him

How about =OFFSET(A1,2,0)

Dave

"FARAZ QURESHI" wrote:

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...)?
--

Best Regards,
FARAZ A. QURESHI

CHOOSE from a column
 

Do it this way:

=INDEX(A:A,3)

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

Hope this helps.

Pete

On Feb 2, 12:51*pm, FARAZ QURESHI
wrote:
Great! Thanx! By the way, does that mean the Choose function can't be used
for an entire column or a large array?
--

Best Regards,
FARAZ A. QURESHI



"Dave Curtis" wrote:
Him

How about =OFFSET(A1,2,0)

Dave

"FARAZ QURESHI" wrote:

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...)?
--

Best Regards,
FARAZ A. QURESHI- Hide quoted text -

- Show quoted text -

CHOOSE from a column
 

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

=INDEX(A:A,3,1)

Dave

"FARAZ QURESHI" wrote:

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

Best Regards,
FARAZ A. QURESHI


"Dave Curtis" wrote:

Him

How about =OFFSET(A1,2,0)

Dave

"FARAZ QURESHI" wrote:

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...)?
--

Best Regards,
FARAZ A. QURESHI

CHOOSE from a column
 

XCLent!
Thanx
--

Best Regards,
FARAZ A. QURESHI


"Pete_UK" wrote:

Do it this way:

=INDEX(A:A,3)

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

Hope this helps.

Pete

On Feb 2, 12:51 pm, FARAZ QURESHI
wrote:
Great! Thanx! By the way, does that mean the Choose function can't be used
for an entire column or a large array?
--

Best Regards,
FARAZ A. QURESHI



"Dave Curtis" wrote:
Him

How about =OFFSET(A1,2,0)

Dave

"FARAZ QURESHI" wrote:

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...)?
--

Best Regards,
FARAZ A. QURESHI- Hide quoted text -

- Show quoted text -

CHOOSE from a column
 

You're welcome - thanks for feeding back.

Pete

On Feb 2, 2:01*pm, FARAZ QURESHI
wrote:
XCLent!
Thanx
--

Best Regards,
FARAZ A. QURESHI



"Pete_UK" wrote:
Do it this way:

=INDEX(A:A,3)

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

Hope this helps.

Pete

On Feb 2, 12:51 pm, FARAZ QURESHI
wrote:
Great! Thanx! By the way, does that mean the Choose function can't be used
for an entire column or a large array?
--

Best Regards,
FARAZ A. QURESHI

"Dave Curtis" wrote:
Him

How about =OFFSET(A1,2,0)

Dave

"FARAZ QURESHI" wrote:

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...)?
--

Best Regards,
FARAZ A. QURESHI- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -