sorting arrays

I am making a table with movies and their movie Genres alongside some other information. Is there a way that i can sort by one Movie Genre even though some movies have more than one Genre. For example The hungergames science-fiction, Fantasy Harry potter Fantasy, adventure The...

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

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

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

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

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

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

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

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.