<div>
Note, I have been using the rank =COUNTIFS($H$2:$H$27325,$H<wbr />2,$R$2:$R$<wbr />27325,&quot;&gt;&quot;&amp;<wbr />$R2)+1<br />
Which gives me the ranks like 1, 68,72, because of the duplicates.<br />
<br />
I could also use a formula that identifies which of those rankings are the top 10 for that group.<br />
But I need like a large formula or something like that?<br />
<br />
Thanks to anyone who can help me with this one!<br />

</div>


Euro5

<div>
Thanks Patrick! I do have 365 - I will try now!
</div>


<div>
<p>How about Pivot Table and filter to show only Top 10</p><p><br></p><p>See attached; amended the column Q values to make them unique.</p><p><a class="fr-file" href="https://filedb.experts-exchange.com/incoming/2023/10_w40/1625064/Sample.xlsx" rel="ugc">Sample.xlsx</a></p>
</div>


Sample.xlsx

<div>
<div class="content wysiwyg-content fr-view">
<p>I need to take a Weight column and rank it to find top 10.</p><p>Complications - there are duplicate Weights and I have to rank by group.</p><p>I attached a sample to help - column H is the group, column R is the weight.<br>I need to know the top 10, but the rest can be blank or have zeros.</p><p>I just need to know if they are in the top 10, not even the exact rank.</p><p>Hopefully the example will help!</p><p>Desperate - I have tried multiple solutions, but none that work for this.</p><p>Thank you!!!</p><p><a href="https://filedb.experts-exchange.com/incoming/2023/10_w40/1625057/Sample.xlsx" class="fr-file" rel="ugc">Sample.xlsx</a></p>
</div>
</div>



I need to take a Weight column and rank it to find top 10.
Complications - there are duplicate Weights and I have to rank by group.
I attached a sample to help - column H is the group, column R is the weight.
I need to know the top 10, but the rest can be blank or have zeros.
I just need to know if they are in the top 10, not even the exact rank.
Hopefully the example will help!
Desperate - I have tried multiple solutions, but none that work for this.
Thank you!!!
Sample.xlsx

Note, I have been using the rank =COUNTIFS($H$2:$H$27325,$H2,$R$2:$R$27325,&quot;&gt;&quot;&amp;$R2)+1
Which gives me the ranks like 1, 68,72, because of the duplicates.

I could also use a formula that identifies which of those rankings are the top 10 for that group.
But I need like a large formula or something like that?

Thanks to anyone who can help me with this one!


Thanks Patrick! I do have 365 - I will try now!


How about Pivot Table and filter to show only Top 10
See attached; amended the column Q values to make them unique.
Sample.xlsx

Rank in excel formula by groups

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

R is a programming language and environment used primarily for statistical data analysis.

Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.

REST

Statistical packages are software titles, such as JMP and GNU Octave, and programming languages, such as MATLAB, R and SAS, that are used to discover, explore and analyze data and suggest useful conclusions, either to learn something unexpected or to confirm a hypothesis. The field includes the design and analysis of techniques to give approximate but accurate solutions to hard problems in statistics, econometrics, time-series, optimization and 2D- and 3D-visualization. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.

Statistical Packages

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.