compare

Hello, Pardon my question if it has been answered before. It's a rush job and need your help. Columns A through C are employees that have completed training. Columns E through G are all employees. Columns I through K should show results. Question: Compare the employees who completed the...

i have two columns in a spreadsheet that contain zipcodes column H has the criteria zipcodes, Roughly 214 but could expand to significantly more column G is the zipcodes i need to search through and only return the ones that match column H. column G has about 120k entries .. of course column A B...

I need to compare two sheets (Sheet 1 titled Client, Sheet 2 titled Advisor), each with a table with identical column headers and first column. The first column has the property names, and the additional columns have the information Fields about those properties. I would like the Macro to...

Hey I am new here, just joined few days ago but I am working on a task to perform text diff, on a detailed scale to cells in a column (comparing previous and current versions). Working on the core function of text diff with string formatting to highlight differences (strikethroughs for deleted...

BF1OfferLow21.3031.7041.6052.4060.9070.3080.8090.20Low100.20Low111.80121.40133.00141.00Low151.30161.10Low171.90181.70Low192.00202.10212.30221.70Low231.80Low241.90Low252.50F2:F24F2=IF(B2<=MIN(B3:B$25),"Low","") When there are no value lower than a cell value, assign ("Low"), else (""). The...

I want to spill the values in Table2 that are NOT in Table1. Any value that has a "[C]" in it, I want to remove it leaving only the name. I can achieve both objectives but can't figure out how to include the names that don't have "[C]" in them as they return #VALUE. TABLE 1 Name Clark...

Hello! Let’s say range1is a spilled range that contains 3 values. We have another range called range2 that is fixed and contains 5 elements. I want to compare first value=20 from range1 with all the values from range2 and get first value that is greater or equal to 20. After this, go to the...

Hi all, My skill in translating logic into a formula and especially VBA is very limited. Hopefully the below makes sense. Basically I was hoping for a VBA code that pulls through results on to a new sheet by using the reference column A (Order Ref) in Sheet 2 and comparing columns of the...

Hi friends, the other day, someone posted an issue on the web asking why the statement "i < ActiveSheet.Rows.Count" returns False, in which the variable "i" is declared as a String and is assigned an integer value 3. I have been thinking about this problem for two days and still can't figure out...

I was hoping for a code that will compare 1000s of entries in column A between sheet 1 and sheet 2 - and then extract the rows of those unique values in column A onto a new sheet (sheet 3) See below from example - Sheet1 1 QWE DOG QWE DOG 2 ASD CAT ASD CAT 3 ZXC MOUSE ZXC MOUSE...

Hello, I have a report fire every morning (1 workbook with 1 sheet) showing what active items need to be worked on (my team tasks are no color fill rows and all others team tasks are grey fill rows). Columns A and lets say J are blank for me to write status notes/dates in. Once I push it out...

Hi All, I am working on a project whereby we have been provided a new list of descriptions with new codining to re-price. We also have years of existing data where the descriptions are somewhat similiar and have been working to match these with the existing codes we have as a base point. I...

Hi all, This should be a simple problem but I seem unable to sort it: I have a list of numerical and word product codes in B44:B60, e.g HJK/5566712/19 A macro button on each row can copy the data from B44 over to H44 when sent to another department. Hitting the button again undoes the...

Hello gurus, I've been trying to nut this one out but it's got me stumped. Scenario: I have two worksheets. The 2nd (System Security Plan Annex Template (March 2023)) is considered a new version of the first (System Security Plan Annex Template (December 2022)) therefore it will mostly have the...

Hello lovely Excel friends...I need help. Getting back into my daily excel use and trying to dust off my fomulas knowledge. I have 2 reports in Excel that I need to cross compare. Both reports have Employee Names and ID numbers, both have varying dates of attendance incidents. I need to compare...

Hello and thanks for your help I have two sheets with different date , i want to return items if in one sheets have value and the other with zero And i have some condition like this picture

I am looking for an automatic way to identify overlap and still count totals acurately. This might take a bit of explaining. In the table below, Columns A,B and C show values 1 through to 50 group in data sets. The first row, I am looking at lines 1 through to 10 which is a total of 10 lines...

We have two spreadsheets both containing a product (the same in both spreadsheets) and a serial number. We'd like to compare both of these, naturally based on product and output all the serial numbers that are found in spreadsheet 2 for one particular product. The product can be found in both...

Hey, I am looking for some guidance on how I might achieve the following: I have a column (column H) of full addresses, for example: 1234 SW 80th Pl, Miami, FL 33331 On another sheet, I have a list of COUNTIES in column A, and CITY in column B. COUNTY CITY Palm Beach Acacia Villas...

Hello everyone, I'm having difficulty with how to make a VBA, which compares all the values of a worksheet in another. I tried to do it this way, but it didn't work: Sub CompareSheets() Dim RowSheet1 As Long Dim RowSheet2 As Long RowSheet2 = 1 While Sheet2.Range("A" & RowSheet2).Value <>...