Remove Duplicate Prospective Customer Information?
Feb 8, 2014
I have two different spreadsheets with customer leads on them. I want to ensure that I don't duplicate my effort by contacting the same customers again, so I want to remove duplicates, but not in the usual way. If I simply use the remove duplicates function I will be left with a combined list of customers, some of which I have contacted and some of which I will not have contacted. I want to be able to search the second spreadsheet so that it removes the information that also exists in the first spreadsheet without combining the two so that I am left with a list of only customers I have not contacted already. I understand I may have to copy and paste, but I need a way to ensure the two lists are able to be separated once the duplicates are gone.
Someone said something to me about an "IF" function
View 1 Replies
ADVERTISEMENT
Jul 3, 2012
I have a file with 2 worksheets:
The "On" worksheet represents ALL of the students that LIVE on campus (freshman, sop****re, juniors, seniors)
The "JS" worksheet represents all the juniors and seniors going to school here
I need to know which of the JS live OFF campus.
So.....I need a macro that will compare the JS worksheet to the On worksheet and create a new worksheet called Off and populate it with those JS that are not in the On worksheet.
The "On" worksheet contains:
A B
Last First
The "JS" worksheet contains:
A B C D E F G
Last First Street Street2 City State NY
The new "Off" worksheet should contain the same columns as "JS"
View 3 Replies
View Related
Jan 9, 2009
I'm still having trouble with this formula. I have a sheet, sample attached, that has a list of transactions, with customer name, date, cash-in & cash-out information that is listed down a set of rows. I'll have a tab for each year & the information will be seperated by months.
My other sheet is a monthly report that I will be printing. I have a seperate "section" for each customer & I want excel to fill the information from that customer based on the month. I tried using a index match formula & a vlookup formula in a helper column, but it doesn't bring out the info that I want.
View 6 Replies
View Related
Jul 1, 2008
I am trying to develop a procedure that allows the user select a customer from a drop down list (using Data validation), thereby providing the user with a summary of customer information. That I can do. What I would like to do is allow the user to add new information in the summary section which is then appended to the customer record further down the sheet (see attached example). New data could only be added to the last two columns. The user would be required to press a form button to append the data.
The catch would be if the customer was selected again, the new data would also display in the summary section.
View 4 Replies
View Related
Sep 29, 2008
I have a Purchase Order template that I created in Excel and an Excel Customer spreadsheet. I am trying to get the Customer Name, Address, City/State/Zip (all found in different columns on the customer spreadsheet) to autopopulate on the Purchase Order when the matching phone number is entered. New to advanced formulas but looking for something like: if the phone number on the purchase order equals the phone number on the customer database, bring over the Customer info above to the appropriate cells on the purchase order.
View 5 Replies
View Related
Mar 27, 2008
I have a list of customers that contains duplicate records. These records ALSO include thier addresses WHICH may or may not be identical.
Example: Customer with LAST NAME in A1, FIRST NAME in B1 may be the same person as A2 and B2, however each record may have a different address in column C1 and C2 respectively.
I want to be able to filter out all duplicate customers based soley on the first and last name (data in columns A and B).
View 9 Replies
View Related
Feb 27, 2009
I have pasted an excel report that I need to find any duplicate information. For example they are seperated 2 sets of 4.
For example:
Column A and B is one set
Column C and D is one set
With column E is where I need a way to flag duplicate information with "yes" or "true" on that set
The same would need to have happen on the next column G thru J then M thru P finaly S thru V
******** ******************** ************************************************************************>Microsoft Excel - compare-v1.xls___Running: xl2002 XP : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutW1=ABCDEFGHIJKLMNOPQRSTUVW1Internet & DMZ Idns db-whipNamed.confInternet & DMZ Idns db-metroNamed.confDuplicates Internet & DMZ edns db-whipNamed.confInternet & DMZ edns db-MetroNamed.confDuplicates Integration idns db-whipNamed.confIntegration idns db-metroNamed.confDuplicates Integration edns db-whipNamed.confIntegration edns db-metroNamed.confDuplicates2zone 0.IN-ADDR.ARPAfile db-whip/db.0.0.0.0zone 0.IN-ADDR.ARPAfile db-metro/db.0.0.0.0 zone 0.IN-ADDR.ARPAfile db-whip/db.0.0.0.0zone 0.IN-ADDR.ARPAfile db-metro/db.0.0.0.0 zone 0.IN-ADDR.ARPAfile "db-whip/db.0.0.0.0"zone "0.IN-ADDR.ARPAfile "db-metro/db.0.0.0.0" zone "0.IN-ADDR.ARPAfile "db-....................
View 9 Replies
View Related
Sep 24, 2013
I'm busy cleaning information from an excel spreadsheet. Not all the columns are populated. e.g. Row 17 will only have an email address in column E whilst row 18 will have a name, surname, company and email address (same as in row 17).
Using the remove duplicate function, removes row 18 and thus leaves me with the row that only contains the email address.
What would it take for me to be able to remove the rows that do not have the additional columns populated?
View 2 Replies
View Related
Nov 24, 2009
I have a sheet with over 1000 rows showing me every employee's benefit choices. It has multiple rows for each employee - one that indicates their health option, one that indicates their dental option and so on.
I'd like to combine them so I have one row that has columns for health, dental, etc...and then their options would be listed all in the same row. I've attached the original with the solution I'd like pasted below. I'm sure this isn't difficult but I'm having trouble figuring it out.
View 2 Replies
View Related
Jan 7, 2014
I am trying to separate the data in my spreadsheet. I will attach the spreadsheets and explain below. T
The column labeled number has entries that include commas. I need each number entered separated and put into its own row and I need the remaining data from the original row duplicated to the new rows.
Here is an example using the first entry.
Original entry
November Wiseman 1,2,11 Bluen Medical CA
How it needs to be separated
November Wiseman 1 Bluen Medical CA
November Wiseman 2 Bluen Medical CA
November Wiseman 11 Bluen Medical CA
View 7 Replies
View Related
May 27, 2014
I have a piece of code that consolidates data onto one sheet.
Once the code has copied everything over, I would like it to also duplicate the Category field.
There is no option to add the duplicated column in the source information.
Here is the consolidation code:
[Code] ......
View 1 Replies
View Related
May 24, 2006
I have a worksheet with duplicate but necessary information. in column A there is a Name and in column B there is a number. like...
John 43
John 6
John 23
Karen 54
Kathy 12
Kathy 23
I need to add all the numbers up for one name and then delete the un-needed rows. so it ends up
John 75
Karen 54
Kathy 35
View 5 Replies
View Related
Apr 8, 2014
I have used a vlookup code from a past post (Vlookup multiple values in one cell) in VBA and successfully retrieved my information to one cell.
However, I would now like to remove any duplicates in this cell; preferably while running the same code.
--vlookup code
Public Function mVLOOKUP(mlookup_value As Range, mtable_array As Range, mcol_index_num As Long)
Dim r As Range
[Code].....
View 2 Replies
View Related
Jun 3, 2009
I have a column 'AE' that contains the html code for ecommerce item descriptions. While importing/exporting back and forth with another program and my spreadsheet, the following was added all throughout the descriptions.
%0d%0a
In some places, it may be three or four times consecutively
%0d%0a%0d%0a%0d%0a%0d%0a
Is there a macro script I could run to simply remove this any time it occurs in this column? It is just showing up as text and I am sure in another program it was representing something other than text, probably a space or hard return. Regardless, I don't need it.
See example below: ....
View 8 Replies
View Related
Apr 9, 2014
I attached a file in which column A is dr_cr and E id INST_NO and column G is INST_AMT. This file like a bank statement. in which one instrument(cheque) present and i denote it c(credit) in column A. but if cheque credit then d(debit) means that this cheque present and dishonour. but some time one cheque credit and then debit and then credit. it means that we have to remove previous credit and debit entries. in this attached file you found this type of entries. i want to remove this type of entries. i further explain.
1. if one instrument have one credit and one debit its ok.
2. if one instrument two credit and one debit then remove one credit and one debit where instrument no and amount and drawee bank must be same.
3. if one instrument have two credit and two debit we have two remove one one debit and one credit.
4. if one instrument have three credit and two debit then we have to remove two credit and two debit so one credit left.
Attached File : remove duplicate.xlsx‎
View 2 Replies
View Related
Aug 9, 2013
Is there any way of Removing the first duplicate in a list only? I am writing some vba to automate a month end process and wonder if there is a way to achieve this? (excels remove duplicates function keeps the first, and removes everything else). The data is in column C.
View 2 Replies
View Related
Jul 6, 2009
I have 2 issues i am trying to work through, i have a spreadsheet with 3 data sheet tabs, the first issue i have is in Data sheet 1 I have a lot of duplicate addresses, I was wondering if there is a way to filter out the duplicate addresses so that only one of each address is showing.
Issue 2 that i have is a lot more complicated, In data sheet 1 i have a list of medical providers that reimburst at 110% or more, each address on that list needs to get 1 letter mailed to them, but i have to keep track of how many are going to each region, i.e. Columbus, OH region, Cincinnati, OH Region, Toledo, OH Region, and Cleveland, OH region. So what i want to do is create a 3rd data sheet that keeps track of total letters sent by region, but was wondering if it was possible for this info to be automatically transfered from data sheet 1 to data sheet 3. I don't need all the information in data sheet 1 to tranfer to data sheet 3. All i need is for data sheet 3 to read off the City field in data sheet 1, and calculate 1 letter sent to that region.
I dont even know if this is possible, but it is way beyond my realm of excel knowledge which isn't much.
Any help would be appreciated. I am trying to attach the spreadsheet, however it isn't allowing me to attach it, i keep getting a database error, when i upload it. It is under the max size limit too. Not sure what's going on.
View 9 Replies
View Related
Sep 4, 2013
I used to have a macro that did this for me, but the layout of the exported data has changed and now the whole macro has had to be rebuilt.
I've got a list of two pieces of data: Material (Column A) and Order (Column B). I'm putting a spreadsheet together and populating it with VLookUps. This spreadsheet will list the materials and the Orders after each, but then I also want to list the second Order in the next cell if there is a second order.
For instance, in the below, Material 10880873 has two different Orders. The first VLookUp grabs Order 513792568. I need the second VLookUp to grab the next Order 513792569.
MaterialOrder
12012223513571068
12149080513739571
10880873513792568
10880873513792569
12215347513792570
12160123513801190
12171779513802721
View 6 Replies
View Related
Feb 7, 2014
How to remove duplicate value for each customer total.
View 3 Replies
View Related
Jan 25, 2010
I have two columns each of 5000 cells. Some cells of column A are duplicated in column B. The duplicates are not necessarily on the same rows. How do I delete the duplicates?
I've spent hours researching for an answer and I've tried Data>Filter>Advanced Filter many many times and it does not work. The two columns just sit there. Shouldn't this be a very easy thing to do in Excel?
View 9 Replies
View Related
Mar 7, 2007
Wihitn a large SS I have a column which has a number of entries that may include an amount of duplicate entries. Till now I have been using Sort and them manually deleting the duplicates is anyway that I can select just the Column and then without sorting go down and if a duplicate is found, then the duplicate would be deleted. Meant to say the dta is numeric.
View 2 Replies
View Related
Aug 12, 2008
ive got a spreadsheet with records such as this
james - smith - leeds- 01535 - 26/02/1983 - bd21 6ls
steven - smith - bradford - 213789 - 28/01/1982 - bd33 5th
james - smith - leeds - 01535 - 26/02/1983 - bd21 6ls
steven - king - manchester - 213789 - 28/01/1982
andrew - wright - bingley - 36473 - 12/01/1981 - bd23 689
what im trying to do is to check all of the rows for duplicates in such a way that (if any row has the matching colums 1,2,5 and 6 then all but 1 of the rows will be deleted.
i have a few thousand entries and am just trying to get rid of all the duplicate rows. The problem is that the duplicate rows are not IDENTICAL for instance soime of them may have spelling mistakes hence i cannot just do a straight forward if row = row then delete.
View 4 Replies
View Related
Jun 13, 2014
I have data in excel that has some information the same with a unique field. See below:
Last Name
First Name
ID
Date
Address
Apt #
Acct #
Code 1
[code]...
I want it to consolidate all of the like information but add on the codes in separate columns like this:
Last Name
First Name
ID
Date
Address
Apt #
Acct #
Code 1
Code 2
Code 3
Code 4
[code]...
Also, sometimes the same code is used multiple times but i want any duplicate codes to show as separate codes.
View 5 Replies
View Related
Apr 24, 2014
So for a project I need to put together a list of Portuguese-speaking last names. So I have various sources where I copied from, so I have one column in excel where I put all that data. I sorted the data to be in the correct alphabetical order. But when I try to remove the duplicate values in that column is says it removed them but it didn't and when it does it leaves many behind. I have tried the trim function, and even formatting but nothing works. I attached the non-formatted and non-trimmed list, because it doesn't seem to be making a difference.
View 3 Replies
View Related
Aug 17, 2014
I am trying to create a summary sheet that updates when input data is added.
I'm still learning many parts of excel and I'm unsure why the SUMIF function on occasion leaves duplicate data in.
I can live with the fact that I will need to correct the input data and am willing to just paste in corrected data when it has been validated via the data validation tab.
Once this has been done, all I am seeking is for a subsequent process to start which updates a summary sheet with the sums correctly adding via the sumif function.
I have left some instructions on the actual spreadsheet to clarify my intended results.
View 1 Replies
View Related
Sep 30, 2010
I have a long list of around 400 phrases, all in their individual cells. My problem is some of the terms have duplicate words in them.
Here's an example: [URL]
Is there any way to remove this duplicate text from the cell?
View 9 Replies
View Related
Dec 12, 2012
My spreadsheet has more than 200 columns and 5000 rows of data and blanks. When I select all columns and rows and remove the duplicates, 6 records are removed. I need to only keep and be able to identify those 6 records. I could use something like =IF(COUNTIF($A$2:A2,A2)=1,1,0) if I had only few columns that would identify dups but since there are so many columns it would be prodigious job to create one formula for each column and filter through 200.
View 1 Replies
View Related
May 14, 2014
Column A has values increasing by 1 but not necessarily each row, i.e.
1 1 1 2 2 2 3 3 3 4 4 4 4 5 5 5 5 7 7 7 8 8 9 10 10 11 11 11 11 12 13 13 14 14 14
I have a listbox which I want to Initialize by listing these values but not duplicating them (so in this case it would contain 1-14). Here is the mindblowingly complicated code I currently have:
[Code].....
This gives me the list as it appears on the sheet but doesn't get rid of the duplicates for me.
View 9 Replies
View Related
Jun 30, 2014
I am using the following code to remove duplicate records from a sheet:
[Code] ....
It successfully removes the duplicates (based on Columns A and B), however it is changing the formatting of the cells and messing with the conditional formatting I have on the sheet.
View 14 Replies
View Related
Jul 1, 2014
Have a sheet that has a bunch of part numbers on it. Column D6 (and down).
Some of these part numbers have a duplicate but they have a W at the end.
Example:
62590391W
62590391
What I need is for the macro to identify the part number without the W. Add the value of the same row Column I to the W part number same column.
And then to delete the entire row that the non W part was in. All the way down column D. Need it just for Active sheet.
Example:
WnonWexample.xlsx
View 2 Replies
View Related
