Get top 10 values but ignore with blank cell if there's less than 10 values

Edited for clarity and typos.

Try array-entering this formula in H15. All the machine numbers agree with the last two expected machine numbers except the last two ...... 13 and 3. My results are reversed and I believe correct.

Formula:

Please Login or Register  to view this content.

It also doesn't report machines that were not used.

I changed your array formula in F15:F24 to

Formula:

Please Login or Register  to view this content.

in order to trap errors and not return users who had used machines "0" times.

In the formulas that had the LARGE k argument hardcoded like this

Formula:

Please Login or Register  to view this content.

I changed to

Formula:

Please Login or Register  to view this content.

Hard coding those numbers makes things more difficult than they need to be. Using ROWS($1:1) increments more easily. I changed that in other formulas where it applies. It also traps errors by not returning 0s.

I also changed the formula in C15:C35 to

Formula:

Please Login or Register  to view this content.

I believe you will find it to operate more smoothly and easier to follow.

Anyway with the exception of the reversed 13 and 3 these results agree with your expected in J15:L24, and where there were no users the cells show blanks.

Let us know what you think.

Hi

This is non-array formula

you on excel 2010? use Aggregate!

K15

Formula:

Please Login or Register  to view this content.

copy down.

J15

Formula:

Please Login or Register  to view this content.

copy down.
or

Formula:

Please Login or Register  to view this content.

copy down

L15

Formula:

Please Login or Register  to view this content.

copy down.
or

Formula:

Please Login or Register  to view this content.

copy down

See the file.

Regard

Good to hear. Thanks for the feedback.

BTW I almost forgot to mention it. micope21 is who I learned that SMALL(formula,COUNTIF()) approach from.