duplicate cells

I have a bank report where I am trying to highlight the duplicates. The highlight duplicates only works for one condition under conditional formatting. How do I get it to work for more than one condition? In my example, I want to highlight duplicates that are duplicates in the Type column and...

I have a list of Companies & Contacts with a column labeled 'Called this year' I'm looking to find a formula that will include All contacts at the same company if one contact at the company has been called Example, Geico, Called Tanya, but not Francene, in this case I would put another column...

I'm looking for a macro that will look at each cell in a specifically named column, compare it to the contents of all cells under the same named column in all other sheets, then return (in a cell in the corresponding row) the sheet name & row number where the duplicate(s) exist (there might be...

Hello, I am trying to create A VBA macro where the user is asked from a input box to select a column for range like "A:A". They are then asked for a second column range, like "C:C" for example. Once the two ranges are selected I want to have excel compare the two column ranges for duplicates...

Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)l

Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)

I have been receiving some help online creating a spreadsheet. So far...I have gotten what I wanted.... But I am stuck at this point... On sheet 2 ,Values in Column A rows; values in Col B-F are multiples of ColA (12x,13x,37x,101x,111x). List pairs of Lottery names and values are in Col H/I &...

Hi everyone, I have a data set that is updated on regular basis by multiple users. Hence, the number of rows of this data set keeps on changing. However, the number of columns remain the same. The data set looks like following...

Hello, Thank you for your help in advance. I am trying to SUM a $ Amount that has rows with multiple $ amounts but same value. Please see example below. I have tried countif to label the duplicates and then sumif based on what was tagged as a duplicate and what wasn't but can not get it to...

Hi, I need to duplicate values in a column based on the value of the cell to the right of it, for example if the Quantity column is 1 then no values are duplicated, if the quantity is 2 then the cell to the left (the salary) is copied and pasted at the end of the salary column once, if the...

Hey Guys Just after some heap been rcking my brain for days! My Table/Range has been pupulated this way; <tbody> <tbody> Window Support Channel 1/1800, 1/1200, 3/600, Window Support Channel 4/1800, 2/1200, 4/900, Window Support Channel 1/1800, 1/1200, 3/600, </tbody>...

Sorry that title is vague, I have a project where I am comparing Column D with Column J, Easy enough with standard CF rules, but I only wish to highlight the duplicates between column D and J, I am not concerned with/if there are duplicates with in each column (D or J) just if there are...

Hi Everyone !! I have written a code to copy values from one column and then pasting without duplicate values on another column in the same sheet. I am having issues because instead of deleting the duplicate values only its is removing the entire row where those duplicate entries are found. I...

Hi, I have a column with huge list of company names. I have removed the exact duplicate companies presented in the column. However, there are plenty of repeated companies name in the column with partial and real spelling of the company name. Eg: ABC inc ABC XYZ Data Inc XYZ Inc XYZ...

Hi, I have approximately 58,000 rows on one worksheet which contains products, and (COLUMN A) will contain the SKU#. On another worksheet, I am bringing over a "column" that represents a certain amount of (sku's) that are the products I wish to use. So in (COLUMN B), I am pasting the column...

I have multiple rows with identical values in 3 columns and the 4th column has a unique value based on the date when it is sold. Can someone please help me in creating a 5th column which will show me based on conditional formatting value which was sold earlier and which was sold more recently...

I have two different columns on different worksheets that I want excel to count. currently I am unsure on how to add another logic to this formula please help. So basically I want excel to count if 'Upload New Class'!$B$2 is found in table 1 with range's X-Z OR table 2 with ranges X-Z...

Hi, Really would like some help here. I have several different dates in a row with one primary date i need to match with. The different dates referring to different events and stages. I would like to extract all the column header which has the event if the main date matches in the same row...

hello, Need help to find a way to duplicate certain cells depending on a value in a cell. example: column A shows Qty, column B shows Location, column C, D, E..... will show value of column B depending on QTY in column A. <tbody> QTY Location 1 2 3 4 2 181201 181201 181201 1 182411 182411...

hi, first i want to apologize for my bad english. i Need help for coding a VBA macros with multiple dynamic ranges and offsets. Here is the file link for exemple. https://drive.google.com/open?id=0B73QGIX8lusWLWlRS1dNamFjdEE thx for help and time.