Need an Array f(x) I think

[Ody]

Hello all,

I've been stuck the last few days on how to accomplish something. I know it's possible, I'm just not seeing it.

I have 3 columns with data:

Column A has a serial number
Column B has type of account
Column C has a time stamp.

The serial number is assigned to an account when the account is opened and then it gets a time stamp. There can also be more than one type of account opened per session resulting in a serial number having 2 or 3 different types of accounts associated with it; each account gets the same time stamp for the session.

I can get an average time for a single type of account but I don't think its accurate because it potentially factors in other accounts opened in the same session. How do I pull the data apart so that I can look at average times per account with and with out other accounts opened in the same session? Hope this makes sense... any thoughts?

Thanks!

 

[Excelestial]

=SUMIF(A:A,D1,C:C)/COUNTIF(A:A,D1)

D1 is the cell where a serial number is held

 

[kpark91]

I have no idea what you are trying to accomplish but it sounds like you need to 'time' users for each account in sessions.

Maybe something like an array like your title suggests is needed.
Everytime a user opens an account, you can set an array with a start time by using Timer function.

'Public variable
Dim Start(1 To 1) As Double, count As Long
'count starts from 1
Sub EveryTimeUserLogsOn()
Dim ub As Long
'Everytime user logs on.
ub = UBound(Start) + 1
ReDim Preserve Start(1 To ub)
Start(count) = Timer
 
End Sub

adn then end the timer in a similar manner and get the difference.