duplicate check

Hello, I am trying to create a macro that will handle data that often includes 3x repeated timestamps. For those repeated timestamps, I need to keep the second iteration and discard the rows with the first and the third. Example: These columns will continue in this manner with three...

I am currently looking for a way to count posts. I have 1- 50 posts so in total 50 posts. If i split the posts in to work groups like the table below I can see if I have any overlap and subtract the number of posts work on twice to get back to my 50 total...

Hello Gurus, I have received data from key users where we have several lines of data distributed across 30 columns. They asked me to; 1. Check for duplicate records across all columns B to AE 2. If all column values are same for given rows then put X in column A for one of the duplicate row...

I'm looking for a macro that will look at each cell in a specifically named column, compare it to the contents of all cells under the same named column in all other sheets, then return (in a cell in the corresponding row) the sheet name & row number where the duplicate(s) exist (there might be...

I am working on a Userform that allows users to sign into projects using their login and password credential. However I'm running into a situation where sometimes my worksheet_change events work and other times they don't and it's allowing for the same username to be entered when creating their...

Hello, I am trying to find a way to perform a check to highlight duplicate values based on the value in another column. For example in the table below I have 2 sorted columns A and B, I need to iterate each value in Column A and highlight duplicate values in Column B Column A Column B...

Hello everyone, I am new to the use of VBA and still learning on my way around. I have designed a userform, where I am to collect data based on different regions eg: London, Derby, Poole, etc (columns). I am trying to collect different varieties from each area as low, mid, high, new, old, etc...

I have a dataset consisting of approx 200,000 rows. One of the columns is named ProjectNumber, and if I remove the duplicates there is approx 2,000 unique values left. I have a lookup formula to another table with projects, to check if the ProjectNumber exists. I know how to do the lookup...

Hi team, I am stuck and any help is highly appreciated. Have 3 columns as below. SKU id can be anything. I need help trying to have a formula for column C. If the SKU is used for first time column C should say NO . I tried =IF(COUNTIF(C:C,C2)=1,"No","Yes") but its not useful in this condition...

I have created a userform with a TextBox and ComboBox controls. The user key-in Date in TextBox and selects data from each of the ComboBox. Which are then saved to the worksheet named "Dashboard". Below piece of code does that perfectly. Private Sub Add() Dim lRow As Long Dim ws As Worksheet...

Hi, thanks for taking the time to help me! I'm pretty new at <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial...

I have two columns of data, one contains a unique identifier, the other contains another 4 digit key. What I want to do is for the unique identifier when there is more than one 4 digit key that is associated to it, I would like to to display x. Marking both entries not just the first or...

Hi guys, Currently the simple code below reads two values on a row, one from column "C" and one from column "D". It concatenates them and writes the new string in column "B". Sometimes the list in column C will contain more than one string exactly the same. I don't want it to write a value...

Okay this should be an easy one. I need to make a function or macro that counts duplicates. The last three characters are numbers. So if it comes across: Milk_001 Milk_001 It would be changed to Milk_001 Milk_002 The problem i am running into is when I get to the 10th duplicate it reads...

Hello, I concatenate two columns, and delete all spaces from the results, after that I conditional format to find duplicated texts. It works ok. My question is: Is there a way to check duplicate for the 10 first characters, or maybe 5 first ones? it would help to find some differences in text...

Hi All, I created a user-form to enter product ID in textbox1. Product ID is unique. There is list of product ID that is already entered in the sheet1 from A2 to A20. I just want to know how to throw a hard-stop vbcritical error if user tries to enter the product ID in the text box which is...

Hi I am trying to write some code which will check text entered in each of 5 textboxes on a form, against a column of data already entered, starting cell B2. I'm a bit of a newbie so please excuse if my terminology isn't very good! I can get the result I want checking one textbox against one...