level

Hello all, I have a code below that copies the contents in columns A, B and C to the next blank row. I also need this code to Duplicate/Rename the contents in Cell C with, preferably REV 1 after it. Basically here is the format the users will be putting in Column C: LEVEL 1/ AREA A/ RM 125 I...

Hi I am looking for assessment questions to assess my level. I did google search but I would like to know if you know good site or you have a sheet that will give me my level after answering questions. I would appreciate your help. Thank you.

Hi, I have a worksheet showing 3 tanks where they have not the same capacity and by help I got a code (below). Current code shows that the 3 tanks have a capacity of 400000. My problem is that only Tank A has that capacity. Capacity of Tank B is 272000 and Tank C is 200000. Will you please...

Hi I have this code (Below) and I want to cut and paste Shape "C" to Sheet 2. What I need to change in the code so that Shape "C" will work in Sheet 2? Option Explicit Private Sub AdjustTank(ByVal CurLevel As Double, ByVal TankID As String, _ Optional MaxLevel As Double = 400000) Dim Tank...

I'm sure there is a more efficient way to write this formula. I'm hoping my Excel Brain Hive and help. I've attempted to break it up in lines. =if (AND(M3="Low",N3="Low",O3="Entry/Lower Level"),"No Change",(AND(M3="Low",N3="Medium",O3="Entry/Lower Level"),"No...

What I'm trying to build is a formula that will search a range of cells and return a specified text value if there's a match. Specifically I'm looking for names which may appear along a reports to hierarchy, 1-7. If the formula finds a particular name, any where in the range, I want it to...

I want to identify my inventory level (days) based on actual/forecasted pull-out and not the average. The desired result can be achieved thru this formula: =IF(F9>J9,1,F9/J9)+IF((F9-J9)>O9,1,(F9-J9)/O9)… But it would be a very long equation if I apply it to day 1 to 31. Can anyone help me...

Currently Matrix table on Report is displaying values in 2 decimal places. How can we round it to 0 decimal place? I look up web resource they ask to use DAX to round but since many rows are 0.2 something, rounding at DAX row level will make them zero but I want to round only at report summary...

I am looking for an IF formula for...number of severance weeks based on salary grade level...for example: IF grade level 21-25 receives 10 weeks of severance @ [amount] (based on individual salary) IF grade level 26-27 receives 12 weeksof severance @ [amount] (based on individual salary) IF...

I have four columns labelled Level 1, 2, 3, or 4. Each contain an Average Rating of BLANK to 100 derived from a ROUND & AVERAGEIF formula. The highest Rating & Level will be used to select a value from an INDEX table on Sheet2 and displayed as a Deduct Value. However, the INDEX table only goes...

I have been racking my brain and gotten stuck. I have a list of ids. Each id has the manager that incumbent report to. The list is from CEO down to bottom of org including every employee. (~46k rows) The list is in no particular order. What I would like to do is analyses on what level each...

Hi I have a spread sheet with over 300 names each name has a score (number) I also have a table with 4 levels each level has a number range eg: 14-45. What I am trying to do is pull the names of which level I select eg: level 2 is a range of 6- 12 so I should be able to see all names with a...

Good afternoon, I'll come clean - I'm trying to work out a formula for item enchantment in Minecraft. I'm trying to find a formula to indicate whether it's more cost-effective at purchasing two items that are enchanted at a particular level over one item that is enchanted at the next level up...

Hi Guys, Can anyone help with the formula I would need to use to have cell C1 show the words "Level 5" in the attached example? Column B shows a number of 'points' and Cell B1 is a changing value, if B1 was showing a figure above 10,000 but below 25,000 then cell C1 should show 'Level 2'...

Hi , I want to incorporate Sumifs formula where my sum range is dynamic basis the given criteria. For ex : In below data, i want to find sum of Sample 2 , for Business A and level 1 as my criteria. and sum should be for all YTD columns, so in case i change June as YTD, sum should include June...

Hi Experts, Here comes a new problem. With Excel 2019 for Mac, when you open a file, it doesn't display Customised Macro Buttons. The workaround is to change the zoom level and they all magically appear. So I wrote a code to change zoom level of all worksheets in one click. But it seems to...

Hi, I am trying to establish below in hierarchical format. Is there anyway if we can achieve output as below. tried grouping but didn't work. Input <colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody> Node Level A100 1 101 Child 1 2...

Hi I’m a really stuck, I have a category list in EXCEL. I have a 35 categories, each with sub categories and each sub categories has further sub categories, a total of 6 levels. The amount of data I have to input manually is in about 15164 lines, over 6 columns. Level 1 = 35 Level 2 =...

Hi, I have a sheet with a lot of rows of data such as: <colgroup><col></colgroup><tbody> Hotel > Level 3 > Room 360 > Courtyard K 4 > Work-Complete Hotel > Level 3 > Room 360 > Courtyard K 4 > Work-Complete Hotel > Level 3 > Room 358 > Courtyard K 4A-HI.C > Work-Complete Hotel >...

I have a workbook, and I want to refer to a number of named ranges within it using VBA. My Users occasionally clone some of these names by accident, so duplicates appear on individual worksheets. My code is then crashing because it can't correctly refer to the names Example, I have a name...