Tables

Hi Charles

Thank you for your question

Could you clarify what exactly you are trying to achieve with your tables, in particular;-

1. Are you referring to data tables for sensitivity analysis, or just lists contained in a contiguous range of cells

2. If the later what do you need help with, filtering, sorting or lookups?

Thanks

Stephen

Dear Charles

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


As Data Tables are covered in our Excel Advanced course I am assuming that your query is specific to that.

Please refer to the following link to provide you more information on Two Variable data tables:

http://techtites.com/2008/09/11/two-variable-data-tables-in-microsoft-excel-tutorial-thursday/


These are other useful sites that may help you in achieving your results:

http://www.ozgrid.com/Excel/data-tables.htm
http://www.bettersolutions.com/excel/EAV113/LO027611611.htm

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT