$$Excel-Macros$$ Re: Phone Number Filtering

2009-06-05 Thread Dave Bonallack
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.

$$Excel-Macros$$ Re: Phone Number Filtering

2009-06-05 Thread Fabio Lemos
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

$$Excel-Macros$$ Re: Phone Number Filtering

2009-06-05 Thread Dave Bonallack
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