Excel Formula Creation
- or -
Post a project like this2216
£20(approx. $25)
- Posted:
- Proposals: 13
- Remote
- #1931456
- Awarded
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer
Colombo
Full stack Web Developer laravel|PHP| Wordpress|Graphics Design|Database| AJAX|REST API|C++ Programming ,
Chevy Chase
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
1394015443720486495571526749479126714014045941406416153654716424921875661
Description
Experience Level: Entry
Hi All,
I have the following formula:
=IFERROR(IF(SEARCH("*blue*",A2,1),"Blue"),"")
I use it for picking out information from lots of descriptions. For example, I have a list of products I will use this formula to pick out the word Blue from the description. After picking out Blue. I will then use it to pick out Red. Etc etc until I have all of the colours pulled into the colour column.
I was wondering if this formula can be adapted to search for Red,Blue,Green etc etc all in one formula. Rather than needing to repeat the process over and over each time with a different colour.
If you know how to do it by adapting this formula or some other way then please send the cost of doing so.
Kind regards,
Graham
I have the following formula:
=IFERROR(IF(SEARCH("*blue*",A2,1),"Blue"),"")
I use it for picking out information from lots of descriptions. For example, I have a list of products I will use this formula to pick out the word Blue from the description. After picking out Blue. I will then use it to pick out Red. Etc etc until I have all of the colours pulled into the colour column.
I was wondering if this formula can be adapted to search for Red,Blue,Green etc etc all in one formula. Rather than needing to repeat the process over and over each time with a different colour.
If you know how to do it by adapting this formula or some other way then please send the cost of doing so.
Kind regards,
Graham
Graham E.
100% (26)Projects Completed
16
Freelancers worked with
8
Projects awarded
12%
Last project
9 Feb 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello,
Are you able to send a sample data so an overview of what you are expecting to get will be much easier
Thank you -
Hi Graham,
Share your data where you want to exercise for same.
Thank you -
Hi Graham,
I would love to help out but then maybe attaching the excel to take look at will give better insight into what you hope to accomplish. Eventually, a macro might just suffice.
Regards
607160607121607119
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