I need to assign the quotient of total IDs per ID. And whenever there is a remainder, it will be added into the first cell. I used =COUNTA(B3:B500)/(no. of ids) to get the quotient
The quotient would be divided equally per IDs. Say I have 130 total items, and 4 IDs. I will divide 130 by 4. Answer will be 32.5. So per ID I will have 33, 33, 32, 32. How can I have that iteration where I can have equal counts per ID? and the remainder will be added on the top items. Column B would be Names that needed groupings which is the IDs.
How can I iterate the quotient per ID? Thanks!
