duplicates

Hi , since using Office 365, when i insert a Pivot for a query ( Insert - > PivotTable - > Use an external data source - > Selecting the query) , it gets immediately duplicated. As many pivot I instert the number of queries increase. I am trying to build a more complex report with several...

Hello Forum I am needing some assistance bringing back multiple results into one cell if a match is found based on a name match and a date falling within a range on another sheet. Sheet 1: this is my results sheet Column A = list of names Column D = start date Sheet 2: this is my lookup sheet...

I have a very large spreadsheet that I am trying to return the value of some columns based on matching depths. Tab1 of my spreadsheet has no duplicate depths while Tab2 DOES have duplicate depths, some of which the columns have null values. The attached Example Tab1 image has a yellow...

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"