I have a few questions:
I would like to use autofilter to get the numbers > 500 from a column(column has with both numbers and strings in cells). However, autofilter.Custom() returns the numbers greater than 500 but also returns all cells with strings.
Also, AutoFilter.MatchBlanks() and AutoFilter.MatchNonBlanks() can only be applied seperately from the autofilter.custom(). For instance, I would like to return cells with >500 or blanks fields. If I use autofilter.custom() and then matchblanks() it will only return the blanks cells(because it’s the last command executed) and the other way around. I would like to combine autofilter.custom() with either Matchblanks() or MatchNonBlanks() methods.
3)FilterTop10() method for bottomitems return blank cells as well(that’s not the case). It should return only the total amount of bottomitems with not including the blank cells.
- FilterTop10() method for topitems return blanks cells as well which it shouldn’t and also returns always one more element. Also, for instance, If you want the 3 top items it will return blank cells and 4 top items instead of returning only the 3 top items with no blank cells.
Looking forward to hearing from you.