+ Reply to Thread
Results 1 to 3 of 3

Provide starting value, then remove numbers from that value, then list what values are rem

  1. #1
    Forum Contributor
    Join Date
    03-21-2013
    Location
    USA
    MS-Off Ver
    365
    Posts
    163

    Provide starting value, then remove numbers from that value, then list what values are rem

    Is it possible to have excel keep a "tally" of numbers being used, based on information provided by the user?

    Example:
    • User enters in 300 as the starting point. (Maybe into a form field or whatever)
    • Then, once that total number is set, the user then enters in unique numbers to remove from that total.
    • The program or formula would then spit out how many total "numbers" are left, but also be able to say which "numbers" haven't been used yet.

    A Visual Example:
    I choose 250 as my starting total.
    I then type in 2, 15, 35, 99, 102.
    That means that I have 245 total numbers left to use, and of those 245, only the numbers that have not been selected can be used for the next round of numbers being chosen. Basically, anything but 2, 15, 35, 99 & 102 can be selected next out the remaining 245 numbers.

    This "number selection" process would continue until all 250 numbers have been used up. At which point, the project would be complete. This whole process in the real world could take weeks, months, or even a year or more to complete.

    I would need the ability to tell how many total numbers are left (the easy part), and then also have the ability to list exactly what numbers haven't been used yet (the hard part! (for me)).

    Is this possible? I'm sure that it is but I have no idea where to begin.
    Maybe excel isn't even the right choice for this. Maybe PHP? Maybe something else?

    This site has always been of great help to me in the past. I'm hoping that I can get some feedback/guidance on this conundrum that I'm asking about now.

    Thank you in advance to whichever genius out there is able to guide me.

    -Mike in CA
    Last edited by xlyfe; 02-15-2017 at 01:30 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Provide starting value, then remove numbers from that value, then list what values are

    There are different ways it could be done. I used a listbox form control in the attached file.
    Attached Files Attached Files
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    03-21-2013
    Location
    USA
    MS-Off Ver
    365
    Posts
    163

    Re: Provide starting value, then remove numbers from that value, then list what values are

    AlphaFrog,

    Wow!! You provided something remarkably quickly.

    I was not expecting such a quick response. I thought this was a difficult task. At first glance of the file, this looks almost perfect. You've definitely giving me a HUGE head start!! Let me play around with this a little bit and then I'll respond with my results/questions.

    Thank you thank you thank you so much!

    -Mike

+ 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: 8
    Last Post: 11-19-2014, 06:12 PM
  2. have vba remove values from one list based on entries from another list
    By frugal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2013, 06:36 AM
  3. Find common Items in two columns and add corresponding values and provide a single list
    By cell1cell2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2013, 05:24 AM
  4. Find common Items in two columns and add corresponding values and provide a single list
    By cell1cell2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2013, 05:23 AM
  5. remove dot at end of some numbers in a list
    By rhua5436 in forum Excel General
    Replies: 4
    Last Post: 09-30-2011, 01:54 AM
  6. remove irregular count of 0 from a list of numbers
    By sa02000 in forum Excel General
    Replies: 3
    Last Post: 04-12-2011, 07:49 PM
  7. [SOLVED] remove symbols and numbers from list of string
    By elaine in forum Excel General
    Replies: 1
    Last Post: 05-11-2006, 01:25 PM

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