Hello guys,
I have a table with many rows (over 10000) and I would like to filter all cells by the first digit of a column, let say C.
This column has different numbers and simply I don't know how to filter them so that to keep only those numbers which start with 9. Of course, I would prefer to avoid any indirect method (looping, ordering + finding first and last relevant row, and so on) and to use the common AutoFilter feature, which is simpler and fast.
Basically, the column that should be filtered is like below:
3161131
9161132
2039811
9670316
1670317
9161131
6670325
...........
Taking into account that I should get something like
9161132
9670316
9161131
...........
are there any way (at code level) to turn AutoFilter method to advantage ?
Thank you in advance.
Daniel
Bookmarks