duplicate

If I have query (1) with multiple steps and I need to have query (2) based on query (1). For performance and/or good practice is it better to: A) duplicate it and then modify and or remove the steps carried over to get what I need or B) is it better to reference it and then create steps to...

Hello, Here's my dilemma. I need to combine the first and last names of the individual and spouse without duplicating last names. (Spouses may have different last names in our spreadsheet). We also may not have a value for the spouse. I have: Column K with individual first name, Column M for...

Is it possible to create a new table based of multiple column of an existent table, but replacing the values that are negatives to zeros?

Dear all, I am a new user of Excel VBA and try to use it to automize the daily working routine. Now I'm facing the problem of checking duplication and change the value. So basically what I would like to do is to check the order for customers and I would like to check whether there are...

Hi, Hoping someone can help. I have a large spreadsheet with a lot of data. I have used concatenate to identify which rows are duplicates. I am looking for a script that will go down column BE checking for duplicates, once a duplicate is found column H needs to be checked and the lowest value...

Data Tier Category Name Tier 1 Tom Tier 1 Tom Tier 1 Harry Tier 1 Rafa Tier 1 Daniel Tier 2 Tom Tier 2 Harry Tier 2 Harry Tier 2 CAN ATALAY Tier 2 HANN-WEN SHEU Tier 3 Oktar Tier 3 Miria Tier 3 Harry Tier 3 CAN ATALAY Tier 3 Tom Tier 3 Rafa Tier 3 Oktar...

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

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

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

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

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

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

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

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

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

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

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

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

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

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