Listing data from data table without a pivot

[benoj2005]

Anyone able to replace the pivot tables with formulas.

Listing info from data table2.xlsx

I've tried a countif + index amalgamation but I'm struggling unless the data is sorted by category, but I want it done without any sorting.

[Fotis1991]

I believe that the easiest way-without array formulas and not even drag down is an advanced filter. You can do this using the option in control panel or recording a macro like i did!

Please Login or Register  to view this content.

[benoj2005]

Thanks thats a new method, I'd prefer a formula based one though

[Fotis1991]

See this.

http://www.excelforum.com/excel-gene...uplicates.html

[mahju]

Hi

Try this one

There are two supportive column Column A to create Category list and column B to create Invoice list.

Used sumproduct to calculate the totals

See attached sheet