Modify An Excel Formula

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!

Kemahiran: Excel

Lihat lagi: excel formula network address range, adjust an existing excel formula, i will provide names address phone email etc etc on a pdf file i need the information put in an excel spread sheet under company, edit formula in excel shortcut, what is the benefit of entering or editing a formula using the formula bar, excel formulas, relative reference excel, excel formula editor, how to change formula in excel for entire column, how to edit a formula in excel to relative reference, how to edit formula in excel for multiple cells, you are required to copy some data from a text file and move it into an excel file according to my instructions, there is a design that nomarlly appear in a flyer though i don t know what it is called but i really want to learn it, how much does it cost to hire an excel exper per hour, how to write it write an article for publication in your local newspaper on the need for ghana to have an indigenous language as, i have an event and want an artist but don t know how much they charge, Modify an Excel spread sheet and email it to customers using Mozilla Thunderbird, Reverse an Excel Formula, Attached is a scanned copy of a form that we need to be created as an Excel sheet, i have an idea for an app but don t know how to code

Tentang Majikan:
( 2 ulasan ) Chesapeake, United States

ID Projek: #19018137

Dianugerahkan kepada:


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 dalam 0 hari
(298 Ulasan)

3 pekerja bebas membida secara purata $23 untuk pekerjaan ini


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 Lagi

$25 USD dalam sehari
(2 Ulasan)

Please give me oppurtinity to work

$25 USD dalam 2 hari
(0 Ulasan)