Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

mutiple filter on 2 columns

Posted on 2014-02-18
1
Medium Priority
?
219 Views
Last Modified: 2014-02-18
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
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39867712
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question