Dynamic Ranking (Top 5 Customer) - Sumif Array / Sumproduct - with Criteria, Ignoring #N/A

Hello Excel Experts!

I'm trying to create a dashboard here that could automatically spit out the top 5 customers for each month, ignoring #N/A.

Since it's per month basis, therefore, top 5 customers could change every month, thus it's dynamic.

In the attached, I've given a sample of a full data, and a pivot table (NOTE: Pivot and Data does values not match)

As you can see in the "Desired Result" sheet, that's how my dashboard will look like per month. These results were taken through pivot table (manual sorting each month largest to smallest and copy and paste). IF POSSIBLE, I would not like to have a pivot table (to save time creating a macro to refresh the pivot table and sorting each month). But if it's un-doable, or it'll take the macro to run longer, I'm OK in getting the final results through pivot table.

If my explanation is not cleared, I hope that the attached file would clarify further!

Your input and help is greatly appreciated!

Pl see attached with ARRAY formula and without helper columns.

First of all, THANK YOU so much for all of your contribution!

nflsales, is so far the closest to what I want, with the use of a helper column! That being said, the reason why I wanted it to be this way is for "tracking" purposes as well. So that if in a given month, the previous top customer suddenly changed, or has a new top customer, then we'll be able to know.

That being said, since I would incorporate this with a macro, wondering if there's anyway that I could get away without a helper column? If not, I'm happy with the result that nflsales has given!

nflsales, care to explain a little of your formula on the helper columns? I'm assuming that the helper column is taking only the top 5 customer, ignoring the #N/A in each given month?

I'll mark this thread as solved for now! Reps up to you nflsales, and of course everyone who helped!

Thank you once again!