|
Counting the number of rows
Hi... is there any way I can determine the number of rows used using formula instead of macro?... The number of rows would constantly be increasing... -- blurboiboi ------------------------------------------------------------------------ blurboiboi's Profile: http://www.excelforum.com/member.php...o&userid=25183 View this thread: http://www.excelforum.com/showthread...hreadid=386724 |
You can count how many cells in a column contain numbers using =COUNT(A:A),
and how many cells contain anything using =COUNTA(A:A) ******************* ~Anne Troy www.OfficeArticles.com "blurboiboi" wrote in message ... Hi... is there any way I can determine the number of rows used using formula instead of macro?... The number of rows would constantly be increasing... -- blurboiboi ------------------------------------------------------------------------ blurboiboi's Profile: http://www.excelforum.com/member.php...o&userid=25183 View this thread: http://www.excelforum.com/showthread...hreadid=386724 |
| All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com