Lets say your Employees and criteria are on sheet1 then go to
INSERTNAMESDEFINE give it the name Under3 and add this in the formula
box *=OFFSET('Sheet1'!$B$2,0,0,COUNTA('Sheet1'!$B:$B), 1) *then enter
this in sheet2 A2
*=IF(ISERROR(SMALL(IF(Under3=$A$1,ROW('Sheet1!$A$2 :$A$100)-MIN(ROW('Sheet1'!$A$2:$A$100))+1,""),ROW(A1))),"", INDEX('Sheet1'!$A$2:$A$100,SMALL(IF(Under3=$A$1,RO W('Sheet1'!$A$2:$A$100)-MIN(ROW('Sheet1'!$A$2:$A$100))+1,""),ROW(A1))))*
and commit the ARRAY formula using Ctrl+Shift+Enter, it must be done
this way, you will then see curly brackets at the beginning and end of
the formula, once you have done this simply copy down, now all you need
to do is enter your criteria in Sheet2 A1.


Brad;259091 Wrote:
I am trying to create a list of employees who meet a criteria and would
like
the names to be added to another list in a new excel sheet.

Employee name is in cell A2:A100
Criteria is in cell d2:d100

criteria is less than -3%

Thanks!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72354