Sorting formular

[issa.o]

Hi friends
i hope you are doing well.
I have data in my sheet named collector
i faced a big challenge of finding sorting formular automatic to get five best people with big numbers and five weakest people with the smallest numbers.
Apart from that i need to sort them based on their ***, as you can see to the attachment what i need i put it manual.
I need you help please.
My god be with you
thanks much

[issa.o]

See the output result i put it manual from column aa to av
AND THEIR IT IS BASED ON *** MALE OR FEMALE
i need your support

[thomglea]

Sounds like what you are looking for is the SMALL and LARGE functions. And to rank based on Male or Female, you need an array formula. Here is an article that can help with that array

https://www.ablebits.com/office-addi...nshot%20below.

[Gregb11]

Are you still on 2007 or have you upgraded since 2016. if you've updated to MS365, you can these formulas:

For 5 highest points:
=TAKE(SORTBY(B7:W40,T7:T40,-1),5)

For 5 Weakest (in order that you are showing them:

=SORT(TAKE(SORTBY(B7:W40,T7:T40,1),5),19,-1)

[issa.o]

I am in 2007
is this applicable to 2007?

[Gregb11]

Sorry, no.