Does it have to be VBA?

An Advanced Filter that extracts Date and Variable, Copy to New Location,
Unique Rows will eliminate all duplicates.

Then a Pivot table can count by date.

Stephen Rasey
WiserWays, LLC
Houston
http://excelsig.org


"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/