+ Reply to Thread
Results 1 to 7 of 7

Create new list based on data from another dynamic list

  1. #1
    Forum Contributor
    Join Date
    02-15-2005
    Location
    Central UK
    MS-Off Ver
    Office 365
    Posts
    175

    Create new list based on data from another dynamic list

    Hi, and thanks for your time. Hope the title sort of makes sense.
    I've attached a spreadsheet showing the effect I'm trying to achieve. A list (which changes weekly) contains employee details and length of service. Based on the length of service I need to build a new list grouping the employees based on the service length.

    Any help would be much appreciated.

    Many thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Create new list based on data from another dynamic list

    An option would be a solution using 2 helper columns. Are you interest?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    02-15-2005
    Location
    Central UK
    MS-Off Ver
    Office 365
    Posts
    175

    Re: Create new list based on data from another dynamic list

    Absolutely - don't understand what helper columns are but I'm willing to try anything. Thank you

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Create new list based on data from another dynamic list

    Ok then. Pls give me some time for this!

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Create new list based on data from another dynamic list

    Ok. Here we are.

    In F2 and copy down.(Column F will be a helper and hidden column)

    Please Login or Register  to view this content.
    Then in G2 this ARRAY(Meaning that you have to confirm this using Control+Shift+Enter-Not just Enter) Formula.

    Please Login or Register  to view this content.
    Drag down. Same formula for the other colums changing the bold red number.

    In all my formulas here you need to change semi colons to comma. But in The example sheet is OK!
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    02-15-2005
    Location
    Central UK
    MS-Off Ver
    Office 365
    Posts
    175

    Re: Create new list based on data from another dynamic list

    Wow! I still have much to learn! Thank you.

  7. #7
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Create new list based on data from another dynamic list

    You are welcome!

    All of us, always learn something new every single day.

    Thanks for the reb*

+ 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