+ Reply to Thread
Results 1 to 4 of 4

Combining 2 formulas to one in a validation list

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Combining 2 formulas to one in a validation list

    Hi, Thanks to Jarko28 I was able to create a really nice quoting tool in Excel. Of course now I’ve been playing with it and tweaking it so I now have a new question.
    I was looking to randomly generate a quote number. Reading older posts I found two that interest me and I was wondering if there is a way to combine them. I created two data validation lists, one I made the data =TODAY() and then set it to be general format so it shows the date as 41400. The other note I saw was regarding a general random number generator. That was set up in the answer to the question I read as =INT(RAND()*(322-132)+132) Is there a way to combine them both so that if I click that dropdown it would generate a number starting with the current days date in the general format plus 3 digits? Such as 41400257? I have the two formulas but I can’t seem to get them to work together. I am open to any ideas or changes to this if there is a better way. I like the current date in the general format and then just some type of 3 digit identifier. It can be sequential if easier than random. That doesn’t matter as long as they don’t repeat in the same day. At the most I may only generate 10 to 12 quotes in a day.

    Any help or ideas would be greatly appreciated.

    Dave

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Combining 2 formulas to one in a validation list

    =Today() & INT(RAND()*(322-132)+132)
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Combining 2 formulas to one in a validation list

    That did it, so all I needed was a "&". Thank you very much

    Dave

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Combining 2 formulas to one in a validation list

    Anytime...

+ 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