Dear All,
on my table I have more than 30.000 customers with the revenue. So if I want exclude by check box some of them I can see only the first or the last 10.000 customers because there is an excel filter. I can't see all customers between position 10.000 and 20.000. Any idea? Thanks
Business Analyst
Hi, maybe because auto filter will just display 10 000 unique values?
edit:In the drop Box, I mean.
Hi,
If I understand your problem correct, try using this : Click on filter drop down for the relevant column >> Number Filters >> Custom Filters. This gives you an option of inputing two parameters with an and / or option. If you use the 'greater than' option and 'less than' option together, it should give you the details of items lying between 10,000 and 20,000.
Thanks K_Mishra,
but if I put an A-Z sorting, how can see the rows between 10,000 and 20,000 result? Thanks, Christian
Es.: from row 1 to 10,000 I have dealer with name aaa, bbb.... and mmm
from row 10,001 to 20,000 I have dealer with name mmm1, nnn, pppp, .... and sss
from row 20,001 to 30,000 I have dealer with name sss1.... zzz
I'd like to select by filter the dealers "nnn" and, "ppp"
Try adding a helper column and filling it with sequential numbers...1, 2, 3, 4, etc
Then use that to filter your data on. You could then also filter on nnn and ppp
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks