sorting arrays

  1. M

    Auto update and Show "Sort By" in Cell

    Hello, I have my data in a table 5 columns wide going from A3:E3 (below) Account Name Account Type State City Distance from Office I would like A2 to automatically show the current "sorted by" that is being used in the table. For instance, if sorted my table by City from A to Z, I would...
  2. M

    How to dynamically transpose array of data sorted by date & time and group them horizontally?

    Please help me with my excel project. I have a stock trading spreadsheet with a database I export from my trading platform sorted vertically by execution date (regardless of whether Its a buy or a sell). I am trying to think of a way to dynamically transpose my database horizontally, grouped by...
  3. A

    Calculations on Large list of data with Duplicates

    Hi - new to this but thanks to all for help (Excel for Mac 2011). Have searched and can find lots to help but the size of my data means am crashing by usual methods of sorting - I need a formula for this rather than pivot tables. I have a list of c. 40,000 rows. Col A is client name (largely...
  4. W

    Complex Sort Question

    New Member and not sure how to do what I need excel to do. I am only reasonably comfortable with vlookup, and I think this will take more functions! I manage assets for clients and each month import my client data base on sheet1, which has account number and name of client. On sheet 2, is...
  5. andrewb90

    moving info to different sheets

    Let me start with saying that I am running Excel 2010 on Win 7 and the user will be using Excel 2007 on Win 7. In my first sheet 'Daily' I have a form and the info typed in is summed up in Column G. G11:G36 is the first of a few ranges I want to work with. Now my other sheet 'Summary' has in...
  6. J

    Sorting Columns to Single File

    We have a school database.. We have nearly 100's of coulumns that are listed not in a format as shown in image. Please see our current format and the output we need from the image.. Xls also attached.. http://seaplane.in/Excel-Multiple-Column-Sorting.xls Output that is Needed We need to...
  7. H

    Dynamic Arrays and sorting

    I am not great with excel macros, so what I think I need is a dynamic array. I have created a function that assigns the color of a cell to a number, and I need to store that number somewhere so that I can sort by it later. The number of cells with colors that need to be assigned a number and...
  8. J

    Sorting Arrays in Ascending / Descending Order

    Everywhere I've read regarding sorting Arrays in Ascending / Descending order with VBA says there is no built in sort function that will do this... Can someone help me out with with a sorting algorithm that will accomplish this? Thanks.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top