excel表里面怎么使用函数在原数前面加A和两位流水号
在D2单元格输入以下3个中任意一个公式后,向下填充即可(按考点,则选第1个):
=IF(C2="男","A","B")&TEXT(COUNTIF($C$2:C2,C2),"00")&B2
=LOOKUP(C2,{"男","女"},{"A","B"})&TEXT(COUNTIF($C$2:C2,C2),"00")&B2
=VLOOKUP(C2,{"男","A";"女","B"},2,0)&TEXT(COUNTIF($C$2:C2,C2),"00")&B2
你这个老师还是学生,也是拿来主义!这样可不好!
热门标签: