# Column A Identifier, Coumn B Values, Perform Mathematical Function

1. ## 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. ## 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

3. ## 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.

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

#### 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