Excel Formulas Needed: I need an expert for a couple hours work
- or -
Post a project like this$55
- Posted:
- Proposals: 26
- Remote
- #3292785
- Expired
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,
Regensburg
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Customer Support, Bookkeeping, Data entry, Product listing, Virtual assitant
Coimbatore
27825679898425437782419330227480422723942117496171158612644631104630745411545010
Description
Experience Level: Entry
I need an excel expert to create a couple of formulas for me.
In the first example - please see attached file.
1) The text to compare is text in cell E1. Ideally, any text that matches cell E1 from the first column which has 30 - 99% similar match is returned in cell E2, E3, E4, etc. Is this possible without creating duplicates? I do not want less than 30% to be returned and I also do not want 100% to be returned as a value. Only 30 - 99% similar matches should be returned.
In the second example - I will ask you for a harder formula which removes common words from a cell and searches for the words that are left over... And then returns those values in cell E2, E3, E4, etc.
If you can't complete the first example - you won't be able to help with the second.
I look forward to receiving your replies.
In the first example - please see attached file.
1) The text to compare is text in cell E1. Ideally, any text that matches cell E1 from the first column which has 30 - 99% similar match is returned in cell E2, E3, E4, etc. Is this possible without creating duplicates? I do not want less than 30% to be returned and I also do not want 100% to be returned as a value. Only 30 - 99% similar matches should be returned.
In the second example - I will ask you for a harder formula which removes common words from a cell and searches for the words that are left over... And then returns those values in cell E2, E3, E4, etc.
If you can't complete the first example - you won't be able to help with the second.
I look forward to receiving your replies.
Trackerlead
99% (73)Projects Completed
61
Freelancers worked with
55
Projects awarded
34%
Last project
31 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies