How to filter out records and dependency on other column

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
How to filter out records and dependency on other column?
I have attached a sample data to elaborate my problem.

Assumption: the source data cannot be modified.
I want to show the FAMILY which have at least 1 "F" in SEX column.
 

Attachments

  • excel2010_sample_filter_depend_on_other_field.xlsx
    12.7 KB · Views: 49
Add a column to the data with a header of say Test and a formula of

=COUNTIFS($A$1:$A$14,A2,$C$1:$C$14,"F")>0

Then add Test to report filter on the pivot and filter for True
 
Add a column to the data with a header of say Test and a formula of

=COUNTIFS($A$1:$A$14,A2,$C$1:$C$14,"F")>0

Then add Test to report filter on the pivot and filter for True
Sorry to inform you that I cannot modified the data source.
I connect as external data source since it is modifying regularly so that I will not copy to local.
 
Sorry to inform you that I cannot modified the data source.

So why not retrieve it to an Excel table. It will still update for you when you open the workbook. Base your PivotTable off the table in the workbook, and you can do what you like to that data source...
 
So why not retrieve it to an Excel table. It will still update for you when you open the workbook. Base your PivotTable off the table in the workbook, and you can do what you like to that data source...
If I retrieve to an excel table, it will become a offline data only but not a live data.
The source excel data is modifying every day.
 
So you retrieve it every day. That is an easily automated task.

What version of Excel are you on?
 
The I suggest that you use PowerPivot to query the data source and manage it there.
 
Back
Top