Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

example: make tow columns, like Product ID and Product Name, if you enter any value in the second column excel give it a serial number in the first column.

user-image
Question added by Hany Hassanein , Microsoft Trainer , Egyptian Banking Institute
Date Posted: 2013/10/14
Rajesh K
by Rajesh K , ISP Manager , CENPAC NET INC

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

reham Al-jarrah
by reham Al-jarrah , سكرتارية , مؤسسة الزكاة الامريكية

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

Deleted user
by Deleted user

Basm Allah Alrahman Alrahim

 

use PowerPivot

Mutassem Watfa
by Mutassem Watfa , Finance Manager , Talas Group

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)

 

Ahmad Okashah
by Ahmad Okashah , Scanning Coordinator - IT department , Saveway

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.

 

More Questions Like This