求助，如何写公式。数据有1万条

hh455 · 发表于 2024-5-7 15:15

求助，如何写公式。数据有1万条

xiaoai007 · 发表于 2024-5-7 15:23

=IF(MAX(IF(B10=B$10:B$19,MATCH(C$10:C$19,B$2:B$6,)))=MATCH(C10,B$2:B$6,),"保留这条","删除")

复制代码

袁勇 · 发表于 2024-5-7 15:47

=IF(ROW()=MOD(AGGREGATE(14,6,(MATCH(C$10:C$19,B$2:B$6,)*100+ROW($10:$19))/(B$10:B$19=B10),1),100),"保留这条","删除")

mountain119 · 发表于 2024-5-7 16:03

=IF(MATCH(C10,$B$2:$B$6,)=MAX(MATCH(FILTER($C$10:$C$19,$B$10:$B$19=B10),$B$2:$B$6,)),C10,"")

复制代码

mykitami · 发表于 2024-5-7 16:09

=IF(MATCH(C10,$B$2:$B$6,)=MAX(MATCH(FILTER($C$10:$C$19,$B$10:$B$19=B10),$B$2:$B$6,)),"保留这条","删除")

hh455 · 发表于 2024-5-7 17:01

谢谢可以解决问题

hh455 · 发表于 2024-5-7 17:04

袁勇发表于 2024-5-7 15:47
=IF(ROW()=MOD(AGGREGATE(14,6,(MATCH(C$10:C$19,B$2:B$6,)*100+ROW($10:$19))/(B$10:B$19=B10),1),100)," ...

谢谢谢谢

hh455 · 发表于 2024-5-7 17:06

xiaoai007 发表于 2024-5-7 15:23

谢谢谢谢

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

[求助] 求助，如何写公式。数据有1万条