In your first post you asked for a "2 character numeric" at the end and you
wanted it "incremented by the number of people who have the same surname"
That would result in GWILL03 NOT GWILL001

So, do you want a numeric with 2 characters or 3 characters?

Is it incremented by surname or by surname plus firstname?

Try to be accurate in what you ask for.
Thank you

"bach" wrote:

>
> My fault,
>
> GWILL should have 001 as he has a different first name from the JWill
> and so he is unique. The number is for if a user has the same first
> letter and last three letters for their surname they can have a number
> to distinguish between them.
>
> All members are stored in the spread sheet with all their details.
>
>
> --
> bach
> ------------------------------------------------------------------------
> bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
> View this thread: http://www.excelforum.com/showthread...hreadid=468946
>
>