我如何让Excel向我显示是否出现了相同的值,即使它们的顺序不同 由 HeroA发布于 2020-05-09 19:14:26 excelduplicatesformula 收藏 基本上我拥有的是3列数据,第4列是3列的CONCENTATE,但是,有时数据会以不同的顺序重复,如果相同的值有,我需要用0或1突出显示或显示以不同的顺序重复,所附的图像显示了我想要发生的事情 当我在这里的桌子上敲头时,有人可以帮忙吗? 评论 请 登录后发表观点 刺青 2020-05-09 19:14:27 If you have O365 with the SORT function, you can set up a helper column: =CONCAT(SORT(A1:C1,,,TRUE)) 然后使用条件格式检查重复项。 If you don't have the SORT function, you can try: =CONCAT(INDEX(A1:C1,N(IF(1,COUNTIF(A1:C1,"<" & A1:C1)+1)))) and if you don't have the CONCAT function, try: =INDEX(A1:C1, INDEX(COUNTIF(A1:C1,"<"&A1:C1)+1,1)) & INDEX(A1:C1,INDEX(COUNTIF(A1:C1,"<"&A1:C1)+1,2))&INDEX(A1:C1,INDEX(COUNTIF(A1:C1,"<"&A1:C1)+1,3)) 点赞 评论 到底啦
If you have O365 with the
SORT
function, you can set up a helper column:然后使用条件格式检查重复项。
If you don't have the
SORT
function, you can try:and if you don't have the
CONCAT
function, try: