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.
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.