duplicate

  1. G

    Insert string before delimiter

    Greetings Excel Community, I am attempting to insert or duplicate a string value within a naming convention without having to do input manually. Is there a formula or a macro code that might be able to complete this possibly? Via the example below, I am attempting to duplicate the ID value...
  2. S

    Combined CSV files

    This might be very easy for one of you but I can't anymore, I am not that expert in Visual Basic. I'm trying to make a new file that asks with a button for two files. Both have vehicle information, one in column A and the other one has same information in column B (as the images show). The...
  3. D

    Adding the count of repeating values

    Hi everyone, I would like your help on figuring out an issue I am facing. I have built a macro, where I need to format the source data and map it and transfer it to a template. One of the fields I have to map requires that I put an underscore and a number after the record, the number being the...
  4. L

    Formula to return the value of the duplicate number

    Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return the...
  5. M

    problem with xlook up if lookup array colume has duplicate values

    hello every one as you see the formulas cell is the red one and there are two sheets the left one is total so i try to get the amount from total (sheet) to the right sheet but there are duplicate values in lookup array (F) column what is solution to consider the duplicate values to get the...
  6. D

    Remove Duplicates in a cell Append formula

    Is there a quick way to remove duplicates in a append formula? When I insert the formula in column E I get duplicates. =A1 & ", " & B1 & ", " & C1 I would like for column E to show Blue,Red for row 1 and Blue,Red,Green for row 2 thus removing the duplicates Thanks
  7. k3yn0t3

    Simple Macro to Dupe Sheet and Update Cell Value by +1 [feat. xl2bb mini-sheet]

    Hi all. Could anyone help me with a macro that will allow me to duplicate the sheet shown below and ensure the following: Increase the Factory number in D7 by 1 each time... Rename the sheet based on the number in that cell i.e., there should be ~200 tabs named "Factory_1"...
  8. G

    De-duplicating/merging rows while keeping any data

    I need to determine whether any people have downloaded any applications. But the database that spits out whether a person has done so can only generate lists for one application at a time. So, I have one spreadsheet showing that Bob downloaded Messenger, and another showing that Bob downloaded...
  9. S

    Conditional removal of duplicates

    Hi, I want to sort a column by removing duplicates, but not all duplicates, only those that appear in sequence, i.e: 1 2 3 3 (I want this removed) 4 2 3 2 2 (I want this removed) 3 4 4 (I want this removed) Reason for this is that I'm trying to build a tree structure where various instances...
  10. V

    Looking to pull specific rows from one sheet to another within the same workbook that will update when one is updated

    Hello again, Thank you so much for your help, I am learning so much here today. Here is what I am hoping to figure out how to to. Column A has a dropdown in it with a series of Text values. At the bottom of the sheet I have tabs for each of those named text values. I would like to populate...
  11. A

    Remove Duplicates - first instance

    I am populating data from a seporate workbook and there are duplicates that get transefered over in the process. I want to remove the duplicates, but keep the last entry. All the removal processes I've seen remove the first instance only, or require additional steps of adding columns to create a...
  12. T

    Excel formular - How to delete duplicate text in 1 cell

    Hi all, I'd like to get your support to keep 1 "a" & 1 "b" in 1 cell of each column while balance should be deleted. (I'd like to get result by using excel formular). Thank you in advance. Column 1 Column 2 a, a, a, a b, b, b
  13. A

    Remove Duplicates and Copy Data in Column F

    I have a project that I am working on that is copying data from 1 tab and pasting into the other but I am coming upon an obstacle. I have a series of code that is comparing data in column A and if it matches then it pastes the quantity in column F. However if there is a row where the data...
  14. T

    Find a value, display, whilst ignoring duplicates

    Hi Guys - looking for an expert to help with this one. Having trouble in finding/showing values (E2 | F2 | G2) when there are duplicates in a range (A2:B8). Essentially: Cell E2 - Lookup D2 amongst Column A, display adjacent value (display B3 - 1111A) Cell F2 - Lookup D2 amongst Column A...
  15. D

    <Need Assitance> MATCH INDEX w/ Multiple Row Conditions Returning Duplicate

    =INDEX(Table!$B$3:$E$450,MATCH(A2&"Schedule 3"&"PLACE 1",Table!$E$3:$E$450&Table!$C$3:$C$450&Table!$F$2:$F$450,0),1)
  16. A

    A list contain value check column wise and sortby randomly list without duplicates

    Hello This is a list contains some values, I actually want this always randomly changed in new row without duplicates, I use this formula, this formula generate new random list than I manually sort and rearrange the list, and row wise its not duplicate, how I do this with formula, I attached...
  17. M

    Conditional Format not acting as expected.

    I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...
  18. P

    REMOVE DUPLICATE BY SINGLE (STRING) ROWS

    Heyy there, My problem is : i cant remove duplicate column by single string I want script or marco or anythink (automation) to fix this problem Take look of screenshot of my solution what i need Thank you every one who fix that :D
  19. D

    Find Duplicates in a Column (No Group By)

    I want to identify duplicates in column RandomColumn without using Group By - as this method will drop unused columns = let columnNames = {"RandomColumn"}, addCount = Table.Group(#"Added Index", columnNames, {{"Count", Table.RowCount, type number}}) in Table.AddColumn(#"Added Index"...
  20. M

    How to flatten this pivot table?

    Full disclosure, I'm not a pivot expert - I created this table attempting to replicate a Crystal Report, and while I've been 99% successful there's a big formatting issue - the fund numbers keep repeating when I add a new column. The columns where this issue starts are calculated fields. I'm...

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
Back
Top