I need to take the data out of one column from sheet A and compare it to the data on another column sheet B.
Real life example:
I have a very large list of contacts with multiple columns of data. On a separate spreadsheet, I have a list email addresses that I need to remove from the larger list of contacts. How can I compare them against one another to detect any matched email addresses for deletion?
List of contacts is appx 130mb
List of email addresses is appx 4mb
Is there a way to compare specific data from three separate worksheets to see if they are equal?
I receive three daily reports that contain some of the same information that must match in order to correctly compile an Executive Report. Currently, I am doing this manually. Is there any way to automate the process to have a warning or something similar pop up if the numbers do not match?
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.
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.
I am trying to use a macro to compare data from 2 sheets and spit out matching data in a third sheet. The first sheet has two columns of data. the second sheet has 4 columns of data. Only one column from sheet 1 and 1 column from sheet 2 will actually have matching data.
All other columns in sheet 1 and 2 are associated to the matching columns and must "tag along" into the 3rd sheet. I would love the third sheet to have a button that I just click and it populates the data.
The macro will be comparing between 50,000 and 500,000 items. Possibly a good book to use or even a referral for a proffesioanl or even some good heartedness,
I have a spreadsheet of products that are listed in column A and another list of products in column B. I need to find the difference in price in a percentage for each product. My problem is the lists differ a little bit in that there are more products in column A so they are not lined up correctly. Is there a way to have excel look in column A and find the match in column B and then line them up so the matching products are in the same row? This will cut out a lot of time having to do the formula in each cell rather than autofilling the formula.
I have repetitive task of copying and pasting. Macro to sort some data.
I have time values (sorted in order) in Column A and a value in Column B.
Sheet1 Â AB1TimeValue 200:00:002300:00:002400:00:001500:00:002601:00:004701:00:002802:00:001902:00:0021002:00:0031102:00:0041202:00:0011302:00:002
I need separate the time each hour of data into columns. So the above would become
Sheet1 Â ABCDEF1TimeValueTimeValueTimeValue 200:00:00201:00:00402:00:001300:00:00201:00:00202:00:002400:00:001Â Â 02:00:003500:00:002Â Â 02:00:0046Â Â Â Â 02:00:0017Â Â Â Â 02:00:002
There are a different number of rows of data for each hour and sometimes there might not be any data for a specific hour.
I have a column on sheet 1 which contains 200 lines with a unique number in each row (account codes). I have another sheet (sheet 2) which contains the same column. sometimes an extra row for an extra account code is added to the col in sheet 1. I need to make sure that the col I have in sheet 2 always has exactly the same as the col in sheet one, where the same account code should never be repeated. I am currently trying to setup a sheet where I keep all the checks and controls.
The code below compares values on sheet 4 column A to sheet 3 column A and then colors a cell "Green" (Temporary), later I will place data from sheet 4 into sheet 3.
I dont know why but when it finds data on sheet 4 that is not 100% numeric it errors out.
Run-time error '91' Object variable or With block variable not set.
The data in sheet 4 column A is primarily numeric, there are and always will be some numeric/alpha strings. I can change the value of sheet 4 A2 to "123x" from "123" and the code stops as described. Leaving sheet 4 A1 as 100% numeric, which works fine.
I'm trying to cmpare two excel spreadsheets, each one of then have 3 columns with column A being the KEY to lookup and compare records into another spreadsheet. So in my example spreadsheet If u take cell ZVNA!A1 and lookup for values in ZSKU!A* and find a match then comapre the B1 and C1 in respective ZSKU! Column B and C. If there is a record for A1 in ZVNA then comapre it's column B value with column B value of ZSKU, and column C value with column C value of ZSKU. I have not used macro/vba before so if you could tell me formula based solution that will be good or point me how to use macro. I did Vlookup but it did not return me 100% accurate result may be bec my format of column is not accurate.
I have a list of names on 2 separate sheets that I need to modify. If I have a name on sheet1 matches a name on sheet2 I would Like to add a "space" then "(SV1) at the end of the text string on sheet2. I have a list of 1500 and will only have to modify 75-100. Example shows on sheet2 how I would like the desired outcome to be.
I have two sheets with pretty much the same content but not exactely. I need to compare the data from the first sheet to the data in the second sheet in this way: data from column b (numbers) in the first sheet needs to be compared to data in column b in the second sheet. if this dosen't match it needs to go to the next line. if the match is positive it needs to compare the data from column d on the first sheet to the data on the second sheet same column and copy the data from the first sheet's column d to the second sheet's column d. But only if the data in column d on the first sheet isn't blank. If it is it should leave the data on column d second sheet intact.
I've got two worksheets ("June" & "July"). On both worksheets, column A is comprised of ID numbers and column B contains dollar amounts. I need to compare the ID numbers in Column A on each worksheet, and if they match I want to copy the ID number and the amount to a third worksheet ("Results").
I have 29 excel files with some number of worksheets from 1 to 4. The name of the worksheets are the same in all the spreadsheets. Then I've a got a pivot table. I have to compare some data (3 columns) from the pivot table to the numbers from all these sheets from 29 excel files.
I'm trying to compile a VBA that would allow me to compare 2 columns "A" in different worksheets (same Workbook) and output any unique values to 3rd worksheet together with the rest of the values in the corresponding row.
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
Im working with a huge amount of data in BOOK1.xls and once or twice a week I received an update of the list.
1. I need to compare and find out from the new updated worksheet if there is a new revision, and if there are new documents added to the list. I have tried Vlookup..but it didnt work for me. Ex. Doc1 has revision 1, 2 in my BOOK1 that I am working on. Note that there is a repetition of the DocName, Doc Number except for the revision.
I have a workbook with the following sheets i do not want to hide called "Detailed Template", "INTERFACES", "STATUS".
I then have a number of worksheets which have their names as cell addresses i.e. "E4", "E5", "D4", "F4", "G7" and so on.
I would like to hide all worksheets (except the 3 mentioned at the top [which are sheets 1-3]) and any which contain say the value of '4'. This value is defined by a cell in the "INTERFACES" worksheet say 'A1' for example.
I want the macro to be able to automatically do this for which ever value is in 'A1'. So if it were to change to '7' it would hide every sheet that doesn't contain '7' in the name.
I have on inventory sheet that has all the data in each cell 2612 to be exact! That changes month to month with deletions.
The format is: Sheet 2 A/B/ 334702/UEMR88QX 334703/UEMR85QX 334704/UEMR81QX 334707/UEMR8JQX
The master worksheet has about 5000 items and the (A and B) data are both on it with other data ranging from (A-Y). My question is how do I have a cell look up data and return that it exists or doesn’t exist on the inventory sheet?
My other problem I need to take that months inventory list and have it look at the master list and return the system number from the master list (B) next to the matching inventory number (C). Allowing me to cross match inventory to master each month and save inventory worksheet each month.
I know I can copy the column and past is as a value so I won’t lose the numbers as the master changes but getting the data onto that months inventory has been a pain.
I have thousands of data entries (each in their own row, all in one column) and need to separate the basic info. In the example below, say you want to isolate the Town names by entering a formula that can produce a TRUE or FALSE result. Is there a way to use the FIND function and a pool of terms to isolate cells that contain excess data (i.e.- produce a FALSE result for cells containing any words from a term pool like : "Police, Park, Power, Water, Community, Bakery, Grocery, Field, Garden, Post Office, School" etc... ) ?
Pic of sample spreadsheet with desired result:
Screen Shot 2014-03-18 at 3.14.09 AM.png
example as text:
A2 = Springfield A3 = Springfield Police Department A4 = Springfield Community College A5 = Springfield Park Of Recreation A6 = Des Moines A7 = Des Moines Power & Water Company A8 = Des Moines Sunrise Bakery A9 = Des Moines Post Office A10 = Des Moines Grocery Store A11 = Lancaster A12 = Lancaster Baseball Field A13 = Lancaster Botanical Gardens
I have a huge list of survey responses which asks people to identify their location and then rate how important 6 facilities in their area is (rating 1 - 4, 4 being most important). So the table has cells are similar to this, except that there are about 5000 responses with about 2500 different locations identified
Location Location Location
[Code].....
I have been able to analyse the average results for the whole dataset by using the following formulas:
=COUNTIF(A2:C4,"camden") Count number of occurrences a location is listed =ROUND(AVERAGE(D2:D4),2) Average response for medical centres =COUNTIF(D2:D4,1) Counts number of times '1' comes up, would repeat '2', '3', and '4' to create a pie graph
But what I would really like to do it be able to count each response for each question by location (for example "Camden"). I've tried both of these but they don't seem to be working.
I am in the process of creating a Phone Roster for my unit. On Sheet1 is their administrative data (Name, Position, Phone Number, etc.). What I am attempting to do is use a formula to find the persons name for that position and place it in the appropriate position and then their phone number below.
Admin!H:H contains the positions Admin!B:B contains their name Admin!N:N contains their phone number
I believe the following is what I need =LOOKUP("Operations NCO",Admin!$H:$H,Admin!$B:$B) and it works, but only for the first person on Sheet 2. After that it is random. If there a different formula I need to use to make this work?
When I get the phone number I used =LOOKUP("Operations CO",Admin!$H:$H,Admin!$N:$N) and the same thing happens. It works for the first person and everything else is incorrect.
A problem is the Admin sheet is listed alphabetically, not by position, so I cant use a specific cell to copy the data. I need the formula to find the position, then find the name and phone number of the person in said position.
I created 14 spreadsheets for each of my call center agents to monitor their metrics. I password protected all then placed the originals on the network. The 14 sheets have 1 cell within them that are linked up to their relevant agent cell in a separate spreadsheet. This spreadsheet is located on the network and automatically updates every hour.
I have monitored the the spreadsheets and updates etc for a while now and everything seemed to be working perfect. So I decided to slowly roll it out by placing a shortcut on 3 agents desktops. I quickly discovered that they were not seeing any updates as I had seen prior to the roll out. I go to the folder within the network and check all spreadsheets and I see all spreadsheets working and updating successfully.
So I thought maybe it was because they were password protected. I removed the protection and the 3 agents saw their spreadsheets update successfully on their computers, the next hour as I had hoped BUT the hour following however they did not see a further update again.
I have a raw data worksheet with 54000 lines, in the format of six columns
In Column A is the USER Name
What I would like with if possible is code that will move the six columns of data from each individual USER into separate sheets, using Column A as the basis of the new sheets, ie the last row for each user is when the user name changes to the next one.
I'm currently using the following code (that I found online) to take a list of data and copy it to specific sheets based on the values in Column C (there are only 4 columns in my data set). The issue I have with it is that it's meant to create the sheets from scratch every time. What I could like, however, is for it to copy the data to preexisting tabs that are already named with the sames values that are found in Column C. This macro will actually perform that but the down side is it wipes out everything that's on those sheets but I cant have it do that. Is there a way to either modify this sheet so it only copies the four columns and only pastes the four columns onto the sheets?
Sub SplitData() Const NameCol = "C" Const HeaderRow = 2
