remove duplicate values

Hello Everybody, I'd like to clean the duplicates from a column and to keep only 1 entry, but I'd like to keep the 1st record and all other data from the other rows. How Can I do that? I'm using Office 365. Thanks, Gabor

I have a few tables of data and I am trying to pull some information in Column F, based on the contents of Column A, into a cell on a different tab with TEXTJOIN. I need it in 2 different formats for different things. I made a sharable sheet with no company info and reduced the dataset for...

I tried this code to copy and paste unique values but 1st value comes twice. Dim cell As Range, areaToTrim As Range Set areaToTrim = ActiveWorkbook.ActiveSheet.Range(Selection.Address) areaToTrim.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("I4"), Unique:=True Range("I4"...

Hi Team, I am looking for some help here, I have base data and need to get the unique info based on one criteria in the below example is is "Category". Why I am looking formula is because it should dynamic and should not perform pivot/remove duplicate every time. Base Data...

I need to add this to a Macro I am working on and this one is beating me right now. Any help is much appreciated. These are columns B,C,D and E in my spreadsheet. What I am trying to accomplish is if there is a duplicate value in column "B" to evaluate the numbers in column "E". If the numbers...

Hi there, Would really appreciate any help with this! I have 2 sheets: Combined Data and VGBB Summary. The snapshot below is VGBB summary. What I need to do is bring over all of the prices associated with each category (e.g. Accessories) to the right of the category. My issue is that there...

Firstly i apologise if this has been answered before but i am getting myself more confused the more i look. I am trying to set a macro / vba up to copy data from about 74 sheets and paste into a sheet called "Master", the problem i have is that i have a number of other sheets I do not want to...

Hi all, I need to count the total time spent for one task among various people, by counting the starting time and ending time of the sub-events. Example here: <tbody> Event 1 1 2 2 3 3 Time S E S E S E Alex 1 Jan 2 Feb 3 Mar 4 Apr 5 May 6 Jun W days Brian 2 Jan 2 Feb 2 Jan 2 Feb...

I have been trying to get a fix for this issue for the past 2 days. I have an excel file that runs to around 54,645 rows showing individual expenses for FY 2015 month-wise. I need to replace duplicate expenses with zero only in one month (June). The list is filtered and it is best that it...

Hi All- I can't seem to figure this one out.. here are the details of the data I am looking to reorganize: In column CT between rows 11:210 is the vertical data that includes duplicates. I am looking to create a formula that can lookup each value between CT11:CT210 and return only the unique...

I’m trying to initiate a worksheet change event which will find duplicate values across multiple worksheets. So if I enter a number in Sheet1 which is already in Sheet2, I’ll get a message informing me and then delete the number which I just entered. (and vise versa if I enter a number of...

Hello, I have 2 columns A and B column A has about 700 rows and column B has about 400 rows. Some of the data appears in both column A and B so what i want to do is take any of the data that are not duplicates and move them to column C, the data in the 2 fields does not directly match up from...