sort order

Hello, I have a sheet of fictional data here: duplicates. Below is a screenshot for convenience. I'd like to list, in the duplicate column, duplicates of values in the id column, with one condition: that the corresponding row in the complete column must contain a 1, not a 0. Furthermore, I'd...

So, I've got a unique scenario that I can't figure out and doesn't seem to have been solved elsewhere yet. Excel allows users to create "Custom List" data for sorting cells - unfortunately, these lists are inherently delimited via commas and it seems to be non-negotiable. Ordinarily, it...

Hi. I'm trying to setup a dashboard for a school showing student result distribution. The marks are provided as "A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-" yet when creating a bar chart with a summary count of these results it orders them as "A, A-, A+, B, B-, B+, C, C-, C+, D, D-, D+" on the...

I have scoured this forum for the answer, but this issue doesn't seem to have been addressed yet. Here's the deal. I am using a formula that searches through a separate sheet for all text strings that match up with a certain Billing ID and Date. On that separate sheet, each of the text strings...

Hello, I have a worksheet where the print ranges are all set and there are about 80 pages in the worksheet. Instead of resorting the pages manually (via cut and paste) or sorting all the pages once they are printed, I would like to find or write a macro that sorts the pages when I print them...

I have a chart (price sheet) with horizontal and vertical titles. Horizontal value is name of item and vertical value is supplier name, the chart is filled with numeric prices. I want to sort the horizontal plane and give as a result the supplier name in decreasing order...

I have a list of voter registration data and am trying to sort it into a "walking list;" i.e., 1 side of the street with ascending numbers and the return side descending numbers so that I can walk 1 side then, without going back to the beginning end, walk the other side back to my car). I will...

I have built the following report using a macro: <TABLE style="WIDTH: 613pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=816 border=0><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 47pt; mso-width-source: userset...

To ensure that my group by fields in my pivot table stay in alpha order upon refresh, I used Pivot Table Options- Display- Field List- Sort A to Z. It seems to work...however, when I checked the "Sort in Data Source Order", it still seemed to keep the A to Z sort...what does the "Sort in Data...