Hi

I have a little problem dealing with some columns that I have created.
The columns look like this…….

Name years number
John 45 2
Angel 50 9
Jenny 28 2

I need to sort de columns in order to get the bigger or mayor 5 values
of them to create links in these 5 positions. The problem is that I
have some #DIV/0 that need to be converted to 0 and I’ve been using the
ISERROR function but I’m getting and error about circular references.
Any ideas.......


--
John21
------------------------------------------------------------------------
John21's Profile: http://www.excelforum.com/member.php...o&userid=36983
View this thread: http://www.excelforum.com/showthread...hreadid=567843

wherever the formula that returns a #DIV/0 change that like so

=IF(ISERROR(current_formula),0,current_formula)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John21" wrote in
message ...

Hi

I have a little problem dealing with some columns that I have created.
The columns look like this…….

Name years number
John 45 2
Angel 50 9
Jenny 28 2

I need to sort de columns in order to get the bigger or mayor 5 values
of them to create links in these 5 positions. The problem is that I
have some #DIV/0 that need to be converted to 0 and I’ve been using the
ISERROR function but I’m getting and error about circular references.
Any ideas.......


--
John21
------------------------------------------------------------------------
John21's Profile:
http://www.excelforum.com/member.php...o&userid=36983
View this thread: http://www.excelforum.com/showthread...hreadid=567843