<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:"\.";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding:0px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>[TABLE="width: 65"]
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"]Hey guys, I'm new with excel esp in analysing data, sorry if this question is too basic for anyone that understand
So I've got this array of datas to work with, I need to find the top 5 values based on the the count of their names:
Hart[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]Crux[/TD]
[/TR]
[TR]
[TD]Manuel[/TD]
[/TR]
[TR]
[TD]Bryan[/TD]
[/TR]
[TR]
[TD]Bryan[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Crux[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Manuel[/TD]
[/TR]
[TR]
[TD]Ziko[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
Initially I use the countif to get the count number for each name (Adam=5, John=3, Crux=2, Manuel=2, Bryan=2, Hart=1, Ziko=1) and then I use Large function to get the top values, but because there are duplicates in two different columns (the names and the "2"s), I can't properly do that.
I did use pivot table and sort, and got the result easily (Adam - John - Crux - Manuel - Bryan), but I do need the manual formulas as well to complete.
anyone can help me please? thank you
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"]Hey guys, I'm new with excel esp in analysing data, sorry if this question is too basic for anyone that understand
So I've got this array of datas to work with, I need to find the top 5 values based on the the count of their names:
Hart[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]Crux[/TD]
[/TR]
[TR]
[TD]Manuel[/TD]
[/TR]
[TR]
[TD]Bryan[/TD]
[/TR]
[TR]
[TD]Bryan[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]John[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Crux[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Manuel[/TD]
[/TR]
[TR]
[TD]Ziko[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
Initially I use the countif to get the count number for each name (Adam=5, John=3, Crux=2, Manuel=2, Bryan=2, Hart=1, Ziko=1) and then I use Large function to get the top values, but because there are duplicates in two different columns (the names and the "2"s), I can't properly do that.
I did use pivot table and sort, and got the result easily (Adam - John - Crux - Manuel - Bryan), but I do need the manual formulas as well to complete.
anyone can help me please? thank you