Note: The other languages of the website are Google-translated. Back to English
English 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
  1.9K 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
3 months 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.