Excel欄位符號的換算公式:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

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

Excel欄位符號的換算公式

Jul 27th 2013, 02:23

Excel欄位符號的換算公式

Excel欄位符號RC式在Exce2010有16384欄，欄位符號A1式是XFD欄。

ZZ是702欄 (26*26+26=702，因多了單字母A. B. C…….Z。)

AAA是703欄………等等。(3英文字母個如何計算?真麻煩，如果有公式就免每次需轉換Excel欄位符號顯示方式了)

需求公式:

在B1輸入欄位符號A1式英文字母，在B2輸入公式參照B1，計算顯示欄位符號RC式的數字欄位數。

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