<div>
<div class="content wysiwyg-content">
is there an easy way in excel to group and filter 2 columns (A and B)... I know there is the advanced filter and filter for unique records only for a single column, but I need to group for 2 columns worth of data, (e.g. column A represents a database, column B represents a table, column C represents a field), I want to filter my data to get a list of all unique database and table parings. As it stands my data is in a format similar too<br />
<br />
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c<br />
--------------------------<wbr />----------<wbr />----------<wbr />------<br />
db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mytable &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field1<br />
db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mytable &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field2<br />
db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mytable &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field3<br />
db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;othertable &nbsp; &nbsp; &nbsp; &nbsp;field1<br />
db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;othertable &nbsp; &nbsp; &nbsp; &nbsp;field2<br />
<br />
in the above I want to filter my data so it should essentailly ignore column c, and group the unique pairings of and and b, so as above I should get<br />
<br />
db1 &nbsp;mytable<br />
db1 &nbsp;othertable
</div>
</div>


is there an easy way in excel to group and filter 2 columns (A and B)... I know there is the advanced filter and filter for unique records only for a single column, but I need to group for 2 columns worth of data, (e.g. column A represents a database, column B represents a table, column C represents a field), I want to filter my data to get a list of all unique database and table parings. As it stands my data is in a format similar too

a                      b                       c
----------------------------------------------------
db1                  mytable            field1
db1                  mytable            field2
db1                  mytable            field3
db1                  othertable        field1
db1                  othertable        field2

in the above I want to filter my data so it should essentailly ignore column c, and group the unique pairings of and and b, so as above I should get

db1  mytable
db1  othertable

mutiple filter on 2 columns

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.