Automatic Sequential Number

[GemBox]

Dear All,

I have a requirement to find the next available number in the same column and to fill up. For example in the same column if TKT-MM-1 & TKT-MM-2 exist, the system should propose the next number as TKT-MM-3. Also it should take the reference 'MM' from the next column as stated in the sample file.

Please help.

Gem

[BadlySpelledBuoy]

In cell B3 and copied down

Please Login or Register  to view this content.

BSB

[GemBox]

Thanks for your quick reply BSB. It works fine...
Thanks a lot..

[BadlySpelledBuoy]

Happy to help.
Thanks for the rep point

BSB

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.