Is it possible to apply filter on the same sheet.

[Jagdev Singh]

Hi Experts

I have a list of data. I am looking to add filter on 2 columns, whenever I add the selection the list in column K and L, the sheet should give me filter data based on it.

Regards,

JD

 

[Hui]

I would first get rid of the duplicate field names in Row 1

Then do as below using the Data, Advanced Filter menu


Result

 

[Jagdev Singh]

Hi Hui

Thanks for looking into it. The duplicate entries should be captured in it. I find a post of Chandoo which filter such data but from one sheet to another. Is it possible to add the same functionality in the same sheet.

Regards,
JD

 

[Hui]

But there is only 1 record which matches 15/05/2015 which is in Row 2
If you want all Jaggi, leave L2 blank

 

[Jagdev Singh]

Oops sorry my fault. The dates need to be same. I amended the sample file now.

Regards,
JD

 

[Hui]

Use:


Result:

 

[Jagdev Singh]

Hi Hui

Thanks for sharing this feature. I was not aware of it.

Regards,
JD

 

[Hui]

If you want a formulaic approach have a read of:

Lookup and summarise a range based on Criteria
Single Criteria
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
Multiple Criteria
http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

Or read up on using Slicers with Pivot tables

 

[Jagdev Singh]

Hi Hui

The links are informative!

Regards,
JD