sort order

  1. Hawks18

    Custom List for Sort Order - Using Sorted Values w/ Commas

    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...
  2. A

    Power View - Reorder items on X axis of chart

    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...
  3. F

    Can I sort concatenated text strings based on other values (using MCONCAT)?

    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...
  4. G

    Print Sort Order

    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...
  5. K

    Sort and text value

    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...
  6. T

    Sort Data by Odd (ascending) and Even (descending)

    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...
  7. R

    Sort using a Macro

    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...
  8. B

    Pivot Tables - Field Sort Option Question

    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...

Some videos you may like

This Week's Hot Topics