vba - counting different items

[abc2002]

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

 

[Tom Ogilvy]

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.

 

[Stephen Rasey]

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