Search code examples
excelsortingfiltercell

Filter/Sort whole sections in Microsoft Excel

I want to sort and filter whole cell sections in Excel. For example I have two 3x3 arrays. I have named first array as "ccc" workbook. Second array I have named "aaa". Is there any solution that in one cell I will create filter or sorter that will hide whole array "ccc" or take array "aaa" and put it above array "ccc"?

5 6 b
a g 1 <<< ccc
p 4 5

d o a
d e 7 <<< aaa
s f 6

Solution

  • The simplest way is to name your tables and to then place a filter on the data column of the table name.

    enter image description here

    enter image description here

    You can then pull together any combination of tables that you like as so

    enter image description here

    Question is very brief so this was my interpretation of what you was after.