Dinamic List with group by

Hi and welcome to the forum

Heres what I did. I did this manually, but you could record a macro to do it automatically.

I copied your table off to the side - you could do this in the original table if you dont mind losing it, or you could just copy it some place else - then used "remove duplicates" and ended up with the same as the table you have on the right.

And by the way, your profile says 2003, but the file you uploaded is at least 2007??

Or

Use Pivot Table, refer the attached file for details

Hello,

I was hesitating to post an answer until FDibbins pointed out that your sample is .xlsx ... The reason is that, in my formula I used COUNTIFS, which is only available for Excel 2007 and later.

Here is a glace at the formula

Please Login or Register  to view this content.

I know it is not elegant, but it does the job.

Here is a sample file with formula that will automatically pull unique data out of your table. All you have to do is dragging the formula down as far as you see blank (In the sample file attached, I dragged it down to row 12).

All of the formulas are Array, so make sure if you copy paste / edit it, hold Ctrl-Shift and hit Enter if you want to enter it (If you do it right, you will see the formula wrapped inside a { } ).