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