Closed

Help with search function in Execel (Micro project)

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?

1586934436997-1586914417351=20,019,646

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.

Skills: Excel, Data Entry, Data Processing

See more: microsoft access search function code, add search function jsp, pr4 links help search engine, excel vba find cell address based on value, excel find function, vba code to search data in excel, excel vba find string in cell, excel vba find value in column and select cell, excel vba find multiple values in range, instr vba, search function vba, gsm pic micro project, extjs add search function top project, search function microsoft project, search function asp project, I am looking for a freelancer to help me with my project. The skills required are Articles, Content Writing, Copywriting and Gho, I am looking for a freelancer to help me with my translation project. The skill required is Translation. I am happy to pay a fix, I am looking for a freelancer to help me with my project. The skills required are extremely high quality Poster Design. I am hap, I am looking for a freelancer to help me with my project. The skills required are Drupal, eLearning, Moodle and SugarCRM. I am h

About the Employer:
( 10 reviews ) Coquitlam, Canada

Project ID: #27422242

22 freelancers are bidding on average $26 for this job

datakillers

Hi,I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a grea More

$30 CAD in 1 day
(405 Reviews)
7.8
(265 Reviews)
7.6
(240 Reviews)
6.6
(167 Reviews)
6.5
hdlan

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

$50 CAD in 1 day
(51 Reviews)
6.5
IgeS

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

$20 CAD in 1 day
(27 Reviews)
4.9
SIBTEHASSANBUTT

Hi there, I have read your project entitled “Help with search function in Execel (Micro project) ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and other data visual More

$50 CAD in 7 days
(10 Reviews)
3.7
samiulvu1830

Hi There! Your job post has caught my attention because I'm a Data Entry expert and I’m considering your job for me as I have these capabilities. I always respect quality, punctuality, and commitment to my job. I can More

$20 CAD in 1 day
(3 Reviews)
0.6
jitesh20393

hello, i understand your requirements, just want to confirm, if the name ia static? pls message mw to discuss further

$15 CAD in 2 days
(1 Review)
0.7
nandysubu2020

Hi, am professional in Data Entry having over 18 years of Central Government office at DRDO, Hyderabad experienced in Word, Excel, Data Processing, Data conversion, I am proud to say that i have designed and used a pay More

$15 CAD in 10 days
(0 Reviews)
0.0
triviamaster

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...

$12 CAD in 1 day
(1 Review)
0.0
Kanika1807

Hi, I have read your task and can give you the formula as soon as you award me the project. I have 7+ years of working in excel and analytics and I have clearly understood your requirement. Requesting you to award me t More

$23 CAD in 1 day
(0 Reviews)
0.0
vasant8055

I am professional data entry expert.I can complete the work within set target time frame.I am a very honest [login to view URL] entry is my hobbie

$11 CAD in 7 days
(0 Reviews)
0.0
hasanaliaytac

Hey, Hope all is well. I am an experienced Excel specialist and happy to help you in this project. I am giving the lowest fee as this will be my first job here although I have strong background in the corporate worl More

$10 CAD in 1 day
(0 Reviews)
0.0
aslamshaik7245

I can type easily with more speed ,I can work more than 12 hours per day,I had lots of experience to do this project

$30 CAD in 7 days
(0 Reviews)
0.0
Jipu007

Hey, I am Nur-E-alam, I have your activity posting on Data Entry Project. As indicated by your set of working responsibilities you need a Data Entry Expert. For your thoughtful data I need to tell you that I have bee More

$30 CAD in 7 days
(0 Reviews)
0.0
smuslimhassan14

Not a big deal, contact me if you need to add any more filters. Place below mentioned formula on A2 onwards and data ( excluding serial number ) from B2 onwards, and filter "Bob" for Bob's messages and "John" for John' More

$10 CAD in 1 day
(0 Reviews)
0.0
dhuhadler

I will summarize all the lectures and will provide you quality notes. Please award me the project so that we can discuss it more.. Thanks!

$10 CAD in 4 days
(0 Reviews)
0.0
nitinpathak14199

Hi, Myself Nitin Pathak from India. I have been working as Internal Auditor & i receive all data from clients in excel then i make that raw data into Meaningfull data using excel basics & advance Features like V lookup More

$25 CAD in 7 days
(0 Reviews)
0.0
adityaprasad1609

I am professional in this field and I have experience also as I work as a DTP operator in printing press. Aditya Prasad.

$30 CAD in 5 days
(0 Reviews)
0.0