attempted a formula to bring back the top ten most repeating values that match a criteria. So far I'm using...
Formula:Please Login or Register to view this content.
to get the top ten reoccurring numbers, then in the next column using
Formula:Please Login or Register to view this content.
to show the number of times the number occurs in the range. How would I show how many times the number occurs in the range for just one criteria ignoring any blank cells in the range? I've attach an example.
Attachment 614490
Bookmarks