班门弄斧5:返回最近进货数量!(已修改)

doggie520

<p>自定义:</p><p>AA=IF(SUM(1/COUNTIF('1'!$B$2:$B$13,'1'!$B$2:$B$13))&gt;=ROW('1'!$1:$12),T(INDIRECT("B"&amp;SMALL(IF(MATCH('1'!$B$2:$B$13,'1'!$B$2:$B$13,)=ROW('1'!$1:$12),ROW('1'!$2:$13)),ROW('1'!$1:$12)))),"")</p><p>=CHOOSE(COLUMN(A:C),IF(AA="","",MAX((INDEX(AA,ROW(1:12))=B2:B13)*A2:A13)),AA,IF(AA="","",IF(AA="","",SUM(((MAX((INDEX(AA,ROW(1:12))=B2:B13)*A2:A13))&amp;INDEX(AA,ROW(1:12))=A2:A13&amp;B2:B13)*C2:C13))))</p><p></p>

doggie520

<p>自定义:</p><p>AA=IF(SUM(1/COUNTIF($B$2:$B$13,$B$2:$B$13))&gt;=ROW($1:$12),T(INDIRECT("B"&amp;SMALL(IF(MATCH($B$2:$B$13,$B$2:$B$13,)=ROW($1:$12),ROW($2:$13)),ROW($1:$12)))),"")</p><p>内存数组:</p><p>=CHOOSE(COLUMN(A:C),TEXT(IF(AA="","",MAX((INDEX(AA,ROW(1:12))=B2:B13)*A2:A13)),"yyyy/m/d"),AA,TEXT(IF(AA="","",SUM(((MAX((INDEX(AA,ROW(1:12))=B2:B13)*A2:A13))&amp;INDEX(AA,ROW(1:12))=A2:A13&amp;B2:B13)*C2:C13)),"?;;;"))</p><p>改上面上第三列格式出错情况.</p>

[此贴子已经被作者于2008-8-26 23:55:49编辑过]

wsmnjj

学习

doggie520

<p>AA:=N(SMALL(IF(MATCH($B$2:$B$13,$B$2:$B$13,)=ROW($1:$12),ROW($2:$13),14),ROW($1:$12)))</p><p>=IF(AA=14,"",CHOOSE(COLUMN(A:C),LOOKUP(AA,ROW(1:14),A:A),LOOKUP(AA,ROW(1:14),B:B),LOOKUP(AA,ROW(1:14),C:C)))</p>

doggie520

<p>还有一个想法:</p><p>利用=OFFSET(A2:C2,5,)可以返回{A6,B6,C6}这个想法.</p><p>可是一直没有成功........</p><p>笨笨团长,你来看看........</p><p>明天再看看!!</p>

doggie520

<p>哈哈..哈哈.......</p><p>=IF(SUM(1/COUNTIF($B$2:$B$13,$B$2:$B$13))&gt;=ROW($1:$12),OFFSET(INDIRECT("A"&amp;SMALL(IF(MATCH(B2:B13,B2:B13,)=ROW(1:12),ROW(2:13),14),ROW(1:12))),,,,3),"")</p><p>内存数组......真假不理了...!</p>

[此贴子已经被作者于2008-9-4 0:25:16编辑过]

yl_li

[em01]

szyygb

路过，学习一下

yaoxuejian

[em01]

vbyou127

66565