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

Excel

ResolvedVersion 2003

Mon 19 Oct 2009, 15:08 Delegate Laura said...

Laura has attended:
Excel Intermediate course

Excel

How do you use the index function?

Tue 20 Oct 2009, 09:40 Trainer Amanda said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Conditional Formatting in Excel 2010