Large and Small Data

Mochammad Fawzi Wahyudi
New Contributor

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 Replies



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

Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies