Shortcutting equations on larger datasets

[estehnach]

I am currently working through middle size data sets, around 1000 recordings, and want to be able to work through them quicker. My main problem is that if I have a column marked "test" with results from the tests in a different column marked "results" with the values, is there a shortcut to lets say find the average of all the "results" to test-X in the "test" column.

Something like =Avg[test==test-X(results)] would be my guess if I were to convert code to excel.

 

[Eric W]

Welcome to the forum.

Your description is a bit vague, but maybe:

Book1
	A	B	C	D	E
1	Test	Average		Results	Score
2	A	4		A	1
3	B	5.5		B	2
4	C	5		C	3
5	D	6		D	4
6				A	5
7				A	6
8				C	7
9				D	8
10				B	9
11				J	10
Sheet2

Cell Formulas
Range	Formula
B2	=AVERAGEIF(D:D,A2,E:E)

 

[estehnach]

Thank you so much! You got it in one

 

[Eric W]

Happy to help! Thanks for the feedback.