Pull out list of Unique values based on multiple conditions/criterias

[MagsinoAS]

Hi,

I need to list all the unique values based on two criteria (Month and Department). Please see the sample result below:

Thanks,

Allan

 

[Col Delane]

Look at the "Remove Duplicates" functionality on the Data tab of the ribbon. By selecting all columns you can then specify which to check. You may need to copy the data and work on that set to get your extract if you need to retain the original set.

The alternative is to use the Advanced Filter tool and extract on unique values to another location.

 

[MagsinoAS]

Look at the "Remove Duplicates" functionality on the Data tab of the ribbon. By selecting all columns you can then specify which to check. You may need to copy the data and work on that set to get your extract if you need to retain the original set.

The alternative is to use the Advanced Filter tool and extract on unique values to another location.

Thanks...but what I need is a array formula to accomplish this.

 

[Col Delane]

Thanks...but what I need is a array formula to accomplish this.

Why?
Describe the outcome you seek rather than a pre-determined mechanism.

 

[MagsinoAS]

The table is my main database and I don't want to remove from my main table. I'm expecting the result to be in a separate sheet/tab and as a separate report. This will allow me to lookup for other information once I pull out the unique list.

Thanks.

 

[Col Delane]

Then I'd recommend a Pivot Table (with appropriate field filtering) or Advanced Filter (to "extract unique values to another location").

PTs are a bit easier to set up but may be messier to then use that extracted data elsewhere - but you can just use the PT to do the filtering and then double-click on the grand total (e.g. count) to dump all data records making up that total to a separate sheet.

 

[MagsinoAS]

I know how to use Pivot Table. But, the report I want is a customized one. Anyways, thanks for your helpl