Create Loop to visualize unique values from table

[jonas-martens]

Hi All,

Excel with example attached.

I would like to create a loop which visualizes all unique tax numbers with customer name and total €, and within this: all invoices per customer.


Formatting is not mandatory. I'll take care of that.

I've tried with a "for each... next" loop, but this generates ALL values. Not only the unique ones.
I'm stuck...

thanks in advance
J

[Mumps1]

Try:

Please Login or Register  to view this content.

Start with a blank destination sheet.