有没有什么函数公式方便排这种编号啊，求助大神！

曦440336 · 发表于 2014-10-21 13:07

K3入库日期	称重编号
2014-07-01	20140701-0001
2014-07-01	20140701-0002
2014-07-01	20140701-0003
2014-07-01	20140701-0004
2014-07-01	20140701-0005
2014-07-01	20140701-0006
2014-07-01	20140701-0007
2014-07-01	20140701-0008
2014-07-01	20140701-0009
2014-07-01	20140701-0010
2014-07-01	20140701-0011
2014-07-01	20140701-0012
2014-07-01	20140701-0013
2014-07-01	20140701-0014
2014-07-01	20140701-0015
2014-07-01	20140701-0016
2014-07-01	20140701-0017
2014-07-01	20140701-0018
2014-07-01	20140701-0019
2014-07-01	20140701-0020
2014-07-01	20140701-0021
2014-07-01	20140701-0022
2014-07-01	20140701-0023
2014-07-01	20140701-0024
2014-07-01	20140701-0025
2014-07-01	20140701-0026
2014-07-01	20140701-0027
2014-07-01	20140701-0028
2014-07-01	20140701-0029
2014-07-01	20140701-0030
2014-07-01	20140701-0031
2014-07-01	20140701-0032
2014-07-01	20140701-0033
2014-07-01	20140701-0034
2014-07-01	20140701-0035
2014-07-01	20140701-0036
2014-07-01	20140701-0037
2014-07-01	20140701-0038
2014-07-01	20140701-0039
2014-07-01	20140701-0040
2014-07-01	20140701-0041
2014-07-01	20140701-0042
2014-07-01	20140701-0043
2014-07-01	20140701-0044
2014-07-01	20140701-0045
2014-07-01	20140701-0046
2014-07-01	20140701-0047
2014-07-01	20140701-0048
2014-07-01	20140701-0049
2014-07-01	20140701-0050
2014-07-01	20140701-0051
2014-07-01	20140701-0052
2014-07-01	20140701-0053
2014-07-01	20140701-0054
2014-07-01	20140701-0055
2014-07-01	20140701-0056
2014-07-01	20140701-0057
2014-07-01	20140701-0058
2014-07-01	20140701-0059
2014-07-01	20140701-0060
2014-07-01	20140701-0061
2014-07-02	20140702-0001
2014-07-02	20140702-0002
2014-07-02	20140702-0003
2014-07-02	20140702-0004
2014-07-02	20140702-0005
2014-07-02	20140702-0006
2014-07-02	20140702-0007
2014-07-02	20140702-0008
2014-07-02	20140702-0009
2014-07-02	20140702-0010
2014-07-02	20140702-0011
2014-07-02	20140702-0012
2014-07-02	20140702-0013
2014-07-02	20140702-0014
2014-07-02	20140702-0015
2014-07-02	20140702-0016
2014-07-02	20140702-0017
2014-07-02	20140702-0018
2014-07-02	20140702-0019
2014-07-02	20140702-0020
2014-07-02	20140702-0021
2014-07-02	20140702-0022
2014-07-02	20140702-0023
2014-07-02	20140702-0024
2014-07-02	20140702-0025
2014-07-02	20140702-0026
2014-07-02	20140702-0027
2014-07-02	20140702-0028
2014-07-02	20140702-0029
2014-07-02	20140702-0030
2014-07-02	20140702-0031
2014-07-02	20140702-0032
2014-07-02	20140702-0033
2014-07-02	20140702-0034
2014-07-02	20140702-0035
2014-07-02	20140702-0036
2014-07-02	20140702-0037
2014-07-02	20140702-0038
2014-07-02	20140702-0039
2014-07-02	20140702-0040
2014-07-02	20140702-0041
2014-07-02	20140702-0042
2014-07-02	20140702-0043
2014-07-02	20140702-0044
2014-07-02	20140702-0045
2014-07-02	20140702-0046
2014-07-02	20140702-0047
2014-07-02	20140702-0048
2014-07-02	20140702-0049
2014-07-02	20140702-0050
2014-07-02	20140702-0051
2014-07-02	20140702-0052
2014-07-02	20140702-0053
2014-07-02	20140702-0054

曦440336 · 发表于 2014-10-21 13:17

我以前都是自己下拉的，有没有简便快捷的方法

wudixin96 · 发表于 2014-10-21 13:26

="20140701-"&TEXT(COUNTIF(A$1:A1,A1),"0000")

曦440336 · 发表于 2014-10-21 13:50

谢了，大神！！

曦440336 · 发表于 2014-10-21 13:53

本帖最后由曦440336 于 2014-10-21 14:06 编辑

还有个问题，就是称重时间，能不能有个公式自己平均分配
2014-07-01       20140701-0001       毛重时间       皮重时间
2014-07-01       20140701-0002       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0003       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0004       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0005       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0006       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0007       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0008       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0009       2014-07-01 PM       2014-07-01 PM
2014-07-01       20140701-0010       2014-07-01 PM       2014-07-01 PM
2014-07-01       20140701-0011       2014-07-01 PM       2014-07-01 PM

曦440336 · 发表于 2014-10-21 13:56

wudixin96 发表于 2014-10-21 13:26
="20140701-"&TEXT(COUNTIF(A$1:A1,A1),"0000")

7月2号又要重新从00001开始，3号的也要从00001开始，能改吗

wudixin96 · 发表于 2014-10-21 14:41

=TEXT(A1,"YYYYMMDD")&"-"&TEXT(COUNTIF(A$1:A1,A1),"0000")

曦440336 · 发表于 2014-10-21 15:14

wudixin96 发表于 2014-10-21 14:41
=TEXT(A1,"YYYYMMDD")&"-"&TEXT(COUNTIF(A$1:A1,A1),"0000")

还有个问题，就是称重时间，能不能有个公式自己平均分配
2014-07-01       20140701-0001       毛重时间       皮重时间
2014-07-01       20140701-0002       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0003       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0004       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0005       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0006       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0007       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0008       2014-07-01 AM       2014-07-01 AM
2014-07-01       20140701-0009       2014-07-01 PM       2014-07-01 PM
2014-07-01       20140701-0010       2014-07-01 PM       2014-07-01 PM
2014-07-01       20140701-0011       2014-07-01 PM       2014-07-01 PM
这个能解决吗

曦440336 · 发表于 2014-10-21 15:15

曦440336 发表于 2014-10-21 15:14
还有个问题，就是称重时间，能不能有个公式自己平均分配
2014-07-01 20140701-0001 毛重时 ...

非常感谢，大神

		自动登录	找回密码
密码			免费注册