+ Reply to Thread
Results 1 to 2 of 2

Auto Populate Column A when Data is entered anywhere in the rest of the row.

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    1

    Auto Populate Column A when Data is entered anywhere in the rest of the row.

    Hi,

    Here is my example:


    UniqID Server IP OS
    1 Server1 1.1.1.1 Windows
    2 Server2 1.1.1.2 Linux
    3 Server3 1.1.1.10 Linux


    Basically, Column A (uniqID) will be hidden from user, however when ever user enters any information in column B,C or D - I would like Column A , on the same row, to auto increment by 1.

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Auto Populate Column A when Data is entered anywhere in the rest of the row.

    Try this in A2: =IF(COUNTA(B2:D2)=0,"",1)

    And this in A3 (then copied down as necessary): =IF(COUNTA(B3:D3)=0,"",A2+1)

    Is that what you mean?
    If I've been of help, please hit the star

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1