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
0
votes
1answer
24 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 ...
-1
votes
0answers
18 views
comparing a cell (A1) with multiple cells and make C1 as vale +1 [on hold]
I would like to compare one cell A1 with group of cell (10x10 Table) and make B1 cell must auto increment.
let me know hot to do this with Excel VBA.
Thanks In Advance!!!!
0
votes
0answers
17 views
How to copy all Local Group Policies from one Windows PC to another
I currently have two test PCs both running Windows 10, both have set different Local Group Policies, i.e. settings accessible using gpedit.msc.
1.) Is it possible to export Group Policies from one ...
0
votes
2answers
30 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 ...
0
votes
0answers
19 views
Compare 2 columns with 2 conditions and highlight if values are equal
I have this kind of spreadsheet in Google Sheets which is used to compare what was ordered and was delivered by delivery company.
https://docs.google.com/spreadsheets/d/e/2PACX-1vQbxS-...
1
vote
1answer
40 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-...
0
votes
0answers
16 views
SQL Compare 13, copy & paste from differences SQL View doesn't copy carriage return/newline?
I'm using SQL Compare 13 to compare a test and production database. Sometimes there are tiny differences and I just copy & paste it from the differences SQL View and run it in the target database.
...
0
votes
1answer
34 views
Determine Multiple values exist in column for same values in other column
I am hoping someone can help me with a formula for the following:
Excel hard data
My goal is to have an addition column return a yes or a no.
Yes if there are different values in column B for the ...
0
votes
1answer
63 views
Compare three or more Word documents (*.docx)
I've seen multiple questions and answers for how to compare two Word documents, and I've seen some questions and answers for how to compare three or more raw text files, but I'm struggling to find a ...
0
votes
0answers
20 views
Comparing multiple columns in excel 2016 for exact matches and returning a list.
I have a workbook with a random list of id numbers with a specific month and year that I want to compare to another master list of ID numbers, months, and years. Note: each of the ID numbers on this ...
0
votes
0answers
25 views
Compare two folders on the basis of file names only
First , let me explain my situation , I have been scraping images from a website to a local folder, I used OpenCV to apply pre-processing on said images and produced the processed images with exactly ...
-2
votes
1answer
96 views
How do the “games-oriented” NVIDIA-GPU-based cards behave w.r.t. CUDA computation?
NVIDIA makes GPUs, which are used both for graphics and for graphics-unrelated computing. It also publishes compute-related specs of its GPUs.
Now, when it comes to cards:
there are some cards that ...
0
votes
1answer
152 views
HLS vs HTTP format codes in youtube-dl
I am using youtube-dl on windows 10 64 bit. I am new to this program. I checked the available formats for a video from dailymotion like this:
youtube-dl -F "http://www.dailymotion.com/video/". In the ...
0
votes
2answers
69 views
Compare binary files with different meta data
In Windows, I wish to compare old binary files with newly built ones in order to determine which files has been updated. However, when I build the files I give them new meta data details (like version ...
1
vote
2answers
199 views
Check if a specific range of values in one dataset exists in another dataset
I have two datasets, 1 and 2, each containing a number of columns with values. My end goal is to find all of the rows in dataset 1 that are different from and can't be found in dataset 2.
Dataset 1 (...
0
votes
0answers
57 views
How do I determine at which commit a non-versioned fork of a git repository was made?
The question
How do I determine at which point in the git history the source tree (or a part of it) was copied? Not forked or cloned — git metadata is lost.
The issue at hand
I wish to determine at ...
1
vote
0answers
338 views
Is there a way to compare two web pages or tabs in Chrome?
I have a website that offers me a "preview" mode, and a "live" mode of a document. I can open each in their own tab in Chrome. I'd like to know if there is a way to compare the two in Chrome, perhaps ...
1
vote
3answers
87 views
Cross compare data between 2 workbooks
I'm trying to cross compare 2 data in 2 different workbook. Then, I need to find the missing data between the 2 and make a separate new, updated list. However, I only need to update the data if there'...
0
votes
1answer
92 views
Use fc.exe in batch file to separate new lines from old lines
I have two text files mount.txt and mount2.txt and I've been trying to separate new lines (lines that were not in mount.txt but are in mount2.txt) from old lines (lines that were in mount.txt but are ...
0
votes
1answer
148 views
How to compare two columns of two different files
I have two file.The first one contains something like:
a.com,5,some,text
b.com,10,some,text
c.com,5,some,text
d.com,12,some,text
e.com,5,some,text
c.com,5,some,text
The second contains something ...
-1
votes
3answers
2k views
Excel VBA - Search for multiple Values in two Excel Sheets
I have two Excel sheets and I need to copy values from one to the other.
Sheet 1: Contains ID´s in one column and Data in another, which I want to have in Sheet 2 later on.
Sheet 2: Contains the ...
0
votes
1answer
21 views
Count values depending on Equality Compare
I have a tables that looks like the following:
I have multiple Item rows, and for each there are many Value columns, and a single Result. What I would like to do in my TOTAL is, for each Value column,...
0
votes
1answer
32 views
Find similar documents between two piles of documents [closed]
I am looking for ways to find similar documents between two group of text documents. I know ways to compare two files. But I am looking for ways to do that between two group of files.
Let's say ...
3
votes
0answers
257 views
Compare 2 video files for 'cut' differences
I have 2 video files with the same content, but coming from a different source. They have a slight difference in 'cut', meaning one can be missing a shot compared to the other.
I have a subtitle file ...
1
vote
0answers
163 views
Error: Command 'download_from_google_storage --no_resume --platform=linux* --no_auth --bucket chromium-clang-format
When I try fetch v8 or gclient sync I get this error:
Error: Command 'download_from_google_storage --no_resume --platform=linux* --no_auth --bucket chromium-clang-format -s v8/buildtools/linux64/...
0
votes
1answer
124 views
Break down the following bash script?
I need help breaking down the following bash script, to understand what the author was trying to do. The script is meant to search a log file for data and then compare it to an email log file. ...
1
vote
1answer
39 views
How to compare files in 2 HDDs, find exact copies and different files and sync only what I need?
Problem: I've got 2 external HDDs, which contains ONLY music files in many folders/sub-folders with some strict hierarchy (Artist/Band name - Albums name folders - song files), but different types (...
0
votes
1answer
44 views
If statement in Excel 2013 - if this date is 1 or more days past this date then
I'm trying to create a formula to compare the amount of days between two dates. Basically if one date (column D) is within 1 day of the previous date (column C), then "Yes" (in column E) if greater ...
0
votes
0answers
160 views
Comparing 2 directories and their sub-directories: du.exe
In a batch program, with Windows XP and Windows 7:
Comparing 2 directories and their sub-directories:
D:\temp (source)
E:\1\temp (destination)
On destination drive (E:), this command ...
0
votes
0answers
46 views
File comparison - Code and others
We have a requirement to compare two sets of files, for content similarity
Folder A - 100 files
Folder B - 150 files
The comparison will be with each file in Folder A against each file in Folder B. ...
0
votes
0answers
34 views
How to auto-highlight redacted parts of pdf by comparing 2 pdfs?
If you have 2 pdf documents with basically the same text but on the 1st pdf there are parts of the text deleted and replaced by [...] - is there any way to auto-highlight the deleted text-parts (in ...
0
votes
0answers
497 views
Compare two large files but ignore order of lines
I have 2 files that I need to compare, but each file has many of the same entries on different lines. How can I compare 2 LARGE files (many gb's) and only see the lines that dont show up in the other?
...
0
votes
0answers
38 views
How to compare cells in Excel based on another comparison
This isn't precisely what I'm working on but it'll do for the purposes of the help I require.
I have a spreadsheet in which I have coordinates. I'm trying to see which coordinates are horizontally ...
0
votes
1answer
65 views
How can I determine if two directories (including all subdirectories) are identical?
I have a directory containing many files spread across several subdirectories. I have a second copy of this directory in a different location, and I'd like to determine whether or not the contents of ...
3
votes
1answer
55 views
Excel Range Count within a cell
I am trying to compare qty and number of entries in an excel spreadsheet.
For instance,
QTY RefDes # of Entries QTY Match RefDes?
3 R1,R5,R22 3 MATCH
3 C1,C2,C3 3 ...
0
votes
1answer
27 views
Excel 2016: explore columns on Sheet 1, if part of content matches with cell on Sheet 2, then copy content from Sheet 2
I have 2 Sheets in one file
Sheet 1 has a column "Article" with old article descriptions like "PO11AD00 facing tiles Island"
Sheet 2 has two columns:
"Old Article" with PO11AD00
and
"New Article" ...
0
votes
0answers
65 views
Efficient remote file diff
I want to verify that two large remote file systems are in sync, and if not which files are different (including if they don't exist on either side). The way I am imagining this being done is ...
0
votes
1answer
47 views
Excel lookup / compare values
I need some help to sort out an old, bulky, crappy file.
So here is my problem.
I have an excel file like this:
and i need to sort it like this:
Keep in mind that the food type changes for each ...
1
vote
0answers
249 views
How to use VBA in outlook to forward incoming emails to specific people based upon a list [closed]
How to use VBA in Outlook to forward incoming emails to specific people based upon a list.
Here is the situation. I work with a system that generates emails so the subject line is always the same ...
0
votes
0answers
155 views
Check for “close enough” Match
So I have two different lists, one of items requested and one of items ordered. The problem is that different people created the lists, so they used slightly different wording when describing the ...
0
votes
1answer
24 views
conditional formatting assistance
I am struggling with a simple function in excel. So I've come to the experts.
I am trying to create a sheet to track a lottery pool. Each person will have 7 cells populated from column B to Column ...
0
votes
1answer
23 views
EXCEL 2016 - compare day-number
I have a Excel column with date in the format: d.
This shows just the day-number of the month
e.g. 2017-05-21 is shown as 21.
If this number is smaller than the one in the column above, I would like ...
4
votes
1answer
932 views
Compare columns in two worksheets, list missing values on third worksheet
I am an Excel rookie with three worksheets in a single file. Each has a column of numbers that I'd like to compare.
If values are present in sheet 1 (about 20 000 rows and 2 columns) but missing from ...
1
vote
0answers
165 views
How can I compare two tables and return the matched value into one row
I have two tables in different sheet (Sheet1 & Sheet2) to compare and match the content and return the result to Sheet3. There are two type of criteria should be match of:
1st. criteria - ...
0
votes
1answer
151 views
Matching phone numbers within a vCard or CSV
I have an iPhone with Whatsapp, and a Windows PC with Outlook 2016 that also runs iCloud sync, to sync Outlook contacts with iCloud.
Somehow, phone numbers from one contact have been copied over to ...
0
votes
1answer
24 views
Excel - List of locations column: Comparing, how to pull out what is missing?
I need top pull out the missing locations from a list, is there a simple way to do this. I have failed thus far.
Example: There is an image here for a sample. I need to see what's in column B that ...
0
votes
1answer
86 views
Comparing netstat scan from previous scans
Lets say you want to compare new netstat scans from old ones to see changes in network connections. Is there a method or tool in windows 7 where you can view these changes?
-3
votes
1answer
138 views
choose between 2 gaming laptops [closed]
Help me choose between the 2 laptops. the MLK Vector is on $500 discount PLEASE HURRY BEFORE IT'S OVER!!!!
i cannot choose between a i7 7th gen with 1050ti or a i7 6th gen with 1060. the MLK is on $...
1
vote
1answer
231 views
PHP compare broken on Eclipse 4.7
I need feedback on Eclipse PDT (Eclipse 4.7).
I'm facing a compare bug as describe in :
https://bugs.eclipse.org/bugs/show_bug.cgi?id=507821
My question is :
Can you give me some feedback ? Maybe ...
0
votes
1answer
196 views
Compare Data from one worksheet to another and fill in the match
I need some assistance with Excel 2010. I would like to find a quick way to assign tickets, but not change previous ownership.
For example: I would like to compare my current list of unassigned ...
