I currently have two tabs. Tab A (Error Report) spit out a bunch of records that I need to find in the raw data/remove them. The value in column C in Tab A refers to Column A in Tab B (Data), and Column D in Tab A matches with Column N in Tab B, and Column E in tab A refers to Column C in tab B.
I want to know how I can find the records that match those 3 columns in the First Error Report Tab as I need to find those records and delete them as they are, as you can see, errors!
I have 2 pretty large zip code lists, we will call them columns A and B. I know that I have some from A that match to zips in B, but I have alot more zips in B that don't match to column A. I need to identify all of the zips in B that do not match a zip in column A.
I need to find if there are matching addresses in 2 different excel files. If the same address appears in both files, I would like the new worksheet to return the address along with the sale price from the 1 file and the rental amount from the other file.
I have tried using vlookup but the problem is the exported data file contains the street number in one column and the street name on another column. I have attached a truncated example of both the rental data and the residential sales data.
My spreadsheet consists of two columns, column A holds a series of numbers whilst column B, again holds a series of numbers but with an added single letter on the end.
What I would like to do is find a function which will match the numbers and letter in column B with the corresponding numbers in column A and then place the result in column C ....
I have two spreadsheets, spreadsheet A and B. In each spreadsheet there is a column labeled 'event' and a number in that column. I need to match the event number in spreadsheet A with the same number in spreadsheet B. In spreadsheet B in the same row as the event number is another value that I need copied back to spreadsheet A.
Manually I would have to copy the event number from spreadsheet A and use 'find' in spreadsheet B. Then check in the same row as the event number in spreadsheet B for a specific number, copy that, head back to spreadsheet A and paste it next to the event number.
I've tried to create a macro to do this but when using 'find' to match the event number in spreadsheet B it keeps on using the first event number I used instead of moving down a row onto the next number. I can upload the spreadsheet if needed.
I have in Sheet 1 a list of product codes (that should be only numbers, i.e: 1010) on column A, product description on B and a sales column on C.
On Sheet 2 I have on column A I have in the same cell a letter "C" the product code and the product description(i.e.: C1010 Onions). On column B I got the sales total. ( I dont care about the letter "C" it can be deleted)
I would like to use a VBA code to find the same product codes between sheet 1 & 2 and copy the sales total from sheet 2 to sheet 1 when the product code is the same.
I have two tables, both contain a column of ID numbers and a column of addresses.
I would like a method to match the IDs from table1 to those of table2 - if no matches are found, search for matching addresses, if a match is found then output the ID in table1, the address, and the corresponding ID in table2.
If still no matches are found, output the ID and address from table1 and indicate that it didn't match.
Then I want to check table2 records - i.e. search for matching address between the records and output the table 1 ID, address and table2 ID were partial or no matches are found, as above.
i need to match 2 columns on one worksheet with 2 columns on another.
One column is alphanumerical (Reference Numbers), the other is company names.
I need to ensure that both the Reference and Company name match from one sheet, with the company and reference from another.
e.g if A1 and B1 on Wks 1 = A1 and B1 on Wks 2 = TRUE, anything else is FALSE.
There is likely to be Reference number and Comapny name duplicates, therefore the trick is to ensure that the number of duplicates match?(I.E ABC Company, Reference number 1234 may appear 5 times on worksheet 1, however if it is only on Worksheet 2 4 times, then this must be flagged).
What I need to do is work out the cost of call 1, to work out the call cost you will times the duration by the cost of the call on the charging codes tab. So if E2 = uk Mobile 02 (fm1) then search for a match in charging codes tab column B then get the cost from column C and times that by the duration on CDRS test tab column D
the cost amount needs to be in column I
a different explanation below..
if CELL e2 matches a column in charging codes tab column B then get the amount of cost from charging codes tab column C and times it by cdrs tab CELL d2 and return the result in CELL I2
i have data that has several bits of information for each different account number. is there a way of writing a macro to transfer the information from the main sheet onto different sheets automatically titled for each of the different account numbers?
ie. Account Cost E1 £100 E1 £200 E2 E2 etc
i want different sheets for the info next to each of the account numbers
I want to add these numbered steps onto the macro I already have, which I pasted below.
1. Starting in Row 2 in the worksheet named Report 1 look at contents in Column A then look at the contents in Column C, if the contents in Column C do not match exactly the contents in Column A then copy the contents in the range column C:E from that row till the last row in Column C:E.
2. Now we will have a range that is made up of cells from C:E. I would like to move that range down a row at a time, until the first cell in Column C from the range Column C:E matches exactly the contents in Column A. Then I would like to continue this pattern for every row in the worksheet.
I get large data sets that are organized in columns and each has a title at the top of it. I will get several sets of this data in order to compare them all on graphs.
Now here is the kicker, the columns are not always in the same order. Not always named the same. And not always the same number of columns.
I want to make a tool to handle this to a point where I just import the data and everything is taken care of. I also want a printable report for each data set to which I can select from a drop down menu. Populate cells on a tab, and then can be printed.
How would I reorder columns & tabs based on a form where the user can put them into order that they would like the columns? I forsee some type of form where the user can dsignate the order and then start a macro that will sort both the columns and tabs.
I have two worksheets, sheet 1 and sheet 2. On sheet 1, I have a information on two columns (Column A and B) Column a has information up to row 10 (aaa, bbb, ccc, ddd, ...). On column B, I have 111, 222, 333 . I have same information on Sheet 2. However, sheet two has an additional column (Column C) with 10 rows on information z, y, x, w, v ...
What I need to do is to match column A and B in sheet 1 to column A and B in sheet 2 and if both columns matches on the same row, copy the value in sheet 2, column C and paste it on sheet 1 column C.
Important: Information on sheet 2, column B may be twisted (As they may not appear exactly the same as in sheet 1. Which means 111,222,333 can be 222,333,111 along the column). Therefore, need to match the entire range.
I need creating a formula that matches the values between two separate columns with results from that matching in the third and fourth columns.
Example: Column A contains the first set of values and column B contains the second set of values. The result in column C would be all the values that are in both columns A and B and the result in column D are all the values that are not found in both columns A and B.
Alright, so I need data in column A(Last names) and data in column B(First name) to match their respective names on another sheet. When a match is made, it will return column C(Hours worked).
I originally used Vlookup to match last names, something akin to =VLOOKUP(A:A,Week1!A:P,4,FALSE)
But this does not account for employees that may have the same last names. Is there a way to combine two vlookup's? Or is Index a possible solution?
I have 2 columns of data. Both should ultimately have identical data, but both have extranious data I need to separate. These lists will be 300+ long, so by hand is taking forever. Example: Column A Column B 12345 12344 12346 12345 12347 12346 12348 12347 12349 12349
I need a way to extract the 12344 from column B since it is not in A, and 12348 from A since it is not in B. They do not have the same number of entries.
I have a problem in my list cheking. I have two sheets in my attached excel file. I have mordified for my own job security purpose. I need to check the individual cells of "parent" column in "Missing Asset" with "parent" column of "Asset" worksheet. It means, presence of cell text of A2 of "Missing Asst" sheet has to be checked with "A" Column of "Asset" sheet. If A2 text is present in "A" Column of "asset" sheet then "Y" should appear in B2 cell of "Missing Asset" sheet. Else "N". Its just Column text checking wothin two work sheet & then identify the cell which is not match. I guess "VLOOK" can work. Is it not?
i am using this spreadsheet to monitor when equipment is being borrowed in the office and want a quick view reference (columns A-C) based on the data entry in columns &G. Please note that htis is an example as the original file is confidential, if someone can answer my query here i will transfer the formula to my actual workbook. In the actual workbook the data entry and quick view will be on different sheets if this makes a difference.
How could I return an 'x' in column C against the A values corresponding with the G values, for example an 'x' in C6, an 'x' in C9, an 'x' in c15' etc? And a blank for example at C8 and C14.
I want a code (Formula) do the follwoing: Matching number 1 in column S with number 3 in Column O and count how many matches found in the two columns, Which in this case only two.
I have a document where there are hundreds of rows and columns. The rows contain lines of data, while the columns are topics. Each row needs to be traced to an appropriate column. Once traced, I simply check off the appropriate cell with an X. I have to make sure that each row has at least one "X".
I have attached a sample file. look at cell B8. The statement in this row reads "Issue Placard information and registration". Now, I already know what column this statement belongs to (column CT).... but I don't want to scroll over hundreds of columns to that particular column, or have to freeze any panes, to locate that cell and mark it off. I have been doing this manually and it is incredibly tedious and time-consuming. Is there a way where I can locate the appropriate cell and go to it without having to scroll? When I'm scrolling I have to not only scroll, but I have to read the rows and columns again to make sure they indeed match. I want to be able to locate the right cell instantaneously and just enter an X value.
