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" wrote in message
...
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