compare

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)

Iam trying to create VBA code to compare the values in a single column andperform a calculation if the condition exist. The below table is a sample of mydata. The 1st 5 numbers of the Security is always a unique number and alwaysend with US. The difference is some lines end with an L (meaning...

Is it possible to compare two records from the same table? For example: I have a database with a table called STEP1. The table contain columns: STEP1_ID, Amount1, Amount2, Date If my record have the values like this: ID=1, Amount1 = 500, Amount2 = 300, Date = 2019-03-01 Now i want to compare...

Hope my ask actually makes sense... I would like to have a macro that would compare the values in a column, let's say column J, to a fixed list or an array written in the macro, and then highlight the cell or change the text color of the value that doesn't match what's in the list? Any...

How difficult would it be to write a macro to compare the code in a workbook code module to the code in an add-in? I sometimes give a workbook to a friend or colleague that depends on VBA code in my personal add-in. I don't want to give out the entire add-in for many reasons, so I usually copy...

hello I want to compare between two tables on 4 conditions one the cod n

Hello. Help needed: need a formula to compare the last input value in an array with the average of the previous ones. Example: | J | F | M | A | M | J | J | A | S | O | N | D | Formula column | | 2 | 3 | 4 | 1 | 5 | 4 | In this case the formula should let me know that in June the value was...