Want to add new colom if a text is found in a cell range

Closed
kashak79 Posts 3 Registration date Monday October 12, 2015 Status Member Last seen October 21, 2015 - Oct 19, 2015 at 09:00 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 21, 2015 at 11:27 AM
Hello Everybody,
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.
thanks you.


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 20, 2015 at 02:34 PM
are you looking this as a formula or as a script that can go thru each row and populate the column
depending on amount of data, it can be quite slow
0
kashak79 Posts 3 Registration date Monday October 12, 2015 Status Member Last seen October 21, 2015
Oct 21, 2015 at 01:12 AM
no problem what it should be and how it slow be!
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768 > kashak79 Posts 3 Registration date Monday October 12, 2015 Status Member Last seen October 21, 2015
Oct 21, 2015 at 11:27 AM
a formula would need to loop thru each cell and find out that if the data exists or not. Any time you change the value, it would be recalculate

script is like a batch processing. once it is done, it is done
0