Mike not quite clear what you are looking for "if greater than B1=28 FROM Min
to
Max" but to achieve " In CK5:CK65 I want to transfer these Names if greater
than B1=28" enter this formula in CK5 and copy down (assuming a number is
entered in B1:
=IF(C15B1,CG5,"")
Come back with more details of your requirement if this is not what you are
looking for.



"Mike" wrote:

CG5:CG65=Names
CI5:CI65=Hours worked fgor these Names
CK4=Min Hours
CL4=Max Hours
CM4=Differece between Min & Max
B1=Magic #28

In CK5:CK65 I want to transfer these Names if greater than B1=28 FROM Min to
Max
Other words i want to equalize with in 28 hours if hours are more transfer
names to CK5:CK65 column is this possible & HOW