Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 17 August 2022
  1 Replies
  2.4K Visits
I want Auto Restart Serial Number as value change in next column

Sr. No Names
1 Rauf
2 Rauf
3 Rauf
4 Rauf
1 Salman
5 Rauf
2 Salman
3 Salman
1 Ali
4 Salman
2 Ali
3 Ali
4 Ali
5 months ago
Hi there,

You can first add a column before the name column, enter the formula in the top cell of the added column: =COUNTIF($B$1:$B1,B1)

Note: B1 is the top cell of the name column. You should leave the dollar signs the way they are.

After entering the formula, drag the fill handle down to the cells below.

If you need to combine the both columns, you can use the formula in the cell C1: =CONCATENATE(A1," ",B1)

Or you can use Kutools for Excel's Combine rows, columns, or cells without losing data feature:

If you have any questions, please don't hesitate to ask me.

  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL