duplicates

Hello. I use an excel document as a form where serial numbers are entered into a table (Table6). This table can not contain duplicate serial numbers. I added macro that highlights duplicates within the table but the user would have to run the macro after entering the data... and sometimes this...

Hello All, If anyone knows how I have a large data set and I would like to check there is duplicates. Issue is there are two parameters needed to confirm this. So for example I have in Cell B3 the Activity ID “BLH7895“ and in Cell C3 I have the Activity Name “Taking out the trash”. How would I...

Hello, I am trying to compile a simple list of select student/ class scores derived from a master sheet that contains all the scores of all the students. So, the master sheet would contain the Following headers starting from Cell A1 - Student Name, Subject, Exam 1, Exam 2, Exam 3, Final...

The script below does a good work removing the rows based on the duplicates found in column a, however, it removes the last line with the duplicate, what I need is to remove the first line of the dups found. I appreciate your help. Column A Value 1 Value 2 <- Remove Value 2 Value 3<- Remove...

Hi! First time poster! I am trying to use a formula field to determine a first occurrence of a contract being signed ( ('Order Items'!$A:$A) result as a "1") or ending (('Order Items'!$B:$B) result as a "-1") per a client name ('Order Items'!$J:$J), per month ('Order Items'!$O:$O), to be...

I have a few columns and couple thousand rows. Name Location Status Action Jake Germany out Retain Jake Ethiopia out Delete Jake Germany in Retain Jake Germany out Retain Jake Ethiopia out Delete In the above table, if Jake is "in" (3rd column) "Germany" (just an...

whats the best way to remove duplicate data in each column specifying a starting and ending column beginning sheet remove duplicates starting in row1 column J-P J K L M N O P 1 cat dog mouse cat 2 bat car ball switch car...

Hello, I'm working on a personal project and I have the following problem: I have drop down menus in 13 rows of one column.. These dropdown menus have some overlapping values and some distinct values (on purpose). For example, Row 1 dropdown might have (1, 2, 3, 6, 7), Row 2 (2, 4, 5, 6), Row 3...

Hello, This might be a very simple solution but I just can't seem to get my head around it. Maybe one of you experts could help me out! :) I am looking to create a loop where the code looks for duplicates in one column (in this case, column A) and if it is a duplicate, the cell next to it...

I have a list of 2500 contacts with their respective email, I have duplicate contacts but the different email, I need to separate the duplicates in different excel files to not generate spam when I export it. What should I do?

Hi there, I am looking for a formula/VBA solution that will lookup an ID in a separate list, then, if the ID appears in the list more than once, I want the formula to look at the date in the first list and find the ID in the 2nd list with the closest date match before returning the value in...

I have a worksheet which has a series of cells which contain data. The following month, the same cells, but some of them my show the same data, some may have changed. I would like to have those cells in the second worksheet that have NOT changed (in other words, the data is a duplicate of the...

Hello All, I have a table of data where in column C I have values that may repeat. I'd like to find the duplicate values and insert rows above each of them using vba. Any thoughts on how to do this? I've attached an image of a sample data set where the column of peoples names have duplicates. In...

I'm trying to label rows as "Duplicate" in Column Q if i have a duplicate phone number in Column G across multiple tabs. I'm struggling with the formula. So far, I have: =IF(COUNTIFS($G$8:$G$2020, G8, 'FW 4'!$G$8:$G$2020, G8),>1,"Duplicated","") But it's not recognizing the second Criteria...

Hi! Thank you for reading this one. For an example of what I am trying to do, lets say I have a sheet that is about 200 rows long by 15 columns wide. It is one sheet with multiple bills-of-materials stacked one on top of the other. Column A has the master/parent numbers and Column B has all of...

I have a range of cells in a row I would like to check for text duplicates. See the image down below. I'm working with about 500 rows. I would love a formula to give me the result I have in cell G2. Sometimes a row may have no duplicates, 1 duplicate, 2 duplicates, 3 duplicates, etc. If that is...

I am trying to achieve the results in D3. I'm in need of a formula that will count unique names, ignoring the blanks and duplicates. Also ignoring the word "na" and "ns"

I need formulas that will count unique occurrences, certain words while Ignoring blank cells and duplicates. I am trying to achieve the results in cells D8 and D9. In this case, I need to count occurrences that starts with W81UTH excluding duplicates and blank cells. I also need to count ALL...

I am trying to achieved the desired results on E4. I'm looking for a formula that will count a unique occurrence specific to a date, ignoring duplicates and blanks. In this case, 19NOV19 has 2 trucks. 20NOV19 has 3 trucks. 21NOV19 has 2 trucks.

I have searched Excel Questions and have not found an answer to my question. I have a spreadsheet with five sheets, I need to see if there are duplicates in column A on three of those sheets. (I am comparing sheet 1 with sheet 2 and sheet 1 with sheet 3.) By the way, column A is social...