Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, August 17, 2022
  1 Replies
  6.2K 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
1 year 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.