Re: I need find largest value in row

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

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)