Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2006
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting number of row entries (2003)

    Counting number of row entries

    I have an excel file with entries in table format. I want excel to count how many rows are in that information table.

    The 1st column of the table is an incrementing number.

    Is this possible?

    Bob.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Counting number of row entries (2003)

    There are several ways all with pros and cons depending on what you need:

    You can use COUNTA and count the number of entries.

    You can also determine the last row to have an item in it with MATCH. (in case your dataset has blank items)

    There are several ways in VB using Endup and end-down.

    Could you be more specific about what you want and need?

    Steve

  3. #3
    Lounger
    Join Date
    Jun 2006
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting number of row entries (2003)

    COUNTA did the job, it gave me the number of entries.

    Now I want Excel to take that number and present it in a chart automatically; what is the easiest way to do this?

    Thanks,

    Bob.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Counting number of row entries (2003)

    I don't understand what you want to do with the number. Could you elaborate?

    This is just a "wild guess", but if you are trying to use the count to create a dynamic chart I recommend looking at Jon Peltier's site on charting, especially at Dynamic and Interactive Charts

    If you are after something else, you will have to be much more specific.

    Steve

  5. #5
    Lounger
    Join Date
    Jun 2006
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting number of row entries (2003)

    Ok I'll open a new thread for this as its quite complex.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •