Extracting data between 2 time periods

[rob.callaghan]

Morning...

I'm wondering if anybody could help me with some vba code.

i have some data which covers 2 days and its over 10000 rows long, i have been trying to get unique values from 1 column based on multiple criteria in 2 other columns using this formula;

SUM(--(FREQUENCY(IF($K$11:$K$10000=$F$5,IF($M$11:$M$10000=Q9,MATCH($I$11:$I$10000,$I$11:$I$10000,0))),ROW($I$11:$I$10000)-ROW($I$11)+1)>0))

it does work but as you can imagine its taking a lot of time to calculate.

i was wondering if it would be possible at all to limit the amount of data rows by just extracting the data between 2 points as there is a lot of data not actually needed... i have tried doing this but the problem i have it spans over 2 different days.

ideally i would like it to show all data from from 07:30:00 (day 1) to 07:20:59 (day 2) and then reset - is this even possible??

Many thanks in advance.

here is some sample data

data.png

[Marc L]

Morning …

Try a filter or an advanced filter, could be faster …

[rob.callaghan]

Hi Marc,

i was looking for a more automatic solution as its a report that is generated every hour by someone with limited excel skills.