I need some help

J

John21

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 value
of them to create links in these 5 positions. The problem is that
have some #DIV/0 that need to be converted to 0 and I’ve been using th
ISERROR function but I’m getting and error about circular references
Any ideas......
 
B

Bob Phillips

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)
 
Top