I am doing a quality analysis and I only want to pull the first two data points from a table from a certain person who has multiple enteries. What would be the best process to achieve this.

Here is a simplified example of what I am trying to figure out: Jake 50 Jake 62 Jake 63 Mary 52 Mary 96 Mary 95 Mary 36

My objective is to find out these:

Jake 1= Jake 2=


Mary 1= Mary 2=

Once I find out these points I have to take the average of the first two scores.

1 Answers

JvdV On

Assuming your data looks like this:

enter image description here

The formula in E2 used would look like:


Notice it's an array formula and should be entered through Ctrl ShiftEnter