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
XERO | QuickBooks | Accounting | Bookkeeping | Excel | Microsoft Excel Spreadsheet | Complex Excel Formulas | Accountant | Spreadsheet | Cash Flow | Financial Statements | Management Accounts
Karachi
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
Professional Digital Marketer | Web Development | IOS and Android Developer | WordPress | React Native | Video Editor | Graphic Designing
Islamabad
WEBSITE DEVELOPMENT & DESIGN ! WORDPRESS ! JAVA ! PHP ! JAVASCRIPT ! GRAPHIC DESIGN | VIDEO | EXCEL VBA & MACRO EXPERT
New Delhi
562314827825673059921311558333061745297124545539459712546060330599087325610665910844
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