I need help

M

Mike

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
 
R

Ron@Buy

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(C15>B1,CG5,"")
Come back with more details of your requirement if this is not what you are
looking for.
 
M

Mike

Sorry !! I want to equalize hours within 28 hours , Lets say CJ5=NAME &
CL5=HOURS This might=30 hours Now lets say CJ65= Name & CL65= HOURS THIS
MIGHT =60 HOURS, Now Min is 30 & Max is 60 hours this will equal 30 hours
differece & now what i want is transfer name into CN column because its over
28 hours by 2 & then in CP column have #2 beside correct name so that we know
this is what extra that we have to pay because its not within 28 hours I HOPE
THIS MAKES SENCE
 
M

Mike

This is what i have & it works but one problem there will be zero values & i
need to exclude them if possible
=AVERAGE(IF(AA5="L",E$5:E$65))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top