+ Reply to Thread
Results 1 to 5 of 5

Function to match name with group project

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82

    Function to match name with group project

    Good morning,

    I am trying to create a function using individual name to match with a specific project group. I prefer to use name is possible. Can you please help? My file contains an end example for reference.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Function to match name with group project

    Administrative note

    Still using XL2007 as indicated in your profile?
    If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
    Thanks

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Function to match name with group project

    Your data layout is a pain but as an array(enter with shift control enter) in d2 on the data sheet put =INDEX(C:C,MIN(IF(C2:C13="",ROW(C2:C13)-1)))

    it would be much simpler if each row was already labelled with the project or the project name came above the project rather than at the end

    use =SUMIFS(Data!$C:$C,Data!$B:$B,'Formula Duplication'!$B2,Data!$D:$D,'Formula Duplication'!D$1) in c2 on the formula duplication sheet and put the name the same way round in the summary table

  4. #4
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82
    Thank you! You are a genius!

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Function to match name with group project

    Administrative Note:

    Hi and welcome
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise then "Somewhere" ( country will suffice, no need to be more precise).
    Thank you for helping us to help you

+ 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. Project dates in the future and group the output
    By virtuosok in forum Excel General
    Replies: 1
    Last Post: 10-26-2017, 08:27 AM
  2. [SOLVED] Match date to project in array and calculate days since last project of same name
    By peepingtom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-22-2013, 12:37 AM
  3. [SOLVED] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  4. how to making to project group
    By x taol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2006, 12:30 AM
  5. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  6. How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By jaking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] How do I group worksheets (Lotus 123 function is "Sheet>Group Shee
    By jaking in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2005, 10:05 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