Sort Limits?

[mateovan]

Are there limits on the number of rows Excel will filter?

I have a spreadsheet with 10,000 rows of data. One of the columns is sorted and then captured onto another sheet in the same workbook to summarize the data associated with specific projects.

Today I noticed that some of the data was not being captured either by the filter or by the formula to capture it over to the other sheet. When I checked the filter on the column, it was not including all of the data in all of the rows.

Not sure if I am explaining that well . . . hoping someone has an idea.

Thanks.

 

[texasalynn]

Welcome to MrExcel Board!

The limit to a filter is the first 1,000 unique. The others are there just not displayed.

 

[mole999]

your filter is limited to 1000 an excel limit, hence why you are struggling

 

[mateovan]

Thanks for the two responses.

Does that also explain why data is not be captured from sheet B onto sheet A? Seems like the 1,000 unique limit for the filter explains why my filter is missing data, but NOT why all the data is not being captured.

Thoughts on that part of it?

Thanks again.

 

[Jonmo1]

I think a Clarification is needed here.

The filter is NOT limited to 1000 unique items.

How many items are displayed in the dropdown for the filter is limited to 1000 unique items.

There is a BIG difference.

You can still select custom and manually enter a value which is not listed in the 1000 unique..

 

[texasalynn]

I think a Clarification is needed here.

The filter is NOT limited to 1000 unique items.

How many items are displayed in the dropdown for the filter is limited to 1000 unique items.

There is a BIG difference.

You can still select custom and manually enter a value which is not listed in the 1000 unique..

LOL you are correct and it was what I meant but you said it much more eloquently. Thx