levels

Hi everyone, this is my first post. I am trying to set up a 3 level drop down list using data validation with the 'INDIRECT' function. The problem arises because the second level requires data groups with the same name. I am trying to identify where we have the most problems in a chemical...

I have a listing of 500 employees with one data field that gives the next reporting manager by name but not employee number. Ultimately there are up to six levels of management to get to the Regional manager. What formulas or structure could I use to create a management hierarchy which will...

Hi, I need to generate number into column F, based on hierarchy (col B:D), below is excel examaple: <tbody> A B C D E F 1 2 Looking Numbers 3 A1 1 4 A1.1 101 5 A1.2 201 6 A1.3 301 7 A1.3.1 10301 8 9 B1 2 10 B1.1...

Hi, Short version: Someone knows about a VBA way to structure data under indented parent-tree when parent name is on same row in columns to the left? (Se bottom example) Long version: This is my first post here so please let me know if I'm writing this wrong. (Tried to read rules and search...

Hello, I wonder if some one can help me solve the folowing... I keep getting this error message "The specified formula connot be entered because it uses more levels of nesting than are allowed"...