• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula for Auto filter

sampath

Member
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
 
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.

upload_2015-8-25_17-20-51.png


Please suggest how to filter as my requirement.

Regards,
Sampath.S
 

Attachments

  • upload_2015-8-25_17-18-25.png
    upload_2015-8-25_17-18-25.png
    27.5 KB · Views: 0
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.
 

Attachments

  • month-year.xlsx
    8.9 KB · Views: 1
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
 

Attachments

  • Sample file.xlsx
    8.5 KB · Views: 1
Something like this?
Easiest to do with helper column.
 

Attachments

  • Sample file_S.xlsx
    12.9 KB · Views: 1
Back
Top