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, 17 August 2022
  1 Replies
  4.7K Visits
0
Votes
Undo
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
·
#3021
0
Votes
Undo
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.
serial-number.png

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

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


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

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