Blogtrottr
批踢踢實業坊 ask 板
 
[請問] excel有分配的功能嗎?
Jun 29th 2014, 21:53, by kimo6414

作者kimo6414 (凡人皆有一死)

看板ask

標題Fw: [問題] excel有分配的功能嗎?

時間Sun Jun 29 21:53:08 2014

※ [本文轉錄自 Office 看板 #1Ji1eyk2 ] 作者: kimo6414 (凡人皆有一死) 看板: Office 標題: [問題] excel有分配的功能嗎? 時間: Sun Jun 29 21:52:57 2014 (若是和其他不同軟體互動之問題 請記得一併填寫) 軟體:excel 版本:2010 A 1 A1 2 A2 3 A3 4 A4 5 A5 6 A6 7 A7 8 A8 9 A9 10 A10 這十個數字 想將An分配到B(1+3n)這個欄位 (也就是將A1值填入B4, A2值填入B7, A3值填入B10, ..依此類推) 請問這個有辦法做到嗎? -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.115.67.164 ※ 文章網址: http://www.ptt.cc/bbs/Office/M.1404049980.A.B82.html ※ 發信站: 批踢踢實業坊(ptt.cc) ※ 轉錄者: kimo6414 (140.115.67.164), 06/29/2014 21:53:08

→ soyoso:B4=IF(MOD(ROW(),3)=1,OFFSET($A$1,ROUNDDOWN((ROW(A1)-1)/ 06/29 22:03

→ soyoso:3,0),),"") 06/29 22:03

→ soyoso:B4=IF(MOD(ROW(),3)=1,LOOKUP((ROW()-1)/3,ROW($1:$65535) 06/29 22:07

→ soyoso:,A:A),"") 06/29 22:08

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜

    jmuko90 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄