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 Ma
sed \ 60
> > tSec = tElapsed Mod 60
> > msg = msg & Chr(13) & Chr(13)
> > If (tMin > 0) Then msg = msg & tMin & " mins "
> > msg = msg & tSec & " sec"
> > MsgBox msg
> >
Chr(13)
> If (tMin > 0) Then msg = msg & tMin & " mins "
> msg = msg & tSec & " sec"
> MsgBox msg
> Application.StatusBar = False
> End Sub
> Sub Load_Features()
> Dim FeatureCnt, C
> FeatureCnt =
>
ication.WorksheetFunction.CountA(ThisWorkbook.Sheets(SummarySht).Range("A1:XY1"))
For C = 2 To FeatureCnt
If (Not Dict_Features.exists(ThisWorkbook.Sheets(SummarySht).Cells(1,
C).Value)) Then
Dict_Features.Add ThisWorkbook.Sheets(SummarySht).Cells(1,
C).Value, C
End If
Nex
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 sto
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 wrote:
>
> I am creating a program that does daily QA of our products. I work for
> a phone company and w
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
