register313

¦^´_ 1# q1a2z5

A17 B17 °}¦C¤½¦¡
A17=SMALL(IF(COUNTIF($A$1:$F$15,$A$1:$F$15)>1,$A$1:$F$15,""),COLUMN(A:A))
B17=IF(ISERROR(SMALL(IF(COUNTIF($A$1:$F$15,$A$1:$F$15)>1,$A$1:$F$15,""),1+SUM(COUNTIF($A$1:$F$15,$A$17:A17)))),"",SMALL(IF(COUNTIF($A$1:$F$15,$A$1:$F$15)>1,$A$1:$F$15,""),1+SUM(COUNTIF($A$1:$F$15,$A$17:A17))))  ¦V¥k½Æ»s

ªþ¥ó.rar (4.13 KB)

¤U¸ü¦¸¼Æ: 10

2012-2-4 12:15