Info
You are currently browsing the Chetan Shah’s Blog weblog archives for the day 31 Oct 2008.
Categories
- AML (14)
- Foundation (4)
- Personal Finance (21)
- Technology (22)
Latest Postings
- 7 Dec 2009: Move securities to Roth Account
- 28 Nov 2009: Leverage Checksum to determine identical files
- 4 Oct 2009: CAMS Certification Preparation
- 30 Aug 2009: Section 311 etc. (ACAMS Notes)
- 24 Aug 2009: FATF Membership Points (ACAMS Notes)
- 22 Aug 2009: Internet Casinos and Prepaid Cards/E-Cash (ACAMS Notes)
- 5 Aug 2009: Spousal IRA
- 15 May 2009: Buying Call Options.
- 7 Jan 2009: Watchlist filtering white paper
- 31 Oct 2008: Autonumber in Microsof Excel (works after inserting rows)
Links
Blogroll
Archives
Archive for 31 Oct 2008
Autonumber in Microsof Excel (works after inserting rows)
31 Oct 2008 by Chetan Shah.
If you want the autonumber to work even after you insert a row in Excel, use the following formula.
=CELL(”contents”, INDIRECT(CONCATENATE(”B”, ROW()-1)))+1
I am assuming the list of values are in B column.
A simple formula =”aboverow”+1 does not work if you insert a new row which falls in the value range.
If you have a better way of doing this please let me know 
Posted in Technology | No Comments »
|