Arrange data

Hi All,

If I have A1=01/01/2017, A2=01/01/2017, A3=01/01/2017, A4=01/01/2017, A5=02/01/2017, A6=02/01/2017 and B1 to B6 has a value against each date what function I can use to have C1= 01/01/2017 C2=02/01/2017 and D1 to be average value of 01/01/2017 and D2 be the average of 02/02/2017?

Thanks

A macro solution, if desired.

Please Login or Register  to view this content.