Formula to count editions of 999 and return a no.

Hi, I have this spreadsheet that I need to calculate how many editions of a picture are being printed. I need column Q (no.) to look at the artist ref (column B) and count how many of those have been printed previously and return the next sequential number - subtracting from 999 (column P).

Does anybody know a formula that can create this?

Thanks
Nikki