Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Filter by Top 10 doesn't work

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Indiana Jones - 05 May 2008 16:08 GMT
Using XL 2003 SP3, I'm trying to filter a column by Top 10.  I have
autofilter turned on, and I see the Top 10 filter option in the drop down
menu for the column I want to filter against., but when I select Top 10
nothing happens....no dialog box opens...nothing.  Selecting the custom sort
causes a dialog box to open for that function, and all the other
filter/sorting options in the drop down menu work, so I'm baffled what's
wrong with the Top 10 filter.  The column I'm sorting contains domain names
(like msn.com) and IP addresses (195.67.68.94), and I suspect the mix is the
source of the problem.  I've tried formatting the cells as General, Numbers
and Text, and it makes no difference on my ability to filter Top 10.  I can
filter by Top 10 on other columns that contain only numbers, even if the
column is formatted as General or Text category rather than as Number.

If Top 10 doesn't work, is there another way to filter a column of that sort
to show the most commonly appearing entries within a column?

Thanks.
Peo Sjoblom - 05 May 2008 16:14 GMT
It only works for numbers, note that IP addresses are text
if they are typed in like 195.67.68.94

Signature

Regards,

Peo Sjoblom

> Using XL 2003 SP3, I'm trying to filter a column by Top 10.  I have
> autofilter turned on, and I see the Top 10 filter option in the drop down
[quoted text clipped - 19 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.