Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a structure like this Current Department/Responsibility unique code/Target Department

I want to create a new sheet where I will put down all the new departments(target departments) and draw all responsibilities that refer to each one of them. The problem is that it is a one (Dpt) to many (resp.) relationship and I don't know how can i add the necessary lines.

share|improve this question
    
You could create a list of unique Responsibilities by inserting a Pivot report to a new Excel sheet. Then you could copy the resulting list into another new sheet and use the Excel function VLOOKUP to find the referenced Target Department. VLOOKUP is explained here: grbps.com/Excel6.pdf An alternative to the Pivot report is to copy the responsibilities and use the Data menu to sort the list and remove duplicate entries. –  Axel Kemper Apr 12 '13 at 14:59
    
thank you Axel I like the Pivot solution although it will need some manual adjustments –  Theodore Apr 12 '13 at 16:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.