Formula for Auto filter

[sampath]

Hello,



Actual

In my excel ( sheet1), range A1:A100 having date's in dd-Month-YYYY.

Requirment

In same workbook (Sheet2), Need formula in B6 to filter the Actual range(Sheet1!A1:A100) in Month and year based.

Please clarify the same.

Regards,
Sampath.S

 

[Chihiro]

No sure what you are looking for here. Are you trying to get all data from "sheet1" that meet your filter criteria?

If so, use Advanced Filter function.

See link for explanation.
http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters/

 

[sampath]

Hello Chihiro,

Thanks for your reply, Here when using filter / drop down list, which is shown all dates in the list, but I need to filter based on month and year.




Please suggest how to filter as my requirement.

Regards,
Sampath.S

 

[Chihiro]

So, what you want is Combo list filled with Month & Year only and not dates?

If so, see attached on how to filter for only unique mmm-yy.

What is the Combo list controlling?

I'd need the Excel sheet to give you recommendation beyond this point.

 

[sampath]

Hello Chihiro,

I have attached my sample excel file for filtering option.

In this excel, Range C4 has input dates and need to filter the output in H6 and same time no. of months should be displayed in H6.

Kindly provide the suggestion as my requirement.

Regards,
Sampath.S

 

[Chihiro]

Something like this?
Easiest to do with helper column.