Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel
Resolved · Low Priority · Version 2003
Reply Mon 19 Oct 2009, 15:08Delegate Laura said...
For upcoming training course dates see: Pricing & availability
RE: Excel
Hello Laura
Thank you for your question and welcome to the forum.
The Excel INDEX function is designed to extract data from a single cell which is in a specific position in a list.
The function has 3 arguments:
Array: This refers to your list range, i.e. which cells in your spreadsheet contain the list you wish to extract data from?
row_num: Which row contains the cell you want to extract data from?
column_num: Which column contains the cells you want to extract data from?
For an example of how the index function can be used, see
http://www.contextures.com/xlFunctions03.html
I hope this helps.
Kind regards
Amanda
Mon 26 Oct 2009: Automatically marked as resolved.
|