Hi,

Put this in a cell and drag down 4 rows to get the top 5 in the range

=LARGE($A$1:$A$50,ROW(A1))

Mike

"yclhk" wrote:

How to show the top 5 of a series of numbers ? The numbers are updated
regularly. Formatting cells setting is expected but how to set the function
formula ?