level

Hi All; I have a lot of data (some of which I've shown below) that I'm trying to map in a certain way. <colgroup><col><col></colgroup><tbody> 27 1005516 1005510 1005511 1005510 1005514 1005511 1005411 1005511 1005513 1005512 1005510 1005513 1005410 1005515 1005512 1005516...

I have a cell that I need to populate with data based on the information of two different cells. To lay this out for you all: I have a sheet that is going to generate payment based on a sales person's status (Certified or Trainee), and the classification of their sale (1st, 2nd, or 3rd-level...

Hi there, I'm in between basic and intermediate level I think. I do know the popular formulas (IF, VLOOKUP etc in isolation) but want to really take it to the next level understanding nested formulas and multiple functions in a formula, index and using arrays etc. and jazz up my chart skills...

Using a template I found on the internet I've created a thermometer guage linked to a formula in another sheet. The 'mercury' itself is a shape plotted with a fill based on the value of a cell. I've formatted the mercury level as a gradient fill using a red to green traffic light spectrum. The...

My first post here with thanks in advance for any help. I want to return only the number to the left of - which is separated by a space. This is the desired result: <tbody> Luna Quartz Level 3 - Pool 3 Supreme Matrix Level 1 - Spa 1 </tbody> When I use the formula...

Hi all, Can someone help to have the following table auto-grouped? VBA would be easiest I think. The goal is to have the hierarchy in a good overview people can get to the desired level and fill something in on the columns I will paste next to the table. And therefore Pivot will not work...

I'm not sure why, but this code isn't finding instances where a formula result in column T is "Reviewer Level Conflict". The last row is identified correctly, and I've verified that the value is present. Private Sub cmd_Create1LRFiles_Click() Dim mws2 As Worksheet Dim rng, rngFound As Range...

All, I have a situation where I need to calculate within a pivot table. I need to calculate a delta between two columns that are at the second level. In other words, the elements that need to be calculated are pivoted and not their own individual field. Is there a way to do this. If it...

Hi, Can anyone point me in the direction of an COVAR() tutorial/example that shows how the COVAR() function is calculated? I'm NOT looking for examples of how it's used, I'm looking for how it's CALCULATED using lower level functions i.e. SUM(), AVG(), COUNT(), multiplication and addition etc...

Hi all, A skills assessment questionnaire has been sent to staff and I now need to collate the information for each different site. I am a bit unsure the best way to set up the spreadsheet and then how to combine the information for all sites <tbody> Name Job Title & Team </tbody>...

Hi All, I inherited a power point presentation that shows the average, minimum and maximum values from survey response question. I have the underlying Excel data but don't have the work of the person that calculated these things. The average is shown, including the confidence level. I'm not a...

I need help with this formula, it's above my skill level. I've worked on this for hours.... [/IMG]

Hi there, I am trying to get excel to extract a unique list based on criteria and priority level. I managed to get the list extracted based on criteria but I don't know how to sort them so they are pulled in order based on their priority level. I'd appreciate any help! Excel sheet is attached...

When group level 2s in level 1 thing in video happens -(When last row of level 1 is included in a level 2 hierchy. Grouped data should be in level 2 but its beyond level 3 as in the video in attachment) When all level 2 headers are selected and grouped for level 1 thing in image happens-

I have a column "C" that has numbers in it (numbers between 0 and 15) The column starts at row 7 I want to go down row C and for every row that has a value I want to "Increase Indent" the text in Column B and D the number of time that equals the value In column C of that row. So in Row 7 if...

Here is my data... <tbody> A B C D E Indiv Avg Rating 1 2 3 1 2.00 1.00% 1.00% 1.00% 2 2.25 1.18% 1.25% 1.30% 3 2.50 1.36% 1.49% 1.60% 4 2.75 1.55% 1.74% 1.90% 5 3.00 1.73% 1.98% 2.20% </tbody> Cell a10=2.8 (Rating) And Cell A11=2 (Tier Level 1, 2 or 3) I need to create...

Hi All, I have a VBA macro code that works on a organisational chart and works pretty well based on pre-defined criteria based on Levels.So for example there is a director of sales and Level 1 is a senior Sales Manager who would report to the director of sales and Level 2 is a sales Manager...

I have a requirement to create a mapping table that is based on 4 columns of my source data where the mapping can occur at 1 or a combination of multiple of those 4 columns. More specific rules (those specifying multiple columns or using the columns representing lower hierarchy levels) will be...

Good day All Code below handle only procedure, how to use it replace Enum string "Level" "LVL" ? THX. Option Explicit Public Enum SecurityLevelp IllegalEntry = 0 SecurityLevel1 = 1 SecurityLevel2 = 8 SecurityLevel3 SecurityLevel4 = 10 End Enum Public Sub SecurityLevel() Cells.Clear [A1] =...

Dear all Could i seek your advice on the below Thanks in advance! I cant seem to get my Lower level calculation to sum up at the lower level, it is now calculating at every level. My sample file is available on http://drive.google.com/open?id=1lehGxqQG2vE_D3wGR0xvuZcNpMTL-Pp7 Sales...