level

hi am finding it hard to explain it but it should be easy in the example <tbody> A B C D E F G 1 Score Level Score Level 2 10 AA 10 =????? 3 20 BB 15 AA 4 50 CC 18 AA 5 100 DD 25 BB 6 200 EE 70 CC 7 </tbody>

I have a question about reading & setting the zoom level of a worksheet, but I need to explain exactly what I'm trying to do. In my workbook, I'm writing code to allow the user to import data from another workbook of the same type. (This is in case the version they have been working on becomes...

Could anyone assist on this? Not sure what happened. I sort based on Column B then 2nd level Column A but it does not sort Column A https://filebin.net/ncwuhi8hv72gmlyn

Hi, I have created a Multipage userform, with 4 Text Boxes. I am using a button to add a New page and copy the controls from the First page dynamically But this code also copies the data entered in the new page. Is there any way I can copy only the form, with no values ? Below is code i am...

Hi everyone, I hope I explain this well, I'm certain many of you will find this soooo easy...., but I need a bit of guidance, please I have a spreadsheet similar to the one below. Effectively I want to be able to add up the sum of all of the 'level 1' rows in that range (marked in red) and...

I am creating a pricing template for services, a section of which is based on an hourly rate. The rates, are by level of seniority which need to be added together then multiple by the number of hours. I would like the option of only selecting the level of seniority and adding the hours, then...

Good Morning- Quick question for someone- I've got numbers A1:A10 a "Y" or "N" in B1:B10 a "Y" or "N" in C1:C10 I'm trying to put a rank formula together that IF B cell is a "Y", it goes to the top of the rank, irregardless of the number in A cell. Then if C cell is a "Y", it goes to the...

Mr Excel, I am trying to pull a dependent part number based on its assembly level in a bill of material. Here is the bill: <colgroup><col width="65" style="width: 65pt;"><col width="104" style="width: 104pt;"><col width="82" style="width: 82pt;"><col width="114" style="width...

Hi there, We have a system that issues tabled data which appears in the following format:- Column A | Column B Level | Description Top Level | Top Level Description (2 "spaces") 2nd Level Code |(2 "spaces")...

Hi Experts, Need your help to calculate number of people under each manager. Please help me the decode this complications. <tbody> Name Level Lead Manager Brian Level 1 Alfred Sheldon Erick Level 1 Alfred Sheldon Alfred Level 2 Sheldon Raymond Sheldon Level 3 Raymond Edward...

S14 has formula =INDEX(CTC!$C$57:$Y$71,MATCH(S$13,CTC!$E$57:$Y$57,0),MATCH($E14,CTC!$C$58:$C$71,0)) I want it to return the value 21,348 from cell E58 but I have messed up somehow, can you help please Excel 2013/2016ES13DescriptionMonth 1 ongoing14Division Manager - Faade-15Technician -...

I was wondering if anyone knows of "hands on" Excel classes on Long Island; Nassau County, New York. I have taken a number of classes, however they fall short of continuing the education to "Master Level". Thank you for any help....

Hello! Can you tell me please how to insert to cells the below characters/format, preferably with a formula as I want to blend them with other text and formulas. • Dfgdfg o Fdgdfgdfg  Fgdfgdfg if the above don't display correctly, you can get them from MSWord where it is basically the first...

I have a range where I need to derive the level/depth in the hierarchy for each cell where some cells are comma seperated , for example: <tbody> Task SubTask ParentTask T1 T2 T0 T5 T3,T4 T8 T2 </tbody> In this example range, the level of T0, T5 is 1. The level of T1,T3,T4 is 2. The...

Hello, I have searched for a solution to this requirement in the many examples which exist but can't find one that does what I need exactly and my vba skills are not good enough to adapt. I would greatly appreciate help from the excel expert community. I'm trying to combine several BOM files...

Let's say I get a datapoint of something that fluctuates over time and I enter it with a date down two columns. I want to find the last date where it was equal to, or less than the current value. And I want to find the first time it was equal to or higher than that value. An example might be...

Hi all, I am after a way to create a dynamic multi level graph, without using a Pivot Table. What i would like is the graph to change, when selecting the month, to show category, depot, fine type, Registration. I have no issue in creating a static multi level graph, but as the data changes...

Hello - I'm trying to calcuate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level. <colgroup><col><col><col span="5"></colgroup><tbody> Fee...

Hi All, please see the formula below. I obtained this formula some time ago and always use it to number cells. Id like to decipher it so instead of being 1.1, 1.2, 2.0, 2.1 etc. When I set the top level number as 000 it numbers 001, 002 or when the top level is 100 its 101, 102 etc Any...

Hello All, I have this code very close to what I need it to do but I think I need to add a counter of some sort. I'll try to explain this AS BEST AS POSSIBLE. I need this code to count how many times there is an occurrence of an Alphanumeric value in Column C and then simply increment the...