Grouping or locking cells
 

I am attempting to sort information on building energy use and building
systems employed, where some buildings use multiple systems i would like to
lock those rows together so that when filtered they will remain together.

ie. use an autofilter to keep all the buildings which use chilled beams,
these buildings' groups of cells remain visable therefore all information and
systems for them are still on screen.

I understand this could be done in a large matrix using one column for each
system and indicating by binary which have what, however it would be far more
effective to be able to list the systems and seach the grouped lists.

Grouping or locking cells
 

If you show a sample of your data, and what you're trying to achieve,
someone may be able to offer specific help.

Perhaps you could add a column to the table, and test for criteria
entered elsewhere on the worksheet. For example, with criteria entered
in cells L1 and M1:

=AND(B2=$L$1,D2=$M$1)

Then, filter that column for TRUE.

Pete.K. wrote:
I am attempting to sort information on building energy use and building
systems employed, where some buildings use multiple systems i would like to
lock those rows together so that when filtered they will remain together.

ie. use an autofilter to keep all the buildings which use chilled beams,
these buildings' groups of cells remain visable therefore all information and
systems for them are still on screen.

I understand this could be done in a large matrix using one column for each
system and indicating by binary which have what, however it would be far more
effective to be able to list the systems and seach the grouped lists.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html