How to apply filter

[Ratan Bhushan]

Hi Team

I am uploading a file in which I have to apply filter more than two times.

First filter I have to apply on column c where I want to keep only "NOIDA" site data
Then next filter I want to apply on column f where I want to keep only data for respective "D" only

Then last filter I need to apply on column D where I want to select few skills which are more than 5 or 7, so this is the last part where I want to keep only these 5 or 7 skills data always

So how can I achieve this
I am uploading the file please help team.

Thanks and Regards
Ratan Bhushan

 

[Luke M]

Stick in a helper column, with a formula to CountIF the records on col D, and it becomes a snap. I converted the data to a table for the structural reference, but you don't have to.

 

[Ratan Bhushan]

Stick in a helper column, with a formula to CountIF the records on col D, and it becomes a snap. I converted the data to a table for the structural reference, but you don't have to.

Luke Sir

I didnt get the way you sorted out problem Please to help me understanding this

 

[Luke M]

I added a new helper column. Helper column has a formula doing something like
=COUNTIF(D:D,D2)
This lets us know how many of each item there is in the table. Then, we can filter like you said.
Filter C = "NOIDA"
Filter F = "D"
Filter Helper column: ">=7"

The last one I wasn't quite sure what you wanted, but hopefully am pretty close. You can even filter to pick multiple numbers, if that's how your statement should be interpreted.