level

  1. N

    Help modify code

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

    Shape cut and paste in VBA

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

    IF AND or IF OR - HELP

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

    Looking for a formula that locates specific text in range of cells are returns specific text value

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

    Inventory Level (days) based on actual pull-out

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

    How to round numbers on Matrix table

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

    Severance Formulas: number of severance weeks based on salary grade level and years of service

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

    INDEX MATCH MAX multiple columns

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

    Analyze organizational level per incumbent

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

    Levels

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

    Cost-effective formula required

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

    How to look up and return a value from a cell?

    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'...
  13. S

    Sumifs for Data given with multiple columns

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

    VBA to change zoom of all Worksheets in a workbook Excel 2019 for Mac

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

    Parent Child hierarchical format using Level

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

    Convert Categories Hierachy To A Row

    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 =...
  17. C

    Return Numeric Value After Certain Text String

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

    VBA distinguish between worksheet and workbook names

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

    List Copy Paste Concatenate

    Hello Experts, I have a sheet that I need to figure out how to automate: - I need to copy the Attendees Column (Could be upwards of 500) to Output A2 - Sort alphabetically - If the level is below the level threshold listed, the person needs to report as NAME,LEVEL - If there is anything in the...
  20. G

    Cross filtering slicers regular pivot

    Hi all, I have several pivot tables based on the same cube and connected slicers cross all of them. Unfortunately the slicers act independently of each-other. I.e; I have a dimension hierarchy of 9 levels. If I filter my pivot tables using slicers on level 3, I would like to only be able to...

Some videos you may like

This Week's Hot Topics

Top