Excel插入幾行後自動編號的問題:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

Excel插入幾行後自動編號的問題

Nov 17th 2014, 14:25

1.假設資料結構如下:

編號	姓名
1	老王
	老王
	老王
2	老吳
3	老張
	老張
4	老李
	老李
	老李
	老李

2.A2公式=IF(COUNTIF($B$2:B2,B2)=1,COUNTIF($A$1:A1,">0")+1,"")下拉複製
3.如有中間插入資料時,插入資料後自A1下拉複製公式即可自動更新
請試試

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