| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Number columns and rows in Excel, Example: C027R36 | Setting up and Configuration of Excel | |||
| How to get number of rows which match criteria | Excel Worksheet Functions | |||
| maximum number of rows that can be coppied to clipboard | New Users to Excel | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
