Re: I need find largest value in row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
    ... "Mike H" wrote: ... 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. ... "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: I need find largest value in row
    ... This will create 2 dynamic ranges that will grow as you add more data. ... And From B1 to B10 i have their marks. ... "Roger Govier" wrote: ...
    (microsoft.public.excel.misc)
  • Re: A 2D Graph tool written in Dolphin Smalltalk.
    ... Thanks for pointing this problem to me Peter. ... size of the GraphView window in the demo. ... check marks' on the context menu items if they were enabled or not. ... show check marks on active toggles, but I can't remember exactly how I did ...
    (comp.lang.smalltalk.dolphin)