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