avoiding circular refs by excludnig cells

[fidgen]

Hiya,

I'm trying to calculate a MAX formula in cell B2 for column B, but obviously get a circular reference! (I don't want to specify B3:Bxx as I want it to just update the MAX as new rows are entered)

Is there a way round this? (other than having the MAX for column B in column C etc)

Thanks
Hugh

 

[jimboy]

Max,

The only way I can think of is to avoid the cell you are in, in this example I was in cell B5...

=MAX(B1:B4,B6:B65536)

jimboy.