自动生成序列号 [英] Autogenerate Serial Number

问题描述

我要自动生成序列号.

Student Name Serial number Address Group Section Student ID

Monir 07001 Dhaka,Bangladesh Science B SC001B

当我输入一个学生姓名时，它将自动在序列号的位置生成其序列号.此后，如果我再次保存它，则输入任何新的学生，它将自动生成下一个序列号.

When I enter a Student name it will automatically generate its Serial number in the place of Serial number .After that if i save it again enter any new student it will generate the next serial number automatically.

我该怎么做.请帮助我.

How do i can do it. Please help me.

推荐答案

如果我正确理解了您的问题，excel解决方案就相当简单.

If I understood your question correctly the excel-solution is rather easy.

手动添加第一个学生的序列号(07001)，并使用以下公式填充其余的序列号字段(以下字段):

Add the serial number for the first student by hand (07001) and fill the remaining serial number fields (the ones below) with the following formula:

公式:= IF(ISBLANK(A2)，"，B1 + 1)A2 =左侧的单元格，B1 =上方的单元格

Formula: =IF(ISBLANK(A2),"",B1+1) With A2 = cell to the left and B1 = cell above

R1C1表示法= =(ISBLANK(RC [-1])，"，R [-1] C + 1)

R1C1 Notation: =IF(ISBLANK(RC[-1]),"",R[-1]C+1)

编辑:要将"0"添加到数字中，您需要将序列号的数字格式设置为以下自定义格式:000000

To "add" a leading 0 to the number, you need to set the number format of your serial number to the following custom format: 000000

这篇关于自动生成序列号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！