- last edited on
i want to know how to find 5 largest datas and 5 smallest datas between 2 criterias ini my A1:A544 and B2:FU2
Do you mean largest/smallest in combination of both of your ranges or for each separately. And what are criteria?
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