compare data

I have a file with three worksheets. Sheet1 is a summary of all clients. Sheet2 has a table that copies only clients with "active" status from Sheet1, Sheet3 has a table that copies only clients with "buyer" status from Sheet1. Is it possible to write a vba code that will delete rows from...

Hi all, this is my first post so pardon me if it is not complete. You can ask me for more info if needed. So i have basically data in consecutive rows that i need to compare with data in a column If the data of each cell in each row exists in the column, then i need the row to be red...

Hi, I'm trying to have my sheet look at data in column A, find duplicates, and merge cells in column U,V, and W based on the number of rows with matching data. So if A5:A9 match, then U5:U9 merge, V5:V9 merge, and W5:W9 merge. I can get it to work for one row but I'm missing a step somewhere...

Hello, I conduct a weekly audit report for 5000 employees. The report is always in the same format such as employee number, department, status, location etc (~10 fields). I have an excel spreadsheet that I currently use with multiple index, nested IF and And Statements and vlookup formulas...

I would like my Macro to go into all works sheets and look at the last row of I matching todays date and if this value is under 20% then to paste the name of that worksheet back into the master worksheet allowing a quick overview of under performing data. I think I have got the selection...

I have 121 values in C column which i need to compare A column 5k values. I made simple IF formula where "Pizza" with wild card represent C column data. =IF(A1="","",IF(ISNUMBER(SEARCH("*Pizza*",A1)),"True","False")) I tried to put range width wildcard but its not giving me correct...

Hi, I have 2 xl file as under: File master.xls: This is master price list file listing available spares with company File inquiry.xls: This is a new inquiry from a customer who requires limited spares We would like to do the following: 1. Check for part no. (column B) from file inquiry.xls...

Hi all, I need a macro to compare two workbooks and return the difference values in new workbook. Workbook1: Column1 Column2 DM 1234 DM 4454 DM 5666 DM 7777 DM 5676 DM 5656 workbook2: Column1 Column2 DM 1234 DM 4454 DM 5666 DM 7777 DM 5676 DM 5656 DM 6757 I need a macro which will...

Hi all, I have to compare two spreadsheets, with same header rows and same number of column. Total number of row are different. Please advice on the process to compare this two spreadsheet and get the difference on the third one. Can we create a macro to solve this?? Please suggest...

I am completely stumped! I work for a tutoring center and I have a form that I am trying to make user friendly for ALL of our employees. I'd like to be able to use it as a time sheet however, I can't seem to get the calculations right. I was able to do the time in, time out, and total hours...

I am trying create and Excel Formula. To compare columns of names and then copy a number in a column next to the correct name. More info Column A = Actor ID Column B = Actor Column H, K, N, Q, T, W, Z = Actor Column G, J, M, P, S, V, Y = Actor ID (This is the column that I want a copy of the...

I need to compare the data in Column A with the Data in Column D. Column A has approx lines 1100 rowes with some duplicates. Column D contains 346 rows and no duplicates. I need to know which itmes in Column D are duplicated in Column A. When I do a duplicate search it also picks up the...

Hi, I'm a fairly average Excel user but I'm trying to find out how to compare same and similar data in a worksheet to calculate their similarity as a fixed percentage. For Example..... HROR11 and HROX11 are codes that represent a 75% similarity in terms of what they represent but does...

I have two workbooks, both contain a price list of parts. One is a master list that I will call workbook "A" which contains every single part we sell. The other is a smaller list that I will call workbook "B" which contains frequently bought parts. What I want to do is compare column B in...

Hello all, I have many entries on an excel sheet (each entry going horizontally A-H) and I would like excel to check if the current date is later than the goal date (column E), so to check if it is overdue. For overdue events, I then want that entire entry to be placed in another sheet in the...

Hi, I've got two excel sheets with each sheet having a single column of records. There are 15,000 records in the first sheet and nearly 13,000 records in the second sheet. The data is basically account numbers. I want to find out three things. First one is the account numbers which are common...