View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abc2002 abc2002 is offline
external usenet poster
 
Posts: 1
Default vba - counting different items

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/