I have two excel sheets both having lakhs (hundreds of thousands) of records. I want to compare if the records present in file1 is also present in file2 or not. Also I want to check what all are the different records which are present in file1 and are not in file2.

  • We're sorry, but this site is all about Ubuntu and its official derivatives as posted on wiki.ubuntu.com/Releases so pure LibreOffice questions are off-topic here as well. However, on stackoverflow.com, a sister site to AskUbuntu, they're very good at all programming questions, so you might be better off there. ;-) – Fabby Feb 1 '15 at 13:15

I think this answers your questions if they are similar sheets:


If it doesn't solve, could you please clarify exactly how the data is ordered/organized in those sheets?

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.