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)
Archives
Autonumber in Microsof Excel (works after inserting rows)
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
