Function for Finding the first 18 occurances of a text and averaging the first 18 values.

Hey everyone,

I was wondering if someone would want to try to help me come up with a function that will find the first 18 occurrences of a text (in this case, the text is "Test") and then average the 18 associated values that are in a different column. There are two values in the text column, "Test" and "Standard", and they are not sorted by text so Test and Standard are all jumbled together (I can't sort them without causing some problems....at least I don't think I can.)

Any help would be greatly appreciated!

Thanks!

Luke

Not sure exactly what you are asking, but if just 2 columns can sort that easily enough. Use sort filter custom sort, highlight the columns you wish to sort together, sort by col a A-Z, add a second sort in the filter sort col B low to high

Sorry for not being clear, an example of the data I have is

Test 3
Standard 4
Standard 5
Test 4
Test 5
Standard 6
Test 1
Standard 7


I wanted a function that would find the first 18 instances of "Test" and then average the values in the second column that go along with the first 18 instances of "Test" However, I think I was wrong about not being able to sort it. I was afraid if I sorted by column one, the specific order in which the "Test"s show up in relation to each other would get messed up. It's important that it is the first 18 of the original non-sorted column. But looking at it now, I don't think that will be a problem, so I'll just go ahead and sort and manually find the first 18