Questions tagged [comparison]

File comparison is the process of comparing the contents of files, finding their common contents and their differences, usually using an automated tool

Filter by
Sorted by
Tagged with
-1 votes
1 answer
48 views

Compare lists of data options besides EXCEL

I want to compare two lists of data and i absolutely tired of excel with its difficult to use formulas what are approach i can take? I could try something like WinMerge and it works, it gives visual ...
Roman Toasov's user avatar
0 votes
1 answer
31 views

Compare requirement list with received list in excel

I receive a matrix of requirements that validate corresponding Values as below: And a current matrix with the completed requirements marked with x: Is it possible to compare the matrices and return ...
Alexandra's user avatar
0 votes
1 answer
519 views

Removing duplicate rows in a CSV file as compared to another CSV file

I have a CSV file named CSV1 with over 5000 rows and 3 columns - last name, first name and email address. I have another file named CSV2 with about 2700 rows with the same 3 columns. I have to remove ...
user1842329's user avatar
2 votes
0 answers
388 views

Compare 2 videos at different frames with ffmpeg

I use this FFmpeg command to compare 2 videos: ffmpeg -i video1.mp4 -i video2.mp4 -filter_complex "[0:v][1:v]blend=difference,blackframe=1:10" -f null -' The command compares the same frame ...
hell's user avatar
  • 21
1 vote
1 answer
2k views

MS Word Compare not showing changes

I recently changed from a computer running Windows 10 Pro 64 with Office 2019 Pro to Windows 11 Pro 64 with Office LTSC Pro Plus 2021. Today, for the first time since that change, I tried using MS ...
NewSites's user avatar
  • 746
0 votes
0 answers
35 views

Highlight the lowest value from a second column of identical items in first column in Excel

In a file with 3852 rows, in col A, each cell has a code and a corresponding value in column B. Some cells in col A have the same code (are equal) but the values could be different in col B. Column A: ...
Liliana Speciale - Ronco's user avatar
0 votes
2 answers
116 views

Excel formula to compare a 6 cell row against a reference row and return value that are missing

I need to work out a problem I have with formula logic. there's a picture with the exact outcome I'm trying to achieve below i have a long list of rows that contain cells with criteria in them that ...
MetaScroll's user avatar
1 vote
2 answers
133 views

How to compare two columns of a HTML (or XML) file, looking for number differences?

As a English to French translator, I can create a bitext of my work, which is a file with 2 columns, the English on one side and the French on the other. These bitexts can either be in HTML of XML ...
user1685291's user avatar
0 votes
1 answer
59 views

Using excel to find missing daily logs for people

I have an excel file with 2 worksheets. One has a list of daily logs and looks like this: Staff Person | Shift Date | Start Time | End Time John | Oct 31 | 8:00 AM | 4:00 PM John | Nov 3 | 2:00 PM | ...
Owen's user avatar
  • 103
0 votes
1 answer
56 views

how do I compare dates separated by semicolon in same cell in excel

This is my data in column A. I want to compare dates with each other separated by semicolon to see if they all match or not and put the answer in another column saying match or no match. How do I do ...
mona's user avatar
  • 3
0 votes
1 answer
252 views

Excel: How do I compare 4 columns with repetitions?

I have 4 columns. A,B,X,Y. How do I compare all 4? I want to create column Z where if A == X and the corresponding value B == Y, the result is 1. It is zero otherwise, how do I do that? Thanks A B X ...
GUEST's user avatar
  • 3
0 votes
0 answers
146 views

Cross-compare several files with a diff tool

Have anyone encountered the challenge of comparing several files with each other on a Mac/unix machine? Consider a list of files 100.txt, 101.txt, 102.txt etc. in the same folder. How can I cross-...
user1736049's user avatar
3 votes
2 answers
7k views

How to compare two hard drives (or folder) to find missing files in one of them?

I'm on macOS and, for context, I have one main hard drive that should include all my files (and yes, it's backed up with redundancy). And I have many other smaller hard drives that I have used over ...
gugavieira's user avatar
0 votes
1 answer
36 views

Compare two excel files to change elements in cells

I have two excel files, A and B. A is a dataframe with a header. B has two columns, the first one has the original name and the second one has new name A: sam1 sam2 sam3 sam4 .... p1 0 1 2 ...
SG Kwon's user avatar
0 votes
1 answer
495 views

Excel VBA - Dealing with Overlapping Times

I have a really big table in Excel that has multiple rows where each row contains a comparison between two employees that had worked over the same time. See examples of some sample rows in the image ...
user1553584's user avatar
3 votes
2 answers
4k views

How do I find common lines in two files

Let's say I have: text.txt with 1 2 3 4 5 and another text2.txt with 9 4 2 1 7 And I want to extract the duplicates: 2 1 4 Note: I'm using windows, I want it to be as easy as possible
RaRe MoDz's user avatar
0 votes
0 answers
335 views

Comparing Files to a list of MD5 Hashes and getting a List as Result (where i can delete, copy, cut etc. the results)

I am searching for a solution for the following situation. I have a list of Hashes in a Text File and i want to find every File in a certain folder and subfolders that matches the Hashes from the Text ...
Sev's user avatar
  • 1
0 votes
1 answer
46 views

One Cell number to compare in multiple rows

I have ID in Col A and Remarks in Col B. I need to Return status in Col C. If Remarks against any specific ID is all Approved, it should show in status as "Approved". If All remarks against ...
MANSOOR Ali's user avatar
1 vote
1 answer
2k views

How to compare two videos and get timestamp(s) of differing frame(s)?

I've got rips of two copies of the same physical DVD. There's a difference between the two disc images - one of the videos files has a small binary diffence. I suspect one of the discs has physical ...
Hiccup's user avatar
  • 329
0 votes
1 answer
642 views

Excel formula to return value based on header and two columns

I'm trying to write an Excel formula that will place an "X" in a cell if the value in the header row occurs anywhere in column A while the values in Column B are unchanged. I envision the ...
Jeff Illingworth's user avatar
1 vote
1 answer
1k views

comparing binary files at different offsets, reporting offsets of first difference

[About a month ago I asked a similar question, requesting a specific CLI software tool that would perform the required task ; it was quickly blocked on the ground that asking for specific software ...
GabrielB's user avatar
  • 855
0 votes
1 answer
888 views

Comparing ISO image files in Windows 10 or MacOS

I have a number of CDs and DVDs (some RW and some not). Some of these disks contain simple files (such as .txt, .doc, etc) and others contain Dell system drivers, various Windows OS's and so on. I am ...
Shamioso's user avatar
3 votes
2 answers
3k views

Comparing two folders and copy differences in another folder

I want to compare Dir1 with Dir2 including subfolders for content ( the directory may contain binary data) If there are differences, I want to create a DiffDir which has the changed or added files ...
Alireza Fattahi's user avatar
0 votes
1 answer
98 views

Comparing Time (only) in two columns and returning value from the third column

I need to call the corresponding value of time from column F in column B. Tried using Vlookup and match/index functions. But they are not working for time. If you know a quick method please share.
Hamza's user avatar
  • 1
0 votes
1 answer
230 views

Compare 2 text files and create a 3rd text file where rows are formatted with common strings (adjacent string completion) [closed]

I have 2 text files. text1.txt : First is structured in this way <title>Developing a wireless </title> ##www.google.com## <title>Webdriver Actionchains </title> ##www.alfa.com#...
Jack's user avatar
  • 67
2 votes
0 answers
1k views

How can I interactively diff large binary files?

I'm trying to compare hex-dumps of some 500GB disk images. I can easily view parts of the files by piping hd into less. I'd like something similar to interactively diff them without having to read the ...
Wes Toleman's user avatar
1 vote
2 answers
56 views

Seeing if a workbook contains data from another, and then adding the data if it doesn't?

Basically what title says, I have two separate workbooks with thousands of entries. One is an updated version of the other. I'm trying to find what's new in one workbook and add it to the older one.
justmayo's user avatar
4 votes
5 answers
2k views

Can WinMerge be used as a plain text diff tool, without needing to compare existing files?

I want to use WinMerge as a plain text diff tool, without needing to compare existing files. That is, I'd like to just click ctrl+n, paste two plain texts onto both sides, hit f4 and find differences. ...
HeyJude's user avatar
  • 350
2 votes
1 answer
617 views

ExcelFuzzyLookUp: Compare Cells In The Same Row

I'm trying to compare two cells that are in the same row and same table. I've been trying to use Fuzzy Lookup to provide a measure of similarity but what happens is that the cells move to match what I'...
dimthemainsjfdjlks's user avatar
4 votes
1 answer
9k views

Windows Batch Script to Compare Two Text Files

I have this script: for /f "delims=" %%a in (data_A.txt) DO ( set "flag=" for /f "delims=" %%b in (data_B.txt) do ( if "%%a"=="%%b" CALL :flagit ) if not defined flag >>...
HTWingNut's user avatar
  • 499
1 vote
0 answers
42 views

Visual Studio comparing workspaces

First, let me explain the situation: I'm a software developer currently in home office. Normally we're using a TFS to sync our sources, but from home I don't have a connection to the TFS. So I'm ...
Daniel Bauer's user avatar
0 votes
1 answer
217 views

Comparison Operator in Powershell

I have a script that is currently working. There are two groups that need to be omitted from the CSV that is exported. As it currently sits it works. see below: Import-Csv -Path .\importactiveusers....
Andrew Diaz's user avatar
0 votes
2 answers
201 views

Compare 2 Lists of E-mail Addresses

How can I go about performing a comparison between 2 lists of e-mail addresses? Specifically, I am looking to find what e-mail addresses are not present in one list vs the other.
THE DOCTOR's user avatar
0 votes
1 answer
64 views

awk comparison on Ubuntu

I'm trying to write a script that check the disk usage of remote clients. There is a filter in script for meaningful output: ... ssh server "sudo df -Ph 2>/dev/null \ | tail -n +2 \ | grep -v ...
Jo Shepherd's user avatar
0 votes
1 answer
7k views

Compare Two Files and Remove the Duplicates

What is the easiest way to compare 2 files and deleting the duplicates found on both files. I'm aware you can do this easily on a linux box with certain commands, but how would I go about achieving ...
holograms's user avatar
1 vote
1 answer
598 views

Microsoft Word: how to compare and edit 2 documents, without creating a 3rd one

I do proof reading on documents written by non-native English speakers. With text editors you get to compare 2 versions of the same document and you can edit either directly. In Microsoft Word, ...
Francis's user avatar
  • 143
1 vote
0 answers
29 views

Merge two incomplete backup volumes together on a third drive?

I have 2 drives that use to be backed up to each other (a 2TB drive to a 3TB drive) but they fell out of sync a long time ago. Files on the drives may not be located in the folders they use to share, ...
user507974's user avatar
0 votes
2 answers
1k views

Excel: Column comparison with dates and values

I currently have 4 columns that contain data on Bitcoin Prices and S&P 500 closing day values, as well as their respective dates: Since the S&P 500 is closed on non-trading days and the ...
Ezra Womark's user avatar
-3 votes
2 answers
182 views

Why is there a loss in processor power emulating 32bit programs on a 64bit system?

May be a stupid question but I cannot find a clear answer. Host CPU=Emulated CPU Pentium Pro 200 MHz = 286 6 MHz Pentium II 350 MHz = 386SX 25 MHz Pentium III 1.0 GHz = 486 66 MHz Pentium ...
Tol's user avatar
  • 1
-1 votes
1 answer
190 views

Excel - Need to compare two times in order

I am using excel to compare two date columns that i need to compare. One is an Expiry time (SLA Expiry Time) and the other one is when it was actually updated (Initial SLA Contact Time). It is to ...
jAC's user avatar
  • 101
3 votes
1 answer
4k views

Compare two binary files of different sizes

I am trying to compare two binary files in order to identify one of them. The first file I have contains the data I am interested in and can use to identify the second. The second file is from a 3rd ...
Carl Owens's user avatar
2 votes
0 answers
1k views

mac tmutil compare works or fails depending on WHERE bundle is mounted

Using Time Machine to a Time Capsule - backups work smoothly. The problem is trying to use 'tmutil compare' to see the differences between 2 backups. MacOS Mojave 10.14.5 (same problem on previous OS ...
JDC's user avatar
  • 21
1 vote
0 answers
2k views

Microsoft Excel Fuzzy Lookup add-on - set too big?

The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...
sarahdez's user avatar
0 votes
0 answers
608 views

Compare two whole HDD's contents, sector-level

While analysing two 4TB HDDs, which were in some kind of RAID 1 configuration, and thus have the same contents in terms of files / folders (they have been reformatted but R-Studio lists the same file ...
GabrielB's user avatar
  • 855
1 vote
0 answers
135 views

Redgate SQL Data Compare - Command LIne Output File

I am comparing 2 databases via command line. When I execute the following command: SQLDataCompare /project:"C:\CompareFiles\compare_AW1_AW2.sdc" /Include:table:[Users] /Out:"C:\Users\mthurman\...
M Thurman's user avatar
2 votes
1 answer
119 views

Compare and partly merge multiple projects without common ancestor

I'm looking for a way to compare/diff 3+ different, strongly related projects, none of which is the others' common ancestor and copy around ("merge") single chunks, and specifically test files. I do ...
Andy's user avatar
  • 23
0 votes
1 answer
656 views

How to compare multiple PDF files?

My professor just uploaded an updated set of all the slides of the whole semester (17 PDFs), referring to them as the now definite examination material. Problem is, I have made lots of notes on the ...
user3545063's user avatar
0 votes
1 answer
164 views

Match 2 sets of numbers in 2 cells

I have 2 cells with similar data extracted from 2 different websites. Data in D6 is supposedly shorter version of H6. I want to put "Match" or "No Match" in E6. For "Match" either 2 sets of numbers ...
Russ Axel's user avatar
0 votes
2 answers
7k views

Excel check if combination of data exists in a certain range

See question 1337631 Check if a specific range of values in one dataset exists in another dataset This solution works great, but what if you want to check WITHIN the same range? Want to use this for ...
Daniel H's user avatar
1 vote
1 answer
72 views

Compare excel worksheets

Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files: Subset: This file has a subset of employees with various details including training status such as in-...
Palak Porwal's user avatar

1
2 3 4 5 6