[已解决]怎么用match函数返回数据是第几次出现啊？

Shelvee · 发表于 2013-3-14 14:07

如题。怎么用match函数返回数据是第几次出现啊？

最佳答案

cbg2008

2013-3-14 14:27

=IF(D5="男","A","B")&TEXT(COUNTIF(D$5:D5,D5),"00")&C5

cbg2008 · 发表于 2013-3-14 14:27

=IF(D5="男","A","B")&TEXT(COUNTIF(D$5:D5,D5),"00")&C5

qingfeng_qf · 发表于 2013-3-14 14:33

=IF(D5="男","A"&TEXT(COUNTIF($D$5:D5,D5),"00")&C5,"B"&TEXT(COUNTIF($D$5:D5,D5),"00")&C5)

Shelvee · 发表于 2013-3-14 15:12

谢谢大家的帮忙！！

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