identifying a cell by the cell next to it

[jedonnel]

I am wondering if there is a way to identify a cell in a formula by essentially calling it "the cell to the right of X"

I have a table of multiple test scores from multiple people and the time it took to complete the test. For simplicity it looks like this

A B C D E
1 Student 1 Student 2
2 Score Time Score Time
3 Test 1 10 3:00 8 2:20
4 Test 2 9 3:10 11 3:11
5 Test 3 12 3:30 10 2:55


I need to throw out the low score and the time associated with it for averages. I'm fine with identifying the low score in column B (and D) and excluding it from the average. Is there a way, though, to do an average of column C that excludes the cell to the right of the lowest value in column B? Sorting is not an option because to do it individually for each student would remove the association between the scores and what test they were for.

Thanks in advance.


EDIT: Sorry, the spacing didn't work out in my example, but hopefully the point is clear

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?
C7 copied to E7

Excel Workbook
	A	B	C	D	E
1		Student 1		Student 2
2		Score	Time	Score	Time
3	Test 1	10	3:00	8	2:20
4	Test 2	9	3:10	11	3:11
5	Test 3	12	3:30	10	2:55
6
7	Average		3:15		3:03
Average Excluding Min Score