Is there a way to group rows so that they stay together when sorted/filtered?

**Brandon2013** · 12-07-2015, 01:24 PM

GroupingRowsTogether.xlsx

I am trying to find a way to group rows based on a similar criteria (ID in the small sample attached), and then filter by another field. If the filter criteria is met, I want to have ALL the rows that match that particular ID displayed.

For example, in the sample file, let's say I want to return all the rows with a Date 2 less/earlier than 2/28/2015. Wonderland, Alice has a row that meets this criteria. I also want to see any and all rows that have her ID in the ID column, even if the Date2 for that row isn't within that range.

Will I need to write a macro to do that?

Should first filter, keep track of the IDs, and then look for any rows that have those IDs?

Thanks.

**Pete_UK** · 12-07-2015, 01:40 PM

All the Date2 dates in your example are greater than 2/1/2015 (I assume you mean 1st Feb 2015), so that isn't a good criteria to choose.

Pete

**Brandon2013** · 12-07-2015, 01:55 PM

Edited original post. Thanks for pointing out my date error.

**Pete_UK** · 12-07-2015, 02:27 PM

You can put this formula in E3:

=IF(D3="","",IF(COUNTIFS(A$3:A$30,A3,D$3:D$30,"<"&DATE(2015,2,28)),"yes","no"))

and copy down to E30. Then you can apply a filter to column E, selecting yes from the drop-down.

Hope this helps.

Pete

**Brandon2013** · 12-07-2015, 02:47 PM

Thank you. That does exactly what I wanted.

**Pete_UK** · 12-07-2015, 03:14 PM

Glad to hear it.

As you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Is there a way to group rows so that they stay together when sorted/filtered?

LinkBack

Thread Tools

Rate This Thread

Display

Is there a way to group rows so that they stay together when sorted/filtered?

Re: Is there a way to group rows so that they stay together when sorted/filtered?

Re: Is there a way to group rows so that they stay together when sorted/filtered?

Re: Is there a way to group rows so that they stay together when sorted/filtered?

Re: Is there a way to group rows so that they stay together when sorted/filtered?

Re: Is there a way to group rows so that they stay together when sorted/filtered?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] group values from 3 different columns when the value in one column is sorted

Stop equations updating dynamically when table is sorted/filtered

Cololrs on individual bar charts won stay fixed when sorted

Sorted and Filtered cell totals

Selecting and manipulating data from a sorted and filtered table

How do I group rows prior to a data sort so they stay together?

filtered sorted packing list report from data table

Bookmarks

Bookmarks

Posting Permissions