Need help with complex filtering

[KoolYute]

**Excel 2010/ Windows 7

Hi,

I am seeking help to resolve a complex (for me that is </SPAN></SPAN>) filter in a worksheet.
I want to filter advisors with a score of 100% on all lines that they appear.
Examples are advisors (#3, #5 and #9). They have 2 lines of entry but only #5 has both lines with all 100%.
When I do my filter it is returning #3 and #5 as well as they have 1 line of all 100%.
Is there a way to filter only if both or multiple lines have all 100% ?

Your help will be greatly appreciated.

Thanks in advance,


BJ.
</SPAN>
*** See sample below***

TM Name Advisor Name Apr May Jun Jul</SPAN>
Supervisor#1 Advisor#1 100 100 85 80</SPAN>
Supervisor#1 Advisor#1 100 75 80 100</SPAN>
Supervisor#2 Advisor#2 100 100 81 100</SPAN>
Supervisor#2 Advisor#2 100 85 100 100</SPAN>
Supervisor#3 Advisor#3 100 100 100 100</SPAN>
Supervisor#3 Advisor#3 96 91 100 98</SPAN>
Supervisor#3 Advisor#4 100 100 81 </SPAN>
Supervisor#3 Advisor#4 88 86 </SPAN>
Supervisor#1 Advisor#5 100 100 100</SPAN>
Supervisor#1 Advisor#5 100 100 100</SPAN>
Supervisor#3 Advisor#7 95 36 77 82</SPAN>
Supervisor#3 Advisor#7 52 100 60 82</SPAN>
Supervisor#1 Advisor#8 100 90 100 100</SPAN>
Supervisor#1 Advisor#8 100 96 100 59</SPAN>
Supervisor#2 Advisor#9 64 100 100 76</SPAN>
Supervisor#2 Advisor#9 100 100 100 100</SPAN>
Supervisor#2 Advisor#10 100 100 85 89</SPAN>
Supervisor#2 Advisor#10 79 100 100 100</SPAN>

 

[ranman256]

make an extra col. that has the condition: if( apr=100 and may=100 and...) then TRUE
filter on that col if =true

 

[KoolYute]

Thanks for the reply.
.. but is'nt that still going to leave me with 1 line returing a True and 1 returning a False for Advisor#3 & #9?

I want to show the advisor only if both lines have 100s or in your example return True.




Thanks,

BJ.

 

[ranman256]

you could then pivot that and get those where: true count = TM name count