comparison

  1. D

    Comparing two sheets and their values using Vba

    Hi All, I'm pretty new to mrexcel and vba and wondered if you could help me... I have two sheets - sheet1 (last week's report) and sheet2 (this week's report). Each sheet is the same format:column A is the unique identifier, column B text and C to F are numbers. Each sheet has over 1000 rows...
  2. C

    How to compare two lists of text and provide a matching level in percentage

    Hello all, I wish to compare a list of text (Name to Match) to a static list of text (Standard Name) and pull the best match from the static list along with a matching value in percentage. The values under the Standard Name column are static values. The values under Name to Match are string...
  3. KamiAlabama

    plugging data from one workbook into another

    :confused:I am working with 2workbooks and need to enter values from one into the other's corresponding data. I am rusty on creating formulas; it has been a decade since I worked with them regularly. The sheet on one workbook is over 600 lines so it is a lot of data in text form (names of...
  4. S

    Counting Number of cells that have been highlighted following conditional formatting

    Hi, I am at my wits end with this. i have searched everywhere but nothing seems to be working for me. I have a spreadsheet of products that i am looking to purchase for my company. I have a column for each of the companies that are quoting for these products. I have put in conditional...
  5. N

    Compare each row in sheet1 to each row in sheet2 -no pair write in sheet3 - HARD

    Hello guys! I have an very big Excel file that has exactly same columns but dirosa. ent many rows. I need help with an VBA-script to compare each entire Eos in sheet1 with sheet2 If it dont finds an pair I want it to write the row in sheet3. Its very important that the script starts in row 1...
  6. C

    compare data between seperate data ranges

    Hello - I am relatively new to analyzing data in Excel - using Windows 7 and Excel 2010. I have two sets of data and am trying to validate data between them. Data sets have columns titled FirstName, LastName, Ethnicity, Gender. I am trying to compare the Ethnicity and Gender to determine...
  7. B

    Formula for Price Comparison

    <tbody> Company 1 Company 2 Company 3 Company 4 Destination Origin 0 (Min $) 100 lbs. 1000 lbs. 0 (Min $) 100 lbs. 500 lbs. 0 (Min $) 100 lbs. 500 lbs. 0 (Min $) 100 lbs. 500 lbs. DFW ATL $25.95 $7.76 $7.12 $39.82 $13.36 $13.09 $40.00 $11.13 $10.89...
  8. N

    VBA - Comparison two sheets and entire row - HARD ONE

    Hi I have a problem that is hard to solve. Im looking for an VBA script (not funcion) that: 1. Compare entire rows (Column A-K) in Sheet1 with Sheet2 (Columna A-K). NOTE! Important that its entire row. 2. If it finds an dublicate somewhere show it in Sheet3 3. The big problem is that the rows...
  9. M

    Comparing Alphanumeric Strings

    Hello Everybody, I got a simple sheet in which I got some columns of data representing certain grid-line i.e. A-25, B-35, C-41 etc and I got another column in which the data is like B-25.5, C-26.5 etc. I want to compare the both columns and know for each item that which item is bigger or...
  10. J

    Macro String Compare is incorrect (40G_EL_TEST_01 is greater than 40GC-TX-ASSY---)

    I manually sort a column of data and the results appear as follows: 3GPHONER710OLD</SPAN> 40G_EL_TEST_01</SPAN> 40GC-TX-ASSY---</SPAN> 4593FCT-03</SPAN> 45GS05</SPAN> I then run a macro with variables defined as STRING. When I compare "40G_EL_TEST_01" against "40GC-TX-ASSY---", it tells me...
  11. N

    Simple lookup is not so simple

    I have two columns of data. Column A has 7,000 names and Column B has 1,500. I need to compare the two and delete all the names in Column A that don't have a match in Column B. How do I do this? Thank you in advance!
  12. N

    Excel VBA - Comparison two sheets

    Hi, I have this script to compare: 'Option Explicit 'Sub FindDuplicate() 'Dim LastRow As Long 'Dim MyRg1 As Range, MyRg2 As Range 'Dim A As Range 'Dim F ' Application.ScreenUpdating = False 'LastRow = Range("a" & Rows.Count).End(xlUp).Row 'Range("B1:B" &...
  13. N

    VBA script - Compare - Loops

    Hi, Can someone help me to write a script that compares the value in columns A with columns B. If the value match in both columns then write the new data in new worksheet. I also winder where I can find an VBA Index there all functions are included like If, Else, For, Len etc. Where it is...
  14. C

    How to compare and highlight a column based other columns matching without replacement?

    So I have a table... <tbody> A B C D E F G 54 8:45 Jane Paul 8:45 37 37 1:12 Dave Chris 5:35 78 78 5:35 Chris Jane 6:40 90 90 6:40 Jane Liz 2:05 14 37 8:45 Paul Sarah 7:30 54 82 3:14 Matt Jane 8:45 54 14 2:05 Liz Dave 1:12 37...
  15. T

    Excel 2003 - Skipping Blank Cell Comparisons

    I have a master table of values that I am using to compare experimental data against. The experimental data has some blank values which must stay in the data set but must not be compared against the master table. There are 286 rows of 13 cells (which only contain 10 cells and 3 blank cells as...
  16. M

    Return index out of two values

    Hi guys, I need to return the index based on values from 2 columns with largest amounts, below the example: From the below table, the index I need returned will be "Purchasing Data Inquiry" because even though this one does not have the biggest % has more number of hits (51) based in column...
  17. B

    VBA String Comparison Issues

    I have a seemingly simple comparison that will only work part of the time. I have searched this and other forums and I just cant seem to find the issue. I'm using the following VBA code to compare and copy the value of the cell into the cell next to it if it matches. It is in a loop but the code...
  18. K

    IF formula question I think.

    Right firstly, apologies if this has been asked before but I have no idea how to shape the search to see if it has or hasn't been posted on before. I have a spreadsheet with quarter on quarter results for a set of penetration tests. I am trying to create a formula which will compare the...
  19. F

    XL07 Comparison Spreadsheet Help

    Hi all, I was hoping you could help me with a problem. I have a spreadsheet that is made up of 3 tabs, Original, Match and Difference. It's purpose is to return the difference between 2 pasted reports (One is pasted in the Original Tab and the other in the Match Tab and the differences are...
  20. A

    Comparison within borders

    Hello guys I am trying to right a macro that will compare different ranges with each other. Each range is enclosed by borders, so I would like the macro to compare what is within the borders to the next range. Essentially I am comparing the same functions from three different projects to see...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top