• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

mutiple filter on 2 columns

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
0
pma111
Asked:
pma111
1 Solution
 
NBVCCommented:
If you select columns A and B only, then go to Advanced Filter, you should be able to filter unique items in place based on the A and B column only, and get the results you show.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now