(this may be a repeat question because my computer went funny - but here you
a)

The below formula

=IF(N(CO23)=0,"",(ABS(CO23)))

it to return an absoulte value from some data. if there is only one data in
the set, then it returns a #Value! error sign. Is there a way to get it to
put a blank in the intended cells when this happens, rather than the error as
other formula gets mucked up by it!

the other formula is:

=MATCH(MAX(B52:AD52),B52:AD52,0)

Has anyone any ideas please??

Ted.