請問Excel如何重覆列:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決

請問Excel如何重覆列

Aug 6th 2013, 03:28

〔原資料A:C欄,欲排列成E:G欄〕

	A	B	C	D	E	F	G
1	甲	65	文具一		甲	65	文具一
2	乙	68	文具二		甲	65	文具一
3					乙	68	文具二
4					乙	68	文具二
5
6
7

E1公式
=INDEX(A:A,INT((ROW()+1)/2))
右拉三欄下刷至需求
防空
=IF(INDEX(A:A,INT((ROW()+1)/2))="","",INDEX(A:A,INT((ROW()+1)/2)))
~
謝謝　Excel迷　大大　提供
=IF(OFFSET($A$1,INT((ROW(A1)-1)/2),COLUMN(A1)-1)="","",OFFSET($A$1,INT((ROW(A1)-1)/2),COLUMN(A1)-1))

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. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

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