subgroup

How can I go about creating a subgroup listing of the top 2 The data Name a a b b b c c d d d d output to starting range("G15") Top 2 D = 4 B = 3 Even the simple stuff sometimes seams difficult

I use an array formula to calculate the z score of numerical results in a list. The reason I use an array formula is because each result in the list is also part of a subgroup (subgroup labeling is in a different column in the same sheet; result is on the same row as its corresponding subgroup...

Hello All, I am having a bit of trouble developing a proper sort that I will eventually be turning into a macro in which data is sorted in order within its own sub-group and then those sub-groups are sorted by the lowest value in the subgroup in descending (A-->Z) order. The data is then...

Hi, I need to figure out how to take a table of data and compute the X-Bar-Bar value from the data based on any subgroup size (n). The user would select the subgroup size, then the formula/code would calculate X-Bar-Bar from the subgroup size. That value would then be stored somewhere of my...

Hello, I was curious if anybody could point me in the right direction. Lets say I have 5 categories and each category has 5 subcategories. How could I set up a macro to not only sort the 5 subcategories (descending), but sort the 5 main categories (descending) AND keep the newly sorted...