You could try to read your Excel sheet from an ODBC driver as a database and while you are extracting, use SQL to gather the number of each similar ID and add this as a new field that will be used as X of 1/X.
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫