Ask Your Question
0

how to match common string in a column [closed]

asked 2014-01-27 13:42:03 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

i have data like

 **column1                 column2**
Ram                        Praveen
Mohan                      Kumar
Praveen                   Chandra
Kumar
Dinesh
Hareesh
Chandra

but i want output like

**column1                 column2**
   Ram                       
    Mohan                      
    Praveen                Praveen
    Kumar                  Kumar
    Dinesh
    Hareesh
    Chandra             Chandra

Means which field are both sides matched.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 04:19:56.888046

1 Answer

Sort by » oldest newest most voted
1

answered 2014-01-27 16:30:05 +0200

JohnSUN gravatar image

updated 2014-01-27 16:50:17 +0200

Just write to C1

=IF(COUNTIF($B$1:$B$3;A1)>0;A1;"")

and drag the formula to the desired number of rows Demo

edit flag offensive delete link more

Comments

Thanq it works fine... Is there any Libreoffice online tutorial pls let me know

Ram.BM gravatar imageRam.BM ( 2014-01-28 06:39:19 +0200 )edit
JohnSUN gravatar imageJohnSUN ( 2014-01-28 10:09:58 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-01-27 13:42:03 +0200

Seen: 208 times

Last updated: Jan 27 '14