compare

Hello, I have this problem, I have a excel work sheet that contains processes. There are some process with the same name inside the same column “F” which want to compare, because some of them are repeated in other rows. However, the other cells contain different data. What I want to do is to...

Hello everyone, First of all I´d like to thank all participants on this website, which help me a lot to improve my VBA skills. I hope to get help with my issue :smile: Don´t get shocked about my long text, the main work is done and works. So, Two workbooks 1 =...

In cell j2 need to compare h2 and c2 to o2 and r2, if they are the same then j2 = c2, otherwise j2=c2. Thanks

Hey everyone! This is my first time posting here :) I've been scrolling through the forum for a solution to my problem but none seems to work! I've just recently started doing macros and I have a macro that would compare two excel sheets Col A(Sheet 1 and Sheet 2) and output the new data found...

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...

Hi folks, I have 2 pieces of data that are both amalgamations of data from other sheets on the same workbook in the following way: =A1&"/"&B1&"/"&C1 The data is: A1 FOC01/FOCAL POINT/C and B1 FOC01/Focal Point /C The difference being the extra space in B1 This is just a sample of the data...

Hello, I would like to compare Table1 Column1 with Table2 Column2. If Column1 value =Column2 value it should be printed "Match" if not "No Match". Both columns are formatted as text. I guess, this should be Custom Column and DAX formula.

Hello, i have two columns in my workbook AC & AD data starting on row 3. what I would like to do is have excel look at column AC and compare it to column AD than have the alphanumeric string that isn't found in column AD and highlight it bold or color the string.below is copied from my tracker...

Hi, I'm hoping to get help with how to compare company data with a handful of other companies. I originally ran pivot table to compare the totals of each company, but was asked to compare my companies data with the average and median number of about 30 other companies in my industry. I will need...

I am trying to compare Names + Course from 2 different months and having issues with Conditional Formatting Can someone advise me how to do this please. Looking to show which Names and Course are reported in Month 2 as well as Month 1 for the same Name and Course Thanks

I have Excel 2013 and I am trying to set up a formula that will compare if the total of cell A1*$14 is less than $500, then I want it to enter the $500 minimum. If it is more than $500, I want it to enter the larger dollar amount. I am wondering if this is possible with my version of Excel...

Hi all, Is there a way to compare two columns to ensure that both columns are not only the same, but are also in the same order. I have a list of products, with prices and sub-totals, in my main spreadsheet. I get sent another list of products, with prices and sub-totals for a particular...

compare 2 (A & C) columns with numbers and display the numbers that are in the first column and not in the second column in the column E then display the numbers that are in both columns (A & C) in column G

I have two (actually more like 20) workbooks that are intended to have a lot of the same formulas in them, with different hand-entered data, resulting in different values for the formulas. Essentially, creating several workbooks from a top level template. On occasion, I have a need to update...

I am needing to compare two columns and have the third be the result what is different, keeping the characters from the first column. It cannot be based off of left or right because there are values (not in the example) where the different characters will be in different places. I need the...

Hi, Is it possible to use COUNTIF function to Range with data in DateTime format and Criteria with data in Date format to compare Dates only? For example: Range: Cells from A1 to A3: 2019-06-04 18:33 2019-06-05 09:58 2019-06-05 12:33 Criteria in cell C1: 2019-06-05 The expected formula...

Dear MrExcelites, Greetings, I need a formula to compare the last and the last second cell and report whether it has increased or decreased or stays the same. Grade Table: Book1BCDEFGHIJKLM1JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC2BBSheet1 Used below formula, but with error. Trend Result...

Hi folks I have a simple UDF just to compare text files and highlight any lines between the two that do not match, it simply runs the basic DOS file compare function but just simplifies the usage. Just had my work pc upgraded to Win 10 (Yep... just), and now find that this doesn't work any more...

I have two files I need to compare. I am supposed to compare using the Customer ID number (in column D of my Salesforce doc). Unfortunately, there are multiple occurrences of these as there are multiple locations. I've been asked to match the customer ID AND address to make sure they're in sync...

Excel 2007 I want Sheet 4, column E5 to return “OK”, if Sheet1 C20, Sheet1 K50, Sheet2 E 70 and Sheet3 J11 are all of same value. If all the 4 values are not same, then return “Not OK”. (May be text or numerical)