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