• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • 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
1 Solution
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.
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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