|
I Really need help with formula
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 |
I Really need help with formula
see your MIN/MAX post
-- Biff Microsoft Excel MVP "Mike" wrote in message ... 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 |
| All times are GMT +1. The time now is 09:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com