Hi Shatin,

Counting 1.1 million rows will take a longer time than counting 65,336 rows.
So will the above still be good technique?

I don't think it will make much of a difference.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com