Find and Count Duplicate values
 

I have a workbook with several sheets, there a 2 cols, SecID, TranID on each
sheet. I need the # of duplicate TranID for each secID. All this should be
done in VBA, The resultset should be

SecID TranID NumOfTimesUsed
1 3 5
1 8 3
etc.

Can I run a union query within Excel, if so what would be the syntax, or is
there another way with this type of result.

Mike

Find and Count Duplicate values
 

Have a look here

http://spreadsheetpage.com/index.php...d_frequencies/

"mikeb" wrote:

I have a workbook with several sheets, there a 2 cols, SecID, TranID on each
sheet. I need the # of duplicate TranID for each secID. All this should be
done in VBA, The resultset should be

SecID TranID NumOfTimesUsed
1 3 5
1 8 3
etc.

Can I run a union query within Excel, if so what would be the syntax, or is
there another way with this type of result.

Mike