Hi,

Follow these steps:

1. Type a heading for the range on sheet1, say Alias
2. Select the range of data (including the heading given in 1 above) on
sheet1 and assign it a name, say dummy1;
3. Select the range again and press Ctrl+L;
4. Select any blank cell;
5. Save the file on the desktop and name it try.xls
6. Go to Data Import External Data New Database query
7. Select Excel files
8. In the folder hierarchy on the right, select Desktop and click on the
try.xls on the left had panel
9. Click on OK
10. Click on dummy1 and then press the greater then symbol to get the Alias
column on the right hand side
11. Click on Next
12. Click on Next 2 times and on the last screen select "View Data or Edit
Query in Microsoft Query"
13. In the MS Query box, click on the SQL button

SELECT Count(*) FROM (SELECT DISTINCT ucase([Alias]) FROM dummy1)

14. It will say that SQL query cannot be depicted graphically - click on OK
15. Go to File Return data to MS office Excel
16. In the Properties box, select the cell where you want the output.
17. The count of names will appear as desired;

Now you may add or edit names in dummy1. All you have to do is right click
anywhere in the output and click on Refresh.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Elton Law" wrote in message
...
Hi Expert,
Wanna count a column but there may be some duplication.
Want to count the number of persons.
If all count, should be 11.
But want to count without duplication, can it be made? In this case,
should
be 7.
(Janie, Jenny are duplicated)


Say Column A ...
Janie
Jenny
Alan
Patrick
Elton
Janie
Janie
Jenny
Alan
Elmer
Tinny