level

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

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

Hi All, I have multiple sheet in a workbook for example : sheet name 1,2,3,4,5,6 Now I want every time when I open excel file it automatically set the zoom level for all the sheets except sheet no. 2 &3. So except sheet no. 2 & 3 , all sheets should be at zoom level 50%. Please suggest , how...

Hello - I'm trying to find a formula that would allow me to perform the following calculation: The average number of new consumers is x per location per month The current level of goods = y By dividing y/x = the lifespan on a monthly basis If I need to determine the number of lifespan unit to...

I am new and was not able to find something specific. We have an external drive, this drive has folders, in those folders there are more folders, in the folders are videos of various formats. Im looking to list the top level folder name and below that list the names of the files. In excel...

I have to automate the drawing of the organizational chart by the way of VBA and complete some calculation. For Example: On Sheet1, I have allowed the user to input the organizational details which can dynamic as below: <tbody> Level Name Percentage value 1 Alphabet 100 1.1 Google 40 1.2...

<colgroup><col style="mso-width-source:userset;mso-width-alt:15908;width:326pt" width="435"> </colgroup><tbody> Hi All, I am just a beginner in Excel If some can assist me in extracting Level #, Unit #, in the sample table below? it would be a great help for me DATA: Column A...

<tbody> Abc School Processing date 7/7/2018 to 7/7/2018 ABC school Clearing type 1 productivity report login level cust name domain name slp chq micr chq date slip l1 l2 l3 chi login id 123456 l3 verfication Abc School new Abc...

Hey guys, I need some help. I've been frying my brain trying to get a formula but all I get is a circular reference. Someone told me to write a macro to do it which I have no clue how to do. I have the following 6 columns: 1. Column A: Day {Mon..Sun} 2. Column B: Demand [kg] 3. Column C...

I am trying to create one cell that shows the discount approval level required which varies by quantity. Thank you for your patience. So here is the matrix of what discount can be given at what quantity. The only require is to output a cell showing discount, which will then be conditionally...

Hi, I have a file where on a tab called Exec Summary you use a drop-down menu to select an expense type, say Travel in cell A1. This drives a VLOOKUP to pull through the name of a Person, say Person A. On a tab called spend type, I am then looking to pull through the Level 1 and Level 2 spend...

Good morning, I have a sales sheet that I use to calculate goals based on the seniority level of each salesperson. The formula checks the amount in column "D" against the appropriate goals in "D1-D15" and returns a rating. Currently I can't just drag the formula down the entire column as there...

To clear an object variable, you would set it to nothing. How would you clear a non-object variable? I ask because in the following code, the variable a is declared at the module level, so every time the sub is run, the variable's value increases. I want the variable a to "clear" after the...

I have these job levels (in order) with their corresponding average salaries, earlier job level salaries, difference in $ and % between the two. This is a manual table, and I need a DAX formula to calculate the earlier job level salary so that I can calculate the differences, but I can't for the...

Hi, I have data that looks like columns 1 and 2 of the following: <tbody> Level Value Tree Index Current Output Expected Output 1 1 1 1 3 2 1 1.1 1 2 3 1 1.1.1 1 1 1 1 2 1 6 2 1 2.1 1 5 3 3 2.1.1 3 3 3 0 2.1.2 0 1 4 1 2.1.2.1 1 1 1 2 3 2 4 2 1 3.1 1 1 3 0 3.1.1 0 0 2 1...

Hello - I have an OLAP pivot that needs conditional formatting. This pivot is a income statement at the account level. So the conditional formatting can be built at a hierarchy level for the pivot. In my case, I can built the formatting on "LEVEL 9" of the hierarchy. The problem is both...

I'm not sure how to explain what I need so hopefully the cells below explain. I have created some dummy data similar to what I need. I'm trying to create a formula to go into the parent column (G) that will return the value from the part number column (B) of the parent above. All parents are a...

Ok so here is what I am after if anyone can help I need to create a unique number from an item list, I am given indent numbers on the list for parent/child relationships top level is level zero which is 001, next level with an indent of 1 will be 001001, next level with an indent of 2 will be...

Hi Team wondering if you can help. I have 2 worksheets: Worksheet 1: Lookup table that has 2 columns that provides a water level and a volume - derived from a model <tbody> Level Volume 1330 14292.8 1329.9 14277.4 1329.8 14262.0 1329.7 14246.4 1329.6 14230.7 1329.5 14214.7...

Ok so here is what I am after if anyone can help I need to create a unique number from an item list, I am given indent numbers on the list for parent/child relationships top level is level zero which is 001, next level with an indent of 1 will be 001001, next level with an indent of 2 will be...