compare 2 ranges

I have one file (Pay Statement) with Employee numbers (column B) and pay period dates (column E). In column M I am trying to pull in data from another file (History). The History file has the employee number (column A), the effective begin date (column C), effective end date (column D) and the...

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

Hi - I have two sets of employee data from two sources, both in separate worksheets within the same workbook. Both sets of data have same 5 columns, e.g employee number, employee name, line manager, email address and department. I need to compare (based on the unique employee number) of any of...

I have a range of column headers that is transposed from a list in column B. When a value from column B changes, I have a macro that will copy those values and transpose them into row 8, starting with R8. I want to prevent the user from changing the column headers. I want the column and the...

I work in grant budgeting and need to calculate fiscal year budgeted amounts based off of calendar year budgets. Usually the amount of calendar year days hits multiple fiscal years. See below; <tbody> Calendar Year Total Days Fiscal Year Total Days Days in CY 365 350 0 715...

Hello, I am trying to compare Column A in the sheet "Craigslist" to Column A in the sheet "VPDC Server Data" and then return all the names from Column G where the two match in a new sheet titled "Craigs VM List" in Column B. I would also like to return the corresponding "Craigslist" Column A...

Hi, i'm trying to write a vba macro to compare data of two cells in same row with two cells in another sheet in same workbook. For example below is my data Sheet1 <tbody> A B C (Exists or not) 1 100 200 yes 2 xyz abc yes 3 fff ggg no </tbody> So i want to compare ROW1 (Cell A1 AND...

Hello everybody, I'm pounding my head on the following problem. Suppose I have a sequence of 7 random numbers in a row, each number in the next column. (I do know how to randomly generate numbers so this is not the problem). On the next row I have another sequence of 7 random numbers. For...

Hi there, I have a column containing a large-ish number of cells (column "A"). Each cell contains a concatenation of a dollar figure (can be pos or neg) & a card number & a datetime (MM/DD/YY hh:ss). Example: <tbody> -2.23|6202xxxxxxxxxxxx|08/06/13 10:02 </tbody> I have generally been...

I am trying to step down row by row through a range and compare the current row against all the other rows in a range before and after the current row. If a possible duplicate is found where 8 of 9 columns in the row are a duplicate of other rows I want to highlight the rows for investigation. I...

Hi all I've two excel sheets in one work book, Sheet 1 contains A - S No B - Mandal Name C - DISE Code (Numbers are stored in this column) D - Name of the School E - Account No (This column is empty, we need to fill this column by the formula) Sheet 2 contains A - S No B - Mandal Name C -...

**I do not have rights to attach my workbook. :confused::confused::confused::confused: I don't even know if this is possible....I have no idea how to code a comparison of a set range of columns with another range of columns and then flag the rows with differences to insert an image in a frame...

Hi, I want to look at our shop vs website sales and see if we have any products that sell in store and not online. I've seperated the sales into two different sheets (one shop, one web) with the same format as pasted below. Can I use a formula to compare the volume of products that appear in...

Hello, I am trying to write a formula to compare two sets of data and indicate if there is a value in range A that does not appear anywhere in range B. I have used a COUNTIF function to give a TRUE or FALSE outcome for whether a single value appears in a range, however I am currently unable...