Spreadsheet: 817463d1676254935-identify-a-specific-symptom-based-on-larger-text-identify-text-based-on-larger-text
Sheet: Sheet1

[NAME] | GO |  | No Sampel | Size |  |  | [NAME]  ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  |  |  |  | Suspect
 |  |  |  |  |  |  | Insang |  |  |  |  |  |  | Sisik/Lendir |  |  |  |  | Ekor
 | Cage | DOC |  | Berat (g) | Panjang (cm) | Tinggi (cm) | Chilodonella sp | Dactylogyrus sp | Gyrodactylus sp | Ichthiophthirius sp | Trichodina sp | Epistylis sp | Ampbiphyra sp. | Gyrodactylus sp | Ichthiophthirius sp | Dactylogyrus sp | Chilodonella sp | Trichodina sp | Gyrodactylus sp | Ichthiophthirius sp | Dactylogyrus sp | Chilodonella sp | Epistylis sp | Trichodina sp | Eksternal Organ | Internal Organ | 1st Treatment | 2nd Treatment | 3rd Treatment | Symptom Flavobacterium columnare dan Francisella sp. | THIS IS THE RESULT I EXPECTED | [NAME] | Francisella sp | Aeromonas sp. | Columnaris sp | Saprolegnia sp. | TiLV
2022-01-04 00:00:00 | ND06 | 53 | 1 | 123.4 | 8.3 | 5.2 |  | 3 |  | 0 | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. Exopthalmia bilateral, hemorhaging pada mata, abse [NAME] [NAME], ventral fin dan pectoral fin, esosi pada caudal fin, dorsal fin dan anal fin. 2. Abses pada mulut, overculum, area ventral, pangkal pectoral fin, erosi pada  caudal fin, dorsal fin, darkening body, sunken eye. 3. Abses pada mulut, ventral fin,pectoral fin, anala fin, dorsal, caudal fin, deformity pada mulut, erosi pada caudal fin, anal fin, [NAME]. 4. Erosi pada caudal fin, abses pada overculum, ventral fin, abses [NAME], finrot. | 1. Insang pucat, hati pucat, limpa bengkak, white nodule pada limpa. 2. [NAME] pucat, limpa bengkak, white nodule pada limpa, hati bengkak dan pucat, white nodule pada ginjal, [NAME]. 3. Hati pucat, limpa bengkak, white nodule pada hati, ginjal pucat. 4. Hati pucat, limpa bengkak, [NAME], white nodule pada limpa, [NAME], ginjal pucat. | 1st 5/01/2022 Halamid 15 ppm (1620 gram) |  |  |  | Francisella sp |  | 1
 |  |  | 2 | 83.3 | 5.1 | 4.9 |  | 2 |  | 0 | 2
 |  |  | 3 | 108.4 | 7.3 | 5.5 |  | 0 |  | 0 | 0
 |  |  | 4 | 84.1 | 6.7 | 5.1 |  | 2 |  | 2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I also want to count a symptom based on the every Symptom detected.
 |  |  | Rata-rata
 | ND10 | 52 | 1 | 69 | 14.5 | 4.8 |  | 0 |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. Darkening body, finrot, abses pada overculum. 2. Erosi pada pangkal ekor, finrot, darkening body, abses overculum, mulut [NAME] seluruh sirip. 3. Erosi pada dorsal fin, caudal fin, ventral fin, anal, [NAME], [NAME]. | 1. White nodule pada ginjal [NAME], hati pucat, limpa bengkak. 2. Hemorhaging pada insang, white spot pada ginjal, [NAME], limpa bengkak, ginjal pucat. 3. [NAME] rot, [NAME], ginjal pucat, hati pucat, white spot pada hati, ginjal, [NAME]. | 1st 5/01/2022 Halamid 15 ppm (1620 gram) |  |  |  | Francisella sp, Streptococcus sp |  |  | 0 | 0 | 0 | 0
 |  |  | 2 | 110.4 | 17.2 | 6.8 |  | 5 |  |  | 100
 |  |  | 3 | 96.7 | 16.9 | 16.9 |  | 3 |  |  | 100
 |  |  | Rata-rata
 | NE05 | 53 | 1 | 230.8 | 21.8 | 8.5 | 2 | 0 |  | 0 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. Ascites, finrot, abses di ventral fin, [NAME], erosi [NAME]. 2. Erosi pada sirip ekor, dorsal [NAME], abses mulutt, overculum dan ventral, finrot. 3. Hemorhaging, Erosi pada caudal fin, abses pada anal fin, dorsal fin, pectorsl fin. | 1. Hati pucat, [NAME] 2. White spot ginjal, limpa [NAME], discolourisasi hati, limpa bengkak. 3. White nodule, limpa, ginjal, Insang pucat, limpa bengkak. | 1st 22/11/2021 H2O2 15 Liter | 2nd 5/01/2022 Halamid 15 ppm (1620 gram) |  |  | Francisella sp, [NAME] sp | 1 | 0
 |  |  | 2 | 118.3 | 18.3 | 6.3 | 0 | 0 |  | 1 | 5
 |  |  | 3 | 116.6 | 18.1 | 6.7 | 0 | 1 |  | 0 | 10
 |  |  | Rata-rata
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspect | Eksternal Organ | Internal Organ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Darkening body & abses & erosi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Francisella sp |  | Insang Pucat & White Nodule
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aeromonas sp. | Hemorhaging
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this is two example of suspect symptom with specific eksternal and internal organ check.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | so the formula should identify the suspect from this specific text.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | but I don’t want to use vlookup, I want to make it manual text.