Hello Excel Guru's and Moderator's,
I need help in one excel activity. I am trying to record the formula in excel however same is not getting recorded as the length of formula is very high.
I request you to kindly create a function for the same.
Note: Please do not create an alternative formulas rather try to give a function since I would be needing the same for other purpose as well.
Thanks in advance!
Regards,
Sandeep
very strange formula? why are you using countif() on one cell?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I am using the countif because I wanted to see if the the cell contains any text which is given in my formula e.g. prophylaxis, vaccine, prevention like that
I am using the countif because I wanted to see if the the cell contains any text which is given in my formula e.g. prophylaxis, vaccine, prevention like that
since you are going you need a list of search words anyway you might just as well use
=IF(A2="","",IF(ISNUMBER(LOOKUP(10^99,SEARCH($D$1:$D$20,A2))),"Not an Indication?","Indication"))
where d1:d20 contain
prophylaxis,prophy,prophi,profy,propylaxis,prevention,prevent,protection,supplement,general health,Vitamin,Vaccine,unknown,surgery,propi,suppl,therapy,A8,preganancy
mind you i'd probably spell pregnancy correctly
Thanks Much!
But it did not work; attached is the workbook with your formula; you can see how the formula give the result as 'Not an indication" for any text.
Hello sandip ! you don't have data till D20 its only upto 7 cells
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Attached Now with correction!
It is resolved now thanks much MartinDWilson and Hemesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks