This one is a tough one and I have no idea where to start.

I have a sheet full of application names and versions. Many are the
same names and different versions.

I need to figure out for the same 'partial' name, such as "McAfee
VirusScan" what versions are on the sheet, and how many of each
version. There are thousands of items so I will not know what all the
possible versions are so I'd like to do this problematically.

Anyone do this before and have some example code or formulas?

thx!

You can obtain a list of unique entries using Advanced Filter - Debra
Dalgleish shows how here:

http://www.contextures.com/xladvfilter01.html#FilterUR

Then you could use a COUNTIF formula to count how many there are for
each of those versions.

Hope this helps.

Pete

On Aug 19, 7:54*am, Livin <AaronLe...@gmail.com> wrote:
> This one is a tough one and I have no idea where to start.
>
> I have a sheet full of application names and versions. Many are the
> same names and different versions.
>
> I need to figure out for the same 'partial' name, such as "McAfee
> VirusScan" what versions are on the sheet, and how many of each
> version. There are thousands of items so I will not know what all the
> possible versions are so I'd like to do this problematically.
>
> Anyone do this before and have some example code or formulas?
>
> thx!