I Really need help with formula

M

Mike

I have
CK4 Min. hours & CL4 Max hours & CM4 is going to = Differece between CK4 &
CL4,
CG5:CG65 =names & CJ5:CJ65 =hours remember hours & names belong together,
Now what i want is to have Names transfered over to CK5:CK65 if greater than
28 from Min to Max & leave cells blank if less
Also in CG5:CG65 for names i have this formula =INDIRECT("B" &
VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE)) & I have a #NA only until names are
entered in other cells
So in CK5:CK65 IF LESS THAN 28 lEAVE IT BLANK
 

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

I need help 3
Min/Max need help 7
i need more help with this time question 5
Help with SUMIF formula 3
Need Help With Array Formula 4
Need help with logic or Vlookup formula 9
Need help with a Formula 4
I need help with a formula calculating time 2

Top