dupe

Hello Excel VBA Masters, I'm hoping someone can help me with my current challenge. I hope to cycle through a one dimension array and when a duplicate piece of data is found the first instance of a duplicate has "dupe_1" appended to the data. If a second duplicate is found it will have "dupe_2"...

Hello, I have various spreadsheets that can contain mailing addresses with anywhere from 60,000 to 140,000 records. On certain records the street address, which is represented in one cell, is listed as a range of home address numbers, such as 145-150 Smith Rd. The City, State and Zip are also...

Hi All, In duplicating an entire row, I would like to remove the row that has LESS data than it's duplicate. Example: Dupe 1: data in columns A-C Dupe 2: data in columns A-F Action: Delete Dupe 1 Is there a way to accomplish this? Thanks in advance! /TWG

Hi, I was wondering if there was a formula that could automatically duplicate the first KeyLetter for each row until it changes then repeat? ITEM LETTERKEY LETTERKEY DUPE Item 1 A A Item 2 A Item 3...

Hello! I'm hoping one of you lovely peeps can help me here. I have a spreadsheet that has cleansed of pre-fix's part numbers in Column B, a duplicate part number warning in Column C and a formula in Column D that says, in English.... If C2 contains "Dupe" then combine the the contents of B2...

Hello, I am trying to run a sum of "Net Cash" to "Dupe Sum". The criteria are that if the client ID and time of day are the same, sum the net cash in to "Dupe Sum"... Currently I am using this (=IF(AA2<>"",SUMIFS(AE:AE,F:F,F2,A:A,A2,AD:AD,AD2),"")) but it is also counting transactions that...

I have a column of numbers. I watered them down for this example below. I am looking for a macro that will search EACH GROUP of numbers and find any dups. If there are none then go on to the next group and so on. I am not trying to find dup numbers in the entire column, just in each group...

Hi everyone, I'm new here so hoping I post this question correctly and not redundant. I have a sheet where in Column A are names of clients and Column B is the company name the client works for. I get weekly commission reports where the vendors sent me the clients who used their service. My job...

I have a column of data now (Col A) - Currently there are 3351 rows, but this can vary by week. I am trying to write a macro now that will flag duplicate values in the next column over (Col B) Example Col A Col B ABC ABC Dupe DEF DEF...

Hello, I am in need of some help! I've got about 7 sheets with data (however it may go up to 30 sheets). I need to find a way to compare all sheets for duplicate records. If there is a duplicate record, I then need each version of that record to be pasted to a new sheet. I would be basing the...

if my data is like: <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP...