å¯ä»¥éè¿å®ä½ç©ºå¼å¹¶è¾å
¥TREND线æ§æå¼å½æ°å
¬å¼æ¥è§£å³ã
1ãé¦å
éè¦å
å°Yåææ°æ®çXYåæ°æ®çé并ç²è´´å°å
¶ä»ç©ºç½åï¼å¦Z:AAåï¼æ¬é¢å¾ç¤ºæ°æ®é¨åæ10è¡ï¼ä½äºZ2:AA11ï¼ä»¥æ¤ä½ä¸ºæå¼çæ¯å¯¹æ¡ä»¶ã
2ãç¶å对Yåè¿è¡âå®ä½ââ空å¼âçæä½ï¼è¾å
¥ä»¥ä¸å
¬å¼ï¼æCtrl+Enterç»åé®ç»æï¼æ¹éå®æå空ç½ä½ç½®æå¼çææã
=TREND(OFFSET($Z$1,MATCH(X5,$Z$2:$AA$11),,2),OFFSET($AA$1,MATCH(X5,$Z$2:$AA$11),,2),X5)
å¯ä»¥åé®ä»¶
[email protected]ï¼å¸®ä½ å¤æä¸ä¸ãå¸æå¯¹ä½ ææ帮å©ï¼
追é®æçé®é¢å·²ç»è§£å³äºï¼è¯äºä½ çæ¹æ³ï¼è¿åçäºé误å¼ï¼ä¸è¿å¯è½æ¯ææä½çä¸å¤§å¯¹å§ï¼è°¢è°¢å~