Zoraya Cruz-Bonilla
New Member
Hello everyone,
I have an Excel spreadsheet which I am using a certain hierarchy to determine which school a student belongs to. The file structured has to have Home School and Second School. but I want to show the same information for duplicate records so that my data does not seem all scattered and is easy to manipulate later down the road during the analysis phase.
I know that Pivot Tables will allow you to repeat duplicates down a column but I don't know how to do this using a formula.
Example:
ID School SchoolHierarchy SchoolPlacement Home School Second School
123 Engineering 3 3 Engineering NONE
234 Nursing 2 2 Nursing NONE
567 Management 1 1 Management Nursing
567 Nursing 2 1 Management Nursing
If my formula states: For repeat IDs, if 'Home School' equals 'School', then the results should be the 'School' BUT if they are NOT equal then give me the value when they are equal (repeat the label 'Management') in the same column.
I have an Excel spreadsheet which I am using a certain hierarchy to determine which school a student belongs to. The file structured has to have Home School and Second School. but I want to show the same information for duplicate records so that my data does not seem all scattered and is easy to manipulate later down the road during the analysis phase.
I know that Pivot Tables will allow you to repeat duplicates down a column but I don't know how to do this using a formula.
Example:
ID School SchoolHierarchy SchoolPlacement Home School Second School
123 Engineering 3 3 Engineering NONE
234 Nursing 2 2 Nursing NONE
567 Management 1 1 Management Nursing
567 Nursing 2 1 Management Nursing
If my formula states: For repeat IDs, if 'Home School' equals 'School', then the results should be the 'School' BUT if they are NOT equal then give me the value when they are equal (repeat the label 'Management') in the same column.