Automatically generate serial no. if it is add more

[AFZAL SOHAIL]

Dear Team, I hope you will be fine and well,
I attached an image in which show the Sr.No. in Column-B, it will be 1 in column-A1 when it is started, so when I add the next adjustment it will be automatically give me 2 in Col-A adjacent of Sr.No. in b-column and so on the same for the next Sr.no.
Please help me I shall be very thankful to you.

 

[etaf]

it looks like you ave merged cells which maybe an issue

how about in first row assuming row 1

=if(C1="name of employee", Countif($A$1:A1,"Name of employee"), "" )
and drag down

But not sure how that will work with merged cells

 

[AFZAL SOHAIL]

Thanks a lot Sir,
I put this formula in cell A1 but it give me Circular Reference error, and I also removed merge.
Kindly help me...

 

[etaf]

sorry should have been
=IF(C1="name of employee", COUNTIF($C$1:C1,"Name of employee"), "" )

Book3
	A	B	C	D
1	1		name of employee
2
3
4	2		name of employee
5
6
7
8
9	3		name of employee
10			\
11
12
13	4		name of employee
14
15	5		name of employee
16
17	6		name of employee
Sheet1

Cell Formulas
Range	Formula
A1:A17	A1	=IF(C1="name of employee", COUNTIF($C$1:C1,"Name of employee"), "" )

 

[AFZAL SOHAIL]

Thanks a lot Mr. Etaf,
It is working perfectly Sir..

 

[etaf]

you are welcome