As shown in attached fig. I want to write in foundIn colom if a text in authors colom is present in Publications colom. If it is found in Publication 1 then 1 would be written and if that text is found in 6 then another 6 would be written after 1 in the same colom. as in the figure foundin colomn against "Dongwook Shin" 1,2,3,4,5,6 is written because this text(Dongwook Shin) is found in Publications 1,2,3,4,5 and in 6. Similarly "Choon Shim" is found in just 3 and 4.
Want to add new colom if a text is found in a cell range