王薰珮,選擇性貼上,轉置Transpose,VLOOKUP,HLOOKUP,ROW
EXCEL函數:
=VLOOKUP($A2,損益表,14,FALSE)
=VLOOKUP($A13,$A$2:$F$8,F$12)
=COLUMN(E1)
=ROW(A1)
{=TRANSPOSE(F2:F5)}
=HLOOKUP(C$30,橫變直,$A34,FALSE)
王薰珮python視窗使用者介面GUI類別class建構正多邊形或星形
.PNG)
#王薰珮 教python設窗程式設計 <div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhyXm2_EKpZ8llr55im-1ENenJKmGVhrFVxxbRuwnzyvsSqZRAPSxXJKWLwOT1NgYnI0B0FZB2IQ-SW9qrmBF6XWJxU60MiRai746cIJ8L76wPgbOqH96AE6rYcVv30UxAUJwxqifRweyHJZ8mLugcKVN6WyMVNMYC5DERN-Jb8C-EmEnPrmNdRfkH6og" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="523" data-original-width="1089" height="316" src="https://blogger.googleusercontent.com/img/a/AVvXsEhyXm2_EKpZ8llr55im-1ENenJKmGVhrFVxxbRuwnzyvsSqZRAPSxXJKWLwOT1NgYnI0B0FZB2IQ-SW9qrmBF6XWJxU60MiRai746cIJ8L76wPgbOqH96AE6rYcVv30UxAUJwxqifRweyHJZ8mLugcKVN6WyMVNMYC5DERN-Jb8C-EmEnPrmNdRfkH6og=w659-h316" width="659" /></a></div><br /></div><div><pre style="background-color: white; border: 2px solid blue; color: #757575; fo...
留言
張貼留言