Filter limits?

L

Leslie

I have a spread sheet with filters, i am noticing that when i am looking for
an item in one of my filters it is not there, but if I sort the actual spread
sheet and look for it that way it is there? Why isn't it in the filter? Is
there a row limit?
 
P

Pete_UK

The drop-down can only display up to 1000 different items (in Excel
2003 and earlier). However, you can still get to the item that you
want. For example, if your items are text items then in a helper
column you can just have the initial letter (=LEFT(A1,1), copied down)
and filter on that. Then you can apply the filter to your main column
and you will only see the items which begin with the letter you have
selected from your helper column.

Hope this helps.

Pete
 
L

Leslie

Thank you! Makes sense now.


Pete_UK said:
The drop-down can only display up to 1000 different items (in Excel
2003 and earlier). However, you can still get to the item that you
want. For example, if your items are text items then in a helper
column you can just have the initial letter (=LEFT(A1,1), copied down)
and filter on that. Then you can apply the filter to your main column
and you will only see the items which begin with the letter you have
selected from your helper column.

Hope this helps.

Pete
Click to expand...
 
Top