+ Reply to Thread
Results 1 to 7 of 7

Find the lowest value of stats selected and inform the user

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Find the lowest value of stats selected and inform the user

    The user will select the day of the week and Dept letter using the filter buttons.
    The totals box automatically update with the number of customers in the Day and File number I have not included the formulas in this work book for that to keep size down.
    I want the green box with red around it to show .
    1 which day the user has selected.
    2 the department they have selected.
    And finally I need a formula to read the selected day from the stats box the user has chosen and to show the user the File number with the least amount of customers in it to keep it all even and when the stats are equal to pick a random file no and display it in the green box ive surrounded in red.
    So to cap it off when the user picks say Monday A the formula would tell them to place the customer in File 3 which has the lowest amount of customers hope this explains what im stuck on.
    Im putting this example with excel 10 but my works excel is 2003
    Please hope you can help me Steve
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Find the lowest value of stats selected and inform the user

    Maybe with an pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Find the lowest value of stats selected and inform the user

    Hi nice idea but i need the original format i posted i need a formula to run but thanks for the suport

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Find the lowest value of stats selected and inform the user

    See the attached file.

    Dutch
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Find the lowest value of stats selected and inform the user

    No guys i think you are off track abit only use my file first
    all i need is if the user picks a day and dept a formula to tell them which file to use 1,2,or 3 as at the moment they go to first 1 and it fills us and the other 2 stay less i want a formula to tell them which file has the least in it hope this helps

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Find the lowest value of stats selected and inform the user

    Sheet 2 and Sheet 3 are empty, so I don't have a clue what you are trying to achieve.

  7. #7
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Find the lowest value of stats selected and inform the user

    Ok the database is for 100 users they get a call they use the filters they pick a day say wed then they pick a dept ok they set the customer filter to blanks and what i need is a formula that will help them and tell them which file section to place the customer at the moment they are going to the first blank space which is causing file one to fill up very quickly and the other two to not so the formula needs to reconize the day and dept the user has chosen and then look in the stats table to the right and tell the user place customer in file say 2 because it has the least customers of the 3 then the next user may go into the database it would tell them to put cust in file 3 because that has the least customers on that day The table auto completes on my database but i havnt put these formulas in because i want to keep the workbook small for this site.

+ 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. [SOLVED] avoiding the excel pop up to inform a user that the sheet is protected.
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-07-2013, 01:02 PM
  2. [SOLVED] User's choice to several checkbox options will place user name on selected worksheets
    By SLJones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2013, 12:03 PM
  3. How to find duplicate entries, find which has the lowest value, and delete the rest?
    By John2810 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-05-2011, 06:39 AM
  4. Find lowest number in groups then lowest overall.
    By swieduwi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-24-2008, 01:00 PM
  5. [SOLVED] for stats worksheet in XL how do i find the minitab function
    By freethrow18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2005, 02:06 AM

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