M Mike Jan 6, 2010 #1 In CH5:CH65 I have names, Now in CL5:CL65 i want to enter these names if greater than THERE values=hours in CJ5:CJ65 by 28
In CH5:CH65 I have names, Now in CL5:CL65 i want to enter these names if greater than THERE values=hours in CJ5:CJ65 by 28
S Sheeloo Jan 6, 2010 #2 Where is the value which might be more than 28? Enter this in CL5 and copy upto CL65 =IF(CJ5>28,CH5,"") This will show names in CL5 if the value in CJ5 is more than 28 (blank otherwise). You can adapt this to your need.
Where is the value which might be more than 28? Enter this in CL5 and copy upto CL65 =IF(CJ5>28,CH5,"") This will show names in CL5 if the value in CJ5 is more than 28 (blank otherwise). You can adapt this to your need.
