Flight Log Fix - Multithread

Rylo,
Thank you for the response;
I entered =INDEX(Date,MAX(IF(Condition1= "NG",ROW(Condition1)))) as a test to see how it would perform on just 1 column of data and it returned the date with the first entry.

=LOOKUP(2,1/(Condition1="NG"),Data!A:A)
I played around with the above statement, as can see from cell G2 from my attachment, and it works for a single column!!

Don't know what I did wrong. I have attached the log for your reference.
Lastly, why did you use an INDEX vs. a LOOKUP? Just for my own SA.

Uploaded the correct file..
I did use the formula that I got a result from in cell G2. I did not array enter the formula as I only need to populate one cell with the data. Maybe I am misunderstanding the purpose of the array in this instance.

Edit: Got it all figured out!!

Please Login or Register  to view this content.

Works like a charm..

Hi

In Home!G3 I array entered the formula

Please Login or Register  to view this content.

and got the same result you got in G2.

However, as you have 3 non contiguous ranges (I originally thought that the range would cover all 3 columns), then try

Please Login or Register  to view this content.

Array entered of course. It brings back a date of 17 Oct 12, which I think is the last appearance of NG on the data sheet.


rylo