H
hoganc
that works again but I'm looking for filter that will get rid of all o
the ones I dont want. I can easily enough find a 225 or 233 no by usin
the auto filter but I need a formula to get shut of the ones i don
want ie
3052
01517334519
07969760557
01512333016 TRUE- here 1 only want 233 or 225 no's to show up lik
this one
3018
3018
22528 TRUE--- here 2 --- dont want this to show u
02072330082
NB so long as it always counts from the right four digits and the 23
or 225 no is no.
987654321 no. of digits from RIGHT
01512253003 digits no. 5 6 7 is the 225 no
the ones I dont want. I can easily enough find a 225 or 233 no by usin
the auto filter but I need a formula to get shut of the ones i don
want ie
3052
01517334519
07969760557
01512333016 TRUE- here 1 only want 233 or 225 no's to show up lik
this one
3018
3018
22528 TRUE--- here 2 --- dont want this to show u
02072330082
NB so long as it always counts from the right four digits and the 23
or 225 no is no.
987654321 no. of digits from RIGHT
01512253003 digits no. 5 6 7 is the 225 no