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.

1	Model
2	DLGY1702W.ABWEEUS <tbody> </tbody>
3	DLGY1702W.ABWEEUS <tbody> </tbody>
4	DLGY1702W.ABWEEUS <tbody> </tbody>
5	WT1801HVA.ASSEEUS <tbody> </tbody>
6	WT1801HVA.ASSEEUS <tbody> </tbody>
7	DLEY1701V.ASSEEUS <tbody> </tbody>
8	DLEY1701V.ASSEEUS <tbody> </tbody>
9	DLEY1701VE.ASSEEUS <tbody> </tbody>
10	DLEY1701VE.ASSEEUS <tbody> </tbody>

<tbody>
</tbody>

 

[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.