duplicates

Hi folks, I'm running Excel 2000 with a legacy spreadsheet which has a single worksheet. Each row contains the details of a given task performed by a particular farm vehicle. The row includes the day. month and year that each job was performed (in separate columns), along with a brief job...

Hello Excel Community, Wondering if someone might have some insight into the following. I am trying to find duplicate values based on a criteria which i will explain below. I am attempting to use the countifs formula to review but i keep getting an error and I cannot figure out what might be...

Hey, so i have an issue with some data. I have two tabs in the same excel. On TAB 2 in A column, i need it to find data in column I of TAB 1 but only IF a value appears in column F of TAB 1. I also need this to pull only 1 value per cell and not to pull duplicate values if possible. Does...

Hello All, I am having trouble, I hope you can help. I have tried a few different versions of code with no success. Example of what I require: Compare ("Sheet1") Range K4:K1000 with ("Sheet2") Range K4:K1000 and if there is a duplication, copy the "non-duplicates" from ("Sheet 1") Columns(B:O)...

I'm trying to write a formula that looks for duplicates and returns a specific text value if a duplicate is present. I'd ideally like to do this without nesting multiple if formulas as this might slow down the workbook. What I have so far is...

Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return the...

Hey all, Thanks for taking the time to review my question. I must be missing something simple but for whatever reason I am missing something. In "Tab A" I have a list of "A" names, "B" dates and "C" total hours, In "Tab B" I have "A9:A39" each date of the selected month, "A1" the name I want to...

Good day to all, I have a sheet as listed below. I am searching for a formula that finds duplicates and lists them in P13:P16. The values should be checked for duplicates between B3:K11 and M3:S10. If there would be more duplicates it only lists the top 4 duplicates alphabeticly. I have...

Hey everyone, I posted this earlier as follow-up in a different thread, but I thought it would be wiser to open a new one since its a different issue than the original one. I want to delete duplicates per key in this table...

I'm running into errors with my conditional formatting. It's highlighting as a duplicate when it's actually not, but it's doing it inconsistently. I'm looking to highlight the cells in column C and D when there is a duplicate across both columns. Here's what I have as my conditional formatting...

Hi Guys - looking for an expert to help with this one. Having trouble in finding/showing values (E2 | F2 | G2) when there are duplicates in a range (A2:B8). Essentially: Cell E2 - Lookup D2 amongst Column A, display adjacent value (display B3 - 1111A) Cell F2 - Lookup D2 amongst Column A...

Hello Excel Masters. I am trying to write a formula that will fill in the blank cells for Column B with "Contact 1", "Contact 2", or "Contact 3". Depending on how many duplicates are in Column A. EX: 174653 Contact 1 174653 Contact 2 175277 Contact 1 175277 Contact 2 178484 Contact 1...

I have a excel file which needs to be unique, I want to remove the duplicates, all kinds of duplicates like below Going to data->remove duplicates is not working. i found a code, which is also not working Sub SimpleExample() ActiveSheet.UsedRange.RemoveDuplicates Columns:=Array(1, 2, 3) ...

Hi I have a reference cell B2 which contains the year. I would like to create a formula that contains dates (not referenced in cells) and counts the duplicate dates. Within the formula I have the fixed dates DATE(YEAR(B2),1,1),DATE(YEAR(B2),3,2),DATE(YEAR(B2),5,1),DATE(YEAR(B2),5,9) and I would...

I have a spill array that is pulling IDs from another sheet. I already have a list of IDs on one side of my visual, and I want to avoid duplicates. The list of my array formula is longer than the existing list I want to compare, and that's tripping me up. My formula with the spill array...

Hi all! I’m looking for some VBA help please! Does anyone have code that can help me find duplicate text in a column and highlight each pair as it were in a different colour? I know the text is an exact match because I used data validation, and I can get the duplicates to flag up using my a...

Hi, I have a data list and a userform to add additional row(s) with data. I would like an error message to pop up whenever duplicate data is entered in the according userform field on the basis of a specific column in a named table. A blank entry field is admitted, but no duplicate entries. I...

Hello, I have VBA code with an inputbox where you can enter specific years in order to create worksheets containing the months of this year. Now, if the year is entered twice, then the sub should be exited with the messagebox "This year has already been entered". Anyone has the VBA knowledge...

Hi! I have a sheet with shipping addresses but the data isn't all perfectly lined up. My headers are as follows, starting with Col A: NAME1 NAME2 NAME3 ADDR1 ADDR2 ADDR3 ADDR4 Some of the addresses are mixed up and come in under NAME2 or NAME3 so I was able to find a couple of formulas...

Hi, I'm basically looking for a VBA that- - identifies duplicates across the whole workbook/multiple sheets - highlights duplicate cells to same random colour (preferably a light colour so text is still visible) - ignores blank cells Any ideas? Many thanks,