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

[Closed]
Report
Posts
3
Registration date
Monday October 12, 2015
Status
Member
Last seen
October 21, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
3
Registration date
Monday October 12, 2015
Status
Member
Last seen
October 21, 2015

no problem what it should be and how it slow be!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768 >
Posts
3
Registration date
Monday October 12, 2015
Status
Member
Last seen
October 21, 2015

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!