Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel

Posted on 2011-02-24
4
Medium Priority
?
263 Views
Last Modified: 2012-05-11
is there anyway i can hide a group if the count is greater than a certain number
0
Comment
Question by:NCGPIICT
4 Comments
 
LVL 6

Expert Comment

by:Cesar Aracena
ID: 34969394
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.
0
 
LVL 19

Expert Comment

by:Arno Koster
ID: 34969474
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
0
 

Author Comment

by:NCGPIICT
ID: 34978603
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.
0
 
LVL 9

Accepted Solution

by:
cool_sathish_333 earned 2000 total points
ID: 34980684
As per your comment, I understand that there are columns for Sub total. You  can use =COUNTIF(range, criteria) where range is the cell range and the criteria is the condition to count. Do visit the link,

http://office.microsoft.com/en-us/excel-help/countif-HP005209029.aspx

Hope that helps..
~Sathish
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question