Formula help

[b777rky]

Hello,

Let s say we have this columns and rows
1. A. B. C. D.
2. Name. 01.04.2018. 03.04.2018 2
3. Name. 05.04.2018 10.04.2018 5

This is the Main Page on my worksheet.
My questions is, i need to sort all period only 'month' and all names from that period i want must be în other Sheet , how to do that? Tried with vlookup.. Index&match but no luck.
If you could tell me please... I can t sort...because i have another criteria for sort

 

[actjfc]

If you do not know Pivot Tables, try to learn the basics of Pivot Tables, watch a short video on Youtube. If you create a Pivot Table, you may choose to show column A and Group B by months as a Filter or Rows in a Table. It can be done in minutes, but you need to discover the wonders of the pivot tables. I hope it helps!