Trying to use FILTER but also get rid of duplicates

**MitchMitchell** · 03-07-2022, 11:07 PM

I'm using the FILTER function in order to get the data I need from one sheet to another. I'm running into a problem in that there are multiple of the same code (A5500) in my lookup array. Is there a way to use the FILTER function but only get unique results? I've tried using advanced on Sort & Filter and it doesn't work.

**MitchMitchell** · 03-07-2022, 11:07 PM

Here's the document (forgot to attach whoops)

**AskMeAboutExcel** · 03-07-2022, 11:12 PM

just wrap UNIQUE () around the formula

e.g.

Please Login or Register  to view this content.

becomes

Please Login or Register  to view this content.

**wk9128** · 03-07-2022, 11:17 PM

worksheet or Tab name : sheet2

Cell A2 formula

Formula:

Please Login or Register  to view this content.

**MitchMitchell** · 03-08-2022, 12:22 AM

Thanks, peeps, this was it! Really appreciate you all helping me

**wk9128** · 03-08-2022, 12:53 AM

@MitchMitchell You're Welcome. Glad to help . Thank You for the feedback

Trying to use FILTER but also get rid of duplicates

LinkBack

Thread Tools

Rate This Thread

Display

Trying to use FILTER but also get rid of duplicates

Re: Trying to use FILTER but also get rid of duplicates

Re: Trying to use FILTER but also get rid of duplicates

Re: Trying to use FILTER but also get rid of duplicates

Re: Trying to use FILTER but also get rid of duplicates

Re: Trying to use FILTER but also get rid of duplicates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Trying to filter out duplicates when counting

Using filter to highlight/filter duplicates in multiple columns but within 1 day

Filter unique Values without macro/advanced filter/remove duplicates

[SOLVED] Filter - Hiding duplicates but displaying 1 of the duplicates item

Custom Filter: Duplicates

Data Filter Duplicates

Filter Out Non-Duplicates

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions