Hi
Tom used the ROW(1:300) as parameter for the SMALL function (cycling
from 1 to 300). So getting the following values:
SMALL(....,1)
SMALL(....,2)
....
SMALL(....,300)

if you change this you don't start with the smalles but in your case
with the 6th smallest

--
Regards
Frank Kabel
Frankfurt, Germany
"amyacc " schrieb im
Newsbeitrag ...
Hi there.

Your info worked but can you explain why it worked?

Thanks.

-Amy


---
Message posted from http://www.ExcelForum.com/