# level

1. ### Look Up BOM Hierarchy using Level field

Hi all, I am trying to come up with a method of looking up the BOM structure below, using the level column, to replicate the manual output i have created in the column 'IDEAL'. The logic here is 1) If 'ISCONF' = 'N' then it remains 'N' 2) If 'IsConf' is 'Y' then look up at its parent, which...
2. ### Deleting certain rows in 95,000 row worksheet

I am using the code below to search cells for certain criteria and then keeping certain rows and deleting certain rows. This code currently takes around 1 hour to process 95,000 records. I need help in determining if there is a better way. Thanks, 'Delete Level 1's and certain Level 2's X =...
3. ### Organisation Chart in Excel

Hi, I have been given a task to create an organisation chart for over 2,000 employees in Excel because it can then be presented in a specific format (effectively I am using grouping to expand and collapse rows to show how the hierarchy flows). This is extremely time consuming and inefficient...
4. ### Multi Level Category Graph

Hi All, Are able to produce a Multi Level Category Graph with Power BI?
5. ### Excel formula to auto-select a figure on certain conditions

The pay of an employee in applicable level in the Pay Matrix will be fixed by multiplying the existing basic pay by a factor of 2.57, rounded off to the nearest rupee and the figure so arrived at will be located in that level in the Pay Matrix and if such an identical figure corresponds to any...
6. ### Bills of Materials - Total Quantities required Help

Hello all, I need to create a summerised parts list from a Bill of Material, ensuring that all items are properly accounted for as the BOM is multi-leveled. A sample of the data: - <tbody> Item Level Part Number REV Qty Per Qty Total 0 0 HD IBC 7500 F50T 2 2 1 1 FHF57 AM132/M 01 1 2 2...
7. ### Excel Hierarchy

I have some data found here: https://1drv.ms/x/s!AktAOe8JUNECiKkS30iC2jH4jX5GdQ?e=eYGYBa Column A is the PARENT with 00000000 the TOP value. Looking at the data in column B, we see 00000000 has many 2nd level values. Looking at the first 2nd level, 00000004, we then look that up in COLUMN A...
8. ### Finding / calculating reporting level in organization/hierarchy

So, I have a list exported from a system containing unique employee ids (children). Each of these rows has the employee’s manager unique id (parent). One of the employees is the CEO and is to be considered level = 1 I would like a way to calculate per employee what level they are on in the...
9. ### How to make a DAX measure NOT to re-calculate on aggregated levels?

I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)? The problem is the aggregated number...
10. ### ActiveWindow.Zoom - Need to change value but not sure how

Hi Guys, Hope you can help me with a very annoying problem. I'm working on a project and receive around 1,000 .xlsm workbooks each week that I need to edit and save. The problem is the person who is sending these workbooks inserted a VBA code on each that goes like this: Private Sub...
11. ### Using a Navigation Form as a subform?

Hi, I am trying to figure out if there is a simple way to use the Navigation Form option as a subform. I have 6 tables and corresponding forms (and 4 look up tables). My top level table/form identifies a person with two tables branched from there, with one of those tables having 3 more...
12. ### Excel stats verses Matlab, R and Python

Hi Everybody, Can anyone provide some pros and cons of each of these stats packages for a general professional level but not for full on data science work. thanks, Farmerscott
13. ### Multi level sort on a dynamic range

Good afternoon...again. :) I'm surprised I can't find some already built code on how to do a multi level sort on a dynamic data range...but I've not found any so far, so I have to bother everyone here again. My header row is on row 7; I have 7 columns, and I need to sort first by column B...
14. ### VBA Count add to Sheet2

I have about 40,000 rows of data on sheet1 like below. What I need to do is to give a summary of grade level on sheet2. Please see below data. <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica...
15. ### I think it's an IF formula.... but I can't get it to work

Hi all - really hoping an Excel genius can work this one out for me :cool: Scenario is: I want to review the safety stock levels of a number of components. I've taken 2 components as an example If the percentage adherence to the agreed safety level, over a period of time, falls below a...
16. ### Cannot use advanced sorting after .cvs import

I have tried over an hour and cannot figure out why it won't sort correctly. I have imported a .cvs file and delimited. I am trying to sort with 2 levels on 2 columns. It sorts fine when I only sort 1 level. When I sort with 2 levels, the 1st level sorts correctly, but the second level I create...
17. ### Vlookup FOLLOWED by IF Statement?

Hi All, I am trying to set up an Excel formula based off of a mapping table. I have a set of "level 1" codes in my data set and can match them to the mapping table that also includes these "level 1" codes via a Vlookup. That takes care of about 75/80% of the data set. There are some lines of...
18. ### Vlookup, Hlookup, Match, Index,... or probably a combination?

Hello, I'm looking for an Excel Formula and I hope that someone can help me out with this? I tried to draw a simplified version of the Excel below. I'm looking for a dynamic formula which returns the required training level for a specific Team. For example: - For Team C - For Training 6 -->...
19. ### Adding Suffix to a cell based on value of a another Cell

i'm dealing with columns A and F. I need to add letter A to end all values in Columns A if Column F has Level or Roof in columns F. Data before modified Column A Column F <colgroup><col><col></colgroup><tbody> P1.00 LEVEL P1.09 LEVEL P1.10 LEVEL M1.11 ROOF PLAN M1.12 ROOF PLAN...
20. ### Look up a value and display the score

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>

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back