conditional average confusion

[GillL]

Hi there,

I am looking for some advice on how to find each runner's average lap time for some data I have on excel. I have two columns of data, one containing peoples names and the other column with their lap times. Each person did several laps and I am not sure of the fastest way to find out their overall average, I have been trying with the averageif function but not really getting anywhere, am I right to keep persisting with this function or is there a better way to do this? Any advice would be greatly appreciated.

Thank you!
G

[etaf]

averageif() should work for you

perhaps you could attach an example spreadsheet with some example - expected results

[AL1976]

hi,
I think you should send a file in order to get better help.
AL

[Tony Valko]

AVERAGEIF sounds like the right function to use.

What problem are you having with it?

Maybe attach a SMALL sample file that shows us what result(s) you expect.

[GillL]

Hi Everyone,

Thank you for your quick responses, I have attached an example of my data. I think I want to tell the formula to average the values in column B if the corresponding values in column A are the same. I'm not sure how to input this properly though so any advice would be greatly appreciated!

Many thanks,
G

[Tony Valko]

Create a list of the distinct P Numbers. You can do this easily using advanced filter:

http://contextures.com/xladvfilter01.html#FilterUR

Assume that list starts in D2 downwards.

Enter this formula in E2 and copy down as needed:

=AVERAGEIF(A:A,D2,B:B)