| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choose last number in a column | Excel Worksheet Functions | |||
| Choose Column in Calculation | New Users to Excel | |||
| how i choose the column from a combo box | Excel Discussion (Misc queries) | |||
| How can I choose top two numbers in a column? | Excel Worksheet Functions | |||
| in excel, how do I choose a column and add 20% | Excel Worksheet Functions | |||
Hybrid Mode
