comparison

  1. K

    Comparing differences in excel documents

    If I sent a document to someone in excel, and then they sent back their own saved verision of the document, is there a way to compare the two to show the changes made?
  2. P

    Compare Two Sheets and Highlight Differences (Sheet attached)

    Hi all, I've been searching for an answer to this question on the internet and there are lots of similar things but nothing does exactly what I want it to do and I'm a bit of a VBA noobie. I am trying to compare two sheets within the same workbook (Sheet1 = Before and Sheet2 = After) row by...
  3. S

    Comparison & Duplicate Check

    I have two columns with names of people, <TABLE style="WIDTH: 241pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=322><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 63pt; mso-width-source: userset...
  4. L

    Label cell if between values for list ISSUE!

    Hello excel enthusiasts, I'm sure there is a way to do it, but I can't figure out the simplest way short of a really long really nested if function. I have a list (900 lines long) and then I have another list which corresponds to scores. Here is an example: 100 - A 90 - B 80 - C 70 - D 60...
  5. S

    Confused On VLOOKUP

    Hello, I am trying to sort through two sets of sku's for different marketplaces however I have come into a problem and doing 2,000 by hand doesnt seem efficient. I need help on writing a formula to figure out if any SKU in Column A is also in Column D, and vice versa. If it is in Column D is...
  6. T

    Format() not formatting according to parameter

    I need help figuring out why I can't force dates to compare in the way that I want. I have worksheet and want to compare a date from a datePicker control to a date in a column to find a match. The column in the worksheet is given the Custom format "yyyy-mm-dd". I did not select the option that...
  7. L

    question for multiple comparisons in if statements

    Hello, I was wondering how to correctly get an if statement to reference multiple entries. For example. I have a column 1 2 3 4 5 6 7 I want to add another column that says something like if(B1=2,3,4, "Group C", "") so if the value in cell B1 = 2, 3, or 4, then label "group C"...
  8. Talon52

    Comparison Problem with Averages

    I am trying to come up with a spreadsheet that has 1 page of sales from 6/18/07-8/16/07 (43 days), with 3 rows beneath each column: Row 45=Total (=Sum(b2:b44)), Row 46=Average (=Average(b2:b44)), and Row 47=Average + 10% (=Sum(b46+(b46*.1))). The next page has a daily input from 6/16/08-8/15/08...

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