+ Reply to Thread
Results 1 to 5 of 5

Sort Users with their application from a chart

  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Sort Users with their application from a chart

    Hello,

    I am new to programming on Excel and was wondering, if someone could provide me some instruction and advice.

    The issue is this, I have a chart with a list of users on the left side and on the right-hand side I have cells that are filled with an 'O' ,corresponding to the application they have on their computer. If you are a little confused here is a rough sketch :

    --------------------------------------------------------------------------------------------------------------------------
    [Cell A1] Users: -|- [Cell B1] MS Paint -|- [Cell C1] MS Excel -|- [Cell D1] Chrome -|-
    --------------------------------------------------------------------------------------------------------------------------
    [Cell A2] Bob -|- [Cell B2] O -|- [Cell C2] <BLANK> -|- [Cell D2] O -|-
    --------------------------------------------------------------------------------------------------------------------------
    [Cell A3] Billy -|- [Cell B3] <BLANK>-|- [Cell C3] O -|- [Cell D3] O -|-
    ---------------------------------------------------------------------------------------------------------------------------
    [Cell A4] Bernard -|- [Cell B4] O -|- [Cell C4]<BLANK>-|- [Cell D4]<BLANK>-|-
    ---------------------------------------------------------------------------------------------------------------------------

    So lets say I wanted to see all the applications Bob has, I run the script/formula and it generates a nice window or a new sheet, that shows me his name and the apps he has.

    I have a huge list of users and a very large library of apps. It would make life easier, if I could check who has what very easily.

    If you can help me, it will be very greatly appreciated! If you can't, then pointing in me in the right direction, either by suggesting a resource where I can learn to-do something like this would be very much appreciated.

    I have tried searching online, but I am still confused as to what I should be looking for.

    Thanks!!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,776

    Re: Sort Users with their application from a chart

    you can use pivot tables.

    First sheet is based on you current data layout. You can filter Users if required.

    Second sheet is a better data layout
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-19-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Sort Users with their application from a chart

    Hi Andy,

    Wow I didn't know I could do that, thanks!

    Just out of curiosity, is there still a way to Query a search using some sort of formula? The query should return the persons name and all data associated with it. For example with Bob, his desk location, software applications, system build etc. Some of the data would be in the form of a chart, other just a dumb of information.

    Thanks again for your help!

    point0two

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,776

    Re: Sort Users with their application from a chart

    You might be able to use Autofilters
    or with formula you could try INDEX, MATCH, VLOOKUP. It's hard to say which ones exactly without knowing what the expected result is and how you intend to use it.

    And of course you can create charts based on the pivot table.

  5. #5
    Registered User
    Join Date
    10-19-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Sort Users with their application from a chart

    Thanks for your help!

    I'm going to look into the stuff you just said..

    Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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