MAX Value

[robert.guers]

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??

 

[Pete_UK]

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

Pete

 

[robert.guers]

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

Pete



- Show quoted text -

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

 

[Pete_UK]

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

 

[robert.guers]

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



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

 

[Pete_UK]

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

 

[robert.guers]

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






- Show quoted text -

FANTASTIC!!!!!!!!!!!!!!!!!!!!!!! Thank you for your help...

 

[Pete_UK]

You're welcome, Robert - thanks for feeding back.

Pete



FANTASTIC!!!!!!!!!!!!!!!!!!!!!!! Thank you for your help...