operations

  1. I

    Multiples operations through Power Query

    Hi everyone, I want to make operations through Power Query. I am a rookie but I almost succeeded reaching my goal here but now I am stuck. I have 5 columns which gives for each technician, type of hours spent (work, holidays, ...), the number of hours spent, the date when it was spent and the...
  2. P

    Surds operations in Excel Spreadsheet.

    I would like to know whether Surds operations work in Excel spreadsheets? Example : Cell E1= 2√3 Cell E2=4√3 Will Cell E3=Sum(E1,E2) = 6√3? And other Surds operations viz product, division etc? Will the Data type for inputing Surds values in Cells should be Decimal numbers? Thanks &...
  3. C

    Errors when Doing Thousands of Workbook.Save / Workbook.Open

    I have a program that requires a lot of Workbook.Save and Workbook.Open operations through out the day. Most of time the program works ok, but once or twice a week, it stops with "fail to open / save object" errors on the Workbook.Save or Workbook.Open line for no obvious reasons (such as...
  4. S

    Order of operations

    Hi all, I was wondering if anyone could help me confirm that this formula, =60.7*height+45.3*weight-2055, was correctly written with the order of operations when put into excel. A2=(60.7*B2)+(45.3*C2)-2055 B2 = height C2 = weight Thanks in advance.
  5. How_Do_I

    Extract...

    Hello all... Is there a way to do this please... I need to extract the topics from my data... So in cell B7 after the word "Agenda"... I'd want the text after "1." but before "2." in C7. Then agenda 2. in D7 etc across the row... I'm assuming numbers in Agenda 1 would mess everything up but I...
  6. M

    VBA to restore CELL(filename) value

    I use the following formula to return the location of the active "master" workbook. =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) This value is used in other formulas within the workbook as well as Power Query to identify the location of various source files in subfolders. My problem...
  7. M

    Match Keyword in Excel

    Hi, I am looking for formula that match keyword in from 2 files. File1: <colgroup><col></colgroup><tbody> Keywords Exclude intern accountant accounting admin advertising advisor analyst architect assistant to vice president assistant to vp Attorney auditor Author...
  8. T

    Automatically populate a table

    Hi All, I have to populate a 3x4 table that is a list of our corporate projects. The projects belong to only one Division and Tier at a time. Projects progress from Tier 3 to 2 to 1. The data is sorted like this: <tbody> Proj_Name Tier Division Project A 3 Operations Project B...
  9. R

    MFG Line balancing help: can excel do this?

    I have a set # of operations, each requiring a set time to complete. Is there functionality in excel to identify operations that sum to a max amount of time, group those operations, and then sum the next operations up to a max time, and so on... Ex. Operation 1: 50 seconds Operation 2: 30...
  10. K

    Help with what route to go with function

    I have a spreadsheet that I need to calculate a bonus based on the years of service. I have had a formula in the past, but every year it has to be updated because the formula is if the employee has 5-9.9 years of service they get a 2% bonus of their annual salary, if the employee has 10-14.9...
  11. S

    Unique count based on different cells

    I need to get unique value of Suppliers based on the different columns Input: <tbody> Functions Suppliers Sites Due Date Operations Apple #N/A #N/A Operations Orange #N/A 4/13/2020 End User Services Watermelon #N/A #N/A Operations Pineapple #N/A #N/A Operations Kiwi Mulgrave...
  12. J

    Copy Range to Another Worksheet

    Greetings all people human and otherwise. I've got a question regarding copying a range of information from one worksheet to another with a piece of VBA code. I have a macro that does some data manipulation, and an excel sheet that updates as required to show those manipulations. The...
  13. N

    Is Their an Order of Operations for Functions ?

    Hello, Wondering if their is an order of operations for functions ? If so, what would it be in the following instance; or is their a better way to achieve the following. Here is a breakdown of the problem : I need to find a value ( AW5 ) That value could be positive or negative ( AW5>0, or...
  14. Nelson78

    Navigate CRM Siebel by Excel Vba: is it feasible?

    Hello everybody. I'm trying to understand the feasibility of a project. I've got login and password for entering CRM SIEBEL 7.8 and executing manually a range of operations. Can I replicate the same operations by an automation with Excel Vba? If yes, what do we need? (Firstly, I think atleast...
  15. L

    =40/2*16

    Hi The result of above formula is 320? Why division has higher priority than multiplication? I thought the order of Operations is PEMDAS So M before D?
  16. P

    Need help with a formula that I need to ignore any colored cells

    I have a formula to prioritize jobs on a worksheets that takes into account the days remaining until the jobs due date & also the operations of the job. I quantify each operation to a number that equals the days that I think the operation will take. Here is the formula...
  17. L

    students marks to grades (using if and logical operation)

    Hi What is the best way to convert numbers to grades. For example 0 to 50 is F 50 - 60 is C 60 - 70 is B 70 - 80 is A 80 - 100 is A+ What is the best way or formula to do so. I was thinking of If() with logical operations like AND, OR etc Any idea would be very much appreciated. Thanks
  18. K

    Simple business process simulation

    I want to understand the best way to run a simulation in excel. Input data: Client orders (normal distribution, time of order placement is random over 24 hours). 1 order is a box (it contains 10 items). Step 1: Compare to Inventory level, do we have over 10 items? If yes > go to step 2...
  19. J

    Need help with a solver problem Don't know how to use slover and identify constraints.

    I'm learning how to use excel for real life project Scheduling. My work is giving me practice promblems and I'm basically on my own learning excel. I learn by baby steps. my job field is operations management I'm use to doing heuristic by hand and I'm an old dog learning how to use excell and...
  20. S

    Run time error 84, Attempting to Perform Operation on a Range

    Hey guys, here is my code: Set Efficiency = Sheets("Sheet1").Range(Sheets("Sheet1").Cells(StartCellRow + 6, StartCellColumn), Sheets("Sheet1").Cells(StartCellRow + 6, StartCellColumn + 21))Set Inefficiency = Sheets("Sheet1").Range(Sheets("Sheet1").Cells(StartCellRow + 8, StartCellColumn)...

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