Filtering

Hello,

I do not know, why I did not solve this, but I would need to have a filter to following situation:

A1 I have names, B1 months and C1 payments.

What Id like to to, is that when I select for example "John" from column A, it would then show all payments from every month detailed (if I do not filter month also). Then excel would look like A2 "John", B12-B13 months under each other, C12-C13 payments under each other.

Then when new person comes along, I could just add the name on column A, and then all the months would be automatically added to that name (saves a lot time when not needed to write for example "january" every time for very person.

I am not sure if you got the point?

Best Regards,


T

Hi,

Thank you a lot for reply.

I know I could make some kind of advanced filter, but the lay out would be messy for me. And for this purpose I did not find with a rapid look any correct video or help with Google.

Please see the attachment, this is just a simple example. Then for this way, I'd like to add no name just to column A when no filter is selected, and it would automatically add this to the list.