Large and Small Data

[Mochammad Fawzi Wahyudi]

i want to know how to find 5 largest datas and 5 smallest datas between 2 criterias ini my A1:A544 and B2:FU2

[#2]

Hi,

Do you mean largest/smallest in combination of both of your ranges or for each separately. And what are criteria?

[#3]

yeaaah i were search for the formula small and large

and now i found the way to combine between small/large and index+match :D