"Split data"

Hello,
I have to calculate the effective dose after a CT-Investigation.
An Investigation includes several pictures with the same ID.
So I would like to separate the same id’s and count them.
Please help!