Is it possible to name filtered criteria in Advanced Filter?

[ie1002]

If you have a table of data, say:

Name	Age	Gender
John Smith	45	Male
Jane Smith	44	Female

<tbody>
</tbody>

To which you apply an advanced filter which returns cells with ‘Male’ in the Gender field, is it then possible to assign a name to that filter i.e. return a separate column which will say ‘Men’ for all rows containing ‘Male’?

That would essentially give you mapping for the various filters so that Males would be Men and Females would be Women in this scenario. Is it possible to do that without having that specific mapped column in your source data?

 

[Yongle]

Have a look at Custom View (see View tab)

It allows you to save many different views of your data
- save a view with male filter
- save a view with female filter

 

[allstarphg]

guys, ineed help how to separate male and female result with high to low sorting?




NAME SCORE
max 5
william 3
susan 7
john 7
cindy 9
lucy 2
thomas 4
jacob 11
lily 9


male score (high to low) score female score (high to low) score

 

[RoryA]

Do you have a gender column somewhere?

 

[allstarphg]

i have,somehow i cannot attach the xcell file here,any help?

 

[RoryA]

Just include that column in the sort then.

Also, for future reference, please note the forum rule on cross-posting and comply with it. Thanks.