Site icon

LibreOffice Calc: Finding duplicate / common entries between two columns


This video demonstrates how to find all matching values between two columns in LibreOffice Calc. Precisely, in this video, we fill in columns A and B with random integer values between the numbers 1 and 100 (inclusive). The formula to generate the random values was the following:


After we filled in columns A and B with random values, we used the following formula in each cell of column C to find all common values between the first two columns:


LibreOffice Cal commands used in this video

This post is also available in: Greek

Exit mobile version