The Excel format looks like this:
Note: Unix is in miliseconds.
1. 1586914296295 4/14/20 6:31 PM 31337 1 -1 10485780 John 0 Hey
2. 1586914316876 4/14/20 6:31 PM 31337 1 -1 10485780 John 0 I want to let you know
3. 1586914334756 4/14/20 6:32 PM 31337 1 -1 10485780 John 0 That you need to complete this page
4. 1586914417351 4/14/20 6:33 PM 1 -1 10485783 Bob 2 Right, the page will be finished tommorrow
5. 1586934436997 4/15/20 12:07 AM 1 -1 10485783 John 2 Did you complete the task?
In the example above, the gap Betweteen 5. and 4. is 20M unix.
I have a document of 30,000 lines, and looking for a way to search for messages between Bob and john, that is > 100,000,000 Unix.
So if Bob posts a message, and john replies > 100M unix after, show these messages.
Write a formula, for excel that can do the following. Note, you'll have to give me the formulas for me to apply this to my sheet, since the files are confidential.
22 freelancers are bidding on average $26 for this job
Hi, I have written an Excel formula so you can: 1) Filter those messages meeting your requirements 2) (Optional) Highlight messages Let’s discuss if you’re interested. Best regards, Duong
Hi there, Need an excel formula find the Unix amount greater than 100 M in the string of conversations between Jonh and Bob? Please message me if this is any of what you need. I’ll be standing by to help. Ige
i have an experience in excel and excel vba programming for more than ten years..i d like to help u with ur project...i can do any excel formula in a perfect and accurate way...thanks...