Prev: macro for a range
Next: Removing Duplicate Values
From: Mike on 6 Jan 2010 19:32
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
From: T. Valko on 6 Jan 2010 21:14
see your MIN/MAX post

--
Biff
Microsoft Excel MVP


"Mike" <Mike(a)discussions.microsoft.com> wrote in message
news:CBCBE795-20D3-43B0-905B-97266607C196(a)microsoft.com...
>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


 | 
Pages: 1
Prev: macro for a range
Next: Removing Duplicate Values