Filter an array hntsignif 11/20/2008 4:09:02 PM 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.

RE: Filter an array Gary''s Student 12/13/2008 12:48:01 PM Use AutoFilter You can select only those rows with DOI blank. Then copy/paste only those visible rows -- Gary''s Student - gsnu200820