calculatation

Morning All, So my FD is having an ongoing issue with formulas not updating automatically within a spreadsheet. The key symptoms are that Excel simply chooses not to automatically calculate a cell with a formula when a corresponding cell is changed. This can be sporadic and sometimes is works...

Greetings, I am somewhat lost how to approach this problem that I have. In essence I want to calculate demands per material for specific date based on the number of projects on that date. for this I have 3 tables Project Consumption Table (showing how much of each material is consumed for each...

Hello everybody, Could please someone check if my workarounds are possible to achieve? I tried to approach it different ways but so far i only managed to prepare data placement with few easy formulas such as =mod =quotient and other cells references. Basicly its about Box on pallets...

When I save the workbook excel triggers a calculation of the workbook. I have no problem with this and I can always turn it off. When I go to each sheet and calculate the sheet the results remain visible on each sheet. When a calculation is done on this workbook, the formula results disappear...

Hello everyone. I need to calculate something with excell macro because its takes 6 hours with manuel. I have a document which is have differant locations like from 0 to 5.918, from 0 to 6.530 every location has diffrent forces for every directions x,y,z. ı need to addition every forces from 0...

The "error": The code: Dim oPL As Double, o709 As Double, o710 As Double, o713 As Double Application.ScreenUpdating = False Sheets("Calculation_Sheet").Visible = True ActiveWorkbook.Sheets("calculation_sheet").Activate Note: P666, P709, P710 and P713 are global variables...

I need help figuring out how to calculate employee's extra earnings due to extra hours they worked each week. Let's say, the year starts on November 1st. So the first week of November starting Sunday and ending Saturday is Week #1 (if November 1 starts on a Friday, then Week #1 will consist of 2...

I have a spreadsheet which is a dump of our user's full names from an old email server. The names appear to be in the formats Firstname Surname, Firstname1-Firstname2 Surname, or Firstname Surname1-Surname2 depending on whether they have a hyphenated firstname or two surnames hyphenated. I'm...

I have the following rows. I use Google Sheets so I need the = formula County is ROW L1 Parcel is ROW M1 NEW PARCEL is ROW N1 How do I fill in the blanks and I want the parcels to have an R in front of them. So, BLANK 1 is row N2 and the end result should be an equation in which the answer is...

Hello, I want to enter a number in these cells (c29, c35, c42, e29, e35, e42, g29, g35, g42, i29, i35, i43) after clicking out of that cell or pressing enter I want to perform the below calculations based on my choice in the dialog box. I had this working in a userform using text box...

Hello !!!! I have this code which creates a module based on values put in excel columns. Basically, I have the name of a division on column 2, an actual number of employees on column 3, a calculated need of employees on column 4, and the difference on column 5 which the box changes colors...

Hi everyone ! I come for your help on Pivot tables. So I have done a pivot table, which depicts the maximum of a value on a specific date, for several parameters. See image in this link: http://www.noelshack.com/2018-49-3-1543999976-capture.png So I have the Max values for X and Y on...

Hello, I have a data set that is very large (180k rows). I am using a countif function to see which ID#s are showing up twice. I do not want these removed, as I still need them in the data. However, when I use the countif function, it does not show multiple counts for ID#s that I know are...

Hi, is this possible? A1 has value 200 A2 has value 100 B1 is a date B2 is another date C1 is =B2-B1 for number of days How can I calculate first 30 days with value from A1 + days over 30 days with value from A2 in a total sum? Anyone? Thanks.

hello i want calculate accuracy for different people by comparing three fields in the spread sheet i don't know how to calculate accuracy by comparing three fields ,any idea ???please help me

Hi, I have an excel dashboard which has a large data set and when a user changes certain options the calculations can take between 2 to 4 seconds to update. I tried to create a message that popup when the user changes asking them to wait, see below code: msg = "Calculating...Please Wait"...

Hi, Some friends of mine and I are staying in a villa for a set total cost £3780. But 7 people will stay for the full 3 weeks, 1 person will stay for 2 weeks, and 2 people will stay for 1.5 weeks. How do I calculate how much each person has to pay?

I have a relatively complex spreadsheet that started out at around 30MB and was built with array formula. I've pared away most the arrays by adding helper columns and cut the file size in half and Full Clac time from 7.9 to 2.8 seconds and Recalc from 4 to 2, but want more speed...

Good afternoon whizzy Excel people, I wonder if anyone can help me solve a problem that I'm trying to come up with a formula for, I'm usually pretty good at this sort of thing but this one is eluding me, no doubt someone out there has a simple answer using a function I haven't come across yet...

Hi all, I have a userform which is being built as a calulation tool I have a combo boxes and text boxes that are dependant on each other, once filled in there is a button that should calculate a range of values dependant on 1.) The value in the text box 2.) The selection in the corresponding...