The macro would evaluate a data set that has two columns (A & B), ColA contains ID numbers and ColB has years so that the combination of the two would create a unique ID/Yr combo. The macro would then count the number of data rows that have an unique combo. For example:
ColA ColB
6119 1980
6119 1981
7231 2000
7231 2001
7231 2001
The expected macro result from the above example would be 4 - which would then be placed within the same worksheet where dataset is. My anticipated thanks for you help.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-prog...binations.html
If the information provided on the above is not to your requirements post updates accordingly - do not create new threads.
Last edited by DonkeyOte; 12-16-2009 at 11:47 AM. Reason: incorrect stock response re: warning
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks