Thanks for your quick answer, Just Tom, but I'm afraid it didn't work. May be
because instead of "Hello" I have a cell (it's a huge list of cels for which
I need to calculate max and mins), not a value...

Thanks anyway...

R,
Just Anna


"TomPl" wrote:

You could use an if statement like:

=IF(A1="Hello",MAX(B:B),"SkipIt")

Just Tom