excel formula required 2

[wbalbion68]

Hi,
I am looking for a solution to my problem.
CODE PART NOTOCOMP FORMULA TO ACHIEVE
8442149 8442A 2
8442149 8442B 1 1
8443159 8443A 3
8443159 8443B 2 2
8443159 8443C 6
8443190 8443A 5 5
I am attemping to find the minimum of the NOTOCOMP field
for the part numbers shown in the CODE field and place the
result in the field called FORMULA TO ACHIEVE.
I have tried variations of the DMIN function without success.
Any help would be greatly appreciated

 

[Loomah]

hi
could you not just use subtotals?

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[SkipVought]

Hi,

I used named ranges...
[tt]
=IF(C2=MIN(OFFSET($A$1,MATCH(A2,CODE,0),2,COUNTIF(CODE,A2),1)),C2,"")
[/tt]


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}