Show no duplicate data in a specific rows

**Statsman** · 03-05-2009, 05:09 PM

Hi everyone,

I need your help! I require a formula that will show unique data in a specific rows or cells. Here are the data:

Raw Data
Col1
Row 1 A
Row 2 A
Row 3 B
Row 4 C
Row 5 C

The result should look like this (Note that the unique data are displayed in rows 6 to 8:

Col1
Row 6 A
Row 7 B
Row 8 C

Your help is appreciated!

Statsman

**JBeaucaire** · 03-05-2009, 05:14 PM

Your example is very specific. A formula based "filter" can be easy with the use a helper column, or hard with the use of an array formula and no helper column.

The main question is how big is your real data set? Is your example too simple? Can you identify how large a data set this has to function on, and do the rows "move" or not. This will all substantively effect the answer and the implementation.

**Statsman** · 03-05-2009, 07:21 PM

Thanks for looking at this JB.

The data set is simple and the rows will not move. Of course, I will decide the number of rows I will use in my sheet. But for now, let's utilize 5 rows only.

Thanks again,
Statsman

**Statsman** · 03-06-2009, 07:37 AM

Hi guys,

I am wondering if you are able to assist me to the above issue.

Thanks,

**JBeaucaire** · 03-06-2009, 10:51 AM

Start with an Advanced Filter.

Highlight your data, click on DATA > FILTER> ADVANCED FILTER

[x] Copy to another location (select target cell)
[x] Unique records only
OK

**Statsman** · 03-08-2009, 07:56 PM

Originally Posted by JBeaucaire

Start with an Advanced Filter.

Highlight your data, click on DATA > FILTER> ADVANCED FILTER

[x] Copy to another location (select target cell)
[x] Unique records only
OK

Hi JBeaucaire - this is not exactly what I am looking for but it is okay. I have resolved the issue. Thanks!