I have 3 variables:
CompanyID
RoundNumber (from 1 to 16)
RoundNumber_max (from 1 to 16)

For each company ID there are more rows with different or even equal RoundNumber. Each row, for each Company ID reports the same RoundNumber_max
How can i find the frequency distribution of single Company ID for each RoundNumber_max avoiding considering that the company reports the same RoundNumber_max?