excel

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Laura has attended:
Excel Intermediate course

Excel

How do you use the index function?

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.


 

Excel tip:

Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips


Server loaded in 0.08 secs.