• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hiding rows working with pivot tables

C

Countess

New Member
Trying not to use macros, I want to see if there is a way to filter information in sections and not have empty rows showing between the sections. Each section, based on the criteria selected, can contain 1-20+ lines and it’s not a set number for each criteria.


I’m experimenting with a couple of options:

1) Using multiple pivot tables, but since, for example, in section 1 I could have 2-10 lines based on the criteria – Say PivotChart1 covers row 1-10 and I start PivotChart2 on Line 11, if a criteria only fits 2 rows, then rows 3-10 would be empty and don’t want that extra space.

2) I thought I might be able to get around the blank lines by using the copy/paste feature and paste the information where I want it in the excel sheet, but I still have the issue of the blank lines.


Not only have I not worked with macros, I’ve read and found macros are not compatible with SharePoint where this excel may wind up going. Was hoping there was a formula that would hide rows based on criteria (if A, B and C is selected, then only show rows containing cells with A, B and C) – if that exists, please let me know as that as well.


If I have to end up using a macro, please make a simply/step-by-step as possible.


Many thanks.
 
I'm afraid I'm not completely understanding your post, but based on the comment in last paragraph, perhaps this will help:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


Describes how to extract data the corresponds to a particular criteria(s). Otherwise, perhaps you could paste a small sample of what your spreadsheet looks like and what you want it to look like at end?
 
You must log in or register to reply here.
Back
Top