org

Hi I have an excel sheet with two columns <tbody> ABC Org Assist Prod-Pers Care/Safety Disability Safety Whole Family Health Interpret/Translate Assist Prod-Pers Care/Safety Personal Mobility Equipment Early Childhood Supports <tbody> Visability Ltd </tbody> Service1...

Hi, I'm seeking to effect the most robust way a user can to drill through 57k rows of organisational hierarchy in a cascade style. <ul> <li>My ask is to create a tool for users to log business services. So it needs to be quick and robust and intuitive</li> <li>There are 8 levels of hierarchy...

I have an organizational chart that has approximately 15000 employees and is about 8 layers deep. I'm trying to associate all employees to their respective "Vice President". So far I've got a recursive vlookup but it seems unstable and messy. I've tried also creating an index table, but...

I have been racking my brain and gotten stuck. I have a list of ids. Each id has the manager that incumbent report to. The list is from CEO down to bottom of org including every employee. (~46k rows) The list is in no particular order. What I would like to do is analyses on what level each...

Dear Friends, It would be helpful if someone can help me with following issue. I have an excel sheet attached in the below link. I have two sheets one which i recieve as an input(org). This input sheet should be converted into another sheet(sheet 3) of different format with datas from the...

Hello, This is my first time using this forum so please be gentle. Your time and help would be greatly appreciated. I've built a list of all zip codes in the US with their corresponding organization code, of which there are ~100. A total of ~42k rows. I now need to group the data in a...

Hi All, I have a simple sheet of names and roles that I need to send out to about 60 different people. The sheet has all data filtered out, and the recipient selects their organization from a drop down filter, which shows their portion of the sheet. This all works well as is. What I would...

Good Day All , Need Help , Im trying to write a formula that will return sorted values base on two criteria, currently working with one . Example is below, Data is from Sku to Ranking . Formula is written on the Answers line.. i need the formula to return the values per "PK" line base on the...

Good Day All , Need Help , Im trying to write a formula that will return sorted values base on two criteria, currently working with one . Example is below, Data is from Sku to Ranking . Formula is written on the Answers line.. i need the formula to return the values per "PK" line base on the...

Hi All I hope this makes sense to some of you! Because after my fruitless attempts it makes less sense to me now that when I started out! I have this data (this is a fictional representation of the names!) in an excel worksheet tab called "Confirmation Forms" - <tbody> A B C D E F G 1...

I need help! I have two columns. Column A is a list of position ID and there are multiple rows for one value. Column B contains a corresponding org unit ID such that each position ID can have 3 to 5 org unit IDs linked to it. I have identified a list of org units that will be tagged as central...

I have created an Org Chart, but due to the size of it I want to generate rollovers, so hover over a name and a larger personalised image appears with the individual's details - name, role, grade, email, tel etc. Is there a simple way to do this? TIA

Trying to get the result in C8 and D8 to read 480 and 480 respectively using the following formula: =IF(OR(AND(G1=A8,B1="BAN"),AND(G2=A8,B2="BAN"),AND(G3=A8,B3="BAN"),AND(G4=A8,B4="BAN")),INDEX(C1:C4,MATCH(A8,G1:G4,0)),"") The result does not sum both 240 listed in C1&C2, C3&C4 respectively...

Hi, does anybody know if it is possible to use two VLookup formuals in one cell, then present the result of that formula to display one answer? Currently I have two columns, to identify from another set of data, postcodes. Column T formula is: =VLOOKUP(A5,'Org...

Hi guys, I have a project where I need to be able to export the details of an org chart to excel, and vice versa. the stuff in the chart includes employees titles for some and shows who is under them. I am not sure how to go about this, or if there's even a way to do this. any and all support is...

Hi, im fairly new to ms access, and im working with org charts for this project. I wanted to know if there is a way to extract the data from an org chart and store it into a database or vice versa? I saw some ways using visio, unfortunately i dont have access to that. any and all help would be...

Is it possible to use Index/Match to create an Org Hierarchy? For simplicity sake I've put in a few columns. So since the manager is Steve in B2, C2 would populate with Steve's manager (Marcia). A result of that D4 would populate with Marcia's manager (Andrew). A1: Employee Name (John) B2...

Hello, I have an OLAP Pivot. There is a Value in one of the rows that I want to move to the end. The field is called "Top Customer", the value is "All Other". The vba recorder produces this: ActiveSheet.PivotTables("PivotTable3").PivotFields( _ "[Sales Org Hierarchy].[Top...