Hey Paul
Good work on the Phone number exercise. I was wondering if you don't mind
sharing the dummy *.txt file you created to test the program and also if you
could send the excel spreadsheet with the VBA code where you implemented
it. I will like to study the methodology or your approach. It
I just uploaded a file called PhoneFeatures.zip into the files area.
However, the Excel file is an Excel2007 file.
What version are you using?
Paul
On Oct 8, 2:03 am, Mog Obahor oba...@gmail.com wrote:
Hey Paul
Good work on the Phone number exercise. I was wondering if you don't mind
Hi Mctabish,
Define header to your data and simply create a pivot table from that.
PhoneID on Row, function on Column and function on Data.
You will get a table as below.
Count of Function
Function
Model
Call Forwarding
Call Waiting
Caller ID
Speed Dial
Voice
Hello.
Have a look at the attached file.
Note that the formula in cells F3 and below are array formulae (validate
with Ctrl+Shift+Enter)
HTH
Daniel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-
mac...@googlegroups.com] On Behalf Of bruce
Sent: mercredi 7
Hi,
First you have to retrieve unique phone numbers I have given the steps in
attached file then use the formula as shown in the file.
Regards
Sandeep
On Wed, Oct 7, 2009 at 6:41 AM, bruce goo...@johnsonclan.net wrote:
I am creating a program that does daily QA of our products. I work for
a
I think I know how I'd approach it.
I deal with something similar.
I use an array to store the values.
But by the time you add a couple thousand entries to the array,
it becomes very time consuming FINDING the array element that has the
correct entry to modify!
so, I use a Dictionary Object to
ok, since I haven't heard from you yet,
I went ahead and created some dummy data.
10,000 phone numbers,
50 features (called Feature_01, Feature_02, ...)
and created just under 200,000 records (196,810 actually)
I assumed that the phone number and 'feature'
were separated by a tabcharacter.
I also