excel函数求同列字符串中不重复的项

excel

1个回答

写回答

jhbknight

2025-12-21 19:39

+ 关注

=INDEX(MID($A$4:$A$10,1,FIND(-,$A$4:$A$10)-1),SMALL(IF(MATCH(MID($A$4:$A$10,1,FIND(-,$A$4:$A$10)-1),MID($A$4:$A$10,1,FIND(-,$A$4:$A$10)-1),)=ROW($1:$7),ROW($1:$7),4^8),ROW(A1)))& 数组公式

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号