Filter and Sort

[siobeh]

Hello,

Could you please help me with my problem.
I just want to filter and sort the data based on names and hours.

Here it goes:

1. Filter Column F.
2. Filter it by: UK & M UK
3. After that, filter Column E in "Ascending order"
4. Count the data that are:

-starts 1:01AM - 7:59AM and display the total count in Sheet2, if there are no data in other specific time, then display a value "0"

For example for UK and M UK:

In Sheet 2, ("F5") = 3 as there are 3 data, G5=1, H5=0 and so on and so forth..

I've attached my file. Thank you gurus and more power to this forum!

[daffodil11]

You lost me at

-starts 1:01AM - 7:59AM and display the total count in Sheet2, if there are no data in other specific time, then display a value "0"

For example for UK and M UK:

In Sheet 2, ("F5") = 3 as there are 3 data, G5=1, H5=0 and so on and so forth..

Sheet2 is blank. Is 1:01AM - 7:59AM supposed to be a time range? That's only 7 hours, so you'd need more than 3 cells for all time ranges.

[siobeh]

Hi daffodil11,

Apologies for wrong attachment.
I've now attached the correct file and have comments/steps on it.

Column("F4") [ 1:00 AM ], this means the time range is 1:00AM - 7:59 AM due to the other columns is next to it.

Please let me know need clarifications.
Thanks in advance!

[siobeh]

Can anyone help me on this please