If it is just a single dimension, zero based array, the only way I can see
is to loop through each element and check it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"quartz" <quartz@discussions.microsoft.com> wrote in message
news:1C11EB20-F462-46C9-A29F-9E3E61DB9DEC@microsoft.com...
> Thanks Bob, but no, this array is already in code and contains dynamic
> data collected from multiple sheets based on user's input - on the fly.
>
> Any further help appreciated...
>
> "Bob Phillips" wrote:
>
> > If we are talking all worksheet cells here, and say the array is in
M1:M8,
> > then use
> >
> > =COUNTIF($M$1:$M$8,A1)
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "quartz" <quartz@discussions.microsoft.com> wrote in message
> > news:9090C79C-E40A-4AF8-A151-CDDBB2130EC5@microsoft.com...
> > > I am using Office 2003 on Windows XP.
> > >
> > > I need to be able to count the number of each item in a single element
> > > array, then write out the counts.
> > >
> > > For example, if the array contains:
> > > Red, Blue, Red, Orange, Orange, Red, Green, Blue
> > >
> > > My result would be:
> > > A1: Red B1: 3
> > > A2: Blue B2: 2
> > > A3: Orange B3: 2
> > > A4: Green B4: 1
> > >
> > > If anyone has a function to which I could pass my array to output the
> > counts
> > > or could share some code I could adapt it would be most appreciated.
> > >
> > > Thanks much in advance.
> >
> >
> >