+ Reply to Thread
Results 1 to 3 of 3

Column A Identifier, Coumn B Values, Perform Mathematical Function

  1. #1
    Registered User
    Join Date
    12-23-2010
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    66

    Column A Identifier, Coumn B Values, Perform Mathematical Function

    Hello,

    Let's say I have an array of values. In Column A, the values are identifiers that put the values in Column B into groups. The values in Column B are observations. For example:

    A B
    001 5
    001 7
    001 4
    001 7
    014 5
    014 2
    014 9
    030 5
    030 3
    201 5
    201 8
    201 9
    201 3
    201 2

    I want to perform a mathematical function on the values in Column B based on the groups they are in. For example, I want to perform a mathematical function on the group with the identifer '014' so that means excel would manipulate the values [5, 2, 9]. The thing is, I don't know what each group's identifier is and there is not a set amount of observations in each group. How do I do this? Can anybody do an example and perhaps use the mean as the mathematical function? So calculate the mean of each group?

    Thanks!

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Column A Identifier, Coumn B Values, Perform Mathematical Function

    See my attached workbook. Let me know if it something that works for you.

    - Moo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-23-2010
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Column A Identifier, Coumn B Values, Perform Mathematical Function

    Thanks for this. I'll see if I can use this to build off of.

+ 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