Write data if a text is found in that colomn

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
-
I want to write some value if A text String in Cell A is present in another colom and if found then I want to write the value of that row in front of Cell A.
V1 J Martin P1 10_1 J Martin; James L Crowley<>An Appearance-Based Approach to Gesture-Recognition <>ICIAP
V2 J-P Martin P2 10_2 J Martin; Augustin Lux ; Christophe Le Gal ; James L Crowley<>Smart Office: Design of an Intelligent Environment <>IEEE Intelligent Systems
V3 J Yin P3 10_3 J Martin; Daniela Hall ; James L Crowley<>Statistical Gesture Recognition Through Modelling of Parameter Trajectories <>Gesture Workshop
V4 Jian Yin P4 10_4 J Martin; James L Crowley ; Olivier Chomat<>A Probabilistic Sensor for the Perception and Recognition of Activities <>ECCV European Conference Computer Vision
V5 Johannes Martin P5 11_1 J Martin; Ramón Puigjaner<>Extending UML Deployment Diagrams form a Performance Engineering Perspective <>Software Engineering Research and Practice
V6 Ludger Martin P6 11_2 J Martin; Carlos Juiz ; Nunzio Nicoló Savino Vázquez<>Unified system builder through interacting blocks USBIB for soft real-time systems <>Workshop Software and Performance
V7 P Devanbu P7 11_3 J Martin; Didier Boudigue ; Georges Gardarin ; José Antonio Corbacho ; Nunzio Nicoló Savino Vázquez ; Ramón Puigjaner ; Sophie Dumas<>Predicting the behaviour of three-tiered applications: dealing with distributed-object technology and databases <>Perform Eval
V8 Holger M Kienle P8 11_4 J Martin; José Antonio Corbacho ; Nunzio Nicoló Savino Vázquez ; Ramón Puigjaner<>Extending SMART to Predict the Behaviour of PL/SQL Applications <>Computer Performance Evaluation Tools
V9 Kostas Kontogiannis P9 12_1 J Martin; Chris Lankester<>Ask Me Tomorrow: The NRC and University of Ottawa Question Answering System <>TREC Text REtrieval Conference
V10 James L Crowley P10 12_2 J Martin; Alain Désilets ; Berry de Bruijn<>Extracting Keyphrases from Spoken Audio Documents <>SIGIR Research and Development Information Retrieval Workshop Information Retrieval Techniques for Speech Applications


As if J Martin is found in P1 then I want to write P1 in a blank colomn and if it is found in P3 then Alongwith P1,P3 should be written.
Same like if James L Crowly is found in P1-P10 then I want to write P1,P2,P3 up to P-10 in a new cell. And want to found all authors one by one in all Papers and write in which papers their name appears.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I think you can start by using macro recorder. You can then record you action. You can search by using find
-1