Trying to create a MTBF database... The File will contain in Column
"A" Internal part number (can be used more then once) and in Column
"B" external part number (Should only be used once, but, may be used
more then once)... I am entering MTBF data in column "C" and would to
have excel populate the MAX MTBF value based on the column "A" Part
number... Can any one help me??

Do you have values of MTBF listed for each Part Number? If so, then
you can use VLOOKUP from that table.

Pete

On Mar 27, 12:58*pm, wrote:
Trying to create a MTBF database... *The File will contain in Column
"A" Internal part number (can be used more then once) and in Column
"B" external part number (Should only be used once, but, may be used
more then once)... *I am entering MTBF data in column "C" and would to
have excel populate the MAX MTBF value based on the column "A" Part
number... *Can any one help me??

On Mar 27, 9:01*am, Pete_UK wrote:
Do you have values of MTBF listed for each Part Number? If so, then
you can use VLOOKUP from that table.

Pete

On Mar 27, 12:58*pm, wrote:



Trying to create a MTBF database... *The File will contain in Column
"A" Internal part number (can be used more then once) and in Column
"B" external part number (Should only be used once, but, may be used
more then once)... *I am entering MTBF data in column "C" and would to
have excel populate the MAX MTBF value based on the column "A" Part
number... *Can any one help me??- Hide quoted text -

- Show quoted text -

MTBF Data is entered for each external Part number...

Well, in your first post you said:

"...
have excel populate the MAX MTBF value based on the column "A" Part
number...
"

so where would Excel get these values from?

Pete

On Mar 27, 1:04*pm, wrote:

MTBF Data is entered for each external Part number

On Mar 27, 9:33 am, Pete_UK wrote:
Well, in your first post you said:

"...
have excel populate the MAX MTBF value based on the column "A" Part
number...
"

so where would Excel get these values from?

Pete

On Mar 27, 1:04 pm, wrote:





MTBF Data is entered for each external Part number- Hide quoted text -

- Show quoted text -

Sorry my bad.


The File will contain in Column:
"A" Internal part number (can be used more then once)
"B" external part number (Should only be used once, but, may be used
more then once)
"C" MTBF data for Part number in column "B"
"D" Max values (See table below for example)

Int P/N Ext P/N MTBF MAX
A V1 5 6
A V2 6 6
A V3 1 6
B T10 3 3
B R33 2.5 3
C ZZ 4 4

Hope this helps... Thanks for any and all help...

So, if you enter MTBF in column C, you want to pick up the maximum of
this for each Internal Part Number? If so, try this array* formula in
D2:

=MAX(IF(A$2:A$200=A2,C$2:C$200))

I've assumed 200 rows of data - adjust to suit.

*An array formula has to be committed using CTRL-SHIFT-ENTER (CSE)
rather than the usual ENTER. If you do this correctly then Excel will
wrap the formula in curly braces { } when viewed in the formula bar -
do not type these yourself. Use CSE again if you subsequently amend/
edit the formula.

You can copy the formula down column D in the normal way(s).

Hope this helps.

Pete

On Mar 27, 2:02*pm, wrote:

Sorry my bad.

The File will contain in Column:
"A" Internal part number (can be used more then once)
"B" external part number (Should only be used once, but, may be used
more then once)
"C" MTBF data for Part number in column "B"
"D" Max values (See table below for example)

Int P/N * * * *Ext P/N * * * MTBF * * * * MAX
A * * * * * * * * * V1 * * * * * * * *5 * * * * * * * *6
A * * * * * * * * * V2 * * * * * * * *6 * * * * * * * *6
A * * * * * * * * * V3 * * * * * * * *1 * * * * * * * *6
B * * * * * * * * * *T10 * * * * * * 3 * * * * * * * *3
B * * * * * * * * * *R33 * * * * * * 2.5 * * * * * *3
C * * * * * * * * * ZZ * * * * * * * *4 * * * * * * * *4

Hope this helps... * Thanks for any and all help