Formula to bring month and date from qtr selected

[rizmomin]

Hello:

Please refer to attached file.

Based on Qtr selection in cell A15, i need formula in
cell A16:C17 to give me month and date from data
in cell range B1:D12

Let me know if you have any questions.
Thanks.

[Fluff13]

How about
In A16 dragged right
=INDEX($C$1:$C$12,AGGREGATE(15,6,(ROW($B$1:$B$12)-ROW($B$1)+1)/($B$1:$B$12=$A$15),COLUMNS($A16:A16)))
in A17 dragged right
=INDEX($D$1:$D$12,AGGREGATE(15,6,(ROW($B$1:$B$12)-ROW($B$1)+1)/($B$1:$B$12=$A$15),COLUMNS($A17:A17)))

[alansidman]

An alternative solution is to create a parameter query in Power Query. The file attached does that for you on Sheet 2.

You will need to create the parameter using the technique displayed in this video.

https://www.youtube.com/watch?v=gK2yBpiITvI

The file which uses this technique is attached.

Mcode for the parameter is

Please Login or Register  to view this content.

The Mcode to make it all happen in your table

Please Login or Register  to view this content.

[rizmomin]

Hello Fluff and Alan:

Superb ...

Thanks

Riz

[Fluff13]

You're welcome & thanks for the feedback.