Filter an array

I need to filter the results of my array.

I have a column "DOI" that is a date and I need the array to only display
the blank/null values into my new sheet. ie. IF(DOI=Null, DOI)

I also need to be able to bring over the Incident and owner columns only if
the DOI column is blank.

I am assuming that it would be an IF statement for the array but am having
trouble getting it working.

Use AutoFilter

You can select only those rows with DOI blank.

Then copy/paste only those visible rows
--
Gary''s Student - gsnu200820