98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
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.
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 tip:Generating simple column charts1.Select cell range containing data/figures |