ms excel sort

Posted on 2014-02-17
Medium Priority
Last Modified: 2014-02-17
I just opened a question about counting the number of rows, it turned out that


counts the rows as per the regmigrant's suggestion

Now I am having a problem with sorting. So I need to sort the excel doc, then total the rows.
But when I sort the rows, the numbers of the rows is all off, for example the numbering goes


as so on, obviously due to the filter, but my formula is


my count is 2000 no matter how I filter the document.
So how can I get an accurate count of the rows after I apply the filter?
Question by:JeffBeall
  • 2
  • 2
LVL 19

Assisted Solution

helpfinder earned 1000 total points
ID: 39865279
try this formula

(3 in the formula represents COUNTA)

Author Comment

ID: 39865322
OK, I tried


but I get this message

"The formula you typed contains an error"

there are some suggestions, but it's just things like click help for more info.
LVL 28

Accepted Solution

MacroShadow earned 1000 total points
ID: 39865330

Author Closing Comment

ID: 39865373
I guess you had a typo helpfinder, using the comma after the 3 worked
Thank you so much! that works great.
LVL 19

Expert Comment

ID: 39865405
it´s not a typo. if comma or semicolon is a separator depends on Regional Settings and what you have set.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial summarizes the causes behind"an unknown error prevented access to the PST File”.  It also suggests the various solutions to fix the problem.
Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question