Need help with extracting one value from same multiple values

[thlee1122]

Hi all,

I need help with extracting one value from same multiple values.

Below is the part of the dataset I have.

Here is the example of what I want.

For example,

There are 3 DLGY1702W.ABWEEUS Model Name. I only want to output one for this model. Same goes for other model names as well.

How do you do this with a formula?

Your help will be greatly appreciated.


[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]Model[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLGY1702W.ABWEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLGY1702W.ABWEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLGY1702W.ABWEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]WT1801HVA.ASSEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]WT1801HVA.ASSEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLEY1701V.ASSEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLEY1701V.ASSEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLEY1701VE.ASSEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD="width: 159"]DLEY1701VE.ASSEEUS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Trebor76]

Hi there,

There a couple of ways to do this - a macro or via the Advanced option in the Sort & Filter tab (Excel 2007 and later) but as you want a formula you can use the following array formula* where the model numbers in A2:A10 and the output starts at cell C2 (change these ranges to suit if necessary):

{=INDEX($A$2:$A$10,MATCH(0,COUNTIF($C$1:C1,$A$2:$A$10),0))}

Regards,

Robert

* Array formulas must be confirmed with CTRL+SHIFT+ENTER after typing or modifying them. When done correctly, Excel will automatically add braces, {}, around the formula. Do not simply type the braces yourself.

 

[alansidman]

Create a Pivot Table.