|
=INDEX(C:C,SMALL(IF($G$36:G270=$I$1,ROW($36:$270),4^8),ROW(C1)))&""
上面的公式,只要$G$36:G270=$I$1,ROW($36:$270)这里面的行数一变动,公式就用不了,
比如把$G$36:G270和ROW($36:$270)同时改成$G$39:G1000和ROW($39:$1000),公式就成文本了!求助!
=INDEX(C:C,SMALL(IF($G$36:G270=$I$1,ROW($36:$270),4^8),ROW(C1)))&""
改为:
=INDEX(C:C,SMALL(IF($G$39:$G$1000=$I1,ROW($39:$1000),4^8),ROW(C1)))&""
|
|