Date Sorting

[Lucy89]

Hi

I have data in column F that contains the time and date for the month April 2016.

I would like to sort the data so that data that contains the 1st is sorted to F1:F999, 2nd F100:F1999, 3rd F2000:F2999 .... and so for the rest of the month so that the 30th would be F30000:f30999.

Is this something that can be achieved pleased?

Many thanks,

L x

Here is my file:

TinyUpload.com - best file hosting solution, with no limits, totaly free

 

[jarjarbingie]

Hi

I have data in column F that contains the time and date for the month April 2016.

I would like to sort the data so that data that contains the 1st is sorted to F1:F999, 2nd F100:F1999, 3rd F2000:F2999 .... and so for the rest of the month so that the 30th would be F30000:f30999.

Is this something that can be achieved pleased?

Many thanks,

L x

Here is my file:

TinyUpload.com - best file hosting solution, with no limits, totaly free

I didn't quite get the requirement but if you want to generate 999 rows per date, then you can use this formula:

F1=DATE(2016,4,INT(ROW()/1000)+1)