Need help in making Serial No

[Santosh080]

Hello Friends,

I need some help in the below table. I have an excel file like this. Now i want to put serial no 1,2,3 like this but according to ID Type Column whichmeans first serial number for AA ID Type starts from 1 to 4 then for ID Type BB it starts from 1 not continuing from serial number of AA. Can it possible ?

Thanks

	Sl. No	ID Type	Name	A/C No.
		AA	xlkopswp	135645
		AA	dskzxzz	545345
		AA	cxzcc	65636
		AA	czxczdsd	5345252
		BB	cxcdfd	454646
		BB	cxcxcf	645656
		CC	wgtgy	4535
		CC	sdsds	5645
		CC	fzdcfxfdf	345435
		DD	sefrtsdfs	4545
		DD	fdfstgy	65576
		DD	fsdterwe	757567
		DD	gsetsetrse	545

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

I want serial number like this which change according to ID Type,

Sl. No	ID Type	Name	A/C No.
1	AA	xlkopswp	135645
2	AA	dskzxzz	545345
3	AA	cxzcc	65636
4	AA	czxczdsd	5345252
1	BB	cxcdfd	454646
2	BB	cxcxcf	645656
1	CC	wgtgy	4535
2	CC	sdsds	5645
3	CC	fzdcfxfdf	345435
	DD	sefrtsdfs	4545
	DD	fdfstgy	65576
	DD	fsdterwe	757567
	DD	gsetsetrse	545

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

 

[frank_AL]

Assuming the data is sorted on ID Type and ID Type is in Column B and SI No is in Column A, enter this formula in Cell A2.
=IF(B2=B1,A1+1,1)

 

[JumpingCrab]

If the SI number starts from cellA2 down and the Type ID is in column B, type the following formula in A2:

=IF(B2=B1,A1+1,1)

Then copy the formula down along column A

That should work.