公式一(筛选重复数据,保留唯一值):
=INDEX(A:A,SMALL(IF(MATCH($A$1:$A$9&$B$1:$B$9,$A$1:$A$9&$B$1:$B$9,)=ROW($1:$9),ROW($1:$9),4^8),ROW(A1)))&""
数组公式,按ctrl+shift+enter产生花括号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd94d82ac5f3501213fb90e918d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
公式二(取日期最大值,日期必须是真日期,假日期无法计算):
=IF(E1="","",MAX((E1&F1=A:A&B:B)*C:C))
数组公式,按ctrl+shift+enter产生花括号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9a504fc2d562853528de49a79cef76c6a7ef637e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)