+ Reply to Thread
Results 1 to 4 of 4

Project Number Generator

  1. #1
    Registered User
    Join Date
    01-23-2019
    Location
    SAUDI ARABIA
    MS-Off Ver
    MICROSOFT EXCEL 2013
    Posts
    2

    Exclamation Project Number Generator

    Dear Excel Forum

    i'm trying to create a project number generator using excel by choosing from a selection as per the spreadsheet provided in the link below

    the goal is to use the solution that you would point out to show an auto generated project number as shown in the spreadsheet. the last 4 digits should be sequential based on the previous projects related to the portfolio & owner

    https www . dropbox . com /s / gcqof03o90wbnub / example . xlsx?dl=0

    thank you & Best regards

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Project Number Generator

    Your link does not work Please attach the file HERE.

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Project Number Generator

    This formula does the trick..

    Please Login or Register  to view this content.
    See attachment for working formula in your example.

    The text formula's are needed for the formatting of leading zero's
    the Vlookups find code for the selected Owners or Portfolio no.
    the count if counts how many Owner-Portfolio combinations there were before the current row.
    The first project of a combo will start result in 0 so we need to add 1 to have projectno start at one.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-23-2019
    Location
    SAUDI ARABIA
    MS-Off Ver
    MICROSOFT EXCEL 2013
    Posts
    2

    Re: Project Number Generator

    Dear Roel,

    thank you for your reply, your approach seems manageable and easy to use.

    thank you again and much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-11-2017, 03:10 AM
  2. Random number generator with x number of duplicates
    By atomichybrid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2016, 05:48 AM
  3. Replies: 1
    Last Post: 05-02-2014, 03:05 PM
  4. Number generator
    By Desina in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2013, 12:08 PM
  5. Linking a project name to a project number
    By tvg543 in forum Excel General
    Replies: 2
    Last Post: 11-08-2012, 04:39 PM
  6. same number appears in a random number generator
    By Carmel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2006, 07:25 PM

Tags for this Thread

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