Minimum Value

[ceemo]

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]

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.

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?

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>