AdvancedFilter

Worksheet.AdvancedFilter method

Filters data using complex criteria.

public void AdvancedFilter(bool isFilter, string listRange, string criteriaRange, string copyTo, 
    bool uniqueRecordOnly)
Parameter Type Description
isFilter Boolean Indicates whether filtering the list in place.
listRange String The list range.
criteriaRange String The criteria range.
copyTo String The range where copying data to.
uniqueRecordOnly Boolean Only displaying or copying unique rows.

See Also