LinkBack URL
About LinkBacks
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...
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...
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks