List unique values with multiple conditions

[erlend]

Hi folks!

I have a hopefully simple question that I would appreciate if anyone can give me some support on. I'll try to give a simplified example to describe what I need.

I have a list that I extract regularly from a database with projects with certain attributes. Setup looks something like this
Column A: Project ID
Column B: Project Name
Column C: Organisational Unit
Column D: Country
Column E: Cost type (external cost, internal man hours etc)
Column F-R: Actual project cost and project forecast

This list usually contains between 400 - 600 rows.

What I'd like to do:
In a separate sheet I'd like to list and sort the same data, but without the Column E (cost type). Values in column F-R are easily handled with sumifs formulas. This means that I in some way need to list unique values based on column A-D, and every time I paste an updated extract from my database, the project list will be updated and sorted with a custom sort filter (on column C, then A, then D. Sorted on values in order A-Z).

I guess that I might need to use makros for this (which I'm not very experienced with), but I hope someone can give some simple input on how to do this.

Thanks a lot.

/Erlend

 

[Andrew Poulsom]

Have you tried a pivot table? You can have a dynamic source:

http://www.contextures.com/xlPivot01.html

 

[erlend]

Hi, and sorry for being unclear on this. I cannot use a pivot table, since I have to map other data as well to the table in the target sheet. The input from the database (column A-D) builds up the main structure in the target table, but then I'm connecting data from other tables as well which contains a huge set of formulas. These formulas can be static though since they look up the correct info/values based on project ID, country and period.

 

[Andrew Poulsom]

Why can't you create a pivot table from columns A:D? What version of Excel do you have? It may help to see some sample data.