Hi sorry i have no clue why my last autofilter removes all values here is the filter code:The last one removes all numbers it is like it delsects all.Please Login or Register to view this content.
Hi sorry i have no clue why my last autofilter removes all values here is the filter code:The last one removes all numbers it is like it delsects all.Please Login or Register to view this content.
After Fields 10,11 and 13 are filtered, there may not be be any match(Criteria1) left to match <100, hence there is no visible cell left.
LOL i wish that was the case... there are many
i even check and look at the dropdown and everything has been de-selected.
No, I did not probably explained it well.
Once you filter the 3 columns with :="<>#N/A", assuming there are filtered visible cells, the next step is to filter these cells with Criteria1:="<100". It is highly likely there are no cells with in filtered visible cells which have values less than 100
I think i get what your saying but even when removing all other filters and just using.Please Login or Register to view this content.
It turns up empty.... changing that line to select 100 or any other number works. i have even tried to change the value of the criteria to other numbers i know are there but same result when asking to do less then.
Are the data in columns 8 texts or numbers?
Please attach a sample so that we can see what is going.
seam the format is text
but doesn't matter ever when i change it number or general.
Please attach the sample.
i wish i could.. but i found the issue. someone change the import and the numbers are stored as text. i just have to convert them back to numbers...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks