delete duplicate entries

Hi, I have a long list of names that gets added to every day and I've formatted it so that every time a duplicate appears, the cell background colour goes light green, sometimes they are 2 or 3 cells clumped together, and other times just one by itself. I delete the row, by selecting it and...

Hello, I have two items for my data where I could use some help. Item 1 The data needs turned into a table but the number of rows varies (the columns are always the same). I used to macro recorder for these and tweaked them. First I tried the below but the code locked in the range...

I have a list of vehicles that are scheduled for maintenance work over 8 columns and 1873 rows (including the header). Each vehicle is assigned to a department. Column 'A' has the week number Column 'G' has the department If I enter a week number in cell J1 i am hoping to generate a list of...

I am working with a large data set (12 columns with 45,000 rows of entries) which is updated each day which in turn auto-updates a dashboard (within the document on another sheet) I have created to analyze this data. Currently, I am using the "remove duplicates" function to delete duplicates...

Hello all learned people, I do not have a clue where to even begin. I have a w/sheet with data in col A through G. I need to be able to find out if there are any duplicates in any rows in col D. if there are, then count how many times they appear (in the rows) and take the total and place it in...