Hi,
I have a large Excel with a lot of data that requires a lot of calculation.
The issue is that I can't even open it without freezing and have an message Excel not responding.
Is there a way for me to open Excel without really open it to switch from auto calculation to manual calculation ?
Excel 2019
In cell A1 we have timestamp
23/06/2018 12:02:18
No in cell B2 we want to add four hours in
but if timestamp is 23/06/2018 14:00:00 and office open and close time is 11:00 am to 5:00 pm then it will add four hours, according to office working hours 24/06/2018 13:00:00 and if...
Hi,
I need an solution in VBA to find Best combination of sum value or Nearest to sum value from the list of data.
For ex:
in A column
A1 = 10
A2 = 20
A3 = 35
A4 = 50
A5 = 60
Given sum value
B1 = 100
B2 = 85
Expected output from macro
A1 = 10 B2
A2 = 20 B2
A3 = 35 B1
A4 = 50 B2
A5 =...
Good day to You all!
I've "inherited" an Excel file that works rather slowly. It consists of multiple sheets with 30+ columns and ±6000 rows containing VLOOKUPS, XLOOKUPS, etc. in lengthy tables. The file needs to be used by unexperienced people. Their work consists of adding/deleting rows and...
Hello fellow colleagues,
I have a task to calculate the number of months in a financial year (Australia) for grant payments that start in one year and end in the next, or in a few years. E.g. a $49,790.40 grant, which payments begins on the 16/10/2018 and ends on the 30/06/2019. The time span...
Interesting one for you all - Excel 365.
If I use a simple formula to subtract 1-1 I get, as you would expect a 0 (Row 2)
However, if I nest this inside an iferror formula I get a very strange answer (yellow cell). (Row 3)
Anyone any thoughts on why this is happening?
I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example
A
B
C
D
SL NO
PRODUCT
MANUFACTURING DATE
EXPIRY DATE
1
ABC
01-01-2021
01-01-2022
2
XYZ
29-03-2021
29-03-2022
3
CDA
04-05-2019
04-05-2020
4
TWC
23-03-2021
23-03-2021
I want my output as...
I am trying to create a formula that answers the following question:
What is the Tenure at the end of 2018 (12/31/2018) for a person that has a HIRED DATE before 12/31/2018 and has a TERMINATION DATE that is either within or after 2018.
I really appreciate the help, I just cant get the...
So I have two sheets. One sheet has my employee list with historic Start and End Dates. My other sheet is the summary of that list by Month. For example, lets say I have 10 Employees on my Employee sheet that all have Start and End dates, on my second sheet I have to summarize that info by...
Hi All,
Very familiar with the ins/outs of using complex array formulas, but found the strangest issue with SUM not summing the numerical contents of the reduced array, e.g., =SUM({0,0,1,0,0})...and this produces a zero. However, it works as intended by entering it as a standard formula (just...
I'm passing values from one Excel sheet to others, it turns out that the variable P666_2 has the value "xxx.xxxx" but when the value is passed to the other sheet the value is in the format "xxxxxxx,0000", can someone help me solve it this problem?
Sheets("Calculation_Sheet").Visible = True...
I am creating a gradebook which has users add new evaluations through a VBA userform. Each new evaluation is added to the next empty column in the worksheet. Two of the data entered are the Category and the Points.
In the sheet Settings!K2:L17, the Category code (column K) is associated with...
Hi Excel Masters,
I would like to ask help on how to calculate this in excel, there two scenarios:
Problem #1:
864434038623597 + 2833349361FC = (answer)getting error here
then (answer) * 11 = (answer #2)
then (answer #2) must be calculated using NCK to get the 11 digit answer. please help...
Hi,
Please help with formula or a method to calculate per employee job level salary cost for different departments when we only have is total salary cost employee for entire dept. We are also given average salary for each level of employee.
Below are the details
Average salary per Job level...
Calculation Question (3 Different Sequences)
Please provide the formula starting with an = sign that I can drag down.
Seeking the answers in the green highlighted areas. The green area has the
correct answer. I am simply deleting the first 2 digits of each sequence,
but I do not know the...
Hello everyone,
Today I have come across a very stupid calculation which I just cannot figure out how to solve. I already feel dumb enough as it is so yeah here goes:
The table on the right is where I fill in all the "resources" I have (this is for a game, I'm sorry if this isn't meant for any...
Hi there. This seems really simple, but honestly not sure how to accomplish.
I'm making a simple trip planner in excel, and I have a total row to total expenses. I'd like to be able make certain trip expenses optional so we can quickly see how skipping/attending certain things affects our total...
Hi,
I am starting to use Power Query.
After query table is done, I load it to a specific sheet to get the results, then I can use again this table for further calculations.
My question is: do I mandatory need to load the query table in a sheet to get the data for further calculation in excel...
Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc?
I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every...
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.