Create Unique List with Criteria

**Fos605** · 07-20-2010, 07:22 AM

Problem:-
I have 3 columns of data.
I wish to create a list of unique combinations of 2 of the columns, but only those with a set criteria for the other column.

example:

Data table

Cloumn A Column B Column C
England Services Level A
England Services Level B
England Services Level A
Wales Services Level A
Scotland Services Level C
England Services Level C
England Services Level A
England Services Level A

I wish to have unique list of column B and C combinations but only for England.
ie the result would be

England Services Level A
England Services Level B
England Services Level C

Hope this is clear,
many thanks for any assistance,

Cheers

Fos605

**DonkeyOte** · 07-20-2010, 07:51 AM

You could perhaps apply an Advanced Filter ?

If we assume your table is A:C such that A1:C1 contain headers (eg Nation, Type, Level) then

E1: Nation
E2: England

Highlight your table of data (inclusive of headers) and run Advanced Filter such that Criteria Range is E1:E2 and Copy To Location is say G1 - check Unique Records Only.

**Marcol** · 07-20-2010, 07:57 AM

In Excel 2007

1/. Advanced Filter
Select Copy to another location
List Range

Please Login or Register  to view this content.

Crireria Range

Please Login or Register  to view this content.

Copy to

Please Login or Register  to view this content.

Check the box Unique Records Only

2/. Filter the resultant table F1 ("England")

3/. Copy and paste the result to say for example J1

4/. Remove filters

Hope this helps

Tip
Better if you put your version of excel in your profile

[EDIT]

As usual DonkeyOte is a step ahead of me!

Create Unique List with Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Create Unique List with Criteria

Re: Create Unique List with Criteria

Re: Create Unique List with Criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions