Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2008

Tip: Looking for answers? Try searching our database.

Anyhelp

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
G3£Wh)zZ@ - 14 Feb 2008 10:37 GMT
I collect music cds and have a big collection - i also collect the uk top 30
music charts

Over the last few months i have compiled a list of wants to complete the
project (to the end of 07)

I need just over 3,100 songs to complete this project

Anyway in excel the list goes like this

     10CC Good Morning Judge 1977 5

Artist song year and chart position

I want to get into this list and collect the big artists first so is there a
way of getting excel to display all of the artists that say have 10 songs in
my list

for example i need 4 - 50cent songs to complete but at the same time i need
12 Elvis Presley songs to complete so i would like to be able to collect the
Elvis first reducing my wants list and so on

So i need excel to go through my list of 3100 songs and pull up the entries
ie artist that consist of say 10 songs at first , then once all of them have
been collected it would pull up the artist that consist of 6 songs etc etc
Dave Peterson - 14 Feb 2008 12:08 GMT
Insert a new column A:
Put this formula in A2 (add a header to A1).
=countif(a:a,a2)
and drag down.

Then apply data|filter|autofilter to that column.

You can filter to show the number of groups over 10.

> I collect music cds and have a big collection - i also collect the uk top 30
> music charts
[quoted text clipped - 21 lines]
> ie artist that consist of say 10 songs at first , then once all of them have
> been collected it would pull up the artist that consist of 6 songs etc etc

Signature

Dave Peterson

Jim Rech - 14 Feb 2008 13:15 GMT
>>=countif(a:a,a2)

Did you mean?:

=countif(b:b,b2)

Signature

Jim

| Insert a new column A:
| Put this formula in A2 (add a header to A1).
[quoted text clipped - 30 lines]
| > ie artist that consist of say 10 songs at first , then once all of them have
| > been collected it would pull up the artist that consist of 6 songs etc etc
Dave Peterson - 14 Feb 2008 14:33 GMT
Yes I did!

Thanks for the correction, Jim.

> >>=countif(a:a,a2)
>
[quoted text clipped - 50 lines]
> |
> | Dave Peterson

Signature

Dave Peterson

G3£Wh)zZ@ - 16 Feb 2008 12:26 GMT
Thanks guys will check it out..
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.