Give you columns headings eg: Letter & Amount then use DataSubtotal - In the
"At each change in" box select "Name" then "Use Function" of Count then "add
subtotal to" the "Amount".

In the left of the screen you will see the numbers 123. Click on the 2 and
this will shrink the data to show totals only. You can then copy those
visable cells only to another sheet. Or alternatively you could research
"Pivot Tables" at the following site.
http://www.contextures.com/tiptech.html

"GarToms" wrote:


Hi all,

I'm looking to count unique items in column 2 within the groups in
column 1.
e.g.
A......B
X......100
X......100
Y......200
Y......100
Y......200
Z......500

Required Output:
Y=2 (because of 100 and 200)
X=1 (because only 100)
Z=1 (because only 500)

I am totaly lost to find a solution so any help would be great.
Note i can't use a pivot due to the size of my worksheet.

GarToms




--
GarToms