VLOOKUP to find repeats?

[wilster2012]

Below is a small sample of data that I am working with. Test parts are identified as 01-24 in column A. Location in Column B is location of test part. The tech in Column C will be S1, S2 and S3. Column D is the max value (resistance) for each Tech. Once a part is used in one test, it cannot be used again. In the sample below, I want t keep the first part 04 and part 17 and discard the second 04 and 17. Will VLOOKUP work for that? There are a least 200 data point to deal with, so I want to automate the process. I am new to VLOOKUP, o any help would be appreciated.

Part	Loc	Tech	Max of Value
04	04-TRA	S2	216	Keep
05	05-TRA	S2	215
06	06-TRA	S2	214
10	10-BLB	S2	211
04	04-BLB	S2	211	Discard
08	08-TRA	S2	208
22	22-TRA	S2	207
03	03-BLB	S2	207
17	17-TRA	S2	206	Keep
17	17-BLB	S2	205	Discard

<colgroup><col width="64" style="width: 48pt;" span="3"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2929;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

Thanks in advance
Willy

 

[Marcelo Branco]

Try

E2 copied down
=IF(COUNTIF(A:A,A2)>1,IF(COUNTIF(A$2:A2,A2)=1,"Keep","Discard"),"")

M.

 

[wilster2012]

That works! Thanks!