What formula should be used to determine the top 5 numbers within a multi page Excel® spreadsheet?

Paste this in your spreadsheet, anywhere on row 2 (I entered it in cell R2)

=IFERROR(MODE(Sheet1!$A$1:$L$16, $A$1:$L$16),"")

Now, in R3:

=IFERROR(MODE(IF(COUNTIF(R$2:R2, Sheet1!A$1:L$16)=0, Sheet1!A$1:L$16), IF(COUNTIF(R$2:R2, $A$1:$L$16)=0, A$1:$L$16)),"")

This is an array formula, so confirm this with CTRL + SHIFT + ENTER.

R3 will show the 2nd most frequent #, so copy down to R6 to get your top 5 frequently occurring numbres.

Change the sheet name to fit your sheet name if it's not Sheet1, and change the ranges to match your specific ranges on each sheet.

As always, let me know if you need any further assistance with this.

Best ranking sites.

I've seen a lot of the site.

I think the best.

Website:http://9nin.com/