Looking up by Multiple criteria the last date an event occurred ?

Hi,

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Thank you
I uploaded a file with representative sample data, the search parameters and the desired result

Hi
Why is the 1st even June 2015 and not Jan. 2015?

hi,

According to the data in the file, the first event (<>0) occurred in June 2015 (line 8)

The criteria are:
site1
type1
event <>0

thank you!

Thank you!

Works perfect !!!

Trying to figure out the solution ...

This is given that the dates are sorted in ascending way.....

Is there an alternative solution in case the records are in random order and I want to extract values only according to the criteria?

Thank you!!!

Probably there is, but I can make this work only with helpers.

In H2 and down:
=MOD(D2/1000,2)+MOD(C2/100000,2)

In I2 and down:
=1/H2

Then for the last event:

Please Login or Register  to view this content.

First Event:

Please Login or Register  to view this content.

Thank you

I learned a lot from you

Originally Posted by bebo021999

With data is in any order

OK, so that's the trick, to divide instead of multiply.....nice.

Thank you
I learned a lot from your approach

Thank you so much for the advice Bebo...I will try that