Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Database Newbie
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 |
#2
|
|||
|
|||
52,000 is a lot of entries!
First thing I would do is to make a copy of the file and work with that, until you get the results you want. You could use 'Autofilter'. Select one of the cells in your list, then Data Filter Autofilter. If you wish to find the number of entries by a certain artist, click the down arrow in the 'Artist' column, find the artist in the dropdown list that you see, and click on it, Excel will display all entries by that artist. To display all entries: Data Filter Show All. HTH George Gee G3£Wh)zZ@ wrote: 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. |
#3
|
|||
|
|||
"George Gee" wrote in message ... 52,000 is a lot of entries! First thing I would do is to make a copy of the file and work with that, until you get the results you want. Thanks for the reply m8...much appreciated. -- The Source For Premium Newsgroup Access Great Speed, Great Retention 1 GB/Day for only $8.95 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
I also work with large database in Excel, be careful with sorting and make sure you always have a "header Row" across all columns, and have every column named. There are issues around with sorts losing integrity, though I have not experienced that as yet. If you meld two databases, what I do, is to make sure the two match "Exactly" the same column amount together with exact column location. I paste them over to the major database, then change the colour of the added rows, before doing a sort of the appropriate column. There are column formulas you can use to detect doubles, although personally I copy "to and fro" between Excels weaker sibling "MSWorks" which has a flashy and blindingly fast flat form Database module. This however only takes 32,000 records, yet it has the peace of mind of being impossible to lose integrity. Due to Excels suspect sort problems, I always open the file do a "Save as" and rename the file as "(File name)B" before working amongst it. I cannot imagine having 52,000 rows losing integrity...Aaaarggghh HTH -- rodney at touch88.com.au Send spam to the FTC at Thanks, robots. "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 |
#6
|
|||
|
|||
"Rodney" wrote in message ... Thanks M8) -- The Source For Premium Newsgroup Access Great Speed, Great Retention 1 GB/Day for only $8.95 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query Excel database from desktop | Excel Discussion (Misc queries) | |||
Links to External Database | Excel Discussion (Misc queries) | |||
make existing pivot charts point at the same database | Charts and Charting in Excel | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
Graphing Database Growth Rate | Charts and Charting in Excel |