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 -
|