Results 1 to 3 of 3

Thread: Assign automatic sequential control # dependent on another field

  1. #1

    Assign automatic sequential control # dependent on another field



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm trying to assign an automatic sequential control number based on another field. I want to begin with "001" and continue sequentially. However the worksheet I'm using will have multiple rows - some with bids won in which I want to assign the next number in the sequence for the control # and some with bids lost in which I want to leave blank and not assign a control number.

    I'd also like the control number to end with the value in another field (the year) to look like this in the end - "001-2014". I know I can accomplish that with a custom format.

    Here's what my worksheet looks like. I don't know why the image is so small. If anyone knows how to make it larger...

    Click image for larger version. 

Name:	excel help.jpg 
Views:	16 
Size:	82.4 KB 
ID:	2549

    Thanks

  2. #2
    Good morning,

    I think this will do it; in J2:

    =IF(G2<>"Bid Won","",TEXT(COUNTIF($G$2:G2,"Bid Won"),"000")&"-"&B2)

    And drag down.

    Best of luck,

  3. #3
    Works perfectly - thank you.

Posting Permissions

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