Hi Lion123,
Have a look at the attached. I've used random numbers to test it.
Details on the sheet.
Hope this is sort of what you want.
Anyway, really interesting.
Regards - Dave.
I am trying to sort special numbers in a long list of telephone
numbers (7 digits). For example:
a.
see atached file... I've created a name for the formula on column B and used
it in the conditional format condition.
2009/6/5 Lion123 asadnave...@gmail.com
I am trying to sort special numbers in a long list of telephone
numbers (7 digits). For example:
a. Highlight yellow those numbers
Hi Fabio,
That's a very interesting approach to the problem, and a very good formula.
Regards - Dave.
From: flnle...@gmail.com
Date: Fri, 5 Jun 2009 09:29:46 -0300
Subject: $$Excel-Macros$$ Re: Phone Number Filtering
To: excel-macros@googlegroups.com
see atached file... I've created a name