Help with generating a table based on data on sheet

[haydenmeeks]

Hi all,

I have a sheet of quite basic data, and would like to generate a table from it which reflects the number of times each sequence of data occurs.
I had it figured out I suppose, then got caught out by the stumbling block - this report is run daily, the date will change each day and I can't figure out how to get around that and seperate the data.

As you can see on the attached worksheet, the output table I desire, would seperate the data into Date, Base, Cat and then for any instance where the start and end is 300-1500 it is tallied. For any occasions where the times are not 300-1500 then it would fall into other.

I hope this makes sense. I normally do things the long way around so any way to save some time would be great.

Any help with this project would be much appreciated.

Thanks!

 

[oldbrewer]

no attached worksheet - post a few rows of anonymised data in the reply box..........