|
Posted to microsoft.public.excel.misc
|
|
|
#REF!
Thanks!
"Max" wrote:
One way
Try, array-entered (press CTRL+SHIFT+ENTER) in say B1:
=MAX(IF(ISNUMBER(A1:A10),A1:A10))
Adapt the range to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote:
If I try to use the max function on a column with a cell with #REF!, I get
#REF! as my result. I tried doing an if statement saying if a cell = #REF!
make it a 0 but it's not working. Anything else I can do?
|