also, if I can email the file let me know, I think it'll make things a lot
easier, THANKS!!!!!

"Ron Coderre" wrote:

> >>field b2, the entry is "cat, dog, bird", in field c3 the entry is "cat,
> bird"<<
> Hmmm....that would have been a really nice piece of information to know
> right up front.. :\
>
> The complexity of your solution (if there is one) just increased
> significantly.
>
> We'll see what we can do for you.
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "Ralph" wrote:
>
> > ahhhhhh!!! Thanks Ron & Bpeltzer but you are over my head with this, maybe
> > I'm too excel challenged but I'm finding your instructions a little too
> > complex for me to pull this off. An additional complexity is that in the
> > fields of the table I have items separated by commas, such as in field b2,
> > the entry is "cat, dog, bird", in field c3 the entry is "cat, bird", is this
> > going to screw up your ideas in terms of counting everything?? I wish I
> > could post the file somehow, it would make all this MUCH easier,........
> >
> >
> > "Ron Coderre" wrote:
> >
> > > I know you posted this in the Worksheet Functions forum, but I think a Pivot
> > > Table might give you what you're looking for more easily:
> > >
> > > Select your column of data (Make sure it has a col heading, I'll assume
> > > "Type")
> > >
> > > Data>Pivot Table
> > > Use: Excel List
> > > Range: If not already selected, select your data
> > > Click the [Layout] button
> > > -ROW: Type
> > > -DATA: Count of Type
> > > Select a destination for the Pivot Table
> > > Click [OK]
> > >
> > > Next, on the Pivot Table, double-click on the Type heading to view the
> > > settings dialog.
> > > Click the [dvance]button
> > > Set Autosort: Descending
> > > Using field: Count of Type
> > > Click [OK]
> > >
> > > That will list each unique item in the list in descending order of its count.
> > >
> > > Does that help?
> > >
> > > ***********
> > > Regards,
> > > Ron
> > >
> > > XL2002, WinXP-Pro
> > >
> > >
> > > "Ralph" wrote:
> > >
> > > > Hi,
> > > >
> > > > Is there a way to select a table and have excel produce a list ranking the #
> > > > of times each item shows up in the list, i.e.
> > > >
> > > > dog 5
> > > > cat 2
> > > > bird 1
> > > > ???
> > > >
> > > > Thanks