Posted to microsoft.public.excel.programming
|
|
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
|