A至H列的数据都跟随显示在K至R列。
J列数据和A至H列区域的数据是公式所得,会更新。
谢谢!
æ¬é®é¢æé®æ带æªå¾æ¯é¾å¾ä¸è§çè§èæªå¾ï¼è¡å·åæ åæ¸ æ¥å¯è§ï¼æ´ä¸ªæªå¾æ¾å¤§åå¾æ¸ æ¥ãç¹ä¸ªèµï¼👍
追é®è¿ä¸ªå
¶å®å¾ç®åï¼æå¯è½è¯´å¤æäºã
以Jåè¾å
¥çæ°æ®ä¸ºåï¼å»Cåæ¥æ¾ãå¦ææç¸åçï¼å°±æç
§å¾ä¸æ¾ç¤ºå¨Måãåæ¶å°åæ¥Cåæåå
æ ¼ï¼è¯¥è¡çæ°æ®ï¼ï¼æè¾¹ç,A,BååD,E,F,Gï¼é½è·çæ¾ç¤ºåºæ¥ã
æ¯å¦J3æ¯13ï¼å¨CåçC4ä¹æ13,é£ä¹å°±å°ï¼A4,B,4,C,4,....G4é½æ¾ç¤ºåºæ¥ãï¼å¦æå¯ä»¥ææ¾ç¤ºç¼å·ä»å°å°å¤§æ¥æ¾ç¤ºå°±æ´å¥½äºï¼ã
C4ä¸C8没æå
³ç³»ãåæ¾ç¤ºçæ¶åèèä¸ä»ä»¬åèªçæ¾ç¤ºç¼å·å³å¯
谢谢ï¼
å°±æ¯è¯´Jåä¸çæ°æ®å¦æå¨Cåæ¾å°çå°±å¼ç¨è¿æ¥ï¼å¹¶æMåä»å°å°å¤§æåºã对åï¼
ç°å¨æè¿ä¸ªè¯´æ³ç»ä½ 设计å
¬å¼ãçä¼æ¥çä½ ç追é®ï¼çææ¯å¦ç解对äºã
æ¯è¿æ ·çï¼âææ1âè´è´£æ¾ç¤ºGåææ°æ®ãâææ2âè´è´£æ¾ç¤ºHåææ°æ®ç
追çå好äºææ1ï¼åå¤ç»ä½ å
¬å¼äºï¼åç°è¿æä¸ä¸ªé®é¢ââææ2ãåµåµï¼ä½ åçä¼çç®åï¼ä¸ä¸ªæ åé¢ï¼è¿ä¸¤ä¸ªé®é¢ãåçä¼å§
第2个æ´é¾ï¼è¦ä¸çäºï¼æä¸ç»ä½ å¼å§
åååï¼å¤è°¢å¦ï¼å¥½äººæ好æ¥æ»´ï¼
追çä¸åæææ1è¿ç解éäºï¼å¿½è§äºGåçæ¡ä»¶ï¼æ以è§å¾ææ2è¦é¾ä¸äºï¼å ¶å®ä¸¤ä¸ªæ¯ä¸æ ·çã
å ¬å¼ï¼
M2ï¼
=IFERROR(SMALL(IF(COUNTIF($J$2:$J$26,($G$2:$G$26<>"")*$C$2:$C$26),$C$2:$C$26,""),ROW(1:1)),"")
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
K2å
¬å¼ï¼
=IF($M2="","",INDEX($A$2:$H$26,MATCH($M2,$C$2:$C$26,),COLUMN(A:A)))
å¤å¶K2å°L2ãN2ï¼å³æN2å°Q2ï¼éæ©K2:Q2ï¼ä¸æå°åºç°ç©ºç½åå æ ¼ã
æM2çå ¬å¼å¤å¶å°U2ï¼æå ¬å¼ä¸çGåä¿®æ¹ä¸ºHåï¼
=IFERROR(SMALL(IF(COUNTIF($J$2:$J$26,($H$2:$H$26<>"")*$C$2:$C$26),$C$2:$C$26,""),ROW(1:1)),"")
åæ ·åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
S2å ¬å¼ï¼
=IF($U2="","",INDEX($A$2:$H$26,MATCH($U2,$C$2:$C$26,),COLUMN(A:A)))
åå³å¤å¶åææåææ1ã
该追å ç¹æ¬èµåå§ã
å
¬å¼å®å
¨æ²¡æé®é¢ã
ä½Cåæ°æ®ï¼åå
ä¸æ¹æ¾ç¤ºç»¿è²ä¸è§æ¶ï¼Måå°±æ æ³è¿è¡ãææ¯2010çç¹å»å¿½ç¥é误åè¿æ¯ä¸è¡ï¼å°Cåæ¹æææ¬ä¹ä¸è¡ãå¿
é¡»è¦æå¨è¾å
¥æ个æ°ï¼Måæè¿è¡æ£å¸¸ã
ä½å®é
è¿ç¨æ¶ï¼è¯¥è¡¨çAåå°Jåé½æ¯è¦å
¬å¼è¿è¡åæå¾å°æ°æ®ã
ææ»å
±åªæ15åï¼é½å¥ä¸ï¼ä¹å°å¾å¯æï¼ææå¦ï¼
ä½ æ¯è¯´ä½ çCåå¯è½æ¯ææ¬æ°ååï¼æK2çå
¬å¼ä¿®æ¹ä¸ºï¼
=IFERROR(SMALL(IF(COUNTIF($J$2:$J$26,($G$2:$G$26"")*$C$2:$C$26),--$C$2:$C$26,""),ROW(1:1)),"")
Cåæ¯å ¬å¼è¿ç®åå¾å°çæ°åæ¶ï¼Måå°±ä¸æ£å¸¸ãå¨Cåæå¨è¾å ¥ææ¬æ°åï¼Måæä¼æ£å¸¸è¿ç®ï¼Måæ£å¸¸Kåå°±è·çä¹æ£å¸¸ã
追çCåçå ¬å¼æ¯ææ ·çï¼