#1   Report Post  
ceemo
 
Posts: n/a
Default Minimum Value


I have a list of names in Column A and in Column B is a number that
corrospondes to the name. The name may appear more than once.

In column D is a list of th unique names in column E i would like a
formula that auto puts the minimum number corrosponding to the name. In
Column F i would like a formula to auto put in the max value that
corrospondes with that name.

Hope not to confusing, Can anyone help?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=394272

  #2   Report Post  
Morrigan
 
Posts: n/a
Default


Using array enter (Ctrl+Shift+Enter), you can try this:

{=MIN(IF(A$1:A$10=D1,B$1:B$10,""))}
{=MAX(IF(A$1:A$10=D1,B$1:B$10,""))}


Hope this helps.


ceemo Wrote:
I have a list of names in Column A and in Column B is a number that
corrospondes to the name. The name may appear more than once.

In column D is a list of th unique names in column E i would like a
formula that auto puts the minimum number corrosponding to the name. In
Column F i would like a formula to auto put in the max value that
corrospondes with that name.

Hope not to confusing, Can anyone help?



--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=394272

  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=MIN(IF(A1:A100=D1,B1:B100))

which is an array formula, so commit with Ctrl-Shift-Enter

I'll leave you to figure the other

--
HTH

Bob Phillips

"ceemo" wrote in
message ...

I have a list of names in Column A and in Column B is a number that
corrospondes to the name. The name may appear more than once.

In column D is a list of th unique names in column E i would like a
formula that auto puts the minimum number corrosponding to the name. In
Column F i would like a formula to auto put in the max value that
corrospondes with that name.

Hope not to confusing, Can anyone help?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:

http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=394272



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating the minimum value ignoring o jo jo Excel Worksheet Functions 1 June 29th 05 11:36 PM
second minimum value Ken Excel Discussion (Misc queries) 3 March 16th 05 07:17 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 04:55 AM
lookup - return minimum value Steve R Excel Worksheet Functions 7 December 30th 04 05:44 AM
Sum minimum values in a pivot table AK Excel Worksheet Functions 1 December 22nd 04 09:55 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"