operations

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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