I can not use pivot table
here is an example

colum b -- filter -- custtom (begins with 2000)
the it gives me 8000 rows.
then in thses filter i have common entries.
So i want to count the unique entires
for example i have 150 rows and the rest are double entries

Thank you for your entry

"Max" wrote:

Try also a pivot table, which gets you the results in a matter of seconds.
Select just the col B range, inclusive the col label in B1 (let's assume the
label is: "Cat"). Click Data PivotTable. Click Next Next. In step 3,
click Layout. Drag n drop "Cat" into both the ROW and DATA area. Click OK
Finish. That's it. Hop over to the pivot sheet (to the left) for the results,
ie a uniques listing of all the categories, and the total counts for each.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---