Excle中提取同一列中唯一日期对应的同行中的数值

Excle中提取同一列中唯一日期对应的同行中的数值

E2=INDEX(C:C,SMALL(IF(COUNTIF($C$2:$C$11,$C$2:$C$11)=1,ROW($C$2:$C$11),4^8),ROW(A1)))&""
F2=INDEX(B:B,SMALL(IF(COUNTIF($C$2:$C$11,$C$2:$C$11)=1,ROW($C$2:$C$11),4^8),ROW(A1)))&""
全是数组公式向下复制。
不想用数组公式，需要加辅助列
D2=IFERROR(VLOOKUP(ROW(#REF!),IF({1,0},$D$2:$D$11,$C$2:$C$11),2,0),"")
E2=IFERROR(VLOOKUP(ROW(A1),IF({1,0},$D$2:$D$11,$C$2:$C$11),2,0),"")
F2=IFERROR(VLOOKUP(ROW(A1),IF({1,0},$D$2:$D$11,$B$2:$B$11),2,0),"")
公式向下复制。
也可以EF列用一个公式
E2=IFERROR(VLOOKUP(ROW(A1),IF({1,0},$D$2:$D$11,CHOOSE(COLUMN(A1),$C$2:$C$11,$B$2:$B$11)),2,0),"")
或者=IFERROR(INDEX(CHOOSE(COLUMN(A1),$C$2:$C$11,$B$2:$B$11),MATCH(ROW(A1),$D$2:$D$11,0)),"")
向下向右复制

e2=index(c:c,small(if(match(indirect("c2:c"&counta(c:c)),indirect("c1:c"&counta(c:c)),0)=row(indirect("c2:c"&counta(c:c)),row(indirect("c2:c"&counta(c:c)),4^8)）,row(a1)))&""数组公式，同时按ctrl+shift+回车三键结束
ef=index(a:a,small(if(match(indirect("c2:c"&counta(c:c)),indirect("c1:c"&counta(c:c)),0)=row(indirect("c2:c"&counta(c:c)),row(indirect("c2:c"&counta(c:c)),4^8)）,row(a1)))&""数组公式，同时按ctrl+shift+回车三键结束追问提示 输入函数参数太多。。。。怎么解决追答e2=index(c:c,small(if(match(indirect("c2:c"&counta(c:c)),indirect("c1:c"&counta(c:c)),0)=row(indirect("c2:c"&counta(c:c))),row(indirect("c2:c"&counta(c:c))),4^8),row(a1)))
f2=index(a:a,small(if(match(indirect("c2:c"&counta(c:c)),indirect("c1:c"&counta(c:c)),0)=row(indirect("c2:c"&counta(c:c))),row(indirect("c2:c"&counta(c:c))),4^8),row(a1)))都同时按ctrl+shift+回车三键结束

简单的方式是把C列的值，在数据选项卡下删除重复项得到E列唯一数据。
根据E列中的唯一值，用函数INDEX,MATCH反向查找就可以了。
二，从你的问中，看出你是不是想用函数来实现这样的功能？
取唯一值函数有点复杂，INDEX+countif+match组合，如何使用，你直接百度就可以。
希望对有你帮助。