Modify An Excel Formula

$10-30 USD

Completed

Posted

about 5 years ago

$10-30 USD

Paid on delivery

As you'll see in file attached, I have a formula to extract data from a crazy excel file - the purpose of which is to ultimately create a .csv file to load into a transportation dispatching app. The issue is with the columns E & H in the formula tab - extracting 'city'. It works if there are only two rows under the pickup address - it extracts "Portsmouth" under "615 Normandy St" - but returns a 0 under "106 Edison Ave." Now if I change the formula for "Edison" to: =IF(Data!A26="pickup",IF(Data!R28<>"",Data!D29,Data!D30)) - it works - but then I don't know how to nest this if it's indeed the right way to do it - with the existing formula: =IF(Data!A26="pickup",IF(Data!R28<>"",Data!D30,Data!D29)). Thanks!

Excel

Project ID: 19018137

About the project

3 proposals

Remote project

Active 5 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

Awarded to:

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$20 USD in 0 day

4.9

(298 reviews)

6.7

3 freelancers are bidding on average $23 USD for this job

@hassan115781

Hi Good Day! After reading your project details I believe I'm suitable for this project. As I'm an expert on it with more than 4 years of experience. WHY HIRE ME? *Professional service *Extra fast and timely delivery *High-quality work *Free support *And many more Please feel free to contact me. I am looking forward to hearing from you. Thanks and Best regards! Hassan

$25 USD in 1 day