difference between cells

  1. P

    Calculate error times based on recurring text string

    Hi all, I am looking for an efficient way to calculate the error time from a sheet of data based on the name column (B). When the value of a certain error is 1, the error is started and when the value is 0, the error is solved (column C). There are a lot of different errors, which sometimes...
  2. S

    How to Stop Excel from Calculating the Days Between Two Dates if Cell is Blank?

    We often calculate the amount of days between two dates for calculating interest (=DAYS(A22,A21) OR =A22-A21), but if there's no date in the cell below (i.e. the end date) it will show as a negative number (see image). I guess we would need the formula to assume if the cell is blank that it's...
  3. T

    Formula for if time is same, earlier or later?

    QUESTION: Can you help me create a formula that looks at time in two different columns and determines if the time is the same, earlier or later? For perspective, this is to determine difference in closing time this winter compared to this summer. Sample data below. CURRENT FORMULA...
  4. O

    How to compare data in two columns that are not written in the same way

    Hello, I have a datasheet with 35000 datas in one column and I have to compare it with another colomn that contain 10-15 lines. The problem is that the way they are written are not the same. For example in one column I have : Microsoft Visual C++ 2008 Redistributable - x86...
  5. smide

    Difference between two dates in hours

    Hello. In columns B and C (B2:B600, C2:C600) I'm receiving dates (with hours and minutes) in rather strange form - without current year? For example in cell B2: 12.02. 19:07 Explanation: 12 - day, 02 - month (February), then after 02. there is a one space, 19 - hours, 07 - minutes In...
  6. M

    Sum the difference of a row of numbers

    Is there a formula that sums in one cell, the difference between a series of numbers? Example: 6 8 2 9 I did it "manually" with this: =SUM(B1-A1,C1-B1,D1-C1) but I was wondering if there was an easier way (the answer is 3).
  7. T

    difference between dates with if function

    Hi folks, please, could you help me to solve following issue? The problem is, that in first column I have for example today's date. In the second I could have different date, could be future date or past date. Column number 3 could be empty, could be with future date or could be with...
  8. S

    Calculating Minutes between Date and Time Stamps only durnig working hours

    I am trying to calculate the amount of minutes it takes our company to complete an Order. We have captured the Date and Time Received and the Date & Time Completed. I would like to get the number of minutes it takes to complete the Order during normal office hour from 7:00 AM PST to 4:00PM...
  9. P

    Find the difference between numbers amongst blank cells

    Hi all, I have a feeling this problem is not too complicated, but i'm struggling to find a formula to handle it, description below: Column A contains numbers and #N/A or blank values. If there is a number in cell A1, I would like cell B1 to trigger a formula where it will search down column A...
  10. T

    Finding the Difference Starting with Zero Dollars

    I'm trying to find the difference of two arrays and have it tell me the difference starting with zero and counting up. I've got two columns, Sub Total (estimated cost) and the Actual total (cost at the time of sale). The Actual hasn't been set up because we haven't purchased anything yet, hence...
  11. C

    Compare two cells, and synthesize the difference.

    Hi, I am comparing some data on types of differences: additions and deletions. I've used some code from a previous thread to compare two strings and find difference; and simply switched the WORDDIF arguments accordingly. =WORDDIF(A1,B1) Code: However, I have come to some obstacles. 1...
  12. X

    List/highlight differences after comparing two groups of set data.

    Hi, My excel's worksheet layout is similar to the table below, but with 7000+rows. The only entity that is unique is the email address (Col A). The table below shows employees who have multiple mobile devices and whether they have installed Mobile Device Management (MDM) on each of their...
  13. T

    Formula to calculate difference between values.

    Hi all, I need a formula that will allow me to help calculate the difference between a value and the next value upwards. so for example as per the table below Megans quarterly billings are 12,458, i need a formula that will calculate the difference between this value and the nearest value up...
  14. R

    Finding a string difference.

    Dear All, My <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA skills are not strong</acronym> so please bear with me...
  15. H

    Compare two columns and highlight the differences

    I have two excel columns side by side "original" and "edited". In a separate column I want to compare the edited column with the original column, with new text coloured green and removed text coloured red and stuck through For example: <tbody> Original Edited Comparison The cow...
  16. D

    12-month Rolling Difference

    I am in need of a two solutions that will compute the difference between two numbers. First Problem: I have a table with hour meter readings in rows representing different equipment. The columns represent the end of month reads with the oldest to the left and newest towards the right. I need...
  17. E

    Write Macro to sort data based on change between rows

    I have a macro written that sifts through the active column and ignores data that is greater than 18 and less than or equal to 0. In addition to this I would like to sift through the column to the left of the active cell and skip over data where the absolute value of the difference between the...
  18. H

    Similar texts with minor differences - How to get just ONE (a standard one)

    Hello, I have a very large database that contains names with minor differences on column A such as: A EXCEL AMERICAN COMPANY S.A. EXCEL AMERICAN COMPANY SA. EXCEL AMERICAN COMPANY, S.A. ASSOCIATION, INDUSTRIAL ASSOCIATION INDUSTRIAL L.A. COMPANY CO LA COMPANY CO As you can see, this makes a...
  19. abarbee314

    Compare columns to figure out which rows were adjusted...

    This feels like a "Track changes" sort of situation, but I can't nail down which way to go here (MATCH, VLOOKUP, etc.). I essentially have four columns of data: > Workbook 1 - an item reference number - a detail amount > Workbook 2 - an item reference number - a detail amount We looked at the...
  20. F

    Calculated Field/ Item query - calculating differences

    Hi I’m currently trying to work out the difference of two valuations (internal and external) in a pivot I have created. Currently my Pivot is arranged as follows, source data (internal or external) as column labels, Product as row labels with a further break down by office region of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top