Sort each column into alphabetical order. It is now easy visually to compare them side-by-side. Perhaps delete the ones in the right column which are not in the left column.

In your example file copy the contents of a cell in the right column and use Find and replace to search for it in the left column.

If necessary, add two extra columns and number each row in each column so that you can undo the sort by sorting on the numbers.

See

Calc functions similar to database functions in the Calc Guide - it has things like VLOOKUP, COUNTIF and SUMIF

VLOOKUP

Search for a specific value across the rows in the first column of an array. Returns the value from a different column in the same row.

The COUNTIF and SUMIF functions calculate their values based on search criteria.

The search criteria can be a number, expression, text string, or even a regular expression. The search criteria can be contained in a referenced cell or it can be included directly in the function call.

The COUNTIF function counts the number of cells in a range that match specified criteria. The first argument to COUNTIF specifies the range to search and second argument is the search criteria. Table 18 illustrates different search criteria using the COUNTIF function referencing the data shown in Table 23.

The first two arguments for SUMIF serve the same purpose as the arguments for COUNTIF; the range that contains the cells to search and the search criteria. The third and final argument for SUMIF specifies the range to sum. For each cell in the search range that matches the search criteria, the corresponding cell in the sum range is added into the sum.

- COUNTIF finds occurrences of items in col B in col A

Do a google search with

find common words in two lists - it gets 700 million hits.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your

first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.