How to make automatic serial number in a column beside a each product name in a excel sheet?

1.Sort with product name(Asendingor decending)

2.Set first cell value as1(Eg: A1), then

3. A2=IF(B1=B2,A1,A1+1)  assuming B  coloumn contain product ID or Name

4.drag A2 cell down up to the last product name in B coloumn

try it

You Can Use this formula For Automatice Serial Number:

=IF(ISTEXT($B2),ROW()- Headers ROW," ")

On the assumption that  column A for Product ID  and column B for Product Name

Basm Allah Alrahman Alrahim

use PowerPivot

Dear sir....

You must use another sheet ( You call it Products... column A is Product name, column B is the serial number)

In your main sheet in the Serial number column use this formula>

=VLOOKUP(B:B;Products!A:B;2;0)

First you should insert the S/N manual (for the products or goods), then you can use the excel funcation to make it small programe, but if you ask me you should using ORACLE or ASP.net to make store product or Goods programe.