=IF(ISERR(SMALL(IF(Sheet1!$B$2:$B$30010,ROW(INDIR ECT("1:"&ROWS(Sheet1!$A$2:$A$300)))),ROWS($1:1))), "",INDEX(Sheet1!$A$2:$A$300,SMALL(IF(Sheet1!$B$2:$ B$30010,ROW(INDIRECT("1:"&ROWS(Sheet1!$A$2:$A$300 )))),ROWS($1:1))))

Adjust your range and your criteria to suit.
ctrl+shift+enter, not just enter


"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.