LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Choose last number in a column Don Excel Worksheet Functions 3 May 22nd 07 05:05 AM
Choose Column in Calculation martins New Users to Excel 2 April 3rd 06 06:14 PM
how i choose the column from a combo box Alberto Vargas Excel Discussion (Misc queries) 4 July 22nd 05 11:07 PM
How can I choose top two numbers in a column? Doug Excel Worksheet Functions 3 May 1st 05 11:04 PM
in excel, how do I choose a column and add 20% servmarkpdx Excel Worksheet Functions 1 November 18th 04 07:36 PM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"