 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008MAX Value
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, robert.gu...@comcast.net 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?? > Do you have values of MTBF listed for each Part Number? If so, then > you can use VLOOKUP from that table. [quoted text clipped - 11 lines] > > - 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, robert.gu...@comcast.net wrote: > MTBF Data is entered for each external Part number > Well, in your first post you said: > [quoted text clipped - 12 lines] > > - 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, robert.gu...@comcast.net wrote: > Sorry my bad. > [quoted text clipped - 14 lines] > > 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 [quoted text clipped - 38 lines] > > - Show quoted text - FANTASTIC!!!!!!!!!!!!!!!!!!!!!!! Thank you for your help... You're welcome, Robert - thanks for feeding back. Pete FANTASTIC!!!!!!!!!!!!!!!!!!!!!!! Thank you for your help... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.