duplicate cells

I have 1 column of data (4000 cells) and some are duplicates which have been located by True and False. The next step is to locate where all the duplicates are by a function that displays the exact cell(s) those duplicates are located. I do not know how to do the second step. Just in case you...

Is there a way to display multiple cells in a separate worksheet that are a part of multiple worksheets? Please see below. Worksheet 1 has list of email addresses in column A Worksheet 2 has list of email addresses in column A How to have Worksheet 3 display email addresses in column A that...

My Excel data table has 100K rows. The rows in column A are reference numbers ending in either ".0" or ".1". Corresponding rows in column B have a transaction name but only where the column A reference ends with ".0". There are no transaction names in column B where column A rows end with a ".1"...

Hi I have a Conditional Filter on Columns A and C to highlight duplicates. What I'm trying to achieve is a macro that finds the non-duplicates in Column C (e.g. Luke) and then deletes that value and all subsequent values to the right, shifting the cells below up. Actual: <tbody> A B C D...

Dear all, I woukld like to use conditional formatting in excel to highlight only consecutive duplicate cells. for example if: A1 4 A2 5 A3 5 A4 7 A6 5 A7 8 I would like only cells A2 and A3 to be highlighted, but if I use the 'highlight duplicate cells' command I get also A6. can anyone help...

Greetings, After searching the forum, I cannot locate anything similar to this scenario, so here it is: 1. Locate duplicate part numbers (Column C). 2. When identified, insert a blank row below 3. Copy cells above blank cell in Columns A, C, D, and E 4. Concatenate the two cells above blank cell...

Hi, I have a fairly easy problem, which is similar to this one: http://www.mrexcel.com/forum/showthread.php?t=70670&highlight=sum+duplicates In this case my data is like so: <TABLE style="WIDTH: 110pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=146><COLGROUP><COL...

Hi folks, I've combined several spreadsheets into one file for an email campaign. Previously I've got around the import of duplicate addresses by using highlight cell rules and showing which addresses are already there. But today I am finding duplicate email addresses are not being highligted...

Greetings and thank you for taking the time to read this. I am having an issue with employee time keeping in excel. I have an 8 sheet workbook with the first 7 sheets having daily time log information representing the days of the week starting with Friday and the last sheet is a summary sheet...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have read over numerous threads on how to do this, but I am still not able to piece together the correct code to make it work.<o:p></o:p> What I am trying to do is write some VBA code to...

I am attempting to use conditional highlighting to highlight duplicate values in a range of data in excel 2007. Here is exactly what I want: Column A is a function of a 'toggle switch'. So if I change conditions of the toggle switch the values in column A change. Columns B through N have...

Hi all, I want to create a macro which loops through all the cells from a certain row(which will be filtered alphabetically by me before running the macro - just to ease the work) and if it finds the same values in the cells below, to write their respective values from other rows in a new...

I am having trouble trying to concatenate cells on various rows in a column, if they all have the same value in another column. Here is some example data that will help explain my issue better: A B C D E F 1 5 Apple Me 12/1/10 2 6 Apple...

So I have two columns of code numbers. There are some code numbers that are the same in both columns. Column A 1082 112 113B 2239 8449 Column B 1082 113B 488 9490A 112 Is there a way to show on Column C which code numbers are duplicates from the two lists above? The result would look like...