LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ) )" /> LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ) )"> LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ) )" />

Excel logic!

30.0 GBP

30.0 GBP peopleperhour Technology & Programming Overseas

6 hour ago

Description

I have the 3 parts that work indpendendtly.
But am trying to combine but does not work. Tried chat ChatGOT.
Ideally what i want is something like "Part A - Exact Matc_Part B- Exact Match_Part C - LOW MATCH" etc
PART A

=IF(LEFT(F17, 11)=LEFT(L16, 11), "Part A - Exact Match", IF(LEFT(L16, 5)<>LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ))

Go Now

Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Similar Teleworks

Develop a Multi-Section E-Commerce Site on Word Press

I already have an existing e-commerce website called UShopWeDrop.ng though recently built, we cater to the needs of parents with children in boarding schools. We want to expand that to include a platform for geo-location hyper local vendor market place. Please find attached the extended document showing the ideal product requirements. Please Note: Some of the features of the website are already existing so everything must not be built or added from scratch.

250.0 USD Technology & Programming peopleperhour Overseas

1 days ago

design a tour operator / Law expert website

I need a simple yet elegant and eye-catching website offering tour packages and Law services. this is a low budget task so we will use free template or comeup with your ideas. 1. We make two sections of the site offering services from Tours and Law services 2. Need text sent through email auto included in blogs 3. preferably be developed in a simple site editor for later edits 4. WooCommerce not needed

25.0 USD Technology & Programming peopleperhour Overseas

1 days ago

Three.js Expert to Create Point & Click

We seek a three.js expert who can create a click-and-drag indicator for an existing 3D object in a browser. We currently are within a Three.js project where we are rendering a 3D object in the canvas.…

$7-$12/hourly Technology & Programming Guru Overseas

1 days ago

Expert in Unanet ERP AE coding/scripting

We are seeking a good communicator to help with our instance of Unanet ERP A/E (formerly known as Clearview Software). The candidate should be familiar with Unanet's use of InFocus Reports using the M…

$250-$500 Technology & Programming Guru Overseas

1 days ago

Logistics Exchange: Software Development

I am attaching the scope and milestones based on our mutual understanding. Please note the following: Fixed Cost and Timeline: We require a fixed cost and fixed timeline for the project. If you wish t…

Technology & Programming Guru Overseas

2 days ago

HuntsBot,a one-stop outsourcing task, remote job, product ideas sharing and subscription platform, which supports DingTalk, Lark, WeCom, Email and Telegram robot subscription. The platform will push outsourcing task requirements, remote work opportunities, product ideas to every subscribed user with timely, stable and reliable.

Platform

Support

Contact US

Any questions or suggestions during use, you can contact us in the following ways:

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.