Hi all,
I want to count the total cases and the string will not be repeated once there. Please note that data are separated by forward slash(/) comes from single cell.For the first cell(non-serious, serious, unknown serious), if any one of the term is there in the record, then that term should be displayed but if the same is repeated, then that term should be ignored.
Please help
<TBODY>
</TBODY>
I want to count the total cases and the string will not be repeated once there. Please note that data are separated by forward slash(/) comes from single cell.For the first cell(non-serious, serious, unknown serious), if any one of the term is there in the record, then that term should be displayed but if the same is repeated, then that term should be ignored.
Please help
| Non-serious/non-suspected/HCP/CTs=45 Cases</SPAN> |
| Non-serious/non-suspected/Non-HCP/CTs=3 es</SPAN> |
| Non-serious/Suspected/Non-HCP/CTs=9 Cases</SPAN> |
| Non-serious/Suspected/HCP/CTs=29 Cases</SPAN> |
| Non-serious/non-suspected/suspected/HCP/CTs=4 Cases</SPAN> |
| Serious/non-suspected/Non-HCP/CTs=95 Cases</SPAN> |
| Serious/non-suspected/HCP/CTs=1411 Cases Unknown serious/non-suspected/suspected/Non-HCP/CTs=1 Output should be like this. Non-serious/Serious/Unknown serious/Suspected/non-suspected/HCP/Non-HCP/CTs=1597 </SPAN> |
<TBODY>
</TBODY>
