I have attached an excel file with an example of advanced filter setup. The problem i am having is getting the widlcard filters to work so that lines with account number 863XX will list with values above a certain value, but also have the subtotals list in the filter results if the value is above a certain value.
In the example shown (attached) i can't seem to get the lines listed as 86300 in the results, only the subtotals. I'm looking to get both to show in the filter results (starting at M10)
I'm really hoping someone can tell me where i am going wrong.