Re: I need find largest value in row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows 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: Mike Waterson.
    ... somehow suggestive of the end of an era. ... RIP Mike ... ... The Watersons started the legendary Folk Union One club at the Old Blue Bell pub in Hull's Market Place, ... May think this column merely marks ...
    (uk.music.folk)
  • 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)