<div>
<div class="content wysiwyg-content">
Is it possible to return the most common value in text via the subtotal function?<br />
<br />
To count the cells would be =SUBTOTAL(3,H9:H60000)<br />
<br />
The average function wouldn't work because it would deal with numbers. Alternatively is it possible to display the most common number?<br />
<br />
Thanks for your help
</div>
</div>


Is it possible to return the most common value in text via the subtotal function?

To count the cells would be =SUBTOTAL(3,H9:H60000)

The average function wouldn't work because it would deal with numbers. Alternatively is it possible to display the most common number?

Thanks for your help

Subtotal formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.