Grouping and showing items only once..?

So the story goes something like this...

I've got a complete chart of accounts, and a report which I run which utilises only some of these accounts.

I will have another sheet which will only show the accounts used. The report will get run and populated based on the accounts being used (which may occur multiple times in the report), and the end result is a report which shows total amount, per account.

What's the best way of doing it?

VLOOKUP won't work... it's a multiple item lookup.

Basically - report will have accounts in no particular order, multiple times - the main chart of accounts has them all in order, but I don't want to show them all.

Would like to be able to avoid using filters, too, where possible.

Originally Posted by sglife

Please give us a file if possible.

I was going to do that today when I got into work

So here's the file - worksheet 'Report' is a very summarised extract of the report of what would come out from the system, and 'Chart of accounts' is the full chart of accounts (which I don't want to use in the new sheet I want to show).

Basically, Sheet3 will contain a new page, which will only list the accounts which are used, and in ascending order.