drewmorris
New Member
- Joined
- Oct 2, 2018
- Messages
- 2
Hi and thank you for all help in advance,
I have a csv. file that I download and it gives me the data like this (not real data):
A B C D
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
If possible, I would like a couple of Formulas which will give me the following:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>01999999999
For the 'Longest Call' I have tried using the following formula: {=MAX(IF(criteria_range=criteria,value_range))} but it has been giving me '00:00:00' even when there is data.
In summary, I would like a formula for extracting the longest call, longest call number and the date the call was done.
Again thank you for all help.
I have a csv. file that I download and it gives me the data like this (not real data):
A B C D
CallDate | DialledNumber | CallingNumber | CallDuration |
27/09/2018 10:34 | 01888888888 | 07333333333 | 00:04:47 |
26/09/2018 12:22 | 01999999999 | 07222222222 | 00:06:04 |
26/09/2018 11:50 | 01999999999 | 07111111111 | 00:06:13 |
19/09/2018 16:01 | 01888888888 | 07444444444 | 00:04:06 |
17/09/2018 12:43 | 01888888888 | 07555555555 | 00:19:59 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
If possible, I would like a couple of Formulas which will give me the following:
A | B | C | D |
Number | Longest Call | Longest Caller Number | Longest Call Date |
01888888888 | 00:00:00 | XXXXX XXX XXX | XX/XX/XX |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
For the 'Longest Call' I have tried using the following formula: {=MAX(IF(criteria_range=criteria,value_range))} but it has been giving me '00:00:00' even when there is data.
In summary, I would like a formula for extracting the longest call, longest call number and the date the call was done.
Again thank you for all help.