Getting top 5 values in a list of numbers

  • Thread starter Thread starter Roel
  • Start date Start date
R

Roel

Hi,

I would like to know if there is a way to get the 5 largest values in a
list of numbers. I know using MAX would only get the largest. I would like
some rountine that would do it.


Thanks very much!

Roel
(e-mail address removed)
 
=LARGE(TheList,k)

k being any value from 1 to 5 for your purposes.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pick the second largest value in a data set? 5
Finding Next Largest Number Based on Criteria 3
Return Largest Value in an Array 3
Formula (or code) return the largest number of duplicates in a list. 16
chart - in order of high to low 2
Weighted randbetween text list 3
Routine for sorting within a selection 1
Get user profile in ASHX 1

Back
Top