I have an unsorted list of 240 elements and I am trying to find the 7th largest and smallest elements of the 240 in the list.
I would like to do this automatically, without having to sort the list or as the list keeps changing.
Thanks in Advance!
I have an unsorted list of 240 elements and I am trying to find the 7th largest and smallest elements of the 240 in the list.
I would like to do this automatically, without having to sort the list or as the list keeps changing.
Thanks in Advance!
Hi,
I'm assuming you are talking numbers in a list, if so then
=LARGE(A1:A240,7)
=SMALL(A1:A240,7)
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
That'll do it. So easy, but would never would have thought of it.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks