Ask Your Question

How can I find if an entry in column A exists in column B? [closed]

asked 2013-04-11 16:55:22 +0100

JohnC gravatar image

updated 2014-01-26 01:17:23 +0100

oweng gravatar image

Hi - I would like to find duplicates of names that sit within two columns, that I have in Libre Office Math (v3.5 I believe). I have a list of names that sit in column a, and a list that sits in column b, but do not necessarily sit across from one another in a row. I need to identify where there are duplicates (and highlight them some how) so I can see which names appear in both columns.

Many thanks for your help!

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 03:35:50.908335


Thanks Mahfiaz. Unfortunately I'm getting #NAME? and #N/A within the column 3 cells. The only thing that I can see is that the programme is automatically changing the ; to a , in the formula (not sure if this is normal or not, I'm a complete novice) - any advice? Thanks again for your help.

JohnC gravatar imageJohnC ( 2013-04-12 10:45:27 +0100 )edit

Same question asked here.

oweng gravatar imageoweng ( 2014-01-26 01:20:06 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-04-11 19:55:39 +0100

mahfiaz gravatar image

updated 2013-04-11 19:56:20 +0100

Let's say A1:A100 is the first row, B1:B100 the second one and from C1 down to C100 you will drag the following formula: =IFERROR(MATCH(B1;$A$1:$A$100;0);"")

If there is no duplicate, the cell will remain empty, otherwise it will show the number of row where the first duplicate is in first column.

And if you need some visual indicator such as red background, use conditional formatting.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-04-11 16:55:22 +0100

Seen: 47,800 times

Last updated: Jan 26 '14