Re: I need find largest value in row

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I tried this way with no luck :(

From A1 to A3 i have name Paul, From A4 to A7 name Peter
In column B their marks.
In column C i have C1,C2 with name Paul, C3 - Peeter (was copied to another
location) as suggested.
In D1 inserted the following formula =MAX(IF($A$1:$A$7=C1,$B$1:$B$7,""))

Wont work, any suggestions or mistakes i made?

Thank you for answearing to my questions.

Peter


"Mike H" wrote:

Hi the formula I gave you was a bit simplistic because it contained the name
within the formula and a much better one would be:-

=MAX(IF($A$1:$A$5=E1,$B$1:$B$5,""))

Where E1 is the name you are looking for. So if you have lotes of names you
could extract the unique names to another column (here's one way)

http://www.mrexcel.com/archive/Data/31167.html

and then drag the above formula down alongside that unique list to get the
maximum for each name

Mike


"Lion2004" wrote:

Thank you it works!
But there is one question is more.

If i have Paul From A1 to A3 and i inserted formula to C1- it is working.
But what if i have ,any thousands Names in A column? Do i need formula
manually several times and what if i add some name?

This is the last question.

Thank you for replying.

Peter

"Mike H" wrote:

Try this in C1:-

=MAX(IF(A1:A5="Peter",B1:B5,""))

Enter with Ctrl+Shift+Enter.

Mike

"Lion2004" wrote:

Thank you Roger and Soundar, these both methods wors fine.
But if i have name list from A1 to A10, for example there are Paul and Peter
names. And From B1 to B10 i have their marks. I need to get largest mark from
Peter in cell C1. It means formula have to scan throug columns from B1 to B10.
Is it possible to do?

"Roger Govier" wrote:

Stupid me!!!
You asked for the largest

=MAX(A1:D1)

--
Regards
Roger Govier



"Lion2004" <Lion2004@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E5FDE7BD-86D7-4FAC-9669-6948A3005DA2@xxxxxxxxxxxxxxxx
I have row with numbers A1-1, B1-54, C1-52, D1-60.
I want to in E1 display largest value from listed above, whis exact
formula
do i need insert into E1?

Thank you for yours help.

Peter



.

Relevant Pages

  • Re: I need find largest value in row
    ... But if i have name list from A1 to A10, for example there are Paul and Peter ... And From B1 to B10 i have their marks. ... It means formula have to scan throug columns from B1 to B10. ... "Roger Govier" wrote: ...
    (microsoft.public.excel.misc)
  • Re: I need find largest value in row
    ... But if i have name list from A1 to A10, for example there are Paul and Peter ... And From B1 to B10 i have their marks. ... It means formula have to scan throug columns from B1 to B10. ... "Roger Govier" wrote: ...
    (microsoft.public.excel.misc)
  • Re: I need find largest value in row
    ... Peter ... "Roger Govier" wrote: ... This will create 2 dynamic ranges that will grow as you add more data. ... And From B1 to B10 i have their marks. ...
    (microsoft.public.excel.misc)
  • Re: 2008 WSOP TV coverage starts tonight
    ... Hopefully this marks the beginning of the 2008 coverage. ... I think you're a day late Mike. ... There was a 2008 $10K pot limit HE event ...
    (rec.gambling.poker)
  • Re: opens in safe mode
    ... opening Properties and removing check marks from the boxes on the ... "Mike" wrote: ...
    (microsoft.public.excel.setup)