filtering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shamoo - 21 May 2008 14:44 GMT

hi all i really need some help. the spreadsheet i have has hundreds of street
names on it and it list all the house numbers, so for example "high street"
will be on the spreadsheet 40 times then i'll have another 100 or more
streets with all the numbers displayed as well, when i chose auto filter it
brings down a drop down menu with all the streets on the spreadsheet to
choose, how do i get excel to display that list, so instead of having 1000+
of road details on the spreadsheet it only lists the street names on the
spreadsheet.

Reply to this Message

G McPherson - 25 May 2008 22:26 GMT

Try using a custom filter to search for street names that you want instead of
having to see all of the addresses in the drop down menu. For example, your
custom filter could specify "CONTAINS high street"
----------------------------------------------------------------------------------------

> hi all i really need some help. the spreadsheet i have has hundreds of street
> names on it and it list all the house numbers, so for example "high street"
[quoted text clipped - 4 lines]
> of road details on the spreadsheet it only lists the street names on the
> spreadsheet.

Reply to this Message