Hi,

In column "A", I have 2 different names Alan and Bernard. In column "B", I have unique numbers.
I would like when adding a new row and adding in column "A", one of the 2 names, to have in column "B" the max value+1 related to the name of column "A"

For ex the max value in column "B" for Alan is 100 and the max value in column"B" for Bernard is 500.
When filling in a new row in column "A" : Alan, it should add 101 in column"B".
When filling in a new row in column "A" : Bernard, it should add 501 in column"B".

Thanks for help,

Daniel