Trevor,

many thanks it all working fine

Cheers

ims

On 26 Jan, 12:52, wrote:
Any other ideas that can help!

cheers

ims

On 26 Jan, 12:40, wrote:



Hi Trevor,

The column is now staying: #NUM!

Cheers

ims

On 26 Jan, 12:36, Trevor Williams

wrote:
Hi ims

Try extending the column width to see if the number shows correctly

Trevor

" wrote:
Hi All,

I haven't a bit of problem displaying a blank cell in D15 as empty when
the others cells are empty. The value that display is ######.

Anyone there that can help me!

Here is the formula: -

=IF(COUNTBLANK(D16:D43)=29,"",AVERAGE(LARGE(D16:D4 3,{1;2;3;4})))

The formula works fine and display the average of the largest set of 4.
The only problem is displaying D15 as empty.

Many thanks

ims- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -