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.
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.