Three HUGE Columns, Deduplicate And Dump Back Into Three Separate Email Campaign Databases
Jul 17, 2009
I have three very large columns that I need to deduplicate and dump back into three separate email campaign databases.
Here's the scenario:
First column: Largest (15,000+ records)
Second column: Medium (10,000+ records)
Third column: Small (7.000 records)
I need to know if the first column contains dupes from the second & third columns. If so, I must delete the DUPES ONLY so I have unique email addresses remaining in column 1. Then I need to know if the second column contains dupes from the first and third column. If so, I must delete the DUPES ONLY so I have unique email addresses remaining in column 2.
Then I need to know if the third column contains dupes from the first and second column. If so, I must delete the DUPES ONLY so I have unique email addresses remaining in column 3. I can't just dump all of them in one column and auto filter on "unique records only" because the three columns MUST remain separate from each other.
View 3 Replies
ADVERTISEMENT
Jun 21, 2014
Have an Excel 2010 spreadsheet with 902 email addresses in one column, and 927 email addresses in other column, sorted in alphabetical order.
Overview: Organization database has 902 Members (some have 2 email addresses subscribed to listserv) and Organizational Listserv which has all 927 (Difference is numbers are some members have 2 email addresses subscribed) BUT 902 of emails should be the same
Objective to compare Listserv Members 927 with Database Members 902. I am trying to isolate the email addresses which do NOT exist in Listserv Column, or who do not exist in Database Column for Audit purposes. All Members from the Database column should be subscribed or entered into the Listserv column.
If it's a perfect world the 902 email addresses will all be exactly the same as 902 out of the 927 Listserv email addresses.
Trying to highlight or sort and put identical email addresses on same line or using Conditionally formatting? Highlight Cell Rules/Duplicate cell rules Even when same email addresses are on the same row conditional formatting does not recognize them.
View 4 Replies
View Related
Jul 27, 2007
I have 2 spreadsheets. One is a promotion calendar that lists the dates that promotions on a certain product runs. The other is a shipment grid of shipments of that product to the customer.
I want VLookup to find the customer and the dates and then bring me back an asterisk in a separate column to show me that that certain week that product was delivered was a promotion week. The problem I have is using Vlookup to lookup 2 things at once (and if they match to the promotion calendar) and return me an asterisk.
Here is my formula now:
=IF(VLOOKUP(J2&" "&L2,'East Data'!M:AU,2,FALSE),"*",0)
J2 is the customer name
L2 is the week
"East Data" is the spreadsheet with all of the promotions and customers.
View 9 Replies
View Related
Nov 20, 2012
I receive an extraction from AutoCAD that lists the electrical devices in a drawing. I don't have any problems extracting the letters. I have a problem extracting the device number and the device number extension.
The device label extraction is similar to this:
DCM1005-1
DCM1005-10
DCM1005A
MTR1005-1
MTR1005-10
MTR1005A
I want to create 3 columns from the device label: (I separated the column with commas)
A1, B1, C1, D1
DCM1005-1, DCM, 1005, 1
DCM1005-10, DCM, 1005, 10
DCM1005A, DCM, 1005, A
MTR1005-1, MTR, 1005, 1
MTR1005-10, MTR, 1005, 10
MTR1005A, MTR, 1005, A
View 5 Replies
View Related
Oct 9, 2013
How can I separate the following numeric/text combination into two (2) separate columns in Excel?
302ALTO
406AMZN
451AMRC
404AMAD
605ANCC
405ADRC
The result would be:
302 ALTO
406 AMZN
451 AMRC
404 AMAD
605 ANCC
405 ADRC
View 6 Replies
View Related
Jun 18, 2012
I have a combined sentence with email address at the end. There is a space between email and other part. For example, in Cell A1, it's: PO Box 132, Washington Ave, dennis789@yahoo.com. In cell A2, it changes to: 12 DW Road, georgeyiui@hotmail.com. How can I separete these emails out?
View 7 Replies
View Related
Apr 3, 2013
I have a list of about 250-500 email addresses, in which there are a few duplicate email addresses as well. How do I find the Duplicate email addresses and get a consolidated list without any duplicate entries in it ?
View 4 Replies
View Related
Jun 26, 2008
below is a VB code to email separate sheets based on sheet anme and email address on a sheet called " mail".
Code seems to fail at the last line " Next a" any ideas why this is not working
Sub Mail_sheets()
Dim MyArr As Variant
Dim last As Long
Dim shname As Long
Dim a As Integer
Dim Arr() As String
Dim N As Integer
Dim strdate As String
For a = 1 To 253 Step 3
If ThisWorkbook.Sheets("mail").Cells(1, a).Value = "" Then
Exit Sub
View 9 Replies
View Related
Jan 21, 2014
Need a graph to illustrate the desired effect of the marketing campaign as a shift in market equilibrium with reference to price and quantity adjustments.
View 1 Replies
View Related
Jul 2, 2014
I have several Campaign Names (about a thousand) and about 25000 categories (with ID's) to choose from and would like to assign the Category ID's to the Campaign Names without doing manual searches. My problem is that the names are not similar enough for vlookup and I didn't get any usable results with the fuzzy lookup add in either.
I will attach an example of both my Campaign and my Category file for reference. Example Complicated Vlookup.xlsx
View 3 Replies
View Related
Jan 10, 2014
I need to write a macro to split an excel file into separate workbooks and automatically email our project managers.
View 1 Replies
View Related
Oct 13, 2008
I'm trying to compare values in 2 separate columns to see how many times the same value appears in both columns. Ideally I would be able to insert a range function to compare the values in the column "ID 1" against the values in column "ID 2" and return the count of times that a value appears in both columns. For example 2122, 1112 and 1718 appear in both columns and I would like the formula to return a count of 3.
ID 1ID 2
12342122
45671112
89101718
11122678
13144544
15162324
17189987
19201215
21221928
1976
2576
2345
4678
In my actual project I'm comparing 2 columns in the same worksheet. The column are column B with data in cells B2:B10266 against column C with data in cells C2:C18560.
View 4 Replies
View Related
Sep 18, 2009
Here is a simple exercise that is necessary only because of the large amounts of data involved.
I have a spreadsheet of columns with budget and actual data. I need to strip out the budget columns (marked as budget) and total column. then add back in at a later date.
It all has to stay in the same spreadsheet.
I know it sounds strange but believe me its necessary.
I was thinking of moving them to the right side of the spreadsheet. Then back at the later step.
I have attached a simple spreadsheet showing the data on sheet1 and how it should look when stripped on sheet 2. and the later step would move them back to sheet3(which is the same as sheet 1).
View 14 Replies
View Related
Jan 13, 2009
I have a csv file which I opened in excel file then i converted the csv to excel columns format using the text to columns delimited.
Now I need to change it back to its original form which is the csv.
View 9 Replies
View Related
Feb 20, 2009
I have four columns of data, as follows:
label 1, value 1, label 2, value 2
I need to create a formula in the fith column that for each line will tell excel to:
look for entry in 'label 1' in 'label 2' if there is a match, then subtract value 1 from value 2, display result.
I have tried doing this with SUMIF but am getting nowhere fast....
View 7 Replies
View Related
Oct 30, 2009
I have a "form" type spread sheet that I have created where the user can enter different information (like name, company, addresses etc.). I have figured out how to create a drop down list. But what I would like to do is create on a seperate sheet a "data base" of information which will be "copied" into the appropriate cells on the first sheet depending on what the user selects from the drop down list.
The drop down list will list company names, which are stored on the second sheet. However, each company will have other data such as the company address (which will be entered in seperate cells with information like, box, street, town, province, country, code).
Now this is the clincher... The user must be able to add to the data list on sheet two and any new entry must automatically appear on the drop down list on sheet 1, and when selected it's "data" must be transferred to the appropriate cells on sheet one from sheet 2.
View 14 Replies
View Related
Oct 12, 2011
I have 3 Databases for three different departments, namely Finance, Services, IT. These 3 databases are housed in the same workbook - Sheet 1(named Finance); Sheet2 (named Services) and Sheet3(named IT).
They each have the identical columns and column headings, but I have to maintain them for each of the departments.
I created an Excel UserForm to enable me to input data onto the first database (i.e. Finance). In the VBA editor, lefthand side, it has the name 'frmFinance', and all the codes are pasted on the righthand window of the 'frmFinance' sheet.
Is there anything I can do to be able to use the same UserForm to enter data onto the other two databases without having to create a new UserForm for each one of them. As indicated above, the three databases have identical columns and headings, and the data entered onto each of them are identical. The only difference is that they are for three different departments and I have to maintain each one of them - albeit in one Workbook.
View 9 Replies
View Related
Nov 14, 2012
I have a connection to an SQL database using microsoft query.
The query definition includes: ORDER BY AAStocktrans.Code But I need a two level sort along the lines of:
ORDER BY AAStocktrans.Code THEN ORDER BY AAStocktrans.Date but obviously that is not correct - cannot use THEN. what I do use to make this work?
View 2 Replies
View Related
Jul 18, 2014
I have two huge database and need to test if Employee name and ID in database A matches to name and IDin databse B. What formula could I use here?
Employee ID Database A
Employee Name Database A
Employee ID Database B
Employee Name Database B
1
JONES JR,STEPHEN W
1
NULL
[Code] ...........
View 2 Replies
View Related
Jan 17, 2014
I've created several access databases to which I've connected my excel files. However I've either deleted/moved these databases but my connections are still showing in Data -> Existing Connections tabs.
I've tried going to C:Program FilesMicrosoft OfficeOffice14QUERIES but no such queries exist.
Is there any way to clear my list ?
View 2 Replies
View Related
Mar 13, 2013
I have a dataset from Oracle that includes a study patient ID, study visit that a UC sample was collected at, date the sample was collected, and sample type. I also have a dataset from Quest, where the UC samples are sent to for testing, that contains similar information.
I need to reconcile this data, making sure that patient IDs, study visits and collection dates all match up with out using just vlookups and having to check the reverse of each (vlookup Quest into RDC, then vlookup RDC into Quest) and I've been wracking my brain trying to figure out VBA code to get my data from Oracle (orange header) to merge with Quest (blue header) and merge on Subject ID and Visit Name only.
In exhibit C, this is what ideally I would like to see as a result, data points from both are reported, but if Oracle subject id = Quest subject ID and Oracle Visit Name = Quest Visit Name, they are reported in the same row. I can then just run a simple formula to compare the collection dates and also identify discrepancies between visits (example: exhibit C, rows 10 and 11, these two UC samples look like they should reconcile because the collection date is actually the same for both, however either the study site or Quest is reporting the wrong study visit name).
View 9 Replies
View Related
Jun 24, 2013
I need a formula that compares 2 databases and returns a count if both values or within the specific range.
Column A is titles Column B is values The first database is simple the range is
View 2 Replies
View Related
Jul 2, 2008
I am getting a DUMP on the "ActiveWorkbook.SaveAs Filename:=ThisFile" which is a valid PATH. Is there a Charachter max length required in A1?
ThisFile = "S:AccountingSales" & Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
View 9 Replies
View Related
Aug 11, 2012
I have a layout something like the following:
A1
A2
A3
[Code]....
Where each (i.e., A1) represents a location. I have tried to use a coordinate system but this will not work for the back-to-back locations. (Assuming each location is 2 feet wide, For example A1 to C1 is 4 feet apart, not 2 feet (as Euclidean or rectilinear would calculate it as).
Would there be a way to incorporate an if statement for those locations that are back-to-back? As a rectilinear distance calculation would work as long as the locations are not part of the same "block".
Ultimately I am looking to have a matrix which contains all the distances between each location:
A1
A2
A3
B1
[Code].....
View 4 Replies
View Related
Mar 12, 2009
I'd like to "dump" an array onto a worksheet. It's called MyArray, it's varying in length, 7 "columns" wide, and I know the uppermost left cell I'd like to dump to.
View 9 Replies
View Related
May 7, 2014
Any way to look up any cells with in a data dump (example: PR1420829-V2) but not having to include the 'V2' but still picking up the cell.
Im currently using the fomula;
=IF(ISNA(LOOKUP($D$5:$D$1000,Test!$C:$C,Test!$L$1:$L$381)),"",LOOKUP($D$5:$D$1000,Test!$C:$C,Test!$L$1:$L$381))
View 2 Replies
View Related
Jan 23, 2009
Rather than looping through a multidimensional array to populate a worksheet, is there a quick function which can export the entire array to a worksheet?
View 2 Replies
View Related
Jul 14, 2009
I have a model which I have created a macro for that will do a data dump of the date when I hit 'update' (on BBG Raw Data Tab) to Column A in the 'Data for Pivot' Tab.
This works fine and all of the data comes over, except the last two data points in BBG Raw data (Cell A5055 and A5056) do not come across into the 'Data for Pivot' Tab (these should be going into Cell A5054 and A5055 of the 'Data for Pivot' tab).
View 3 Replies
View Related
Dec 21, 2013
I have a daily data dump that starts at the beginning of 2012 up to the current date. I have an executive view that allows the user to see metrics(in a data graph) from the current date back to a date selected from a drop down menu. I would like to have it so they can choose what the end date will be as well as the start date. I have tired using offset with very little luck. Is there a way I can accomplish this task with VBA? Everyday a new row of data (for the previous date) is added to the front sheet. So row 1 is a header row and then row 2 is 01/01/2012, row three 01/02/2013, etc.
View 7 Replies
View Related
Aug 26, 2006
I am trying to find a way to automatically do a query and dump the data into a sheet when a previously created workbook is open. I know how to get the data (use the Tools, Import External Data option to retrieve data from Access) but what I don't know is how to make it do it automatically when the workbook is open.
View 2 Replies
View Related
