Hello everyone,

For some time now I've been trying to optimize this report I am doing but I seem to fail to "beat the system".

I have a raw data report, that returns a certain number of events, that have taken place at specified time intervals. For example:

00:00 4
where 00:00 is the specified interval, and 4 is the amount of events for that period. I was able to figure out lookup for that, but the problem comes when multiples get extracted, e.g.:

00:00 4
00:00 19
00:00 8
00:00 12

I need to figure out a formula, that will lookup all the evens that have taken place at that time ("00:00" ). However, with a standard vlookup what I get is only 1 value and I don't even know how does the system chose which value to return. Anyway, any ideas will be highly appreciated !

Thanks in advance,
T.S.