Answer the question
In order to leave comments, you need to log in
How to find lines in a file that are missing in another file?
Good afternoon. Please tell me how can I find out the number of unique lines in the A.txt file that are missing in the B.txt file? Each line is a set of ID numbers. Files up to 15mb.
Answer the question
In order to leave comments, you need to log in
Upload files to excel (in sheets or books) and make VLOOKUP(ID; table; 1; 0), filter by #N/A and make advanced filter unique records
Excel hangs from such volumes. 680000 cells. I figured out how to do it differently through Notepad ++, a little crooked, but in principle, he gives the data that I need.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question