I'm attempting to create a formula that reads a range of cells using MODE.MULT and an array to determine the top 5 most occurring numbers in order from greatest to least and have it continually update as data is entered. Here is the formula i am using now (which is not working)
=MODE(IF(ISNA(MATCH($E$4:$E$499,$E$501:$E501,0)),$E$4:$E$499))
This was giving me a circulation error for a reference in the formula so i went in and enabled iterations under formulas...still no success. Is all i am looking for is to get the top 5 most occurring numbers in order from greatest to least from E4:E499 and get the answers to read out starting in E501:e506...i'm no excel genius by any means so...at this point i'm just looking for an answer...i'm quite frustrated with this one. my file is attached.
Bookmarks