If you don't mind putting the results on the worksheet, you can use the
Advanced filter using the Unique setting. Turn on the recorder while you do
it manually to get the code.

--
Regards,
Tom Ogilvy


"abc2002 " wrote in message
...
Hi

I need to know how many different variables for each day

Range A1:A4 contains
2004-08-01
2004-08-01
2004-08-01
2004-08-02

Range B1:B4 contains
abc
bbb
abc
ccc

In VBA, how can I get that?

I should get:
2004-08-01 - 2
2004-08-02 - 1

thanks


---
Message posted from http://www.ExcelForum.com/