Need to advanced filter the list and copy to different cell to show all of this

Question

Need to advanced filter the list and copy to different cell to show all of this together in one filtered table: numbers in column N greater than numbers in column M and less than numbers in column O or numbers in the top 15 % of column P.

insert Page Layout FormulasData Review View Developer Power Pivot Tell me what you want to do Cut Copy Format Painter Wrap Tot wrap Text Sort & Find & B l u. |-. . .. ___ Merge & Center. $. % , Conditional Format as Cell Insert Delete Format Formatting Table Styles Number Editing Investment Fund Type Size Categc Style Categ Risk Rank Return Rar Current Pri52-Week H 52-Week L Return 201 Return 201Rturn 201 Return 201 Return 201 Avg. Marke Fund Total Assets (Smil) 7 HRVIX Heartland Value Plus VASC Van Kampen Small Cap G 19.21 36.47 17.48 29.39 1927 8.39-10.89:23.45 21543.9 1586.64 12 HIMGX Harbor Mid Cap Growth 14 NMTAX Columbia Marsico 21st 5 TMCGX Turner Emerging Growth 16 VASVX Vanguard Selected Value 17 FDSSX Fidelity Stock Selector 18 VSGX Vanguard Small Cap Gro 19 EAVSXEaton Vance Small-Cap V 20 SSCTX RidgeWorth Small Cap G 1500 Domestic Small 21 LAUAX Columbia Acorn USA A 22 ARTQX Artisan Mid Cap Value 23 PRIDX T. Rowe Price International Discovery 24 CSCPX CMG Small Cap Value 1 29.55 65.5567 49.26 23.1910.86 14.65 17.34 958.1 Growth 27 HFMCK Hartford Midcap A 12.8 22.29 1111 35.8415.94 16.25 11.04 14.724122.81

Explanation / Answer

numbers in column N greater than numbers in column M

=IF($M$6:$B$27<$N$6:$N$27,N6:N27,)

numbers in column N less than numbers in column O

=IF($N$6:$N$27<$O$6:$O$27,N6:N27,)

numbers in column N greater than numbers in column M
and less than numbers in column O
or numbers in the top 15 % of column P.

=IF($M$6:$B$27<$N$6:$NC$27, $N$6:$N$27, IF($N$6:$N$27<$O$6:$O$27, $N$6:$N$27, IF(=SUM(LARGE($P$6:$P$27), $N$6:$N$27,))))

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.