My bad, stupid me I changed your original data and forgot to change it back,
if you replace the date in A2:A8 with your original data you'll get 5. When
I tested it I changed D4 from rst to "cascade", if you change back to "rst"
you'll get 6 (and if you remove line 12 you'll get 5)
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
Portland, Oregon
"via135" wrote in
message ...
i'm afraid Peo!
that your sample download gives the result as "7" i/o "5"!
while your earlier post throws the correct result of "5"!!
maybe bcoz of extending the range upto row31 in your sample
download??!!
-via135
Peo Sjoblom Wrote:
You can download a sample here
http://www.nwexcelsolutions.com/Down...0a%20Twist.xls
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
Portland, Oregon
"via135" wrote
in
message ...
sorry Peo!
I'm getting #VALUE! error!
-via135
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=513331
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=513331