well I was thinking of doing a count the defenciate between the numbers, so if the number came once, it would add it onto the first cell and so on,

The dates and the numbers will always be different as there is a consildation function, which removes duplicate numbers and dates from the same rows,

I know how to do it but just cant seem to write it as a VB Macro

Thank you