Register now or log in to join your professional community.
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.
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
Dear sir....
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.