duplicate data

Hello, I've been working on an excel code to try and determine if an input already exists in our directory, however excel is spitting me out incorrect data. Say, I am looking to input a new name in the directory and want to input "0788-CREPE-SP" but "pr:0788-CREPE-SP" already exists. I want...

Hello, I have a vba script that copies entire rows that contain certain words from sheets(1) and paste the rows onto sheets(2). Nothing is ever deleted on either sheets so both sheets are updated at the end of the last row. Being that sheets(1) is the main sheet manually updated on a daily...

Hi, I have a spreadsheet where I am referencing some data from another spreadsheet. There are occasionally some duplicate values and it automatically grabs the first one. I would rather it not populate any data (a note saying it's a duplicate would be ideal) so that I can manually investigate...

Need help… Vlookup will only being the first instance back with duplicate valves. In my case I am looking a large amount of part numbers and bring the quantity back. Many of the part numbers repeat with different quantities, with vlookup it only brings the first instance of the part numbers...

Hi, I was wondering if anybody could help me on here, I have scoured the Internet for solutions but none quite solve my problem. I use a 2007 excel sheet to book products in and out of work. There are two sheets in the workbook, sheet one for booked in and sheet two for booked out. As I book...

My new position at work has me doing a lot of spreadsheet analysis. I love it, but realize I have to ramp up big time to learn how to do a bunch of excel how-to functions. I have a 15 year background of writing Visual Basic EXE applications, and told I can use a lot of that experience via VBA...

Hi, I have a question I'm hoping to get help with! I have multiple columns / rows of data, some of which are duplicates. Column S is a concat of columns A:R where this data is stored, and is sorted alphabetically. I'm looking for a way using VBA to find duplicate concat rows by cycling...

I'm finishing up a pedigree database of sorts that I've been working on as a personal project, and I need a way to highlight duplicate values. I know conditional formatting can be used to identify duplicates, but I need each duplicated value to be a different color. The goal: I found a VBA...

Hi, ok i have some financial data that i was using Vlookup for where i have a unique id and then i was having it return a value. This works fine for example i can vlookup id 1234 and have it return the funds of 23000. My problem is when i have duplicate values in ID1. My question is what is...

I am trying to step down row by row through a range and compare the current row against all the other rows in a range before and after the current row. If a possible duplicate is found where 8 of 9 columns in the row are a duplicate of other rows I want to highlight the rows for investigation. I...

Hello, I am trying to calculate the difference in time between the current movement type and the last movement made by a particular vehicle according to the following data set in PowerPivot. For instance, for Truck A I would like to calculate the time difference between movement 2 and 1 that...

Hey guys, I'm given a number of student id's and I need to extract the classes they're taking from a classes file. I can't seem to find anywhere how to populate cells based upon this criteria. In the classes file, you would be correct in assuming the majority of students have more than one class...

Okay ! I got a two huge separate excel sheets. One has values upto 90k (Sheet 1) and other has 7k (Sheet 2) Now I want to find the duplicate value in sheet 2 present in sheet 1 and have a all unique values to be present in sheet three It be some what like this <TBODY> Sheet 1</SPAN> Sheet...

Ok guys and gals, I am trying to find Duplicate Data inside of a file with 15000 records. This is what I have Column 1 has weld numbers that are formatted as such: F2ML-1 F2ML-2R CTI-1 CTI-2 Now what I looking to find is anything that as the F2ML on it with the same number. But see the...

I have two excel sheets A & B respectively each containing vendor data. I want to check if excel B has duplicate data similar to excel A.The basis for differentiating will be the e-mail id column/field in both the excels which is unique. e.g. If excel A has email ids...

Dear all, I have an example of a simple version of a table that I need to convert to different table structure. Can anybody please help me with this.:confused: I need to convert the following table... <TBODY> Dep Type 2010 2011 2012 A X 1 2 A Y 3 4 5 B X 6 7 8 B...

Hi guys, I've been working on a code that references several named ranges, and operates a Marlett check box accordingly. Half of the named ranges also prompt an input box. (This is for a pass/fail style check sheet. The input box is for the user to enter a reason for a failure.) This is my...

Not sure what the best way to accomplish this is but I have a master database table which has all the information I want on an employee. I want to create a new sheet which only includes certain parts of the master spreadsheet data. I want the data on Sheet 2 to change when new data is entered or...

Hi All, Can anyone will help me out with stated requirement. I need a macro code where if I enter same data (text or number) in any given column then I should get the error message or pop-up message. It also should be optional message not mandatory and excel need to allow to user enter same...

hi, everyone! i wonder if & how i can make that when i have a sheet let say MyDatabase where all my stuff is in there, then i want that the same stuff should be in another sheet (tab) named Filter1, where i want to make a filter on the data, then another copy named filter2 and place there a...