Worksheet.AdvancedFilter

Worksheet.AdvancedFilter method

Filters data using complex criteria.

public void AdvancedFilter(bool isFilter, string listRange, string criteriaRange, string copyTo, 
    bool uniqueRecordOnly)
ParameterTypeDescription
isFilterBooleanIndicates whether filtering the list in place.
listRangeStringThe list range.
criteriaRangeStringThe criteria range.
copyToStringThe range where copying data to.
uniqueRecordOnlyBooleanOnly displaying or copying unique rows.

See Also