Finding biggest observation conditioned on several factors

H

homie

Board Regular
Joined
Nov 30, 2014
Messages
66
Hi,

I need to make a formula to return the largest number of Deposits of NOK for any given day in the previous 30 days. The deposits are timestamped by the minute. So I need to add the number of deposits per day for each day of the previous 30 days and then find the largest number of deposits for any of those days.

This formula/solution needs to be in one cell. I will copy it downward and the "present day" will change, so the previous 30 days will change as I copy it downward. The table below is where I get the information, but I will present the relevant data in another sheet entirely.

How do I go about solving this?

2nd related problem: I also need to find the largest Amount Deposited of NOK for any given day in the previous 30 days.

The dataset where I will be looking, looks like this:

Timestamp recognized by ExcelTimestamp recognized by Excel, roundedRemove USD,EUR,NOK or XBT, ETH, LTC from stringAmount American number as textCurrencyAmount European numberAction
16.09.2015 00:0916.09.2015 00:099/16/2015 0:09,100100NOK100Deposit
16.09.2015 00:1516.09.2015 00:159/16/2015 0:15,100100USD100Deposit
16.09.2015 05:5416.09.2015 05:549/16/2015 5:54,0.300150.30015XBT0,30015Withdraw
16.09.2015 14:3416.09.2015 14:349/16/2015 14:34,100100NOK100Deposit
16.09.2015 17:5116.09.2015 17:519/16/2015 17:51,48004800NOK4800Deposit
16.09.2015 18:1916.09.2015 18:199/16/2015 18:19,10001000NOK1000Deposit
16.09.2015 20:1916.09.2015 20:199/16/2015 20:19,0.26990.2699XBT0,2699Withdraw
16.09.2015 21:0416.09.2015 21:049/16/2015 21:04,0.7560.756XBT0,756Withdraw
17.09.2015 05:3017.09.2015 05:309/17/2015 5:30,20152015NOK2015Deposit
17.09.2015 06:5017.09.2015 06:509/17/2015 6:50,200200NOK200Deposit
17.09.2015 07:4017.09.2015 07:409/17/2015 7:40,900900NOK900Deposit
17.09.2015 08:4917.09.2015 08:499/17/2015 8:49,0.520.52XBT0,52Withdraw
17.09.2015 08:5317.09.2015 08:539/17/2015 8:53,0.375017920.37501792XBT0,37501792Withdraw
17.09.2015 11:0717.09.2015 11:079/17/2015 11:07,0.027079970.02707997XBT0,02707997Withdraw
17.09.2015 11:2617.09.2015 11:269/17/2015 11:26,0.801502390.80150239XBT0,80150239Withdraw
17.09.2015 11:2817.09.2015 11:289/17/2015 11:28,0.07240.0724XBT0,0724Withdraw
17.09.2015 11:2817.09.2015 11:289/17/2015 11:28,0.50.5LTC0,5Withdraw
17.09.2015 12:0817.09.2015 12:089/17/2015 12:08,0.10510.1051XBT0,1051Withdraw
17.09.2015 12:2717.09.2015 12:279/17/2015 12:27,0.40.4XBT0,4Withdraw
17.09.2015 16:3017.09.2015 16:309/17/2015 16:30,25002500NOK2500Deposit
17.09.2015 16:3317.09.2015 16:339/17/2015 16:33,0.0250.025XBT0,025Withdraw
17.09.2015 17:4017.09.2015 17:409/17/2015 17:40,1.51.5XBT1,5Withdraw
17.09.2015 17:5517.09.2015 17:559/17/2015 17:55,0.0250.025XBT0,025Withdraw
17.09.2015 17:5717.09.2015 17:579/17/2015 17:57,500500NOK500Deposit

<tbody>
</tbody>
 
Last edited:
Sort by date Sort by votes
Have to think how to create a macro...
Questions
How many rows of data do you have?
Are the dates (days) always in ascending order?

M.
 
Upvote 0

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
homie said:
P.S. In my Array formulas I have references for 99 000 rows, e.g. the equivalent of "B$2:B$25" in your formula above I have "B$8:B$99000". Does that slow down Excel? I have 10 000 rows in my dataset so far, but it might be expanded to 20 000 when I get more data, I just wrote 99 000 to be safe. But does this slow down Excel even if there is no data in most of these rows?
Click to expand...

With 99K rows the array formulas will almost certainly have a horrible performance. I think it is not a viable solution.
You did not answer the question if the dates (days) are always in ascending order. I'm trying to create a macro, that should be quick, but i'm assuming the dates are sorted. Could you confirm?

M.
 
Upvote 0
Marcelo Branco said:
With 99K rows the array formulas will almost certainly have a horrible performance. I think it is not a viable solution.
You did not answer the question if the dates (days) are always in ascending order. I'm trying to create a macro, that should be quick, but i'm assuming the dates are sorted. Could you confirm?

M.
Click to expand...
Hi,

I had to get to bed, time difference you know, hehe. Yeah, I've sorted the dates in ascending order. So far there are 10 300 rows, but it might be as much as 25 000 in the end.
 
Upvote 0
Marcelo Branco said:
With 99K rows the array formulas will almost certainly have a horrible performance. I think it is not a viable solution.
You did not answer the question if the dates (days) are always in ascending order. I'm trying to create a macro, that should be quick, but i'm assuming the dates are sorted. Could you confirm?

M.
Click to expand...

It's only 11 000 rows of data, but still way too slow. With 8 array formulas per row (derived from the two you gave), 120 rows of those, 11 000 rows of input data plus another 5000 or so in a reference sheet (which I look up for Bitcoin prices), plus plenty more formulas it is just too slow. When I press "Calculate Now" it takes about 30 minutes for Excel to calculate.

How do I solve this using Macros?
 
Upvote 0
I don't why you need 8 formulas per row. According what you've told us till now, i created the macro below thinking in 4 results per row: Largest Num per Day; Day Largest Num; Largest Deposit any day; and Day Largest Deposit

Data in Sheet1

A​
B
​
C​
D​
E​
1​
Timestamp​
Day​
Currency​
Amount European number​
Action​
2​
16/09/2015 00:09​
16/09/2015​
NOK​
100​
Deposit​
3​
16/09/2015 00:15​
16/09/2015​
USD​
100​
Deposit​
4​
16/09/2015 05:54​
16/09/2015​
XBT​
0,30015​
Withdraw
​
5​
16/09/2015 14:34​
16/09/2015​
NOK​
100​
Deposit​
6​
16/09/2015 17:51​
16/09/2015​
NOK​
4800​
Deposit​
7​
16/09/2015 18:19​
16/09/2015​
NOK​
1000​
Deposit​
8​
16/09/2015 20:19​
16/09/2015​
XBT​
0,2699​
Withdraw​
9​
16/09/2015 21:04​
16/09/2015​
XBT​
0,756​
Withdraw​
10​
17/09/2015 05:30​
17/09/2015​
NOK​
2015​
Deposit​
11​
17/09/2015 06:50​
17/09/2015​
NOK​
200​
Deposit​
12​
17/09/2015 07:40​
17/09/2015​
NOK​
900​
Deposit​
13​
17/09/2015 08:49​
17/09/2015​
XBT​
0,52​
Withdraw​
14​
17/09/2015 08:53​
17/09/2015​
XBT​
0,37501792​
Withdraw​
15​
17/09/2015 11:07​
17/09/2015​
XBT​
0,02707997​
Withdraw​
16​
17/09/2015 11:26​
17/09/2015​
XBT​
0,80150239​
Withdraw​
17​
17/09/2015 11:28​
17/09/2015​
XBT​
0,0724​
Withdraw​
18​
17/09/2015 11:28​
17/09/2015​
LTC​
0,5​
Withdraw​
19​
17/09/2015 12:08​
17/09/2015​
XBT​
0,1051​
Withdraw​
20​
17/09/2015 12:27​
17/09/2015​
XBT​
0,4​
Withdraw​
21​
17/09/2015 16:30​
17/09/2015​
NOK​
2500​
Deposit​
22​
17/09/2015 16:33​
17/09/2015​
XBT​
0,025​
Withdraw​
23​
17/09/2015 17:40​
17/09/2015​
XBT​
1,5​
Withdraw​
24​
17/09/2015 17:55​
17/09/2015​
XBT​
0,025​
Withdraw​
25​
17/09/2015 17:57​
17/09/2015​
NOK​
500​
Deposit​

<tbody>
</tbody>


Sub Main and Functions
Code: 
Option Explicit

Sub Main()
    Dim lastRow1 As Long, lastRow2 As Long, lDataFirst As Long, lDataLast As Long
    Dim shData As String, rData As Range, i As Long
    
    shData = "Sheet1"
    With Sheets(shData)
        lastRow1 = .Cells(.Rows.Count, "B").End(xlUp).Row
        Set rData = .Range("B2:E" & lastRow1)
    End With
        
    With Sheets("Sheet2")
        lastRow2 = .Cells(.Rows.Count, "A").End(xlUp).Row
        For i = 2 To lastRow2
            lDataFirst = GetFirst(rData.Columns(1), .Range("A" & i) - .Range("B" & i))
            lDataLast = GetLast(rData.Columns(1), .Range("A" & i))
            If lDataFirst > lDataLast Then
                .Range("E" & i).Resize(, 4) = Array(0, "", 0, "")
            Else
                .Range("E" & i).Resize(, 4) = GetResults(rData, lDataFirst, lDataLast, _
                                .Range("C" & i).Value, .Range("D" & i).Value)
            End If
        Next i
    End With
End Sub

Function GetFirst(r As Range, lDay As Date)
    Dim rFound As Range, lFirst As Variant
    
    Set rFound = r.Find(lDay, After:=r.Cells(r.Rows.Count), _
        Lookat:=xlWhole, LookIn:=xlValues, SearchDirection:=xlNext)
    
    If rFound Is Nothing Then
        lFirst = Application.Match(CLng(lDay), r)
        If IsError(lFirst) Then
            GetFirst = 1
        Else
            GetFirst = lFirst + 1
        End If
    Else
        GetFirst = rFound.Row - r.Row + 1
    End If
End Function

Function GetLast(r As Range, lDay As Date)
    Dim rFound As Range, lLast As Variant
    
    Set rFound = r.Find(lDay, After:=r.Cells(1), _
        Lookat:=xlWhole, LookIn:=xlValues, SearchDirection:=xlPrevious)
    
    If rFound Is Nothing Then
        lLast = Application.Match(CLng(lDay), r)
        If IsError(lLast) Then
            GetLast = 0
        Else
            GetLast = lLast
        End If
    Else
        GetLast = rFound.Row - r.Row + 1
    End If
End Function

Function GetResults(r As Range, lFirst As Long, lLast As Long, Crit1 As String, Crit2 As String)
    Dim vData As Variant, dic As Object, vKey As Variant
    Dim i As Long, lMaxCount As Long, dbMaxAmount As Double
    Dim DayMaxCount As Variant, DayMaxAmount As Variant
    
    Set dic = CreateObject("Scripting.Dictionary")
    
    vData = Range(r.Cells(lFirst, 1), r.Cells(lLast, 4))
    For i = LBound(vData, 1) To UBound(vData, 1)
        If UCase(vData(i, 2)) = UCase(Crit1) And UCase(vData(i, 4)) = UCase(Crit2) Then
            If dic.exists(vData(i, 1)) Then
                dic(vData(i, 1)) = Array(dic(vData(i, 1))(0) + 1, dic(vData(i, 1))(1) + vData(i, 3))
            Else
                dic.Add vData(i, 1), Array(1, vData(i, 3))
            End If
        End If
    Next i
    
    For Each vKey In dic.keys
        If dic(vKey)(0) > lMaxCount Then
            lMaxCount = dic(vKey)(0)
            DayMaxCount = vKey
        End If
        If dic(vKey)(1) > dbMaxAmount Then
            dbMaxAmount = dic(vKey)(1)
            DayMaxAmount = vKey
        End If
    Next vKey
    If lMaxCount = 0 Then DayMaxCount = ""
    If dbMaxAmount = 0 Then DayMaxAmount = ""
    GetResults = Array(lMaxCount, DayMaxCount, dbMaxAmount, DayMaxAmount)
End Function

Sheet2
Criteria light blue area
Results light gray area

A​
B​
C​
D​
E​
F​
G​
H​
1​
Ref Date​
Days Before​
Currency​
Action​
Largest Num per Day​
Day Largest Num​
Largest Deposit any day​
Day Largest Deposit​
2​
17/09/2015​
30​
NOK​
Deposit​
5​
17/09/2015​
6115​
17/09/2015​
3​
16/09/2015​
30​
NOK​
Deposit​
4​
16/09/2015​
6000​
16/09/2015​
4​
17/09/2015​
30​
NOK​
Withdraw​
0​
0​
5​
17/09/2015​
30​
USD​
Deposit​
1​
16/09/2015​
100​
16/09/2015​
6​
17/09/2015​
30​
USD​
Withdraw​
0​
0​
7​
17/09/2015​
30​
XBT​
Deposit​
0​
0​
8​
17/09/2015​
30​
XBT​
Withdraw​
10​
17/09/2015​
3,85110028​
17/09/2015​
9​
17/09/2017​
30​
NOK​
Deposit​
0​
0​
10​
17/09/2014​
30​
NOK​
Deposit​
0​
0​

<tbody>
</tbody>


Possibly (i hope ;)) the code may be adpated for more results.

M.
 
Upvote 0
Marcelo Branco said:
I don't why you need 8 formulas per row. According what you've told us till now, i created the macro below thinking in 4 results per row: Largest Num per Day; Day Largest Num; Largest Deposit any day; and Day Largest Deposit

Data in Sheet1

A​
B
​
C​
D​
E​
1​
Timestamp​
Day​
Currency​
Amount European number​
Action​
2​
16/09/2015 00:09​
16/09/2015​
NOK​
100​
Deposit​
3​
16/09/2015 00:15​
16/09/2015​
USD​
100​
Deposit​
4​
16/09/2015 05:54​
16/09/2015​
XBT​
0,30015​
Withdraw
​
5​
16/09/2015 14:34​
16/09/2015​
NOK​
100​
Deposit​
6​
16/09/2015 17:51​
16/09/2015​
NOK​
4800​
Deposit​
7​
16/09/2015 18:19​
16/09/2015​
NOK​
1000​
Deposit​
8​
16/09/2015 20:19​
16/09/2015​
XBT​
0,2699​
Withdraw​
9​
16/09/2015 21:04​
16/09/2015​
XBT​
0,756​
Withdraw​
10​
17/09/2015 05:30​
17/09/2015​
NOK​
2015​
Deposit​
11​
17/09/2015 06:50​
17/09/2015​
NOK​
200​
Deposit​
12​
17/09/2015 07:40​
17/09/2015​
NOK​
900​
Deposit​
13​
17/09/2015 08:49​
17/09/2015​
XBT​
0,52​
Withdraw​
14​
17/09/2015 08:53​
17/09/2015​
XBT​
0,37501792​
Withdraw​
15​
17/09/2015 11:07​
17/09/2015​
XBT​
0,02707997​
Withdraw​
16​
17/09/2015 11:26​
17/09/2015​
XBT​
0,80150239​
Withdraw​
17​
17/09/2015 11:28​
17/09/2015​
XBT​
0,0724​
Withdraw​
18​
17/09/2015 11:28​
17/09/2015​
LTC​
0,5​
Withdraw​
19​
17/09/2015 12:08​
17/09/2015​
XBT​
0,1051​
Withdraw​
20​
17/09/2015 12:27​
17/09/2015​
XBT​
0,4​
Withdraw​
21​
17/09/2015 16:30​
17/09/2015​
NOK​
2500​
Deposit​
22​
17/09/2015 16:33​
17/09/2015​
XBT​
0,025​
Withdraw​
23​
17/09/2015 17:40​
17/09/2015​
XBT​
1,5​
Withdraw​
24​
17/09/2015 17:55​
17/09/2015​
XBT​
0,025​
Withdraw​
25​
17/09/2015 17:57​
17/09/2015​
NOK​
500​
Deposit​

<tbody>
</tbody>


Sub Main and Functions
Code: 
Option Explicit

Sub Main()
    Dim lastRow1 As Long, lastRow2 As Long, lDataFirst As Long, lDataLast As Long
    Dim shData As String, rData As Range, i As Long
    
    shData = "Sheet1"
    With Sheets(shData)
        lastRow1 = .Cells(.Rows.Count, "B").End(xlUp).Row
        Set rData = .Range("B2:E" & lastRow1)
    End With
        
    With Sheets("Sheet2")
        lastRow2 = .Cells(.Rows.Count, "A").End(xlUp).Row
        For i = 2 To lastRow2
            lDataFirst = GetFirst(rData.Columns(1), .Range("A" & i) - .Range("B" & i))
            lDataLast = GetLast(rData.Columns(1), .Range("A" & i))
            If lDataFirst > lDataLast Then
                .Range("E" & i).Resize(, 4) = Array(0, "", 0, "")
            Else
                .Range("E" & i).Resize(, 4) = GetResults(rData, lDataFirst, lDataLast, _
                                .Range("C" & i).Value, .Range("D" & i).Value)
            End If
        Next i
    End With
End Sub

Function GetFirst(r As Range, lDay As Date)
    Dim rFound As Range, lFirst As Variant
    
    Set rFound = r.Find(lDay, After:=r.Cells(r.Rows.Count), _
        Lookat:=xlWhole, LookIn:=xlValues, SearchDirection:=xlNext)
    
    If rFound Is Nothing Then
        lFirst = Application.Match(CLng(lDay), r)
        If IsError(lFirst) Then
            GetFirst = 1
        Else
            GetFirst = lFirst + 1
        End If
    Else
        GetFirst = rFound.Row - r.Row + 1
    End If
End Function

Function GetLast(r As Range, lDay As Date)
    Dim rFound As Range, lLast As Variant
    
    Set rFound = r.Find(lDay, After:=r.Cells(1), _
        Lookat:=xlWhole, LookIn:=xlValues, SearchDirection:=xlPrevious)
    
    If rFound Is Nothing Then
        lLast = Application.Match(CLng(lDay), r)
        If IsError(lLast) Then
            GetLast = 0
        Else
            GetLast = lLast
        End If
    Else
        GetLast = rFound.Row - r.Row + 1
    End If
End Function

Function GetResults(r As Range, lFirst As Long, lLast As Long, Crit1 As String, Crit2 As String)
    Dim vData As Variant, dic As Object, vKey As Variant
    Dim i As Long, lMaxCount As Long, dbMaxAmount As Double
    Dim DayMaxCount As Variant, DayMaxAmount As Variant
    
    Set dic = CreateObject("Scripting.Dictionary")
    
    vData = Range(r.Cells(lFirst, 1), r.Cells(lLast, 4))
    For i = LBound(vData, 1) To UBound(vData, 1)
        If UCase(vData(i, 2)) = UCase(Crit1) And UCase(vData(i, 4)) = UCase(Crit2) Then
            If dic.exists(vData(i, 1)) Then
                dic(vData(i, 1)) = Array(dic(vData(i, 1))(0) + 1, dic(vData(i, 1))(1) + vData(i, 3))
            Else
                dic.Add vData(i, 1), Array(1, vData(i, 3))
            End If
        End If
    Next i
    
    For Each vKey In dic.keys
        If dic(vKey)(0) > lMaxCount Then
            lMaxCount = dic(vKey)(0)
            DayMaxCount = vKey
        End If
        If dic(vKey)(1) > dbMaxAmount Then
            dbMaxAmount = dic(vKey)(1)
            DayMaxAmount = vKey
        End If
    Next vKey
    If lMaxCount = 0 Then DayMaxCount = ""
    If dbMaxAmount = 0 Then DayMaxAmount = ""
    GetResults = Array(lMaxCount, DayMaxCount, dbMaxAmount, DayMaxAmount)
End Function

Sheet2
Criteria light blue area
Results light gray area

A​
B​
C​
D​
E​
F​
G​
H​
1​
Ref Date​
Days Before​
Currency​
Action​
Largest Num per Day​
Day Largest Num​
Largest Deposit any day​
Day Largest Deposit​
2​
17/09/2015​
30​
NOK​
Deposit​
5​
17/09/2015​
6115​
17/09/2015​
3​
16/09/2015​
30​
NOK​
Deposit​
4​
16/09/2015​
6000​
16/09/2015​
4​
17/09/2015​
30​
NOK​
Withdraw​
0​
0​
5​
17/09/2015​
30​
USD​
Deposit​
1​
16/09/2015​
100​
16/09/2015​
6​
17/09/2015​
30​
USD​
Withdraw​
0​
0​
7​
17/09/2015​
30​
XBT​
Deposit​
0​
0​
8​
17/09/2015​
30​
XBT​
Withdraw​
10​
17/09/2015​
3,85110028​
17/09/2015​
9​
17/09/2017​
30​
NOK​
Deposit​
0​
0​
10​
17/09/2014​
30​
NOK​
Deposit​
0​
0​

<tbody>
</tbody>


Possibly (i hope ;)) the code may be adpated for more results.

M.
Click to expand...

Thanks!

Well, it's actually
-Largest number of deposits for any given day (in the past 30)
-Smallest number of deposits for any given day (in the past 30)
-Largest amount deposited for any given day, calculated by totalling all deposits that day (in the past 30)
-Smallest (or 2nd smallest) amount deposited for any given day, calculated by totalling all deposits that day (in the past 30)

That's the 4 results per row, what we covered in the thread so far, and what I've used in the model. That is for currency NOK, then I use the same formulas for currency BTC, for a total of 8 results per row. Does this Macro do the 4 mentioned above?

Thanks so much! :) This looks like Visual Basic, which I haven't done since High School, but it will be interesting to work out :D
 
Upvote 0
You are very welcome,

If i understood correctly, the requirements are:
-For currencies NOK and BTC:
1.LDA = Largest number of deposits for any given day
2.LAA = Largest amount deposited for any given day, calculated by totalling all deposits that day
3.SDA = Smallest number of deposits (greater than zero) for any given day
4.SAA = Smallest amount (greater than zero) deposited for any given day, calculated by totaling all deposits that day

- Show the days where such values occur

- All in the past past 30 days (you can define a different number of days in column B, if you want)

Goals 1 and 2 already achieved (macro above). Now, I'll try numbers 3 and 4

M.
 
Last edited:
Upvote 0
Could you provide a data sample that also contains deposits/withdrawals for BTC?
The data sample you've already provided contains no values for such currency.

M.
 
Last edited:
Upvote 0
Marcelo Branco said:
Could you provide a data sample that also contains deposits/withdrawals for BTC?
The data sample you've already provided contains no values for such currency.

M.
Click to expand...


Here we go. I don't know how to paste the data in a neat table like you did earlier. Here it is though: (XBT is the denotion of BTC)
Note: We can exclude the (smaller than zero) requirements for your points 3 and 4 above. This is because if it makes the Model faster and simpler it is worth it. Also, with the newer data zero deposits and zero withdrawels seems not to be a thing anymore. Likely due to the increased customer base (more deposits/withdrawels).


Date onlyRemove USD,EUR,NOK or XBT, ETH, LTC from stringAmount American number as textCurrencyAmount European numberAction
16.09.20159/16/2015 0:09,100100NOK100Deposit
16.09.20159/16/2015 0:15,100100USD100Deposit
16.09.20159/16/2015 5:54,0.300150.30015XBT0,30015Withdraw
17.09.20159/16/2015 14:34,100100NOK100Deposit
17.09.20159/16/2015 17:51,48004800NOK4800Deposit
17.09.20159/16/2015 18:19,10001000NOK1000Deposit
17.09.20159/16/2015 20:19,0.26990.2699XBT0,2699Withdraw
17.09.20159/16/2015 21:04,0.7560.756XBT0,756Withdraw
17.09.20159/17/2015 5:30,20152015NOK2015Deposit
17.09.20159/17/2015 6:50,200200NOK200Deposit
17.09.20159/17/2015 7:40,900900NOK900Deposit
17.09.20159/17/2015 8:49,0.520.52XBT0,52Withdraw
17.09.20159/17/2015 8:53,0.375017920.37501792XBT0,37501792Withdraw
17.09.20159/17/2015 11:07,0.027079970.02707997XBT0,02707997Withdraw
17.09.20159/17/2015 11:26,0.801502390.80150239XBT0,80150239Withdraw
17.09.20159/17/2015 11:28,0.07240.0724XBT0,0724Withdraw
17.09.20159/17/2015 11:28,0.50.5LTC0,5Withdraw
18.09.20159/17/2015 12:08,0.10510.1051XBT0,1051Withdraw
18.09.20159/17/2015 12:27,0.40.4XBT0,4Withdraw
18.09.20159/17/2015 16:30,25002500NOK2500Deposit
18.09.20159/17/2015 16:33,0.0250.025XBT0,025Withdraw
18.09.20159/17/2015 17:40,1.51.5XBT1,5Withdraw
18.09.20159/17/2015 17:55,0.0250.025XBT0,025Withdraw
18.09.20159/17/2015 17:57,500500NOK500Deposit
18.09.20159/17/2015 17:59,2560025600NOK25600Deposit
18.09.20159/17/2015 18:01,0.0250.025XBT0,025Withdraw
18.09.20159/17/2015 19:46,1.0271.027XBT1,027Withdraw
18.09.20159/18/2015 7:51,0.431993160.43199316XBT0,43199316Withdraw
18.09.20159/18/2015 8:22,0.50.5LTC0,5Withdraw
18.09.20159/18/2015 9:37,0.01370.0137XBT0,0137Withdraw
18.09.20159/18/2015 10:08,0.10.1XBT0,1Withdraw
19.09.20159/18/2015 14:31,2.38362.3836XBT2,3836Withdraw
19.09.20159/18/2015 15:05,600600NOK600Deposit

<tbody>
</tbody>
 
Last edited:
Upvote 0
Your new data sample has only withdrawals for XBT (BTC), no deposits. Is this correct?

M.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
conditional formatting question
Replies
2
Views
156
kerm007
K
K
  • Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
310
awoohaw
awoohaw
D
  • Solved
Filter large amount of data by multiple constraints
Replies
7
Views
196
Peter_SSs
Peter_SSs
J
  • Solved
Add 1 day to a date within a range as long as 2 conditions are met [without macros]
Replies
4
Views
565
juanam
J
V
  • Question
MAx Date and Time
2
Replies
16
Views
639
awoohaw
awoohaw

Forum statistics

Threads
1,214,975
Messages
6,122,538
Members
449,088
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top