Advanced filter

To display unique rows, you can use the Advanced filter.

To count unique rows in a table you can use the Advanced filter.

the Main drawback of the standard filter (Data/ Sort & filter/ Filter) – is the lack of visual information about applied at the moment the filter is necessary every time to go into the filter menu to remember the selection criteria of the records. This is especially inconvenient when applied several criteria. Advanced filter does not have this drawback all criteria are placed in separate plates over the filtered records.