Find, then find next

Hello,

I need some help with the following problem:

I've got a generated list with data which is build on the following way.

Team 1
Monday
user 1 data
user 2 data
user 3 data

Team 1
Tuesday
user 1 data
user 2 data
user 3 data
user 4 data


etc....

The list shows the whole week for 20 teams

The trick is that i want a list with specific users of a specific day,
See the example for details.

Anyone an idea?

Is it possible to restructure your data or is it that you have old files to process?
With a better data structure, you could use pivot table to get your output.

Originally Posted by p24leclerc

Is it possible to restructure your data or is it that you have old files to process?
With a better data structure, you could use pivot table to get your output.

Sadly no,

the data is delivered in this specific output.
there is no possibility to change it.

Try this. Macro add two columns and filter. In column B you choose day, in column D choose unique user id.