Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to filter countries and then cities because I have calculations
that are specific to the exact spellings. My raw data is on one sheet, the calculations I do are on another worksheet. A sample of the countries is below. Country City AUSTRALIA ADELAIDE AUSTRALIA BRISBANE AUSTRALIA CAIRNS AUSTRALIA CANBERRA AUSTRALIA DARWIN NORTHERN TERRITORY AUSTRALIA FREMANTLE AUSTRALIA HOBART AUSTRALIA MELBOURNE BELGIUM ANTWERP BELGIUM BRUGGE BELGIUM BRUSSELS BELGIUM DIEGEM BELGIUM GOSSELIES As I said, I would like to filter the country, then the city, otherwise, using Data Validation lists all the cities without reference to the country. Is it possible to filter the country on my calculation sheet and then the city? Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple filters in same column | Excel Discussion (Misc queries) | |||
Multiple Column filters | Excel Discussion (Misc queries) | |||
How do I add multiple filters | Excel Discussion (Misc queries) | |||
Multiple Filters in one Sheet | Excel Worksheet Functions | |||
Joining Multiple filters with OR rather than AND | Excel Worksheet Functions |