compare data

  1. N

    VBA data compare

    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...
  2. M

    Comparing one column of data and merging rows based on contents

    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...
  3. J

    Data Comparison Tool

    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...
  4. A

    find values under 20% across worksheets and list said worksheets

    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...
  5. M

    Compare range data to another column data

    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...
  6. P

    How to compare compare common data in 2 seperate xl files

    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...
  7. A

    Compare Workbooks

    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...
  8. A

    Compare two excel spreadsheet

    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...
  9. M

    Need help with a complicated excel formula!!

    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...
  10. J

    Compare Copy Paste

    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...
  11. K

    Compare Data two Columns

    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...
  12. R

    Comparing similar values in Excel

    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...
  13. J

    Compare two Workbooks to update a price List

    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...
  14. L

    Date comparison

    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...
  15. G

    Need help in comparing data in 2 sheets

    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...

Some videos you may like

This Week's Hot Topics

Top