Creating a pivot table

[mcdanik]

I need to create a database (of sorts) but I have to use Excel, not Access.
I have Excel 2003 and have a list of countries and want to be able to list,
for a given country, all of the different products the country uses and also
to show how they label these different products. Is a pivot table the best
way, or is there a database type function in Excel I should use?

 

[Ed Ferrero]

Hi mcdanik,

I need to create a database (of sorts) but I have to use Excel, not Access.
I have Excel 2003 and have a list of countries and want to be able to
list,
for a given country, all of the different products the country uses and
also
to show how they label these different products. Is a pivot table the
best
way, or is there a database type function in Excel I should use?

I think a pivot table - put country as a page field.

My tutorial on how to use Excel as a database might help
http://www.edferrero.com/ExcelTutorials/tabid/54/Default.aspx

Ed Ferrero
www.edferrero.com