Sort Limits?

mateovan

New Member
Joined
Dec 2, 2008
Messages
2
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

Well-known Member
Joined
May 19, 2002
Messages
8,458
Welcome to MrExcel Board!

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

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,939
Office Version
2019, 2016, 2013
Platform
Windows
your filter is limited to 1000 an excel limit, hence why you are struggling
 

mateovan

New Member
Joined
Dec 2, 2008
Messages
2
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

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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

Well-known Member
Joined
May 19, 2002
Messages
8,458
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
 

Forum statistics

Threads
1,084,859
Messages
5,380,326
Members
401,665
Latest member
iahmad

Some videos you may like

This Week's Hot Topics

Top