formulas

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

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

Formulas

resolvedResolved · Low Priority · Version 2010

Olivia has attended:
Excel Introduction course

Formulas

Hi,

How do Match and Index formulas work?

Many thanks,

Olivia

RE: Formulas

Hello Olivia,

Re Index and Match. There is a good explanation of these functions on our blog. The link below should take you directly to the actual blog, if not search blog for Index match.

https://www.stl-training.co.uk/b/category/application/microsoft-office/excel-training/

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 6 Oct 2011: Automatically marked as resolved.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.09 secs.