Teethless,

Thanks for your help but Still no luck, have this formula in place and no
results
=IF(ISERR(SMALL(IF(Sheet1!$E$2:$E$300350,ROW(INDI RECT("1:"&ROWS(Sheet1!$E$2:$E$300)))),ROWS($1:2))) ,"",INDEX(Sheet1!$A$2:$A$300,SMALL(IF(Sheet1!$E$2: $E$300350,ROW(INDIRECT("1:"&ROWS(Sheet1!$A$2:$A$3 00)))),ROWS($1:2))))

Would it be possible to email you the 1 sheet to you to see if you see my
stupidity?



"Jessinat" wrote:

I have 2 columns of data (1st column is name, 2nd column is value) and want
to filter the data so that the name appears on a separate sheet for those
individuals whose value exceeds a certain number. Any ideas would be greatly
appreciated. TIA.