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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,137,301
Messages
5,680,705
Members
419,929
Latest member
Atlas Quinn

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