I need an excel conditional formatting formula to be built
- or -
Post a project like this2743
£10(approx. $13)
- Posted:
- Proposals: 12
- Remote
- #1308051
- Awarded
✪Software Developer ✪Web Developer (Java,Python, Android, jee, JSP, JSF, Java Fx,Vue, Blue J, Nuxt) ✪ Processing ✪ Elastic Search ✪ Database
Saitama
4165901901141934783615166498651244165133619813554341355454137045113718271387085
Description
Experience Level: Intermediate
General information for the business: we sell products online
Industry: Healthcare
Description of excel work: please download attachment.
i need a formula to be built which shows where text matching in column A does not appear in column B ( for the cell directly adjacent / same row )
in the example i have - row 3 is fine - even though this is not an exact match - it contains the first part of column A in the cell in column B.
row 3 is also ok because this is an exact match
row 4 is not ok because the code in cell A4 is 1116 - however B4 Starts with 1115.
i need a formula or condtional format settings to show which ones are not ok.
due to the high number of codes i have i can not rely on the human eye to see where the codes do not match - an excel is needed instead.
the formula should also be explained so this can be used on spreadsheets in the future
Extra notes:
Industry: Healthcare
Description of excel work: please download attachment.
i need a formula to be built which shows where text matching in column A does not appear in column B ( for the cell directly adjacent / same row )
in the example i have - row 3 is fine - even though this is not an exact match - it contains the first part of column A in the cell in column B.
row 3 is also ok because this is an exact match
row 4 is not ok because the code in cell A4 is 1116 - however B4 Starts with 1115.
i need a formula or condtional format settings to show which ones are not ok.
due to the high number of codes i have i can not rely on the human eye to see where the codes do not match - an excel is needed instead.
the formula should also be explained so this can be used on spreadsheets in the future
Extra notes:
Footcare UK L.
98% (31)Projects Completed
53
Freelancers worked with
55
Projects awarded
36%
Last project
23 Oct 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Sir,
i dont think this is a difficult task i will do it for free. I just need to understand what exactly is required here because i think the columns manes are not correct in the above explanation
Please contact me if you are willing -
Sir,
i dont think this is a difficult task i will do it for free. I just need to understand what exactly is required here because i think the columns manes are not correct in the above explanation
Please contact me if you are willing
173008173005
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