level

  1. B

    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 =...
  2. P

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

    Multi Level Category Graph

    Hi All, Are able to produce a Multi Level Category Graph with Power BI?
  4. B

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Checking and changing Zoom value without Activating workbook/sheet?

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top