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

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.

edit retag 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.

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

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

Sort by » oldest newest most voted

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.

more