comparing data

Hey everyone, I’m looking for advice on how to compare two different worksheets for differences, perhaps by the highlighting of differences on one sheet. The issue is that the data set I’m comparing to is in a different format e.g. less columns and was essentially used to build the larger...

Greetings, I have a spreadsheet with names and addresses. In the name column, I need to compare all the words to a fixed list of terms, such as "borrower", "homeowner", "LLC", etc. I will be highlighting the row to look at individually. So far, I can get the code to work, but with only one...

I have written a piece of code that asks the user to open one text file and it loads it into an Excel sheet. Then asks for a second text file which it loads into another sheet. Then runs through the second sheet to find corresponding records and when it does it compares a column of data. This...

Does anyone know how to calculate between 2 numbers. Example - one report has to pay accurately which is between 95%-102% (we count these as accurate). another report has to pay the same way (these 2 never match since they pull from different sources). I need a formula to show if these 2...

I have a 'master' sheet that contains a big Table with several columns (A:G) and 283 rows (with header). The other Sheets contain sections of this 'master' table based on unique values in Column B (i.e. Column B is filled with names like 'dog' 'cat' 'pig' 'horse' etc. and these could appear...

Morning y'all! I am trying to figure out how I can pull some data over in a specific way to ensure that it matches my criteria. I have my source workbook which contains all data for Item, Location, Ranking (based upon location), & Data Points 1-10 (1 through 10). I also have my template sheet...

I'm hoping someone would be kind enough to help me with an excel formula that i'm struggling to get my head around. I have a spreadsheet of products e.g. column A = product name, B = Price, C = description, D = key features and so on. Row 1 would be product 1, row 2 product 2 and so on. I...

I have two rather large lists that need to be compared. List #1 is a previous version of list #2 List number #1 may contain names that are no longer on list #2. I need some help creating a formula that detects the differences of list #2 from list #1 and either highlights the none matching...

I need help I need to know how to store this set of numbers in an array and to compare them to another variable. I am getting a subscript out of range error, and I just do not understand why at all. The trouble I am having is getting the values to store in the array and compare. Maybe it's my...

I'm having an issue with my nested if function. What I would ideally like to do is to compare 2 cells against a confidence interval percentage. So, if cell A is 5% higher than cell B I want my function to create a label the next cell as "Higher" and if its 10% higher than to be labeled as "Much...

Hi, I am having 2 excels each with 50000 records. I am comparing both the excels by updating formula (Sheet1 data - Sheet2 data) in the first cell & then 'Autofill' the same formula to other cells using VBA code. Sample Code: ThisWorkbook.Worksheets(3).Cells(1, 1).Value =...

Hello I am hopeful that someone can help me on this website. I have had great help in the past with other issues I have come across. What I have now is beyond me as I am a beginner level VBA. Currently I have to web based data sources that I need to access. Once accessed (this part I have...

Hi and thank you so much for reading. So here's my situation: I have two columns of data, call them column A and column B - both of variable length. I want to compare each value from column A to column B, and every value in column B to column A. For those entries which do not have corresponding...

:) Good afternoon, What i'm trying to do is to have a dynamic comparison between cell values. Here is the case: In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column...

Hi I was hoping someone could help me compare 4 columns of data. For my data I am just comparing the outputs of two programs (for example the x-y coordinates of a map). So in columns A & B I have the x-y coordinates from 1 program and columns C & D I have the x-y coordinates from another program...

Hi all OK I am tracking Students BTEC grades (a UK course) and am going round and round in circles The Data Range is the same in both columns A&B. This is arrayed order below Dist* Dist Merit Pass Fail Column A is students Targeted Grade and column B is Students current Progress I want to...