Find values in an adjacent cell based on the value in cell A and average these

**DBrouwer** · 09-10-2014, 08:14 PM

Hi Guys,

I have got a data set which in column A has got all the dates and in other columns contains values. Now some days I have got 5 values and others I might have 6, 3 or whichever. what I want to do is get an average for each day. So basically I want a formula that looks up all cells which have got the same date in column A and create an average of this. I have been trying to muck around with Vlookup but that just seems to be able to only get one value.

Thanks,

**Tony Valko** · 09-10-2014, 08:21 PM

Try this...

Data Range

	A	B	C	D	E
1	Date	Value	------	Date	Average
2	9/18/2014	97		9/28/2014	43.33333
3	9/28/2014	33
4	9/25/2014	89
5	9/4/2014	49
6	9/4/2014	93
7	9/15/2014	51
8	9/28/2014	29
9	9/13/2014	81
10	9/28/2014	68