You may like to try Pivot tables?

Regards.

Bill Ridgeway
Computer Solutions

"G3£Wh)zZ@" wrote in message
t.com...
I have just finished typing my entire cd collection into a excel database
which comprises of Artist , Song, Cd Title, duration , year of release.

There is over 52,000 entries in the database.

First of all i would like excel to count how many songs i have by a artist
and display this in one of the columns.

Is this possible?


Then secondly i am a dj and i have the entire uk top 40 charts also on
excel, if possible i would love to create a new database using my cd
collection database and the chart database
to work out and to display what songs i don`t have, is this possible as
well.


Many thanks.

--
The Source For Premium Newsgroup Access
Great Speed, Great Retention
1 GB/Day for only $8.95