Why not just have VBA sort your data and then compare the differenc
between teh first and second numbers with the difference between th
last and second to last numbers in your list? This would identify you
greatest outlier and it could be handled accordingly

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38069