Limitations of filtering
- Thread starter pedhed
- Start date
No, There is no limit
You can filter as much data as you have memory to handle it
Just be careful as Excel will slow down depending on the complexity of your formulas linked to the data
There are techniques for dealing with hundreds of thousands of rows, but they are too advanced to discuss here, but they involve the use of Conjunctive Truth Tables...
If you start getting beyond 0.5 Million and towards 1 Million Rows (Excel has a limit of 1048576 rows) you may want to consider leaving the data in a Database like Access or SQL
If you get real serious Power Pivot can handles 20-30 Millions rows quite easy
You can filter as much data as you have memory to handle it
Just be careful as Excel will slow down depending on the complexity of your formulas linked to the data
There are techniques for dealing with hundreds of thousands of rows, but they are too advanced to discuss here, but they involve the use of Conjunctive Truth Tables...
If you start getting beyond 0.5 Million and towards 1 Million Rows (Excel has a limit of 1048576 rows) you may want to consider leaving the data in a Database like Access or SQL
If you get real serious Power Pivot can handles 20-30 Millions rows quite easy
Thanks for the reply Hui.
I had edited my sheet to leave two columns of data and tried to use conditional formatting to highlight non duplicate cells. What I am finding is that a certain number of cells seem to show the conditional formatting works but the further down (past 10,000 rows) the formatting doesn't seem to work
I had edited my sheet to leave two columns of data and tried to use conditional formatting to highlight non duplicate cells. What I am finding is that a certain number of cells seem to show the conditional formatting works but the further down (past 10,000 rows) the formatting doesn't seem to work
BOBHC - I went into CF via the following..........is this what you meant?
home >conditional formatting > manage rules
I couldn't see anything specific to the data range.
I think my problem lays with my laptop overheating as it slows down when I use a filter.
I had another attempt at conditional formatting and the formatting appeared to work on the worksheet that had more than 10,000 rows.
home >conditional formatting > manage rulesI couldn't see anything specific to the data range.
I think my problem lays with my laptop overheating as it slows down when I use a filter.
I had another attempt at conditional formatting and the formatting appeared to work on the worksheet that had more than 10,000 rows.
