1. M

    Counting and updating dupes in an array

    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"...
  2. C

    VBA - Automation for replicating data under certain conditions

    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...
  3. T

    Deleting Duplicates

    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
  4. J

    Formula Help Please

    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...
  5. L

    Help with joining 2 cells if an argument is correct

    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...
  6. S

    SUMIF Problems (Special Case?)

    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...
  7. JTL9161

    Looking for dups numbers in groups of numbers in single column

    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...
  8. S

    Duplicate name in vlookups with multiple resutls

    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...
  9. J

    Macro To Flag Dupes In Next Column

    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...
  10. K

    Finding Duplicates In Multiple Sheets and Pasting

    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...
  11. K

    Locate dupes across multiple columns with different number of rows into 1 column

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back