Hi,
I have 2 columns of data, one is a date column and another a number column. Dates are often duplicated many times as there are multiple observations (numbers) per day. I need to extract all the values for each day, then find the median of these and return the result, so I have one single figure for each day in a new column. I think this involves a search by function such as VLOOKUP combined with the calculation to aggregate the results but don't seem to be getting anywhere.

Any ideas would be appreciated. Thanks
P