How to compare two lists in LibreOffice Calc

This is a LibreOffice Calc tutorial covering, how to compare two lists. The tutor starts off by demonstrating how the three nested function work together, to check whether a number in one list appears in another list. The tutor then breaks down each part of the final formula explaining how each element works. The final part of the video covers how to join the three functions together to tidy up the results. The tutor mentioned that he had used named ranges to avoid using dollar sign to lock data ranges. LibreOffice Calc tutorial. Compare two lists. How to compare two lists in LibreOffice Calc. #libreoffice Courses are available through Microsoft Teams, Online and Face to face in the UK Training Guide Books Excel for New Managers Very cheap E_books are here: