ARRAY Formula: Seach Range and list row information of Non-Blanks

Consider a re-design of your data layout. Its much simpler to have just 1 single sheet to house all of the contents of 2014 - 2016. Stack it up* via copy n paste into a single sheet, adding a new col A (for example) to populate the driver name.
*Your col layouts are the same in 2014 - 2016 and each row is distinctly defined by date

Originally Posted by Max, Singapore

Consider a re-design of your data layout. Its much simpler to have just 1 single sheet to house all of the contents of 2014 - 2016. Stack it up* via copy n paste into a single sheet, adding a new col A (for example) to populate the driver name.
*Your col layouts are the same in 2014 - 2016 and each row is distinctly defined by date

Noted. Most likely if this is an issue i will create seperate driver summary sheets for each of the years. Thanks!

Edit: Will remove 2015 and 2016 as a summary just keep just 2014 for now.

Originally Posted by Vikas_Gautam

Try this..

Formula:

Please Login or Register  to view this content.

Only for one sheet..
check the attached file...

Hi Vikas,

Works great. But now i realize that I needed two formula's to do what i originally request. Just need to the dates (array formula) to self populate if there is a possible validations in 2014. Edited original post.

Here is the logic in layman's terms:

Logic for Column B (Dates) in Driver Summary:
1) If Possible violation (Column K) is blank then ignore and skip.
2) If Possible violation (Column K) is not blank:
- then use value (Dates) in cell for Column B is Driver Summary.