Hi,
Is there an array formula for eliciting the top five strings by frequency of occurence, not unlike what the LARGE array function does for integers?
For instance, I might have a list of thousands of alphanumeric codes under column A: how do I figure out what are the top five most frequently occurring codes? (I'm dealing with ISIN codes, if it matters.)
I realize a similar question has probably been posed here before but I found it difficult-impossible to search...
*(Also, not necessary and I hate to be a pain, but if you could explain the formula, it might be of great benefit. For instance, this one just confuses me to no end: why do you need the ROW and INDIRECT elements? I've tried it without and it spits out an error:
)
Hope you can help!
Thanks,
Derek
Bookmarks