+ Reply to Thread
Results 1 to 6 of 6

In a list of Code-Group-Member-value Find out max value for each member in a group

  1. #1
    Registered User
    Join Date
    01-17-2015
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    85

    In a list of Code-Group-Member-value Find out max value for each member in a group

    Dear All,

    I have some set of data in four column - "A" , "B" , "C" , "D"
    Column "A" is code
    Column "B" is Group (Set of similar code)
    Column "C" is members of code
    Column "D" is points

    There are equal member against code for specific group.
    I required a list of code -group-member-max point for all group.

    To solve this at present I filter each group, then filter each member and in
    Column "E" - "FILTER FOR MAX POINT". I put "1" against max value.
    After that I filter Column "E" for value "1". I copy this data to other
    worksheet and filter member in ascending order. Again copy the same and paste it in final result.
    I manually combine code -for example AC28,AC27,AC32,AC31. (Please refer attached file).

    For demonstration I have considered 4 group in attached file. They are " G1", "G12", "G13" , "G16".


    I need help to automate the procedure as I have long list of data. Is it required to write macro to solve the issue?

    Kindly suggest solution.

    Regards,
    PN
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: In a list of Code-Group-Member-value Find out max value for each member in a group

    Can you use pivot table and change the Pivot Field setting to by Max?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-17-2015
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    85

    Re: In a list of Code-Group-Member-value Find out max value for each member in a group

    Dear JieJenn,

    Thanks for your kind reply. I know very little about Pivot table.Yes will help me to find out max value. But I need to use this data again for final report. So I need data under column head only.

    We can alter column here and there.

    Regards,
    PN

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: In a list of Code-Group-Member-value Find out max value for each member in a group

    If that's the case, you might need to find a way to group the columns together first.

  5. #5
    Registered User
    Join Date
    01-17-2015
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    85

    Re: In a list of Code-Group-Member-value Find out max value for each member in a group

    Suppose we forget Code column ( AC4,AC1,AC3,AC7 etc) in result. I will put it manually. After that can we get required result?
    Regards,
    PN

  6. #6
    Registered User
    Join Date
    01-17-2015
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    85

    Re: In a list of Code-Group-Member-value Find out max value for each member in a group

    Minor error in Required result. I am attaching revise file.
    Regards,
    PN
    Attached Files Attached Files

+ 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. [SOLVED] Marking a whole group FALSE if one member is FALSE
    By j_Southern in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-23-2014, 11:34 AM
  2. Happy to be a member of this group.
    By excelkrishha in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-21-2013, 02:41 AM
  3. [SOLVED] MIN bid of a group member
    By jrm0523 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2012, 03:53 PM
  4. Sorting a specific group of columns by a member of that Column
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2011, 09:22 PM
  5. condition - member of a group
    By elbows in forum Excel General
    Replies: 7
    Last Post: 03-13-2006, 12:57 PM

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