How to add automatically the max value in a cell based on conditions

[danielfr]

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

[TMS]

Something like:

Please Login or Register  to view this content.

[aworfolk]

Here is a Formula that should work it is an array.
Just change the row numbers as needed to start then drag down.

Please Login or Register  to view this content.

[Pete_UK]

Note that in Belgium you may need to use semicolons ( ; ) rather than commas ( , ) in the formulae suggested, depending on your regional settings.

Hope this helps.

Pete

[danielfr]

Hi TMS,

Thank you for your reply but unfortunately it doesn't work

[Pete_UK]

Did you see my comments in Post #4 ?

Pete

[danielfr]

Hi Pete,

Thanks so much. It works

[TMS]

So:

Please Login or Register  to view this content.

You may want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.