Lisa has attended:
Excel Intermediate course
Ranges and Match
Please could you tell me more about ranges and match and offset.
Please could you also advise on filtering more than one column. Thanks
RE: Ranges and Match
Hi Lisa
Thank you for your questions.
Here are the links for Match and Index
https://www.stl-training.co.uk/article-1621-learn-how-use-index-and-match-functions-in-excel.html
and the dynamic range using offset.
https://support.microsoft.com/en-us/kb/830287
Can you remind me about the filtering information you would like? In the meantime I have included some information on Advanced Filtering which you may find of interest.
https://support.microsoft.com/en-us/kb/2720580
Let me know if you have a further question.
Kind regards,
Andrew