Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba - counting different items
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba - counting different items
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Items | Excel Worksheet Functions | |||
Counting items | Excel Discussion (Misc queries) | |||
Counting the items | Excel Worksheet Functions | |||
Counting different items in one column | Excel Discussion (Misc queries) | |||
Counting items | Excel Programming |