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=

and

Mary 1= Mary 2=

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

Assuming your data looks like this:

The formula in

`E2`

used would look like:Notice it's an array formula and should be entered through

CtrlShiftEnter