excel filter not working extra rows appearing

This means that those rows are part of the filter. To work around this issue use the AutoFilter command on several smaller sectio…