This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have been using sort in Excel for many years, but recently when sorting eg Email records in a column (not all rows in the column have data), the sort appears at the bottom of the sheet instead of the top. The only way to get the data to the top is to z-a the data? Also, when creating a pivot table and calculating 'values', every count equals the same number (the sum total of all the records on the worksheet). I am thinking that I may have adjusted a setting accidently as this has never happened previously.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It could be those cells are not truly blanks. You may use Isblank function to confirm whether the cell is truly blank.
When you create povit table, check the add this data to data model.
Have you tried switch to Distinct count?
Sorry, one of the Analyze Data images is incorrect (Company Email)
Thank you for responding. Unfortunately, the file contains a large number of personalized data and due to data protection regulations, I am unable to share the full document.
However, I have attached three screen shots, one showing the Pivot table with incorrect numbers. The other two are screenshots of the 'analyse data' option, showing the correct numbers.
I can explain in more detail about the 'sort' issue.
My worksheet has around 20 fields, one contains personal Email address and another contains generic Email addresses.
When undertaking an a-z sort of either fields, the sorted content appears at the bottom of the list and the blanks appear at the top.
However, when undertaking an z-a sort, the content appears at the top and blanks at the bottom. Essentially, in reverse.
However, this seems to be only happening on Excel documents that have been created from an Microsoft Access table using the 'external data' option. I have been using this method for a few years, and this is the first time that I have experienced this issue.
.
Could you share some screenshot of your issue?