Bad Filtering Problems

Nucleus

New Member
Joined
Sep 5, 2006
Messages
1
Hello -

I need help filtering ... its seems very complicated.

Problem : If I want to filter area D which has about 1000 invoice numbers not all of them show up in the filtering index. It will go to lets say 100 - 700 and then skip 800 - 900 and in the very bottom of the index it will have lets say 850.

Problem2: At times I will be working on a spread sheet for Artist payments and I will filter by the name. When I filter by the name only that name is supposed to show but when I try to filter by name it gets scattered in the other names and it wont group. When this happend in the past I would copy and paste everything to a new spread sheet but it is starting to happen again.
Is it the excel program or me?

Please Help! i trust this program but i dont want to make any errors because of this.

- Thank you.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
hi - welcome to the board!

autofilter drop down is limited to 1000 items, I'm afraid.
 

Forum statistics

Threads
1,171,579
Messages
5,876,290
Members
433,192
Latest member
butterexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top