On Sun, 21 Jun 2009 00:50:01 -0700, andy
wrote:

Dear all, i hope somene can help - because ive just pulled out my last hair
i'll tryto explain - in column A i have a list of 30 names (which may be
duplicated in some places) - in column B i have two possible entries against
each name "OK" or "DI"

What i would like to do is have a formula that would count the name and the
number of "OK" and "DI" together
I could then on a seperate sheet have the one name and the total of OK and
DI against the name

simple for some of u - but not for me - sorry

Regards

Andy the novice


Perhaps a Pivot Table?

Select a cell in your data table.

The Insert/Pivot Table

Drag Names to the row area
Drag Type to the Data or Value area
Drag Type also to the Columns area

A table like:

name type
dave OK
mike OK
joey ok
ken DI
dave DI
ken OK
mike DI
ken DI
joey OK
joey OK


Winds up showing a report like:

Count of type
Names DI OK Total
dave 1 1 2
joey 3 3
ken 2 1 3
mike 1 1 2
Total 4 6 10

The report can be formatted in various ways.
--ron