Hi everybody,
I tried to use Match formula to code Main Diagnosis for each patient, because some patients may have multiple disease, but I only want to choose 1 Main Diagnosis for each and every patients according to the sequence of the Diagnosis in the Column.
It works fine for the first 11 column, but not the 12th. The file is uploaded.
Can anybody please help me with this?
Thank you very much for your attention and time
Last edited by suriawati; 03-07-2012 at 11:55 PM.
your formula that generates the 1 in the final column has the number 1 in quotes, this makes it a text instead of a number, if you remove the quotes, or put your search criteria in quotes, it will work.
your other columns work because of the math that you have, adding "1" + "0" will convert it to a number automaticaly.
hope this helps.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
I don't really get it actually. Could you please explain it a litle bit more? What should I do to get 12 in that D5 cell?
in cell D5 change your formula to:
=IF(ISNUMBER(SEARCH("#",C5)),1,0)
Thank you very much, that really worked. You've been a great help. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks