+ Reply to Thread
Results 1 to 1 of 1

Lookup/multi functions trouble

  1. #1
    Registered User
    Join Date
    06-14-2011
    Location
    albany, ny
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unhappy Lookup/multi functions trouble

    I am very new to excel and could definitely use some help. I am trying to create a tracker for people then place them in the most desired location based on the corresponding value. My first table consist of =countif(range, "x") formulas. Then i use this information on another table with simple subtraction (i.e. =3-sheet1!cell)). This table gives me important data such as "this person has this item to do this many more times". Then my next table gives me the same type of information in reverse. Meaning, I have this item...who needs to do it. where I am getting stuck is the next few steps. I want to take the information (i.e. the names of the people) and place them in the best spot possible based on how many more times they need to do the item.
    "based on the highest number in column "B" I want the associated name to go in a different column" However, the name that ends up in that column cannot go into the column next to that one.
    Name1 4
    Name2 3
    Name3 5
    Name4 2

    Now there are multiple names and values and I am trying to optimize their placement. Also, there will be multiple names with the same number that I would like to organize in the best way. This is the first of three steps I am looking for help with. Thank you for your time!
    Last edited by kdub13; 06-14-2011 at 03:02 AM.

+ 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