compare

I'm trying to use spreadsheet compare. Sometimes it works fine. Sometimes I have that error message about the file being password protected. I'm usually trying to compare an autosaved file - when I'll open Excel 365, I get that box on the left 'do you want to save this'. I can't tell if the...

Can anyone tell me if this is possible at all? I have a sheet which keeps track of my horse racing results. The number of runners in the race are recorded in column F and the finish position of the runners is recorded in column AC I want to determine which races do NOT have the same number of...

Hey guys, I need to make a formula that compares the list of truck routes in column F to the days of my roster, and spits out the missing routes from roster (ideally a list under each day). The roster is normally sorted out alphabetically by surname, but sometimes by truck routes.

Hi everyone, I'm migrating data from a legacy source information system to a new information system and want to confirm a variety of counts of values from the source data against the counts of the same values from the migrated data to ensure the counts match as a way to verify the records...

Hi. I'm looking for the simplest way to analyze data stored in a tabular format in an excel sheet and make comparisons (text as well as value fields) using dates as columns. To clarify, I have data for five days spanning over 20 different columns stored in an excel sheet. For each day, the date...

Hello, I need to compare two files (File A and FIle B) and highlight the differences (in File A). The two Files may have different columns but I only want to compare two of the columns with the same name. See below for Column info: Identification Number...

I have two large worksheets. One was run a couple months ago and the other was run this week. I'm looking for VBA to find the differences between the worksheets. Each worksheet is set up the same, but the data may not be in the same order, and may not have the exact same items. Spreadsheets...

Column N Column P Column R Housing#VALUEDargon 1 1 2 #VALUEwww.google.comR@ND0M 2 ... ... .. Hi guys, I'm exploring how to compare data contained in the same row between two columns, then copy to Column C for cell values that don't contain #VALUE in it using VBA and run it all the...

Hi everyone! I'm looking to compare two columns on 2 different files. Let's call them Column 1A (File 1, always has the same file name and directory) and Column 2A (File 2, shares directory with File 1). I want to extract the unique values from Column 1A that are not present in Column 2A and...

HI Friends , I'm looking for a little help in Vba macro. I have two sheets ( category ) which has values like CURRENT ASSETS ,NON CURRENT ASSETS, CURRENT LIABILITIES ,NON CURRENT LIABILITIES , PROFIT LOSS Etc.. in the other sheet (Balance sheet) in column A i have CURRENT ASSETS ,NON...

Need help with this. Looked through some similar posts but couldnt figure out how to adapt them. I got a value in cell B2 and a value in Cell B1 (a value between 0-10). They are values that are not allowed to be the same. If the value in B2 ends up to be the same as in cell B1 i need to call...

Hello All, I need a big favor regarding a work I need to compare sheet1 which consists old data and Sheet2 Which consists Some new data or edited one I need to compare two sheets and need to highlight or need to cross check which is same and Different. I don't know how to wirte vba code so...

Hello, I am fairly new to vba and i am having a hard time coding something that will solve my issue :( I have two data sources I wish to combine. Sheet 1 Data source on Sheet1 contains 2 columns: AccountID and Cost. Source is in cells A3:B3 (data row starts in A4) for 1 to N records. A...

I have a macro that compares the column of a table with the column of another (both are extracted from an application), and returns me which values do not exist in both. However, the Table4[MSG_DESCRIPTION] column has a limit of 50 characters, and the Table3[Title] column has 500 characters. I...

Hello friends, I am doing various updates on more than one "workbook". I forget some of the updates I made when it came to order. Is there an application that compares "workbooks" to prevent this? vba page is quite limited, i can't even open two codes side by side on the same page. What is...

I want to vlookup with supplier and product with other file "Comparing file" which has supplier and product. if value matches and status is completed , Mark as Yes in output Supplier Product Status Output AB XY-1 Completed Yes AB XY-1 Completed Yes AB XY-2 Completed Yes BC ZA-1...

I have 2 columns of data, Y & Z; they are times of goals scored. I want to create a column which will compare the data in those 2 columns and tell me whether the Home or Away team scored first. The issue I have is that many games do not simply have 1 goal, or 1 goal from each team. Often one...

Hello, I am trying to come up with a function that compares two delimited lists to see if they are made up of the same values. Each list is in its own cell, can be variable length, and can have variable order. I'll give a few examples of inputs and outputs to display what I am trying to...

Hi Folks, I have two sheets, 'Details' (contains invoice line items) and 'Summary' (contains invoice totals only. Both sheets contain values starting at row 6 and have intermittent spaces between sets of values. Details is separated by invoice numbers in column C and Summary is separated by...

Hi, I am working with a formula that I am getting some weird results and hopin someone has a solution. I have two Concatenate formulas that combine about 3 Columns of data, These formulas are in Col J:K. I then have two other columns that individually look at each concatenate formula nand...