PDA

View Full Version : Pull Date by Criteria for Visible cells only



Loss1003
01-23-2018, 01:54 PM
Please suggest a formula to accomplish the following.

I need to pull the earliest date into C2 and most recent date into D2 by criteria from the filtered data sheet.
If the total in Column B is >0 data needs to be pulled as above, else can be left Blank.

See attached sample file


21440

Please do not suggest a pivot-table.

Leith Ross
01-23-2018, 05:24 PM
Hello Loss1003,

In C2 of the "Table" worksheet add the formula
=SUBTOTAL(105,'Filtered-Data'!F:F)

In D2 of the "Table" worksheet add the formula...
=SUBTOTAL(104,'Filtered-Data'!F:F)

Format both C2 and D2 as Dates with the format of "m/d/yyyy"