<div>
Hi NCGPIICT,<br />
<br />
What is it exactly that you want to hide? A group of what?<br />
<br />
If you only want to hide some cells you could easily use conditional formatting.
</div>


Hi NCGPIICT,

What is it exactly that you want to hide? A group of what?

If you only want to hide some cells you could easily use conditional formatting.

<div>
Or you could use filtering.<br />
<br />
with filtering you can manually select the values that you want to be visible, but you also have the option to only show values above / below / equal to / above average / below average / top 10 etc
</div>


Or you could use filtering.

with filtering you can manually select the values that you want to be visible, but you also have the option to only show values above / below / equal to / above average / below average / top 10 etc

<div>
user has large spreadsheet of about 20,000 records, on the column called loc id they are grouped into subtotals showing the count, the user wants to hide all groups that have a lower count than 2.
</div>


user has large spreadsheet of about 20,000 records, on the column called loc id they are grouped into subtotals showing the count, the user wants to hide all groups that have a lower count than 2.

<div>
<div class="content wysiwyg-content">
is there anyway i can hide a group if the count is greater than a certain number
</div>
</div>


is there anyway i can hide a group if the count is greater than a certain number

Excel

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.