+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : How to determine which cell is occupied and has least value?

  1. #1
    Registered User
    Join Date
    12-27-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    24

    Unhappy How to determine which cell is occupied and has least value?

    I have to simulate bank transactions using excel. I've generated random numbers for the service time as well as the arrival time. The customer chooses the available server upon arrival. If all servers are occupied, the customer will wait in the shortest queue. Otherwise, if more than one server is available upon arrival, the customer chooses server 1 by default, then 2 and so on. The shortest queue is the earliest time of departure of the customer currently served by the servers. What would be the syntax for choosing which server the customer should go to? How do I determine which cell is occupied and how can i compare cells which are not exactly in order, to see which has the least value. I have attached the file for reference. please help.
    Attached Files Attached Files
    Last edited by whattodo; 01-30-2011 at 02:51 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to determine which cell is occupied and has least value?

    I'd be inclined to insert a blank column between Arrival (H) and Server 1 Start such that the latter moves from Col I to Col J and Col I is blank - at which point:

    Please Login or Register  to view this content.
    then copy J6:K362 and paste to L6:Q362

    I would also revise the Waiting Time calculation (Col R post column insert)

    Please Login or Register  to view this content.
    edit: figured I should add a working sample as proof of concept
    Attached Files Attached Files
    Last edited by DonkeyOte; 01-30-2011 at 11:29 AM.

  3. #3
    Registered User
    Join Date
    12-27-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: How to determine which cell is occupied and has least value?

    thank you so much for the help!

+ 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