Just googled upon this old post when I had the same (or a similar) problem The same pathology applied I worked out in the end that when the Module has the same name as the UDF within, the UDF cannot be called / returns #NAME Go figureI don't know of any specific resource for the formulas you can use inside of the filter They need to start with an "=" sign, and you create a formula for the first row of your data, and let the filter apply that test to all the other rows, eg if your data was in D100 say, with index numbers in column 1, and you wanted just odd numbers to remain, you could use aThe applications/code on this site are distributed as is and without warranties or liability In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code
Filter Function In Excel Excel Off The Grid
