comparison

I am working on a process to remove inactive users from a system that we are trying to automate. The problem is we decided we want a 30 day buffer on deleting users and our current system does not make that easy. I can export a list of all inactive users ever and a list of users made inactive...

Hello, Apologies if my post title is not the best summation of what I need. I am currently working with two different data sets that contain a unique identifier in column 8. This unique identifier is a concatenation of other fields within each row on each data set. What I would like to do is...

Hi, I'm pretty new to Excel, and I'm still not 100% around the functions, so any help, that someone could give me on my question would be much appreciated! I have 2 sheets with similar hierarchies of 5 levels in the following format: Sheet1 Row L1 L2 L3 L4 L5 1 a b c d e 2...

Hi All N00b to excel I have a excel file with two sheets with some HR type data.. so we can consider column A for both sheets (say Sheet1 and Sheet2) to contain employeenumber Now what I want to do is 1) Find if Sheet2 contains employeenumber (A in both sheets) - some kind of vlookup? 2)...

Okay all great minds out there I am at a stand still. I have two sheets with the 13 columns and ~700 rows I need to know what data is different in each row. NOT what is different by each column/cell just what data is different in each row. Example Sheet1 <tbody> ROW1 GridName Page1 Page2...

Hi, I'm trying to compare two columns worth of data. I'd like to use conditional formatting (I think?) to compare cells in column A with cells in column B and highlight the matching cells if/when any cell in column A matches any cell in column B. For example: <tbody> Sparrow Eagle Thrush...

I've got a rather sticky situation with a spreadsheet that is calculating sales commissions. 1) Within my spreadsheet, I have a tab (COGS List) that contains all of our inventory items (by item number), their cost, and their price (Columns A, B, and C respectively). 2) I have another tab that...

I'm looking for a UDF, Macro or Array that can solve the following challenge > I have Text in Columns A + B, which could include up to 35,000 Rows. The Text will be mixed with various forms of punctuation and numerals (see List below of ALL possible "Text" characters). I want to run a...

Hi All, I'm pretty new to mrexcel and vba and wondered if you could help me... I have two sheets - sheet1 (last week's report) and sheet2 (this week's report). Each sheet is the same format:column A is the unique identifier, column B text and C to F are numbers. Each sheet has over 1000 rows...

Hello all, I wish to compare a list of text (Name to Match) to a static list of text (Standard Name) and pull the best match from the static list along with a matching value in percentage. The values under the Standard Name column are static values. The values under Name to Match are string...

:confused:I am working with 2workbooks and need to enter values from one into the other's corresponding data. I am rusty on creating formulas; it has been a decade since I worked with them regularly. The sheet on one workbook is over 600 lines so it is a lot of data in text form (names of...

Hi, I am at my wits end with this. i have searched everywhere but nothing seems to be working for me. I have a spreadsheet of products that i am looking to purchase for my company. I have a column for each of the companies that are quoting for these products. I have put in conditional...

Hello guys! I have an very big Excel file that has exactly same columns but dirosa. ent many rows. I need help with an VBA-script to compare each entire Eos in sheet1 with sheet2 If it dont finds an pair I want it to write the row in sheet3. Its very important that the script starts in row 1...

Hello - I am relatively new to analyzing data in Excel - using Windows 7 and Excel 2010. I have two sets of data and am trying to validate data between them. Data sets have columns titled FirstName, LastName, Ethnicity, Gender. I am trying to compare the Ethnicity and Gender to determine...

<tbody> Company 1 Company 2 Company 3 Company 4 Destination Origin 0 (Min $) 100 lbs. 1000 lbs. 0 (Min $) 100 lbs. 500 lbs. 0 (Min $) 100 lbs. 500 lbs. 0 (Min $) 100 lbs. 500 lbs. DFW ATL $25.95 $7.76 $7.12 $39.82 $13.36 $13.09 $40.00 $11.13 $10.89...

Hi I have a problem that is hard to solve. Im looking for an VBA script (not funcion) that: 1. Compare entire rows (Column A-K) in Sheet1 with Sheet2 (Columna A-K). NOTE! Important that its entire row. 2. If it finds an dublicate somewhere show it in Sheet3 3. The big problem is that the rows...

Hello Everybody, I got a simple sheet in which I got some columns of data representing certain grid-line i.e. A-25, B-35, C-41 etc and I got another column in which the data is like B-25.5, C-26.5 etc. I want to compare the both columns and know for each item that which item is bigger or...

I manually sort a column of data and the results appear as follows: 3GPHONER710OLD</SPAN> 40G_EL_TEST_01</SPAN> 40GC-TX-ASSY---</SPAN> 4593FCT-03</SPAN> 45GS05</SPAN> I then run a macro with variables defined as STRING. When I compare "40G_EL_TEST_01" against "40GC-TX-ASSY---", it tells me...

I have two columns of data. Column A has 7,000 names and Column B has 1,500. I need to compare the two and delete all the names in Column A that don't have a match in Column B. How do I do this? Thank you in advance!

Hi, I have this script to compare: 'Option Explicit 'Sub FindDuplicate() 'Dim LastRow As Long 'Dim MyRg1 As Range, MyRg2 As Range 'Dim A As Range 'Dim F ' Application.ScreenUpdating = False 'LastRow = Range("a" & Rows.Count).End(xlUp).Row 'Range("B1:B" &...