Hi all
I discovered a following formula from a search of this site, and I have used it with the letters and words I require..
=IF(ISNUMBER(FIND("T",A1)),"TRANSPLANT",IF(ISNUMBER(FIND("L",A1)),"LEAVEOUT",""))
This works perfectly, however, I also need to add 2 more letters to check for: P=Peritoneal and N=Nephro. When I tried to lengthen this formula by repeating twice more,it does not work.
Any help writing this would be gratefully appreciated!
Many thanks
Ant
Oh and to follow I will want this to then be applied as a "fill down" for an entire column of data... will the "fill down" tool change Cell 'A1' references to A2, A3, A4, etc?
Maybe this:
=IF(ISNUMBER(FIND("T",A1)),"TRANSPLANT",IF(ISNUMBER(FIND("P",A1)),"PERITONEAL",IF(ISNUMBER(FIND("N",A1)),"NEPHRO",IF(ISNUMBER(FIND("L",A1)),"LEAVEOUT",""))))
Last edited by AlKey; 10-01-2013 at 12:34 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello Ant & Welcome to the Forum,
Administrative Note:
- We would love to continue to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread titles and adjust accordingly...
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks