Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced filter and Criteria Range
I'm trying to get used to the advanced filter at the moment and the criteria
range in Excel .... I think I have it working as expected, but each time I change the critera (say changing a name from "John" to "James"), the list isnt refreshed/refiltered to show the new criteria that I entered. I have to go through the menu "Data/Filter/AutoFilter" to refresh the list to show whatever it is I changed in the Criteria.... is this normal behaviour? |
#2
|
|||
|
|||
Yes - that is how it works. You may want to experiment instead with
Autofilter. This will allow you to choose your criteria from a dropdown, and the data refreshes immediately "gearoid" wrote: I'm trying to get used to the advanced filter at the moment and the criteria range in Excel .... I think I have it working as expected, but each time I change the critera (say changing a name from "John" to "James"), the list isnt refreshed/refiltered to show the new criteria that I entered. I have to go through the menu "Data/Filter/AutoFilter" to refresh the list to show whatever it is I changed in the Criteria.... is this normal behaviour? |
#3
|
|||
|
|||
Cool, thanks!
"Duke Carey" wrote: Yes - that is how it works. You may want to experiment instead with Autofilter. This will allow you to choose your criteria from a dropdown, and the data refreshes immediately "gearoid" wrote: I'm trying to get used to the advanced filter at the moment and the criteria range in Excel .... I think I have it working as expected, but each time I change the critera (say changing a name from "John" to "James"), the list isnt refreshed/refiltered to show the new criteria that I entered. I have to go through the menu "Data/Filter/AutoFilter" to refresh the list to show whatever it is I changed in the Criteria.... is this normal behaviour? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing or ill egal extract range advanced filter | Excel Discussion (Misc queries) | |||
advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions |