| I'll try it ! thank you
"KC Rippstein" <kcrippsteinAThotmailDOTcom> wrote in message
news:%%23XYgSHgUHHA.1036@TK2MSFTNGP03.phx.gbl...
> Probably not a "power user" solution, but what the heck.
> In BF14, put =J14, in BG14 =M14, and so on...this gives the data you want
> in one contiguous range.
> In BE14, put =COUNTIF(BF14:BR14,"<50")
> In BD14, put =IF(BE14>3,"Very Slow",IF(BE14=0,"Very |
|
 |
|
 |
Group: microsoft.public.excel · Group Profile · Search for Bg14 in microsoft.public.excel
Author: Khalil Handal
Date: Feb 16, 2007 12:17
Not sure why you haven't received the festive cheers package sent earlier ?? Think the link to d/l the sample is good (just checked) Anyway, here's a text descript of the set-up in the sample construct .. Week#s are placed in B2:BA2, viz.: 1, 2, 3, ... 52 Month#s are input within B1:BA1 to "coincide" with the last week for the month, viz in E1: 1, in I1: 2, in N1: 3, ... in AR1: 10, in
| 
