Mr Excel & excelisfun Trick 8: Top 10 Filter Trouble

See Mr Excel and excelisfun try to deal with the Top 10 Filter with Two Criteria Trouble. Mr Excel solves the problem with Advanced Filter and a Criteria Formulas. Excelisfun solves the problem with a series of formulas.

Related Video:

MrExcel's Learn Excel #1005 - Dueling: Top 5 For a Golfer

Category:

Science & Technology

Tags:

• Excel
• Filter
• Top
• Ten
• 10
• Advanced
• Array
• Formula
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Duel
• Dueling

[MrHelal123]

I did not even know what a cell was before i watched your videos. I look forward to your replies on the questions asked and once again, thank you so much. I dont know how to reward and thank you enough for your support but i really do mean it.

[ExcelIsFun]

Rate all video 5!

[MrHelal123]

Mike how in this video you showed how to extract the bottom scores. But what if there are duplicate of bottom scores, whats the formula to have it skip the duplicate scores and move to the next lowest score. i,e 1 2 2 3 4 5 i would want the bottom 5 scores to be 1,2,3,4,5 and not 1,2,2,3,4 (so basically skip the duplicate value of low scores)

[ExcelIsFun]

I don't know. You might have to post this question to the Mr Excel Message Board.

[gajukrish]

ok thank you very much, you'r really great for helping others.

[ExcelIsFun]

You are welcome!

[1022roland]

Mr. Excel, I would like to ask if the given is like this figure (shown in below), what would be the formula to be use? I tried this but shown #NUM! I really appreciate if you will answer my concern. thanks....

Name  Data

Tom basketball

Tom baseball

Tom soccer

Fred volleyball

Fred football

Joe chess

Joe dark

[MrHelal123]

Mike i know i have sent you a few mails, and questions in regards to dynamic index chart (to extract top 3 values rather than last 3 values) and a few other questions in regards to reverse 2 way look up (0, in the index argument for the row criteria etc)...I really appreciate your support and with your explanation and help, i am learning and becoming better with excel.

[ExcelIsFun]

I will make a video, but not for at least a week.

=IF(AND(I3="",K3="",L3=""),"", formula)

just says if cell I3 and K3 and L3 are all blank, then show a blank in the cell, otherwise show the formula.