I have a list that includes both blank spaces and text values. How would I
go about finding the 'mode' of the text, while excluding the 0's? For example,
Say this is the list of values I have. Clearly, AA is the most common text.
However, blanks are the most common character. Auto-filter will not work,
since I need this 'mode value' to appear on a separate line, so it can be
linked to another part of the spreadsheet. I use Office 2007. Thanks for the