duplicate values

I need a formula to identify or select a single occurrence of a duplicate value based upon values in other columns of each row. For instance, in the table below, I would want to select the instance in A4- where none of the other row values were blank. Any advice is appreciated. <tbody> A B...

Hi, I have a spreadsheet with just three columns but after using the Conditional Formatting to highlight duplicate values from column A (Name) there are duplicates present as per the first table below. I need to get to a stage as per the second example whereby the duplicate Names have been...

Hello all, I'm look for a way to remove duplicate values that are not an exact match. The processes from everywhere I look seem to not work. Example: Original values: Wal-mart #2501 Wal-mart #2600 Wal-mart #5164 Change to new value: Walmart Thanks for any and all help

I have 2 columns: 1st column contains dates and 2nd column contains Names. I need to count the number of duplicate entries between a date range. thanks,

Hi, Apologies for posting another Index/Match thread, but I think I've been through them all now and I'm still struggling. Index/Match is my Achilles Heel so apologies if this is straightforward. I have a summary tab displaying stats on various sites (each site has its own tab). An example of...

Is there a way to count only when the data repeats a certain number of times in a row? For example, I need a formula to highlight cells only if the duplicate value occurs 30 or more times consecutively. I have been using either "=COUNTIF(A1:A3,A2)>1" or "=OR(A2=A1,A2=A3)" in conditional...

I am attempting to create a list from the unique data of 2 row. I have tried VLOOKUP, MATCH, and PivotTables and couldn't find what I'm looking for, I am still new to Excel and its various functions. An example of what I'm trying to accomplish is: In A1 to A5 we have: a,b,c,d,e and in B1 to...

Hi everyone! Does anyone know how to find case sensitive duplicate values (0001678bv5 and 0001678bV5 are NOT duplicates) in Excel? I don't want to delete these values, I only want them highlighted. I found a formula to input in the conditional formatting tool, but I must be missing something...

Hi all. I am building a spreadsheet to calculate to total value of items that have been assigned a specific code. I want to be able to sum the cells in (for example) column D that have the same code in column A. I'm thinking maybe SUMIF would work but I'm a little stumped. Thanks

I am trying to highlight values that only appear twice in a data set, but not ones that appear 3 or more, is there a way to do this, and also change it to highlight ones that only appear 3 times, etc.?

I have 12 tables (specific years( 2006, 2007, 2008..)) and within each year table there are 2 columns containing Part number & VSC. I am trying to gather every part number and its corresponding VSC from each of the tables without any duplicates. Not sure if query or script will work best. Any ideas?

Hi there - I am hoping someone can help me with my first post on any forum.:) I have a set of data where there are duplicate occurrences of the same person. Each duplicate person has other attributes which make the data unique which is used in another report and I used 'Index, Match' to return...

I have two sheets. Sheet1 contains a list of SKUS(A) and associated UPC's(B). The other list contains just UPCs(B). I'm working on a script to identify the matching cells UPCS between both sheets, and copy the associated SKU from Sheet1 into matching cells in column A Sheet2. I hope I'm making...

Hello, I need to find the same 3-4 symbols or signs in 1 or 2 columns (but as one whole string), and mark them as duplicate in another column, or just mark them with color, or maybe extract that same cells in other column. example: A 1 qw34-5-23789 2 zw34-59asdaz 3...

My code, which is functional, finds the top 5 point earners and displays their name and points they earned. Everything works great, except when two people have the same points earned. When two people have the same points, the first name with those points is just shown twice. How can I get the...

Dear all I have a sheet (sheet 1) where I have duplicate CO# and there QTYs but in sheet 2 I have CO # but I want the sum of QTY against a CO# which is repeated in sheet 1. I am stuck there, couldn't develop any formula. Please help me to resolve this issue. I will be gratefull to you all...

Hi, I have been using the Application.WorksheetFunction.Large to find the top 10 numbers in a range but I cannot seem to get the rest of the code to find the corresponding row number when there are duplicate values. My code so far is as below: Sub Top10Values() Dim rngTestArea As Range, k As...

in Excel 2010: I currently get Excel reports given to me from my companies CRM tool. It shows me activity history in every account. There are many duplicate values in the Account name column and I need to delete the duplicates leaving only the value for the time the account reached the...

Hey Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Got a bit of a head scratcher. I have the following two columns in a spreadsheet that I would like to calculate total elapsed time, however as you see below some of the “timers” that I am...

Hi, all! I have a large sheet with, after a boatload of formulae, a TRUE or FALSE returned in column AZ. I thought I was finished, but apparently there cannot be two TRUEs with the same value in column D. I need a formula to keep the FIRST true event true, and change all the duplicates to...