Help with search function in Execel (Micro project)

$10-50 CAD

Closed

Posted

over 3 years ago

$10-50 CAD

Paid on delivery

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.

Excel

Data Entry

Data Processing

Project ID: 27422242

About the project

22 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

22 freelancers are bidding on average $26 CAD 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 great work for you and ensure your quality.

$30 CAD in 1 day

4.9

(405 reviews)

7.8

@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

4.9

(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

5.0

(27 reviews)

4.9

@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 assure you that you will not be disappointed by paying trust on me. Please award me the job. I promise that you will get the best work from me. I will be paid after your satisfaction. Regards Thank you. Md. Samiul islam

$20 CAD in 1 day

5.0

(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

5.0

(1 review)

0.7

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

(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 been working with these kinds of works. Let me tell you that My typing speed is 47 WMP. I am completely master in web research, extricating email, information mining, Google, Bing, Yahoo, MS Office (Full), Google Docs, Google Document, Google Spreadsheet, Adwords, Data Processing, Excel, Web Scraping, Analytics, Webmaster, and other related projects. I can guarantee you that I will have the option to present your assignment in time with quality work. I have just finished such huge numbers of ventures. If it's not too much trouble view my portfolio and profile. I am holding back to be recruited in this venture to show my abilities.

$30 CAD in 7 days

0.0

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

(0 reviews)

0.0

@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 payroll package approved by Central Defence of Accounts (R&D), Hyderabad. Use to do independently run and use to show a transactions of Rs.55,00,000/- every month of all my officers & staff got very good appreciations from Govt. employees. I AM VERY HARD WORKING PERSON, I CAN FINISH ANY KIND OF DATA ENTRY JOBS !!

$15 CAD in 10 days

0.0

(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

0.0

(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 the project. Looking forward to hear from you.

$23 CAD in 1 day

0.0

(0 reviews)

0.0

@dashiwal

Hi, I have experience of more than 20 years in IT industry, working in different technologies. this task is not very complex if you can use one column in addition to the chat column in your excel. i am sharing the small method you can use for this quickly. thanks if below text is in column A (removed srl numbers) 1586914296295 4/14/20 6:31 PM 31337 1 -1 10485780 John 0 Hey 1586914316876 4/14/20 6:31 PM 31337 1 -1 10485780 John 0 I want to let you know 1586914334756 4/14/20 6:32 PM 31337 1 -1 10485780 John 0 That you need to complete this page 1586914417351 4/14/20 6:33 PM 1 -1 10485783 Bob 2 Right, the page will be finished tommorrow 1586934436997 4/15/20 12:07 AM 1 -1 10485783 John 2 Did you complete the task? then you need to put "=LEFT(A2,13)-LEFT(A1,13)" in column B, second row and onwards, this will give you the difference between the existing row unix (MS) and previous row unix (MS) values, you can use filter with column B once you have difference.

$10 CAD in 1 day

0.0

(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 world. Best, Hasan

$10 CAD in 1 day

0.0

(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's messages which are above 100 M unix at column A, You will be getting all messages of Bob, If you need =IFERROR(IF(A1="Bob","John",(IF((FIND("Bob",B2))>0,(IF(((LEFT(B2,13)-LEFT(B3,13))/-1000000)>100,"Bob","-")),"-"))),"-")

$10 CAD in 1 day

0.0

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

(0 reviews)

0.0

@jeidretlivefm

Good morning, I'm not an excel expert but i think i could do the task. I just use formula logical and text function in excel. If you don't mind messaging me more lines to make sure that the formula i used is correct. You could delete/blur the conversation messages if it's confidential.

$15 CAD in 1 day