Excel 2013 - Using FILTER limit the minimum number of rows returned.

[homer_123]

I've using the `FILTER` option (Auto Filter) in Excel 2013.

When filtering what I need is to place a 'minimum' number of rows that must be returned.

For example, if I place a filter on a column and then choose a filter option and the number of rows returned is less than 10 then the rows should not be shown and/ or the filter doesn't take place.

Happy to explore VBA if that is the only way to achieve this behaviour in Excel 2013.

Thanks,

Homer.

 

[Kamolga]

Sub MacFilter()
'To filter in A1 if less than 10 rows
    Range("A1").Select
    Selection.End(xlDown).Select
    If Selection.Row < 10 Then
    Range("A1").Select
    Selection.AutoFilter
    End If
End Sub